Course Registration Form
Data & AI High Growth

Data Analytics with Excel & Power BI

Transform raw spreadsheets into executive dashboards and actionable business intelligence.

Modern organizations make decisions based on empirical metrics rather than intuition. This course equips you with the modern analytics stack. Starting with advanced Excel formulas and data cleaning, you will progress into SQL database querying and master Microsoft Power BI — designing star-schema data models, writing DAX measures, and creating compelling executive dashboards.

Total Duration 8 Weeks (32 Live Hours)
Experience Level Beginner Friendly
Instructional Mode Weekend & Weekday Batches
Authorized Credential Course Certificate
Learning Deliverables

What You Will Master

Clean, reshape, and validate disorganized raw datasets using Power Query ETL
Perform statistical summarization, scenario modeling, and pivot analytics in Excel
Write essential SQL queries to extract, filter, and aggregate relational business data
Build relational data models and author DAX formulas (CALCULATE, RELATED, time intelligence)
Design intuitive, visually balanced Power BI reports with drill-through interactions
Syllabus Breakdown

Curriculum Modules

Sequenced deliberately to transition you from core statutory or architectural logic to independent practical execution.

Modern lookup functions (XLOOKUP, INDEX/MATCH), conditional calculations (SUMIFS, COUNTIFS), Power Query data cleaning, unpivoting columns, Pivot Tables, Pivot Charts, and building interactive spreadsheet models.

Relational database querying, SELECT statements, WHERE filtering, aggregation (SUM, AVG, COUNT), GROUP BY, HAVING, multi-table INNER and LEFT JOINs, and writing subqueries for business metrics.

Importing diverse data sources, building star-schema data models, managing table relationships (1-to-many, many-to-many), calculated columns, and fundamental DAX measures (CALCULATE, FILTER, ALL, YTD/MTD).

Visual hierarchy principles, selecting appropriate chart types, interactive slicers, KPI metric cards, bookmarks, tooltips, drill-through pages, publishing reports, and presenting insights to non-technical stakeholders.

Prerequisites

  • ✓ Familiarity with spreadsheets (opening files, entering basic arithmetic)
  • ✓ A PC with Windows or virtualization to run Power BI Desktop

Who This Program Is For

  • ✓ Fresh graduates seeking entry into Junior Business Analyst or Data Analyst positions
  • ✓ Marketing, finance, operations, and HR professionals wanting data-driven literacy
  • ✓ Career switchers wanting a high-demand tech career without intensive software coding

Authorized Certificate of Completion

Data Analytics Professional Certificate awarded upon evaluation of an approved portfolio dashboard.

Backed by practical assignment verification and capstone code/return review.
← Return to All Programs