FUNDAMENTALS OF
DATA ANALYTICS

Understand the fundamentals, analytics lifecycle and the role of a Data Analyst.

Topics & Overview:

• Understand the core fundamentals and scope of Data Analytics.
• Explore the complete Data Analytics lifecycle from business question to insight.
• Understand the key responsibilities, workflows, and tools of a modern Data Analyst.
• Introduction to descriptive, diagnostic, predictive, and prescriptive analytics.

Learn about datasets, data types, KPIs and how to translate business questions into data analysis.

Topics & Overview:

• Learn about datasets, structured vs unstructured data, and quantitative vs qualitative types.
• Understand relational database essentials, tables, rows, columns, and primary/foreign keys.
• Identify and define Key Performance Indicators (KPIs) across diverse business functions.
• Learn how to translate vague business questions into precise, answerable data queries.

Get hands-on with Excel essentials, data organization, formatting, sorting, filtering and tables.

Topics & Overview:

• Get hands-on with essential Excel navigation, shortcuts, and spreadsheet interface.
• Master data organization, structured layout rules, and effective cell formatting.
• Perform fast multi-level sorting, conditional filtering, and search operations.
• Create and utilize dynamic Excel Tables with automatic range expansion.

Learn how to clean, transform and prepare data for analysis.

Topics & Overview:

• Learn why clean data is critical for accurate decision making.
• Identify and remove duplicates, fix inconsistent casing, and trim extra whitespace.
• Handle missing values, invalid entries, and date/number formatting errors.
• Clean, transform, and prepare standardized datasets ready for in-depth analysis.

Use formulas, calculations, lookups and business metrics to analyze data with confidence.

Topics & Overview:

• Use essential arithmetic, statistical, and logical formulas (SUM, AVERAGE, COUNTIF, IF, AND/OR).
• Perform table lookups and relational merges with VLOOKUP, XLOOKUP, and INDEX/MATCH.
• Build Pivot Tables and dynamic summaries to aggregate metrics across dimensions.
• Analyze business performance metrics with speed and confidence.

Create meaningful reports and interactive visualizations.

Topics & Overview:

• Introduction to Microsoft Power BI Desktop interface and data import workflows.
• Connect to Excel files and structured data sources seamlessly.
• Select and build the right chart types (bar, line, donut, treemap, matrix).
• Create interactive visual reports that tell a clear business story.

Learn to design dashboards with KPIs, charts and interactive reporting.

Topics & Overview:

• Learn dashboard design principles, visual hierarchy, color palette, and layout balance.
• Incorporate KPI cards, summary figures, and dynamic targets.
• Add interactive filters, slicers, date pickers, and drill-through capabilities.
• Produce executive-level interactive reports for business decision makers.

Build and present a beginner-level analytical dashboard and derive insights.

Topics & Overview:

• Work on an end-to-end beginner-level analytical dashboard mini project.
• Clean, organize, calculate, and visualize real-world business dataset.
• Present findings and articulate key business takeaways and decisions clearly.
• Add a demonstrable practical project to your analytics portfolio.