Data & Operations

Data Analytics (Excel, SQL & Power BI)

Tech Mahindra SMART Academy
Not rated yet
OnlineBeginner

Online4 months · 10 hrs/week

No fee

Overview

The three tools most analyst job descriptions actually ask for. Clean messy data in Excel, query it properly in SQL, and build dashboards in Power BI that someone will use every morning.

What you'll learn

  • Clean and model data with advanced Excel functions
  • Write SQL joins, aggregations and window functions
  • Build interactive Power BI dashboards
  • Present findings to a non-technical audience

Curriculum

Loading the syllabus…

Hands-on projects

A sales performance dashboard

A SQL analysis of delivery delays

A cleaned survey dataset

Campus & labs

Data Analytics (Excel, SQL & Power BI) gallery image 1

Your trainer

Vikram Desai

Analytics lead who has built reporting for retail and logistics operations teams.

Learner reviews