Overview
This course is intended for a broad range of candidate backgrounds. It is suitable for professionals who want to learn how to accurately perform data analysis using Microsoft Power BI.
It is suitable for data professionals and business intelligence professionals who develop reports that visualize data from the data platform technologies that exist on both on-premises and in the cloud.
- Aspiring Data analysts
- Financial analysts
- Data Scientist
- Finance Professionals
- Accountants
- Business Analysts
- Consultants
- Research Professionals
What you'll learn:
By the end of this course, you'll be able to:
- Clean and transform data for analysis using Power Query
- Build Data Model and perform Advanced calculations using DAX
- Perform Time-based calculations and analysis using Time Intelligence functions
- Perform Advanced analysis using AI/ML Capabilities in Power BI
- Create Interactive and dynamic Reports and Dashboards using Power BI
- Enhance reports for usability using Bookmarks, Tooltips, Drillthroughs and buttons.
Why you should enroll in this Power BI Course
🔶 Step by step instructions for turning data into amazing reports and Dashboards
🔶 Highly practical and interactive. You will learn how to analyze and visualize data with Power BI by doing and following practical examples and demos.
🔶 The training is 100% online and self - paced meaning you will access the course materials 24/7 and learn at your own pace.
🔶 12 months access to the course materials including videos, pdfs and Sample Dashboards.
🔶 1-on-1 Expert Support. Though the Course is 100% online and self - paced, you have the option to schedule a live session with our Expert Instructors when you need support.
🔶 Verified credentials and accredited badges. You will receive a digital badge and certificate which you can add to your CV and LinkedIn Profile
What you'll learn
Getting started with Data analytics
Available in
days
days
after you enroll
Getting started with Power BI
Available in
days
days
after you enroll
Getting Data
Available in
days
days
after you enroll
Preparing Data for Analysis
Available in
days
days
after you enroll
- Downloadable Files
- Introduction to Power Query Editor (8:36)
- Data Profiling (4:05)
- Basic Data Transformation (8:18)
- Basic Data Transformation Conti. (7:16)
- Appending Queries (6:57)
- Appending Data from a Folder (2:14)
- Merging Queries (6:35)
- Join Kinds (10:12)
- Unpivot Columns (4:55)
- Summarizing Data with GROUP BY (5:49)
- Adding Column: Column from Examples (3:49)
- Adding Column: Custom Columns (4:58)
- Adding Column: Conditional Column (3:59)
- Adding Column: From Number (7:15)
- Adding Column: From Date (4:34)
- Advanced Editor (5:18)
- Reusing M Code (8:51)
- Changing Data Source (3:05)
- Data transformation Challenge (6:32)
Data Modeling and DAX
Available in
days
days
after you enroll
- Exercise Files
- Loading Data (12:06)
- Introduction to Power BI Interface (5:22)
- Intro Data modeling (9:39)
- Creating relationships (9:45)
- Autodetect (2:43)
- Cardinality (4:36)
- Cardinality Part 2 (1:39)
- Dimensions and Fact Tables (2:53)
- Cross filter Direction (7:31)
- Bi-Directional (4:07)
- Table Properties (3:56)
- Column properties (6:31)
- Creating Hierarchies (5:42)
Data Analysis Expression
Available in
days
days
after you enroll
- Dataset
- Dataset walkthrough (1:54)
- Connecting and Transforming the Data (8:31)
- Data Modeling (8:20)
- Introduction to DAX (1:05)
- DAX Calculations (1:28)
- DAX Functions in Power BI (2:28)
- DAX Operators (1:15)
- Referencing Model objects (2:15)
- Using Variables (0:58)
- Using variables Demo (6:02)
- Adding Comments in DAX (1:16)
- Adding Comments in DAX Demo (3:29)
- Introduction to calculated tables (2:46)
- Using the VALUES Function (4:11)
- Using the VALUES Function with Table Input (3:44)
- Using the DISTINCT Function (2:51)
- Create Date Table with the CALENDAR Function (3:06)
- Create Date_Table with CALENDARAUTO (4:27)
- Add Columns to a Table with ADDCOLUMNS Function (6:24)
- Create a Table with the FILTER Function (4:59)
- Using the FILTER Function with Logical operators (5:55)
- Calculated Tables Review (1:08)
- Introduction to Calculated Columns (3:08)
- Add Calculated Column with the IF Function (3:46)
- Understanding Row Context (2:02)
- Using the RELATED Function to retrieve Data (8:58)
- Using the RELATEDTABLE Function (8:00)
- Creating Measures Table (3:47)
- Introduction to AGGREGATE Functions (1:59)
- Using the SUM Function to aggregate values (6:55)
- Using the COUNTROWS Function (2:35)
- Using the AVERAGE Function (3:55)
- Aggregate values using the MIN and MAX Functions (2:26)
- Difference between Measures and Calculated Columns (2:18)
- Understanding Evaluation Context (2:51)
- Understanding FILTER Context (2:47)
- How FILTER Context works in Power BI (6:05)
- FILTER Context and Cross Filter Direction (5:32)
- Introduction to Iterators(X-Aggregators) (1:36)
- SUMX Function (7:57)
- AVERAGEX Function (2:58)
- MINX Function (3:33)
- MAXX Function (2:50)
- Introduction to the CALCULATE Function (1:00)
- Understanding the CALCULATE Function (3:59)
- Using the CALCULATE Function Demo 1 (7:54)
- Using the CALCULATE Function Demo 2 (4:48)
- Using the CALCULATE Function Demo 3 (5:10)
- Creating a virtual table with the FILTER Function (11:51)
- Introduction to Filter Modifiers (0:53)
- Introduction to REMOVEFILTERS (8:32)
- Using REMOVEFILTERS with CALCULATE (8:32)
- Introduction to the ALL Function (2:24)
- Using the ALL Function with CALCULATE (6:33)
- Introduction to Time Intelligence (3:46)
- Using the PREVIOUSYEAR Function to perform YoY Analysis (6:36)
- Using the DATEADD Function (5:21)
- Using DATEADD for MoM Analysis (6:28)
- Using SAMEPERIODLASTYEAR Function (4:41)
- Calculating Running Total with TOTALYTD Function (4:20)
- Running Totals with different Fiscal Year (3:23)
- Using the TOTALMTD Function (2:35)
- Using the DATESYTD Function (4:20)
- Introduction to RANKX (2:14)
- RANKX Demo (7:02)
- TopN Function Introduction (2:09)
- Creating table with TopN Function (6:54)
Live session: Advanced Visualization
Available in
days
days
after you enroll
- Power BI Visuals Guide
- Power BI Visuals Guide Power BI Files
- Introduction to Power BI Visuals (10:49)
- The Card Visual (18:06)
- The Card Visual_Question (5:09)
- The KPI Visual (12:31)
- The KPI Visual Part 2 (6:31)
- The KPI Visual_Question (2:42)
- The Multi-row Card (3:56)
- Creating Multi-Row Card (2:48)
- Columns and Bar charts (12:17)
- The Gauge (9:55)
- Pie and Doughnut (10:12)
- Combo chart (10:24)
- 100% stacked charts (4:38)
- Waterfall chart (4:11)
- Funnel chart (9:08)
- The Q and A visual (15:04)
- Decomposition tree (15:27)
- Key influencers (10:35)
- Smart Narrative (9:59)
- Custom Visuals (4:20)
- Edit Interactions (11:01)
- Object Alignments (5:09)
Artificial Intelligence Visualizations
Available in
days
days
after you enroll
Explain increases and decreases
Available in
days
days
after you enroll
Naural Language with Q&A visual
Available in
days
days
after you enroll
Create smart narrative summaries
Available in
days
days
after you enroll
Decomposition tree visuals in Power BI
Available in
days
days
after you enroll
Create key influencers visualizations
Available in
days
days
after you enroll
Anomaly Detection
Available in
days
days
after you enroll
Apply clustering techniques.
Available in
days
days
after you enroll
Guided Project
Available in
days
days
after you enroll
- Guided Project Sample (3:26)
- Datasets
- Connecting the Data (4:34)
- Performing Data transformation (2:40)
- Adding Calculations (9:26)
- Loading the Data (1:46)
- Data modeling(Calculated Columns) (7:27)
- Adding calculated Tables (9:16)
- Creating measures (13:32)
- Time Intelligence Calculations (11:05)
- Introduction to Visualization (15:03)
- Dashboard Layout (12:39)
- Key Performance Indicators (7:21)
- Working the Slicers pane (6:00)
- Visualization 1 (17:03)
- Grouping Data (4:50)
- Visualization 2 (9:58)
- Visualizing trend with KPI visual (3:49)
- Editing visual interactions (2:54)
- Sharing the report (1:19)
- Dashboard Design version 2 (6:35)
Guided Project 2 - Designing Financial Analysis Dashboard
Available in
days
days
after you enroll
- Connecting and importing the Dataset (3:05)
- Transform and Load Data (5:02)
- Data Modeling (11:22)
- Data Analysis with DAX (7:03)
- Time intelligence calculations (5:54)
- Time intelligence part 2 (3:49)
- Report development - Report Theme (6:13)
- Report_Development - Background Design (9:59)
- Data visualization - Key Perfomance Indicators (8:14)
- Data visualization - Breakdown of KPIs (6:11)
- Data visualization - Breakdown of KPIs 2 (17:50)
- Data visualization - Profit Margin by Segment (6:14)
- Sharing and Consuming report - Export to PDF (2:54)
- Export report as Powerpoint Presentation (5:19)
- Sharing report via Email (2:44)
- Sharing report on Microsoft Teams (1:16)
Testimonial
"Data analytics course by FestMan Data School has been insightful and very practical in nature. It has helped develop my skills in Microsoft Power BI. I look forward to having subsequent related courses with them. Keep up the good work." ~ Rose Osei
Sample Dashboards and Reports
These are Samples of Dashboards you'll build in this Course
