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

What you'll learn

PowerBI
Business Intelligence
Business Analyst
DAX
PowerQuery

Course content

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

About Me3:47
Introduction2:35
Content of the Course1:57
Introduction to BI2:08
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
[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
[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
[Demo] Sorting6:23
[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
[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
[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
[Demo] Column Splitting4:53
[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
[Demo] Conditional Column2:22
[Intro] Index & Duplicated Columns1:32
[Demo] Index & Duplicated Columns3:44
[Intro] Add Column Format & Extract1:15
[Demo] Add Column Format & Extract2:43
Challenge3:08
Solution6:59

[Intro] Master Calendar1:31
[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
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: