
Learn to build powerful business intelligence dashboards with Power BI and Tableau, mastering bar, line, pie, tree map, and map visualizations, plus drilldown and interactive slicers for storytelling.
Create a simple bar chart in Power BI and Tableau using an Excel data set, illustrating price variation over time for four products across months, quarters, and years.
Create a line chart in Power BI by dropping price into values and product into axis, then customize with legends, data labels, and options like solid, dotted, or step lines.
Create a pie chart in Power BI by selecting product category for the legend and dropping order quantity into values. Then adjust labels, colors, and formatting to tailor the visualization.
Learn to create a donut ring chart from a pie chart, align category and subcategory data, and link charts on dashboard with drilldown and filters in Power BI and Tableau.
Create an interactive treemap in Power BI showing country-level orders by category, with linked charts and formatting options to compare United States and Canada.
Learn to create and format tables and matrices in Power BI, add measures and dimensions as values, rows, and columns, and apply drill-down and styling for insight.
Drill down lets you access deeper data levels by selecting a category or location, updating the table and a connected pie chart in real time.
Explore creating ribbon charts in Power BI to visualize rank flows over time, compare categories, and customize labels, colors, and tooltips for insightful dashboards.
Learn how a slicer acts as a basic filter with checkbox options to refine visuals by country or state, supports multiple selections, and links across multiple charts in Power BI.
Learn to create date slicers in Power BI to filter visuals by a date range or hierarchy, enabling real-time, interactive dashboards without scripting.
View a chart’s data point as a table, filter to a subset like technology or country, and export the data to CSV or a spreadsheet for shareable analytics.
Learn to pull live web data from sources like Wikipedia, extract tables, and transform them with the query editor to create visuals such as ring and line charts.
Import Excel files and data sources into Tableau and Power BI, clean data and nulls, define dimensions and measures, and create bar, treemap, or pie charts, then save visuals.
Explore how to create and customize a range of visualizations by combining dimensions and measures, switching chart types, and applying aggregations like sum, average, median, distinct, and variance.
Create interactive map visualizations from geographic data by mapping a numeric measure to color, labeling regions, and customizing color schemes for dashboards.
Learn to convert measures to dimensions and back, and adjust data types and formats. Explore switching between discrete and continuous values in Power BI and Tableau dashboards.
Learn how to create multiple worksheets in Tableau, add diverse visualizations from maps to pie and bubble charts, and assemble dashboards and stories by dragging dimensions and measures to marks.
Create a dashboard by arranging multiple visualizations on a single page, resizing charts, maps, and filters. Drill into data with tooltips to present insights clearly to a broad audience.
Use a map as a filter in a Power BI and Tableau dashboard to update all charts by state, revealing insights and outliers such as California.
Learn to create custom filters in Tableau using map visuals, filtering by years, dates, and weekend days, and apply multiple filters across a dashboard to sync visuals.
Learn how to add and position filters in a Power BI and Tableau dashboard, applying time-based filters (days of week, year) to map visualizations or the entire dashboard.
Create dual axis charts in Tableau by calculating measures such as count, average, min, max, standard deviation, and variance, mapping order quantity to one axis and profit to the other.
Learn to create a butterfly chart in Power BI and Tableau by arranging measures and dimensions on columns, centering the axis, and styling colors, labels, and tooltips.
Explore building a funnel chart and area charts in Tableau, including reversing order, color coding by product category, sorting, labeling, and adding filters for interactive dashboards.
Welcome to this course on Creating Analytics Dashboard and Business Intelligence Reports in Microsoft Power BI and Tableau. Here you will learn to create various kinds of Visualization charts based on a dataset using its columns and field, where you will learn to perform various operations such finding insights about data, outliers and trends. You will also learn how to customize these charts based on various parameters such as color, size, scale, text and much more. Each chart has some different set of properties that are unique to them, and you will be learning about them in some details in form of dedicated lessons on individual charts. You will learn to create various kinds of charts ranging from simple to advanced. Simple charts include- bar, line and pie chart, while complex charts include Ribbon, Dual Axis and Butterfly charts and much more. You will not just learn about creating these charts but you will also learn to used them to find insights and narrate it to others. You will also learn to create slicer filters, exporting in Power BI and creating a Dashboard in Tableau.
This course is divided into multiple sections where starting sections are dedicated on Power BI, followed by lessons on Tableau. If you want to jump straightly to the Tableau you may skip Power BI sections.
In Power BI, you would learn following-
Bar chart
Line chart
Pie chart
Ring chart
Tree Map chart
Map Chart
Table and Matrix
Ribbon Chart
Drill Down
Slicer Filter
View and Export data in CSV
Using live web data
In Tableau, you would learn following-
Various chart types- Bar, Pie, Tree Map, Map, Bubble and much more
Map Chart
Converting Measure to Dimension and vice versa
Dual Axis Chart
Multiple worksheets and Dashboard
Map Filter
Custom Filter
Butterfly chart
Funnel chart