All Courses Store Cart Agency Contact Log in Get started
63% off

SQL & Power BI for Data Analysts

The two tools every analytics job posting asks for, taught against real business data.

4.7 (174 ratings) 928 learners 7h 20m of content 22 lessons Hindi + English Beginner Updated 13 Sep 2026
Pratik Naiya
Pratik Naiya
AI Engineer · Data Analyst · Founder, HackWithPro

What you'll learn

  • Write SQL from SELECT to window functions with confidence
  • Model data properly with star schemas
  • Write DAX measures that survive slicing and filtering
  • Build dashboards that answer a question in five seconds
  • Automate refresh and share reports safely
  • Handle SQL and Power BI interview rounds

What's included

65+ lessons
Practice database + sample datasets
SQL interview workbook
Lifetime access
Completion certificate

Course content 5 sections · 22 lessons · 7h 20m total

Watch free preview
Databases, tables and relationships Preview 13:40 Setting up the practice database Preview 15:40
SELECT, WHERE, ORDER BY 19:40
Aggregations and GROUP BY 20:40
All the JOIN types, visually 24:20
Subqueries and CTEs 22:00
Window functions: rank, lag, running totals 28:00
Date handling and cohort queries 21:20
Query performance and indexes 19:00
SQL practice workbook PDF
Power BI Desktop tour 14:40
Connecting and transforming data in Power Query 25:20
Building a star schema data model 27:20
Relationships and filter direction 19:40
Calculated columns vs measures 18:00
CALCULATE, the one function to understand 24:00
Time intelligence: YoY, MTD, rolling averages 25:20
Debugging wrong numbers 19:20
Layout, colour and accessibility 20:40
Building an executive sales dashboard 38:00
Publishing, refresh and row-level security 23:00
Interview prep: SQL + BI rounds PDF

Requirements

  • A Windows machine for Power BI Desktop (free), or a VM
  • No SQL experience required
  • Basic spreadsheet familiarity helps

Description

Most analyst job descriptions come down to two skills: query the data, then show it clearly. This course covers both properly.

You will write SQL from basic SELECTs up to window functions and performance tuning, then build Power BI dashboards with a clean data model, DAX measures that do not lie, and a layout that answers the question in one glance.

Your instructor

Pratik Naiya

Pratik Naiya

AI Engineer · Data Analyst · Founder, HackWithPro

Pratik Naiya builds production AI systems, automations and data products at HackWithPro. He has shipped AI agents, RAG helpdesks and document-intelligence pipelines for real businesses, and teaches the exact workflow he uses on client projects.

Frequently asked questions

Access details are listed on this page. Lifetime courses stay in your dashboard forever, including all future updates.
No. Lectures stream inside our protected player so the content stays with the people who paid for it. Notes and code files are provided where mentioned.
Yes. We start from fundamentals and build up to production-grade projects. The requirements section lists exactly what you need.
Yes, a HackWithPro completion certificate is issued once you finish all lessons.
Email contact@hackwithpro.com any time. Doubt support is included with every paid course.

Still deciding?

Tell us what you are trying to build and we will say honestly whether this course is the right fit — or point you at something better.

2621451,499 2621453,999
Enrol now