PROJECT 01
Sales performance dashboard
Revenue, margin, targets and YoY trends by region and product, with drill through to details.
Star schemaTime intelligenceDrill through
01 / OVERVIEW
What this course is about
A good dashboard is mostly a good data model with the right measures on top. In six weeks you learn to shape data with Power Query, build a clean star schema, write DAX that gives correct answers, design reports that are easy to read, and publish them securely in the Power BI Service. You leave with portfolio dashboards like the ones on my home page.
You learn by doing: every week has hands-on exercises on Google Classroom, and every module ends with something you built yourself.
01
Shape data with Power Query
Clean, merge and reshape data from Excel, SQL and the web.
02
Model like a pro
Star schemas, relationships, date tables and model best practices.
03
Write correct DAX
Measures, CALCULATE, filter context and time intelligence.
04
Design clear reports
Layout, drill through, tooltips, bookmarks and mobile views.
05
Publish and secure
Workspaces, apps, scheduled refresh, gateways and row level security.
06
Build a portfolio
Two or three dashboards you can show in interviews.
02 / CURRICULUM
Week by week
A clear plan from the first session to the last. The pace adapts to you: if you already know a topic we move faster, and if something needs more time we take it.
WEEK 1Power BI and Power Query5 topics
- Power BI Desktop tour
- Connecting to Excel, SQL and web data
- Power Query transformations
- M language basics
- Query folding
WEEK 2Data modelling5 topics
- Star schema
- Relationships and cardinality
- Filter direction
- Date tables
- Model size and best practices
WEEK 3DAX fundamentals5 topics
- Calculated columns vs measures
- CALCULATE
- Row context and filter context
- Iterators like SUMX
- Common DAX mistakes
WEEK 4Advanced DAX5 topics
- Time intelligence: YTD, MTD, YoY
- Variables
- Ranking and Top N
- What-if parameters
- Calculation groups intro
WEEK 5Report design and storytelling5 topics
- Layout and visual choice
- Drill through and tooltips
- Bookmarks and field parameters
- Mobile layout
- Accessibility
WEEK 6Power BI Service and career5 topics
- Workspaces and apps
- Scheduled refresh and gateways
- Row level security
- Performance analyzer
- PL-300 study plan and interview questions
03 / PROJECTS
What you will build
Real projects you can put on GitHub and explain with confidence in interviews.
PROJECT 02
Inventory and supply chain report
Stock levels, days of cover and slow movers, similar to the inventory dashboards I build at work.
Power QueryDAXKPIs
PROJECT 03
Secure HR or finance report
One report, different data per user, published as an app with row level security and scheduled refresh.
RLSServiceRefresh
04 / TOOLS
Tools and technologies
The same tools used by data teams in real companies.
Power BI DesktopPower BI ServicePower Query (M)DAXDAX StudioTabular EditorExcelSQL
05 / IS IT FOR YOU
Who this course is for
Who it is for
- Excel users who want to build real dashboards
- Analysts who want to master DAX
- Data engineers who need to deliver reports
- Managers who want self-service BI skills
What you need
- Basic Excel
- No coding needed
- A Windows laptop or a Windows virtual machine (Power BI Desktop runs on Windows)
Roles it leads to
- Power BI Developer
- BI Analyst
- Data Analyst
- Reporting Analyst
06 / HOW YOU LEARN
What you get
Live and one-to-one
Every session is just you and me, never a batch. No recordings, so we can talk openly about your code.
3 sessions a week
Each session is 1 hour 15 minutes, on weekdays, weekends or both. We agree the schedule before starting.
Google Classroom
Assignments, projects, quizzes, interview questions and homework, all organised in one place.
Real projects
You build projects like the ones companies run, and get feedback on your code and design.
Interview preparation
Common questions, live coding practice and mock interviews with honest feedback.
Job placement support
CV, LinkedIn, applications and interviews. I stay with you until you are hired, as long as you do the work.
07 / PRICING
Simple pricing
You pay for your time with me, not per course. All prices are in US dollars.
Estimated total for Power BI Developer at the typical pace (1.5 months)
About 300 USD
Full refund if it is not right for you after the first session. Go faster and it costs less.About 300 USD
08 / YOUR MENTOR
Hikmat Ullah
Senior Data Engineer at Algo · Lahore, Pakistan
I build data platforms with Snowflake, Azure Databricks, Azure Data Factory and Microsoft Fabric every day, and I have been mentoring since 2021. I teach what I use at work, and I stay with you until you land the job.
7+years in data
100+students trained
80+placed in jobs
1:1always, never a batch
09 / FAQ
Questions about Power BI Developer
Can I use a Mac?+
Power BI Desktop only runs on Windows. Mac users can use a Windows virtual machine, and I help you set one up.
Do I need a Power BI Pro licence?+
You can learn almost everything with the free Power BI Desktop. For the Service features we use a trial, or your company licence if you have one.
Is PL-300 covered?+
The course covers the main PL-300 areas, and in the last week we make a study plan and go through practice questions.
How much does it cost?+
200 USD per month whichever course you choose. You can also pay 100 USD every 15 days or 50 USD per week. All prices are in US dollars wherever you live.
What is the refund policy?+
If the training is not right for you after the first session, you get a full refund. After that, payments already used for completed sessions are not refunded, but unused prepaid time can be refunded.
Is there a job guarantee?+
Yes. As long as you attend your sessions and complete the assignments and projects, I keep helping you with CV, LinkedIn, mock interviews and job applications until you are hired.
Can I join from another country or time zone?+
Yes. Students join from many countries. We pick session times that work for your time zone before we start.
10 / KEEP GOING
Related courses
2 months
SQL Developer
From your first SELECT to stored procedures, data models and fast queries.
View course → 6 monthsMicrosoft Fabric Data Engineer
OneLake, lakehouses, pipelines, Spark, warehouse, real-time and Power BI in one platform.
View course → 4 weeksAzure Data Fundamentals
Relational, non-relational and analytics data on Azure at DP-900 level.
View course →START WHEN YOU ARE READY
Start the Power BI Developer course
Tell me your goals and your time zone. We plan your schedule together, and your first session can start this week.