Data Analytics with Power BI
Become a job-ready data analyst with hands-on training in Excel, SQL, and Microsoft Power BI — including DAX, data modelling, and interactive dashboards.
Ankit Verma
Last Updated: April 29, 2026
Description
Become a data analyst with hands-on training in Excel, SQL, and Microsoft Power BI. Learn DAX, Power Query, data modelling, and storytelling through interactive dashboards. Real-world business case studies included.
Course Requirements
- Basic computer skills and familiarity with Microsoft Office
- No prior data or SQL knowledge needed
- Power BI Desktop (free to download) — Windows only
- Curiosity and a desire to work with data
What You Will Learn
- Clean, transform, and analyse data with Excel and Power Query
- Write SQL queries including joins, aggregations, and window functions
- Build professional Power BI dashboards from scratch
- Master DAX measures and time-intelligence calculations
- Design star-schema data models for optimal report performance
- Publish and share reports via Power BI Service
- Implement row-level security for data governance
- Tell compelling data stories through effective visualisations
Video: Excel Interface & Navigation
Video: Data Cleaning & Text Functions
Reading: Pivot Tables & Pivot Charts
Video: VLOOKUP, HLOOKUP & XLOOKUP
Audio: Conditional Formatting & Sparklines
Video: SELECT, WHERE & ORDER BY
Video: Aggregate Functions & GROUP BY
Reading: INNER, LEFT & RIGHT Joins
Video: Subqueries & CTEs
Audio: Window Functions: RANK, ROW_NUMBER, LAG/LEAD
Video: Getting Started with Power BI Desktop
Video: Connecting to Excel, SQL & Web Sources
Reading: Power Query Editor Transformations
Video: Building Data Models & Relationships
Audio: Report Canvas & Page Layout
Video: DAX Fundamentals: Calculated Columns vs Measures
Video: CALCULATE, FILTER & ALL Functions
Reading: Time Intelligence: YTD, QTD, MTD
Video: KPI Cards & Conditional Measures
Audio: Star Schema & Snowflake Design
Video: Bar, Line & Combo Charts
Video: Maps, Treemaps & Waterfall Charts
Reading: Custom Visuals from AppSource
Video: Drill-through & Cross-filter Reports
Audio: Bookmarks & Page Navigation
Video: Publishing to Power BI Service
Video: Building Dashboards & Pinning Tiles
Reading: Row-Level Security (RLS)
Video: Scheduled Data Refresh
Audio: Exporting & Embedding Reports
Ankit Verma
Certified Microsoft Power BI Data Analyst with a background in business intelligence. Helped 3 Fortune 500 companies migrate from Excel reporting to live dashboards. Speaker at DataFest India.
Reviews (5)
Sneha Sharma
1 week agoGood course overall. The video quality is great and the explanations are clear. Would love more practice exercises.
Ravi Teja
1 month agoAmazing course! I was a complete beginner and now feel confident enough to work on real projects. Thank you!
Arjun Kumar
1 month agoBest course I have taken online. The depth of content is incredible and the examples are very easy to follow.
Suresh Babu
2 months agoThe course content is up to date and covers everything you need to get started professionally.
Pooja Gupta
3 months agoVery practical course with real project experience. The step-by-step approach made it easy to follow even for beginners.