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.
Eswar
Last Updated: September 16, 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
Eswar
Senior Full Stack Developer with 10+ years of experience in Python, Django, and cloud infrastructure. Has trained 5,000+ students at top tech bootcamps across India. Previously at Infosys and Flipkart.
Reviews (5)
Gaurav Tiwari
2 weeks agoExcellent content and well-structured curriculum. I landed a job within 2 months of completing this course. Worth every rupee!
Deepika Nair
3 weeks agoVery practical course with real project experience. The step-by-step approach made it easy to follow even for beginners.
Swathi Reddy
1 month agoGreat value for money. The instructor explains things clearly and the curriculum is logically ordered. Highly satisfied!
Prakash Devi
3 months agoThis course completely transformed my understanding. The instructor breaks down complex concepts into digestible lessons. Highly recommend!
Suresh Babu
3 months agoI have taken many online courses but this is by far the most comprehensive and well-taught. The projects are excellent.
