Data Analytics with Excel & Power BI
Turn raw data into powerful business insights. Learn Advanced Excel, Power BI, and SQL basics — the three most requested tools in data analyst job descriptions — and become job-ready for one of the most in-demand roles of 2026.
About This Course
Data is the new currency of business — and companies across every industry are urgently hiring professionals who can collect, clean, analyze, and visualize it. Data analytics is consistently ranked among the top skill-driven careers of 2026, with employers specifically seeking candidates who demonstrate practical ability rather than just theoretical knowledge.
This 4-week course is open to students from all engineering branches — CS, IT, ECE — as well as MBA students. No advanced programming background is required. If you can use a computer, you can take this course.
You will master Advanced Excel features that most professionals never learn: pivot tables, VLOOKUP, Power Query, and complex formulas. You will then move into Power BI, Microsoft's industry-leading data visualization platform, where you will build interactive dashboards from real datasets. Finally, you will learn SQL basics to query databases — a skill listed in nearly every data analyst job description.
By the end of this course, you will have built multiple dashboards and reports that you can immediately add to your resume and portfolio.
Curriculum Highlights
Week 1 — Advanced Excel
Data cleaning and formatting; VLOOKUP, HLOOKUP, INDEX-MATCH; conditional formatting and data validation; pivot tables and pivot charts; Excel formulas for business analysis
Week 2 — Power Query & Data Modeling
Introduction to Power Query: import, transform, and load data; connecting multiple data sources; data modeling basics; relationships between tables
Week 3 — Power BI Dashboards
Power BI Desktop interface and workflow; importing data and creating visuals; bar charts, line charts, maps, and KPI cards; filters, slicers, and drill-through; publishing dashboards
Week 4 — SQL Basics & Capstone Project
Introduction to SQL: SELECT, WHERE, GROUP BY, JOIN; writing queries to extract business insights; connecting SQL data to Power BI; capstone project: end-to-end business analytics report
What You'll Achieve
Perform advanced data analysis using Excel pivot tables, Power Query, and complex formulas
Build professional, interactive dashboards in Power BI
Write basic SQL queries to extract and filter data
Clean and transform messy real-world datasets
Communicate data insights clearly through charts and reports
A portfolio of dashboards and reports ready for job applications
Job-ready for Data Analyst, Business Analyst, and MIS Executive roles
