PREPARED FOR PREPARED BY
New to Data/Freshers Rushika Kale
POWER BI 101
FROM BASICS TO
CORPORATE INSIGHTS
PROJECTS- MULTIPLE INDUSTRY
SECTORS COVERED
About me:
Rushika Kale
Talent Intelligence Consultant
Fortune 500 Company (Healthcare)
Microsoft Certified Power BI Developer
Data Analyst with 6+ years of experience
Power BI Desktop, QlikSense, SQL and Python
Total of 45+ projects in 10+ different domains
About the Course
This course covers module-wise topics in detail, for beginners and
for people transitioning from different fields to Power BI Desktop.
It focuses on introducing users to the fundamentals of Power BI
and guiding them through an end-to-end analytics scenario using
a combination of lectures, demos, and hands-on labs. The
curriculum includes an introduction to data warehousing and
business intelligence, data sources and connections, data
modelling, visualization, and creating reports. Advanced data
transformations, the DAX language, and the Power BI Services are
also covered.
In addition, the course offers guidance on ATS scoring, resume
reviewing, LinkedIn optimization, and portfolio creation to help
students get into the corporate world. By the end of the course,
users will have learned the necessary Power BI skills for
selfservice business analytics and sharing insights.
Course Syllabus
Day 1: Introduction to Power BI Desktop
Understanding the data and types of data.
Installing and setting up Power BI Desktop
Understanding the Power BI architecture and components
Day 2: Get your data in the Power BI
Understanding data sources
Basic data transformations and data cleaning techniques
Day 3: Power Query Editor
Using the "Append Queries" option in Power Query
Using Group By to group data
Understanding when to use Group By
Understanding the M language in Power Query
Using the Formula Bar to write M code
Creating custom functions in Power Query
Day 4: Advanced Power Query Editor I
Advanced data transformations using Power Query Editor
Creating a custom function
Unpivoting data in Power Query
Handling null values in Power Query
Day 5: Advanced Power Query Editor II
Understanding null values in data
Using the Replace Errors option to handle null values
Understanding the importance of handling null values
Day 6: Data Modelling in Model View
Understanding data modelling and its importance in Power BI
Creating relationships between tables
Understanding of Fact tables and Dimension tables
Converting a Single table to multiple tables
Day 7: Visualizations and Reports I
Introduction to Power BI visualizations
Creating bar, column, pie charts, tables and matrices
Formatting and customization options
Creating maps and geographic visualizations
Day 8: Visualizations and Reports II
Advanced visualizations and customizations using Power BI
Custom Visuals
Custom themes and templates
Using custom visuals from the marketplace
Creating interactive visualizations with drill-through and drill
down
Using geographic data types and hierarchies
Using map themes and layers
Day 9: Filters and Slicers in Reports
Interactive reports and dashboards using field parameters,
Edit interactions and buttons
Filtering and sorting data in visuals
Using slicers to filter multiple visuals at once
Filter pane, Selection Pane, Bookmark
Day 10: Introduction to Power BI service
Overview of Power BI Service and its features
Publishing reports to the Power BI service
Creating dashboards and sharing with others
Basic collaboration and sharing features
Day 11: Understanding the working of Power BI
Apps
Understanding the basics of Power BI apps
Creating and deploying Power BI apps
Configuring Power BI app settings
Managing app workspaces and collaboration
Day 12: Introduction to DAX
Understanding DAX syntax and functions
Creating basic DAX formulas
Create basic calculated columns and measures
Creating a custom calendar table
Day 13: Understanding the Use of DAX
Calculating Year-to-date and Month-to-date
Creating rolling averages and cumulative totals
Using What-If analysis
Use of SWITCH and IF functions
Day 14: Aggregation and Calculation Functions
Using SUMX and AVERAGEX functions
Creating rank and percentile calculations
Using conditional functions
Using clustering algorithms to group data
Day 15: Understanding of AI visuals and RLS
Using forecasting techniques in Power BI
Using decision trees to predict outcomes
Introduction to AI visuals
Understanding & Implementation of Row Level Security
Day 16: Advanced Calculations and Measures I
Advanced DAX formulas for complex calculations
Using CALCULATE for advanced calculations
Understanding the "Filter Context" and "Row Context"
Using variables and iterators in DAX
Understanding variables in DAX
Day 17: Advanced Calculations and Measures II
Creating custom date calculations using DAX
Understanding error handling in DAX
Handling division by zero errors in DAX
Using advanced aggregation functions in DAX
Day 18: Advanced Calculations and Measures III
Understanding advanced aggregation functions in DAX
Using the DISTINCTCOUNT and RANKX functions
Understanding the importance of these functions in DAX
calculations
Using DAX to create advanced conditional statements
Understanding the importance of conditional statements in
DAX
Day 19: 10 AI Terms Everyone Should Know
Bring the global conversation about AI right to your desk, with
an exploration of 10 important terms that can help you learn
the basics of AI.
From machine learning and generative AI to responsible AI,
multimodal models, prompts, and beyond, immerse yourself
in the language of AI.
Day 20: Introduction to Microsoft Fabric
What is Microsoft Fabric?
Components of Microsoft Fabric
One Lake and Lakehouse
Special Session:
Session 1: Mega Seminar
Mock Project presentation seminar just the way Corporate
holds it
Live feedback from industry experts, instructors and
classmates.
Session 2: Project Portfolio
Work on different dataset, a session only to create a report
Understand how to use different Power BI features to
apprehend the KPIs and other important analysis
Review the projects and encouraging to share it on LinkedIn
Session 3: LinkedIn Optimization & Portfolio
Creation
LinkedIn Optimization
Creating a professional LinkedIn profile
Optimizing your LinkedIn profile for job opportunities
Portfolio creation and Management
DISCLAIMER
Dear students, our course is designed to provide you with
valuable skills and knowledge in the field of Power BI.
Please note that while we do not provide job guarantees,
we encourage you to continue learning and exploring
opportunities to enhance your skills and build your career.
actors such as your personal qualifications and job market
conditions may impact job prospects and opportunities.
Keep up the great work!
