Power BI DAX & Projects – Power BI Internship
About Course
Dive deep into the world of Power BI with our Power BI DAX and End-to-End Projects course, crafted for those ready to advance their data skills and deliver professional-level analytics solutions. This course not only covers the essentials of DAX (Data Analysis Expressions) for complex calculations but also guides you through complete, end-to-end Power BI projects—from data connection and modeling to visualization and reporting.
You’ll learn how to leverage DAX to perform advanced calculations, develop custom metrics, and uncover insights hidden within your data. Each module builds your expertise, culminating in real-world projects that simulate industry scenarios. By the end, you’ll be equipped to handle full Power BI workflows and create impactful, data-driven stories that support decision-making at any organizational level.
Here are the learning objectives for the Power BI DAX and End-to-End Projects course:
- Gain Proficiency in DAX Fundamentals
- Understand the basics of Data Analysis Expressions (DAX), including syntax, functions, and their applications within Power BI.
- Develop Advanced Calculations and Custom Measures
- Learn to create calculated columns, measures, and tables to derive insights and customize analytics for complex data requirements.
- Build Robust Data Models for Analysis
- Design and optimize data models with relationships, hierarchies, and aggregations to ensure efficient and accurate analysis.
- Apply DAX for Time Intelligence Calculations
- Use DAX functions to analyze data over time, performing calculations such as year-to-date, month-over-month, and running totals.
- Design Interactive Reports and Dashboards
- Create dynamic, user-friendly Power BI dashboards and reports that showcase data insights through visual storytelling.
- Implement Filters, Slicers, and Drill-Throughs for Enhanced Interactivity
- Use filters, slicers, and drill-through features to provide an interactive data exploration experience for end-users.
- Execute Complete End-to-End Power BI Projects
- Work through entire Power BI workflows, from data preparation and modeling to visualization, in real-world, project-based scenarios.
- Share and Publish Power BI Reports with Security and Collaboration
- Learn to publish reports securely, manage user permissions, and collaborate within Power BI Service to deliver BI solutions organization-wide.
These objectives ensure you develop the advanced Power BI and DAX skills necessary to handle complex business scenarios and create powerful BI solutions that drive strategic decisions!
What Will You Learn?
- Understand the fundamentals of DAX syntax and functions.
- Create advanced calculations, custom measures, and calculated columns.
- Build and optimize data models with relationships and hierarchies.
- Apply time intelligence calculations for date-based analysis.
- Design interactive dashboards and reports for impactful data storytelling.
- Use filters, slicers, and drill-throughs to enhance report interactivity.
- Complete end-to-end Power BI projects that mimic real-world scenarios.
- Publish and share reports securely within the Power BI Service.
Course Content
Introduction to Power BI DAX
-
1.1 Introduction to Power BI DAX
12:37
Power BI DAX – Date Functions
-
1.2 Basic Date Functions in Power BI DAX 1
06:52 -
1.3 Basic Date Functions in Power BI DAX 2
04:06 -
1.4 Basic Date Functions in Power BI DAX 3
13:11 -
1.5 Basic Date Functions in Power BI DAX 4
17:12 -
1.6 Basic Date Functions in Power BI DAX 5
06:20
Power BI DAX – Aggregate Functions
-
2.7 Aggregate Functions I
19:12 -
2.8 Aggregate Functions II
06:08
Power BI DAX – Logical Functions
-
3.9 Logical Function (IF)
06:46 -
3.10 Logical Function (IFERROR)
06:58 -
3.11 Logical Functions (AND OR)
08:42
Data Cleaning with Power BI
-
4.12 Data Cleaning 1
11:21 -
4.13 Data Cleaning 2
09:37 -
4.14 Data Cleaning 3
12:05
Data Cleaning with Power BI – Power Query
-
5.15 Data Cleaning With Power BI Power Query 1
12:48 -
5.16 Data Cleaning With Power BI Power Query 2
06:36 -
5.17 Data Cleaning With Power BI Power Query 3
15:15 -
5.18 Data Cleaning With Power BI Power Query 4
06:49
Power BI DAX – Calculate Function
-
6.19 Calculate 1(Count & Sum)
13:51 -
6.20 Calculate 2( Count & Profit)
12:31 -
6.21 Calculate 3 (Date Difference)
13:38 -
6.22 Calculate 4 ( Qtrs, Not Equal)
08:23
Power BI DAX – Time Intelligence Functions
-
6.23 Time Intelligence Function 1(Between Dates & MTD)
13:18 -
6.24 Time Intelligence Function 2 ( QTD & YTD)
12:19 -
6.25 Time Intelligence Function 3(Checking answers)
11:21
Data Modeling with Power BI
-
7.26 Data Modeling 1
13:04 -
7.27 Data Modeling 2
00:00 -
7.28 Data Modeling 3
00:00
Power BI Internship
-
Project 1Krest Recruitment I
14:28 -
Project 1 Krest Recruitment II
14:45 -
Project 1 Krest Recruitment III
13:03 -
Project 2 The London Metal Exchange I
13:26 -
Project 2 The London Metal Exchange II
14:31 -
Project 3 – AK Technology I
13:52 -
Project 3 – AK Technology II
07:29 -
Project 4 – Presh Technology I
14:44 -
Project 4 – Presh Technology II
15:01 -
Project 5 Sales Transaction Data Analysis 1
13:53 -
Project 5 Sales Transaction Data Analysis 2
15:00 -
Project 6 Norlands e-Commerce Store 1
14:49 -
Project 6 Norlands e-Commerce Store 2
09:28 -
Project 7 Sales Data Executive Reporting 1
14:31 -
Project 7 Sales Data Executive Reporting 2
00:00 -
Project 8 Shopping Analysis of Istanbul 1
15:03 -
Project 8 Shopping Analysis of Istanbul 2
14:05 -
Project 8 Shopping Analysis of Istanbul 3
14:05 -
Project 9 RushTech Financials 1
15:03 -
Project 9 RushTech Financials 2
07:18 -
Project 10 African Population by Sub Region 1
09:38 -
Project 10 African Population by Sub Region 2
14:16 -
Project 10 African Population by Sub Region 3
11:42 -
Project 20 – Skibs Enterprise
-
Project 21 – Freelance Gig (4 Projects)
Earn a certificate
Add this certificate to your resume to demonstrate your skills & increase your chances of getting noticed.
Student Ratings & Reviews
Subscribe Now
Don’t miss our future updates! Get Subscribed Today!