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
- 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)
- 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)
- Download Files
- Data Modeling Revisited (142:09)
- Introduction to DAX (16:31)
- Calculated Columns(Related and RelatedTable) (42:24)
- Calculated Tables (34:37)
- Check your knowledge
- Introduction to measures (22:39)
- Aggregate Functions (14:23)
- Evaluation context (27:10)
- Measure Vs Calculated Columns (7:37)
- Iterators (18:45)
- Advanced CALCULATE (31:49)
- REMOVEFILTERS AND ALL (13:08)
- FILTER FUNCTION (25:45)
- Time Intelligence (43:38)
- DAX GUIDE SUPPORT
- Worked Power BI File
- 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)
- Downloadable Files
- Introduction (8:56)
- Get Data (5:43)
- Transform Data (8:17)
- Relationships (2:48)
- Data View (3:50)
- Calculations Part 1 (13:49)
- Calculations Part 2 _ Time Intelligence (21:15)
- Building Dashbaord_KPIs (13:46)
- Building Dashboard Part 2 (32:37)
- Adding Buttons for Page Navigation (5:39)
- Creating Free Corporate mail for Power BI signup (15:33)
- 12 Power BI Services (14:08)
- 19 Final (9:49)
- Dashboard Design 2
- Dashbaord 3 : Exercise Files
- Dashboard 3: Video (266:19)
- Dashboard 3: Background Design (5:43)
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