PowerBI Tutorial : Mastering Data Visualization and Analysis

Name: PowerBI Tutorial : Mastering Data Visualization and Analysis
Rating: 3.9 (182 reviews)

Learn PowerBI from scratch

Created byArthur Fong

Last updated 7/2023

English

English [Auto],

What you'll learn

PowerBI
Business Intelligence
Business Analyst
DAX
PowerQuery

Course content

6 sections • 82 lectures • 4h 0m total length

About Me3:47
Arthur shares his journey from information technology and artificial intelligence into analytics, offering step-by-step, beginner-friendly tutorials and practical guidance to help anyone learn data analytics.
Introduction2:35
Content of the Course1:57
Introduction to BI2:08
Harness business intelligence with Power BI to collect, transform, and analyze data from Excel files and databases, revealing insights and designing dashboards that boost revenue and decision making.
Installing PowerBI Desktop1:18
Exploring the Interface4:35
Exploring the Power BI interface is an essential step in leveraging the full potential of the tool for data analysis and visualization. It involves familiarizing yourself with these features and functionalities, experimenting with different options, and leveraging the capabilities to gain insights, create impactful visualizations, and make data-driven decisions.
Dashboard Design5:04
Dashboard design plays a crucial role in effectively communicating data insights and facilitating data-driven decision-making. Well-designed dashboards enhance data understanding, foster collaboration, and empower users to make informed decisions based on accurate and relevant insights.
Subsribe Now!0:32
Youtube Link : https://www.youtube.com/watch?v=LIOizopeGs8

Loading Data into PowerBI2:41
Load data into Power BI from an Excel file, preview sheet two, load and refresh data, then manage tables and learn about the usage of calendar tables.
[Intro] Creating Our First Dashboard (Slicer, Card, Donut)3:31
A slicer, card, and donut chart are three different visual elements commonly used in data visualization and reporting. When used together in a Power BI report or dashboard, slicers, cards, and donut charts can provide a comprehensive and interactive data exploration experience.
[Demo] Creating Our First Dashboard (Slicer, Card, Donut)5:34
[Intro] Creating Our First Dashboard(Table and Bar)4:06
Table and bar charts are commonly used visualizations in data analysis and reporting. When used together, a table and bar chart can provide complementary data views. The table includes detailed information and allows users to explore specific data points, while the bar chart offers a visual summary and facilitates quick comparisons across categories.
[Demo] Creating Our First Dashboard(Table and Bar)3:22
Challenge0:41
Solution2:07
Navigate to transform data, locate discount sheet, promote headers from the first row to column names, and verify the discount column is added to the table via the check box.
[Intro] Creating Measure1:30
"SUM" and "SUMX" are two functions in the DAX (Data Analysis Expressions) language used in Power BI. "SUM" is used for aggregating values within a single column, while "SUMX" allows for more complex calculations and aggregation across multiple rows or a table expression.
Creating Measure1:29
Creating Measures in Excel2:22
Data Types3:17
Creating Measures in PowerBI3:43
[Intro] Sorting1:50
Sorting is a common operation performed on data to arrange it in a specific order based on one or more criteria. Sorting data provides organization, clarity, and the ability to analyze and compare data effectively. It is a fundamental operation in data analysis and reporting, enabling users to make sense of the information and draw meaningful conclusions.
[Trailer] Sorting3:49
Create a custom sort order in Power BI by building a sort table (B, A, C), wiring it to the products table, and using related to display the ordered results.
[Demo] Sorting6:23
Learn how to sort data in Power BI, including ascending and descending orders, and build a custom sort table to control product order in your visuals.
[Intro] Calendar2:57
A calendar is a fundamental component in data analysis and reporting that represents a chronological sequence of dates. In the context of Power BI or other data visualization tools, a calendar table is a specialized table created to support time-based analysis and reporting. It forms a foundation for time intelligence and enables effective reporting on trends and historical performance.
[Demo] Calendar1:44
[Intro] DAX2:06
DAX (Data Analysis Expressions) is a formula language used in Power BI, Excel Power Pivot, and Analysis Services to perform calculations and define custom calculations. DAX provides a powerful and flexible language for calculations and analysis. It enables you to perform advanced calculations, implement complex business logic, and create dynamic and interactive data models in Power BI.
[Demo] DAX5:07
This demo shows building measures with DAX in Power BI, using a calendar table linked to fact data, exploring month-to-date and year-to-date logic, and using slicers to analyze sales.
[Intro] Disabling Chart Interaction in PowerBI1:40
Chart interactions refer to the ability to interact with one chart or visual element in a data visualization tool, such as Power BI, and have it affect the behavior or display of other connected charts or visuals. It enhances data exploration and analysis by allowing users to dynamically filter, highlight, or drill down into specific data points based on their interactions with the visualizations.
[Demo] Disabling Chart Interaction in PowerBI2:40
Learn how to disable chart interaction in Power BI so a visual, like a card showing the grand total, remains unaffected by slicers.
[Intro] Drill Up & Drill Down1:26
Drill Up and Drill Down are interactive features that allow users to navigate between different levels of data hierarchy or detail within a chart or visualization. These features are commonly used in data analysis and reporting tools like Power BI. Drill Up and Drill Down allows users to dig deeper into their data, uncover insights, and make more informed decisions.
[Demo] Drill Up & Drill Down2:58
Creating Buttons3:28
Creating Variables5:18
Creating Bookmarks3:08

[Intro] Connecting Data from Web Source1:07
[Demo] Connecting Data from Web Source3:51
[Intro] Changing Data Types1:31
[Demo] Changing DataTypes3:07
[Intro] Column Splitting1:42
Split a specific column in Power Query to extract portions into new columns, using custom rules and delimiters to enable better organization, data quality, and analysis.
[Demo] Column Splitting4:53
Explore column splitting in Power BI power query, using delimiter-based, character-based, and position-based methods (including space delimiters) to reshape data.
[Intro] Formatting1:14
[Demo] Formatting3:18
[Intro] Extract1:35
[Demo] Extract2:15
[Intro] Statistical Toolbar1:30
[Demo] Statistical Toolbar4:37
[Intro] Alternative to Transform Column2:30
[Demo] Alternative to Transform Column1:30
[Intro] Custom Column1:23
[Demo] Custom Column4:10
[Intro] Conditional Column1:20
Build conditional columns in Power Query to segment data by criteria, enabling dynamic updates and automatic recalculation of derived values without manual intervention.
[Demo] Conditional Column2:22
[Intro] Index & Duplicated Columns1:32
[Demo] Index & Duplicated Columns3:44
Create a rank column by adding an index column in Power Query Editor, sort data in descending order, and duplicate the source column for a practical top-100 ranking workflow.
[Intro] Add Column Format & Extract1:15
[Demo] Add Column Format & Extract2:43
Challenge3:08
Solution6:59

[Intro] Master Calendar1:31
Create a master calendar in Power BI with year, month, and quarter data. Link it to other tables to enable time-based calculations and consistent date hierarchies.
[Demo] Master Calendar3:22
[Intro] Table Matrix1:14
[Demo] Table Matrix4:23
[Intro] Variable1:22
[Demo] Variable5:18
[Intro] MTD Logic1:17
[Demo] MTD Logic8:16
Challenge0:59
Tackle a year-to-date measure in Power BI by accumulating sales from the month start to year end, or to the max current month if the year isn’t finished.
Solution4:57
[Intro] Advanced Filter1:51
[Demo] Advanced Filter5:17
[Intro] Prior Month & Prior Year0:56
[Demo] Prior Month & Prior Year8:17
[Intro] Buttons1:20
[Demo] Buttons8:29
[Intro] Color Code1:37
[Demo] Color Code3:00

Requirements

Description

Today, we are all surrounded with full of data.

Data can be in the form of structured data(eg: Tables, worksheets), or unstructured data (free text fields or comments from social media).

In the current modern world of Business Modelling, many organizations have leveraged the importance of having Business Intelligence(BI) to surface the business problems that could be found in their underlying transactional data.

BI tools have helped a lot of organizations, either in preventing some dreadful losses in the business or helping in adding growth towards revenue.

BI has now emerged as a Marketing & Strategizing component to help organizations in monitoring the performance of a promotional event, either the promotional event has attracted a lot of attention, or the promotional event did not benefit the organization.

Data is everywhere but if we do not transform the data into useful insight, we are not able to make the correct decision on a certain matter.

Imagine if we are recently appointed to be a director of an organization, are we able to:

1. React based on the latest or historical information that is happening around us?

2. Reduce or automate the manual works that have been done in decades?

3. Draw insights from a stack of printed reports?

If you do not have the answer, join this class to know how PowerBI can help solve your problems.

Who this course is for:

Beginner in BI
IT Fresh Graduate
Beginner in Data Analytics
Business Analytics Beginner

PowerBI Tutorial : Mastering Data Visualization and Analysis

What you'll learn

Explore related topics

Course content

Introduction8 lectures • 22min

Contents26 lectures • 1hr 19min

PowerQuery24 lectures • 1hr 3min

Report Visual, Measure and DAX18 lectures • 1hr 3min

Dashboard Optimizations5 lectures • 12min

Conclusion1 lecture • 1min

Requirements

Description

Who this course is for: