8 weeks, 90 Hrs Intensity Timeline

Data Analytics

Transform raw data into actionable business intelligence. Master advanced SQL database querying, complex Excel modeling, and professional interactive dashboard design using Power BI and Tableau.

Total Duration

8 weeks, 90 Hrs

Category

Analytics & Business Intelligence

Credential

Certified Data Analyst (CDA)

Modular Protocol Breakdown
MODULE 01 20 Hours Intensity

Advanced Excel for Analytics

Master lookup functions, array formulas, data cleaning techniques, and dynamic pivot tables for professional data manipulation.

Excel Pivot Tables VLOOKUP/XLOOKUP Data Cleaning Power Query
MODULE 02 25 Hours Intensity

SQL for Data Extraction & Manipulation

Write complex SQL queries to filter, aggregate, and join data from multi-table relational databases. Learn window functions and subqueries.

SQL PostgreSQL JOINS Aggregations Subqueries
MODULE 03 25 Hours Intensity

Business Intelligence with PowerBI

Connect data sources, build robust DAX calculations, and construct stunning, interactive executive dashboards for business reporting.

PowerBI DAX Data Modeling Dashboards BI Reporting
MODULE 04 20 Hours Intensity

Visual Analytics with Tableau

Create compelling data stories. Learn customized visualizations, dual-axis charts, mapping, and sharing insights through Tableau Server/Public platforms.

Tableau Data Visualization Storytelling Calculated Fields