Power BI 2 Week Roadmap
(Beginner to Advanced)
Day 1 – Power BI Basics & Installation
● What is Power BI?
● Power BI vs Excel/Tableau
● Install Power BI Desktop
Resources:
● Video: https://www.youtube.com/watch?v=AGrl-H87pRU
● Docs:
https://learn.microsoft.com/en-us/power-bi/fundamentals/power-bi-overvie
w
Day 2 – Interface Tour + Data Import
● Power BI interface overview (Home, Ribbon, Views)
● Import data from Excel, CSV, Web
● Perform basic transformations (remove rows, rename columns)
Resources:
● Video: https://www.youtube.com/watch?v=njzsy5NswmU
● Docs:
https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-data-sour
ces
Day 3 – Power Query Editor (ETL)
● Clean messy data
● Remove blanks, merge/append queries
● Understand and use Applied Steps
Resources:
● Video: https://www.youtube.com/watch?v=xVd6ZLYecV4
● Docs:
https://learn.microsoft.com/en-us/power-query/transform-data
Day 4 – Data Modeling + Relationships
● Understand star schema vs snowflake
● Create and manage relationships
● Use the "Manage Relationships" pane
Resources:
● Video: https://www.youtube.com/watch?v=eaWyoYgRIlQ
● Docs:
https://learn.microsoft.com/en-us/power-bi/transform-model/desk
top-relationships-understand
Day 5 – DAX Fundamentals
● Introduction to DAX: Calculated columns vs Measures
● Basic functions: SUM, COUNT, DISTINCTCOUNT
● Logical functions: IF, SWITCH
Resources:
● Video: https://www.youtube.com/watch?v=3gA0ATn3DA4
● Docs:
https://learn.microsoft.com/en-us/dax/logical-functions-dax
Day 6 – Intermediate DAX
● CALCULATE, FILTER, ALL, VALUES
● Aggregation with filtered context
Resources:
● Video: https://www.youtube.com/watch?v=wuejFZPa0Jg
● Docs:
https://learn.microsoft.com/en-us/dax/calculate-function-dax
Day 7 – Visualizations & Filters
● Create visuals: bar, pie, table, matrix
● Use slicers, filters, and drill-down
● Sync slicers across pages
Resources:
● Video: https://www.youtube.com/watch?v=EVHcDCE0SGI
● Docs:
https://learn.microsoft.com/en-us/power-bi/visuals/power-bi-visua
lization-types
Day 8 – Advanced Visual Features
● Use and customize tooltips
● Create bookmarks and navigation buttons
● Apply conditional formatting
Resources:
● Video: https://www.youtube.com/watch?v=BE6W8qMbqgY
● Docs:
https://learn.microsoft.com/en-us/power-bi/create-reports/deskto
p-bookmarks
Day 9 – Time Intelligence in Power BI
● Build and use date tables
● YTD, MTD, QTD calculations
● Use SAMEPERIODLASTYEAR, DATESYTD, DATESBETWEEN
Resources:
● Docs:
https://learn.microsoft.com/en-us/dax/time-intelligence-functions-dax
● Video: https://www.youtube.com/watch?v=RfXbDB7ziqA
Day 10 – Power BI Service & Dashboards
● Publish to Power BI Service
● Create dashboards and pin visuals
● Share reports securely
Resources:
● Docs:
https://learn.microsoft.com/en-us/power-bi/create-reports/service-publ
ish
● Docs:
https://learn.microsoft.com/en-us/power-bi/consumer/end-user-dashb
oards
Day 11 – Data Refresh + Gateway
● Set up scheduled data refresh
● Configure On-premises data gateway
● Troubleshoot common refresh errors
Resources:
● Docs:
https://learn.microsoft.com/en-us/power-bi/connect-data/refresh-
data
Day 12 – Row-Level Security (RLS)
● Set roles and filters in Power BI Desktop
● Test roles locally
● Configure RLS in Power BI Service
Resources:
● Docs:
https://learn.microsoft.com/en-us/power-bi/admin/service-admin-r
ls
Day 13 – Mini Project: Sales Dashboard
● Use the Superstore dataset
● Create summary page, KPIs, and filters
● Add slicers, dynamic titles, formatting
Resources:
● Dataset:
https://www.kaggle.com/datasets/vivek468/superstore-dataset-final
● Video Tutorial: https://www.youtube.com/watch?v=WXkDkckVfXg
Day 14 – Portfolio + Interview Prep
● Upload final project to GitHub
● Record a short explanation video
● Prepare for interviews with common Power BI questions
Resources:
● GitHub: https://github.com/new
● Interview Questions:
https://www.edureka.co/blog/interview-questions/power-bi-interview-q
uestions
