Sales Performance Dashboard
An executive dashboard built from raw sales data.
- SQL and Power Query preparation
- Star schema and DAX measures
- Clear recommendations
Data Analytics · Beginner
Data Analytics
Clean, analyse and present data for business decisions.
- Excel
- SQL
- Power BI
- Python
- Statistics
- Copilot
About this course
Learn the skills analyst roles commonly ask for: Excel, SQL, Power BI and Python, plus how to use AI tools and communicate findings to business teams.
Who this is for
- Freshers from any graduate background
- Professionals moving from operations, finance or support
- Excel users wanting to work with larger data
What you will be able to do
- Clean and analyse data in Excel and Python
- Write SQL for real business questions
- Build clear Power BI dashboards
- Use AI tools while checking their output
- Present findings and recommendations
Prerequisites: Comfort with basic mathematics.
8-week curriculum
- 8
- Learning units
- 40
- Topics covered
- 2
- Projects
- 7
- Tools
Week 1
Analytics Foundations and Excel
- The analyst role and the analytics workflow
- Formulas, XLOOKUP and data cleaning
- PivotTables and charts
- Power Query basics
- Asking good business questions
Assignment
Clean a sales dataset and build a summary report.
Week 2
SQL Fundamentals
- SELECT, filtering and sorting
- Aggregations and GROUP BY
- Joins
- Subqueries
- Data types and NULL handling
Assignment
Answer 20 business questions with SQL.
Week 3
Advanced SQL
- Common table expressions
- Window functions
- Date and text functions
- Cohort and funnel analysis
- Writing readable, efficient queries
Assignment
Build a customer retention analysis.
Week 4
Power BI: Data and Modelling
- Power Query transformations
- Star schema modelling
- Relationships
- DAX fundamentals
- Time intelligence
Assignment
Model a retail dataset in Power BI.
Week 5
Power BI: Dashboards and Storytelling
- Dashboard design principles
- Choosing the right chart
- Interactivity and drill-through
- Row-level security
- Publishing and sharing
Assignment
Build an executive sales dashboard.
Week 6
Python for Analysis
- Python basics
- Pandas for cleaning and analysis
- Visualization with Matplotlib and Seaborn
- Exploratory data analysis
- Working in Jupyter
Assignment
Complete an exploratory analysis in a notebook.
Week 7
Statistics and AI for Analysts
- Descriptive statistics and distributions
- Correlation vs causation
- A/B testing basics
- Copilot in Excel and Power BI
- Checking AI-generated analysis
Assignment
Analyse an A/B test and write a recommendation.
Week 8
Capstone and Interview Preparation
- End-to-end capstone
- Presenting to stakeholders
- SQL and case interview practice
- Portfolio on GitHub
- Resume review
Assignment
Present your capstone and complete a mock interview.
Keep the full curriculum with you
Verify your email and download this course as a PDF.
Projects you will build
Customer Retention Analysis
Cohort analysis of why customers stay or leave.
- Advanced SQL
- Python analysis
- Stakeholder presentation
These are training projects. Please describe them honestly as training work on your resume and in interviews.
Tools and technologies
- Excel
- SQL
- Power BI
- Python
- Pandas
- Jupyter
- Copilot
Career support
- Resume tailored to your target role
- LinkedIn, Naukri and Indeed profile guidance
- Technical and HR mock interviews, with feedback
- Help explaining your projects clearly
MYP does not guarantee a job or interviews.
Need More Information? Connect with Our Course Expert.
Ask about the course, fees, duration or which path suits your background.
₹30,000