Data Science

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.

4.6 (2,100 Reviews)
Ankit Verma
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
08:30
Video: Data Cleaning & Text Functions
12:45
Reading: Pivot Tables & Pivot Charts
05:00
Video: VLOOKUP, HLOOKUP & XLOOKUP
15:20
Audio: Conditional Formatting & Sparklines
06:10

Video: SELECT, WHERE & ORDER BY
08:30
Video: Aggregate Functions & GROUP BY
12:45
Reading: INNER, LEFT & RIGHT Joins
05:00
Video: Subqueries & CTEs
15:20
Audio: Window Functions: RANK, ROW_NUMBER, LAG/LEAD
06:10

Video: Getting Started with Power BI Desktop
08:30
Video: Connecting to Excel, SQL & Web Sources
12:45
Reading: Power Query Editor Transformations
05:00
Video: Building Data Models & Relationships
15:20
Audio: Report Canvas & Page Layout
06:10

Video: DAX Fundamentals: Calculated Columns vs Measures
08:30
Video: CALCULATE, FILTER & ALL Functions
12:45
Reading: Time Intelligence: YTD, QTD, MTD
05:00
Video: KPI Cards & Conditional Measures
15:20
Audio: Star Schema & Snowflake Design
06:10

Video: Bar, Line & Combo Charts
08:30
Video: Maps, Treemaps & Waterfall Charts
12:45
Reading: Custom Visuals from AppSource
05:00
Video: Drill-through & Cross-filter Reports
15:20
Audio: Bookmarks & Page Navigation
06:10

Video: Publishing to Power BI Service
08:30
Video: Building Dashboards & Pinning Tiles
12:45
Reading: Row-Level Security (RLS)
05:00
Video: Scheduled Data Refresh
15:20
Audio: Exporting & Embedding Reports
06:10
Ankit Verma

Ankit Verma

(4.6)
1 Courses 15 Enrolled

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.

4.6

2,100 Students Review

40%
40%
20%
0%
0%
Reviews (5)
Sneha Sharma
Sneha Sharma
1 week ago

Good course overall. The video quality is great and the explanations are clear. Would love more practice exercises.

Ravi Teja
Ravi Teja
1 month ago

Amazing course! I was a complete beginner and now feel confident enough to work on real projects. Thank you!

Arjun Kumar
Arjun Kumar
1 month ago

Best course I have taken online. The depth of content is incredible and the examples are very easy to follow.

Suresh Babu
Suresh Babu
2 months ago

The course content is up to date and covers everything you need to get started professionally.

Pooja Gupta
Pooja Gupta
3 months ago

Very practical course with real project experience. The step-by-step approach made it easy to follow even for beginners.

Rs 12,000Rs 16,000
25% Off
Enroll Now
  • Instructor: Ankit Verma
  • Level : Beginner
  • Lectures : 30 Lectures
  • Duration: 60 Days
  • Enrolled: 15 Students
  • Language: English
Course Includes
  • Full Lifetime Access
  • Downloadable Resources
  • Certificate Of Completion
  • Community Support
  • 15 Days Money Back Guarantee