📈
Data
Data Analytics
Excel, SQL, Power BI, Tableau, Python basics and business analytics storytelling.
Duration
12 weeks
Students
340+ enrolled
Rating
4.7
What You Will Learn
Create dashboards
Write SQL queries
Clean business data
Present insights clearly
Curriculum
1
Analytics career roadmap
Analyst rolesToolsBusiness metricsCase studies
Lab: Set up Excel, SQL and BI workspace
2
Excel fundamentals
FormulasFormattingTablesData validation
Lab: Create student admissions tracker
3
Advanced Excel
Pivot tablesLookupsChartsPower Query
Lab: Build sales analysis workbook
4
SQL basics
SELECTWHEREORDER BYAggregations
Lab: Query customer and course data
5
SQL joins and reporting
JoinsGroup bySubqueriesViews
Lab: Create monthly performance report
6
Power BI fundamentals
Data importRelationshipsVisualsFilters
Lab: Create first Power BI dashboard
7
DAX and dashboard design
MeasuresKPIsCardsSlicers
Lab: Build placement performance dashboard
8
Tableau basics
ChartsCalculated fieldsDashboardsStories
Lab: Create interactive Tableau view
9
Python for analysts
Pandas basicsData cleaningSimple chartsExporting reports
Lab: Clean dataset using Python
10
Business storytelling
Insight writingExecutive summaryRecommendationsPresentation flow
Lab: Prepare dashboard presentation
11
Analytics capstone
Problem statementData modelDashboard reviewInsights
Lab: Complete end-to-end analytics project
12
Interview preparation
SQL interview questionsDashboard explanationResume projectsMock interview
Lab: Present portfolio and answer case questions