PowerBI MasterClass (All in 1 hour)

Name: PowerBI MasterClass (All in 1 hour)
Rating: 4.2 (152 reviews)

Learning PowerBI starting from zero

Created byArthur Fong

Last updated 6/2024

English

What you'll learn

PowerBI
Business Intelligence Beginner
Business Analyst
PowerQuery
DAX

Course content

2 sections • 34 lectures • 1h 54m total length

Introduction2:35
Beginner-friendly Power BI masterclass guides you from scratch to loading an Excel data source, creating visuals, performing transformations, building a data model, and delivering client insights through a final dashboard.
Table of Content1:59
Introduction to PowerBI2:24
Explore business intelligence basics by collecting and analyzing data to inform decisions and boost revenue, using Excel as a data source and transforming tables for Power BI analysis.
Installing PowerBI Desktop1:18
Analysity: Your University towards Analytics4:10
Analysity guides your university toward analytics by providing free BI resources, courses on data pipelines and transformations, insights, and tailored content, with updates and promotions delivered by email.
Loading Data into PowerBI2:41
Dashboard Design5:04
Design a four-quadrant, simple dashboard that uses consistent color and fonts to tell a data-driven story with charts and interactive drill-downs, supporting KPI tracking and informed decisions.
Creating Our First Dashboard_Demo (Slicer, Card, Donut)5:58
Creating Measure1:29
Create measures in Power BI and compare sum and sumx functions to understand how measures aggregate data and affect grand totals, with practical demonstrations of different results.
Data Types3:17
Learn to create sum and sumx measures in Power BI while diagnosing data type issues, adjusting columns from text to decimal numbers, and applying transform data steps.
Creating Measures in PowerBI3:43
Sorting3:49
Learn to create a sort order in Power BI by building a sort table, linking it to the product data, and using the related function to sort the product column.
Sorting_Demo6:02
Learn to apply a custom sort order in Power BI by setting sorting priority on a column and choosing ascending or descending.
Calendar1:44
DAX5:39
Learn how to use DAX to create measures for monthly and year-to-date insights in Power BI, connect tables for time-intelligence, and build slicers to compare current and past periods.
Chart Interaction2:40
Learn to control chart interactions in Power BI by configuring visual interactions so specific visuals ignore slicers, using formats and interactions to set none across visuals.
Drill Up/Down2:58
Add the date hierarchy to a bar chart to enable year view and drill down to month and day, then use drill mode to move up or down between levels.
Creating Buttons3:28
Learn to recreate and customize a landing page button in Power BI, adjusting text, alignment, and font, then configure a page navigation action to the main page.
Creating Bookmarks3:08
Subscribe Now!0:32

Introduction to PowerQuery3:22
Connecting Data from Web3:51
Changing Data Type3:07
Learn how to change data type for specific columns in Power BI, converting integers to text and using transform data, to control table layout and data interpretation.
Splitting Columns4:53
Learn to split columns in Power Query using a delimiter or number of characters, including leftmost and rightmost options, to produce multiple clean columns.
Formatting3:18
Apply the Power BI transform panel to format a key column, converting text to uppercase, lowercase, or capitalized, and learn to add prefixes or suffixes for consistent data presentation.
Extract2:15
Statistical Information from PowerQuery4:37
Learn to extract statistical information from PowerQuery by computing minimum, average, and count, and identifying unique values in a column, including the difference between count and unique values.
Alternative to transform Column1:30
Discover an alternative to the transform column in Power BI, using quick right-click shortcuts to apply uppercase, lowercase, and capitalization without opening the transform panel.
Custom Column4:10
Create and customize a new column in Power BI using the column panel, applying a formula, text concatenation, and renaming the column for clarity.
Conditional Column2:22
Learn how to create a conditional column in Power BI based on another column's values, and categorize search volumes into high, moderate, and low using defined rules.
Index & Duplicated Columns3:44
Create an index column and rename it rank to order rows by descending search volume, then duplicate the source column as needed.
Add Column: Format & Extract2:43
Challenge 23:08
Load data from downloadable into Power BI, create a cost column as cost times quantity, replace the cost, split product into category and items, and format aging to two decimals.
Solution_26:59

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.

In this course, we are going to learn more on PowerQuery transformation steps:

1. How to transform our columns to extract values or change column formatting

2. How to add new columns, eg: Custom columns, conditional columns, index columns, etc.

For the report table, we are going to explore more on DAX to help us with some of the common expressions that we used in reporting, eg: MTD/YTD DAX expressions.

Hope you enjoy the course and let's roll!

Who this course is for:

Beginner in BI
IT Fresh Graduate
Data Engineer
Data Specialist
Data Analyst

PowerBI MasterClass (All in 1 hour)

What you'll learn

Explore related topics

Course content

Introduction20 lectures • 1hr 5min

PowerQuery14 lectures • 50min

Requirements

Description

Who this course is for: