What is Data Analytics?

Importance of Analytics in Business

Data-Driven Decision Making

Real-World Applications of Analytics

Analytics Lifecycle

Descriptive Analytics

Diagnostic Analytics

Predictive Analytics

Prescriptive Analytics

Structured vs Unstructured Data

Data Collection Methods

Data Sources – Databases , APIs, Excel / CSV , IoT Devices , Social Media Platforms

Open Data Platforms

Data Cleaning Techniques

Handling Missing Values

Removing Duplicates

Data Type Conversion

Splitting & Merging Columns

Filtering & Aggregation

Pivoting & Unpivoting

Merge Queries

Append Queries

Dimensions – Categorical Data, Slicers & Filters, Contextual Analysis

Measures – Aggregated Calculations, KPI Metrics, Dynamic Calculations

Fact Tables

Dimension Tables

Relationships

Primary & Foreign Keys

Star Schema

Snowflake Schema

Cross Filtering

Report View

Data View

Model View

Visualization Pane

Filters Pane

Publishing Reports

Calculated Columns

Calculated Measures

DAX Syntax

Variables in DAX

CALCULATE()

FILTER()

SEARCH()

LOWER()

DIVIDE()

Variables & Context

Principles of Effective Visualization

Dashboard Design

KPI Design

Choosing Appropriate Charts

Interactive Reporting – Themes , Canvas Backgrounds, Interactive Elements

Card Visual

Gauge Chart

Map Visual

Stacked Bar Chart

Clustered Column Chart

Donut Chart

Ribbon Chart

Line Chart

Scatter Plot

Matrix

Treemap

Slicers

Drill Down & Drill Through

Include / Exclude Filters

Play Axis

Animated Charts

Page Navigation

Analysis Areas – Infection Trends, Mortality Analysis, Vaccination Progress, ICU Occupancy Analysis, Mobility & Lockdown Effects

Dashboards Built – Infection Trends Dashboard, Healthcare Strain Dashboard, Vaccination Analytics Dashboard

Visualizations Used – Line Charts, Gauges , Maps, Ribbon Charts, Donut Charts, Scatter Plots

Topics Covered – Layoff Trend Analysis , COVID Impact on Employment , AI & Automation Impact, Workforce Transformation

Concepts Learned – Text Analysis using DAX, Trend Analytics, Comparative Analytics

Dashboards Built – Job Loss Trend Dashboard, AI vs COVID Impact Dashboard

Visuals Used – Stacked Column Charts, Line & Stacked Charts, Animated Visuals, Slicers

Python Setup for Power BI

Python Scripting

Python Visuals

Warehouse Automation

Robot Efficiency Monitoring

Pick Station Performance

Manual vs Automated Picking

Robot Efficiency Dashboard

PPS Efficiency Dashboard

Manual vs Automated Comparison

Product Pick Time Dashboard

Order Fulfillment Dashboard

Introduction to Generative AI

AI-Assisted Analytics

Business Intelligence with AI

Automated Dashboard Summaries

AI-Generated Insights

Automated Narratives

AI Storytelling

Prompt Engineering for DAX

AI-based Formula Generation

DAX Optimization

Q&A Visual in Power BI

Conversational Analytics

English-to-Insight Systems

AI-based Chart Recommendations

Visualization Best Practices

Data Storytelling with AI

Forecasting in Power BI

Time-Series Forecasting

Trend Prediction

Built-in Anomaly Detection

AI-Generated Explanations

Statistical Trend Analysis

Introduction to Microsoft Copilot

Automated Insight Discovery

Copilot in Power BI

AI-Assisted Report Generation

Introduction to Copilot Studio

Building AI Agents

Conversational Workflows

Power Automate Integration

Enterprise AI Automation – Topics , Actions , AI Workflows, Agent Orchestration

Power BI + Power Apps

Power Automate

Dataverse Basics

Low-Code AI Solutions

Infection Monitoring

Vaccination Tracking

ICU Analytics

Interactive Dashboards

Workforce Transformation Insights

Layoff Trend Analysis

AI Automation Impact Visualization

Robot Efficiency Monitoring

SLA Tracking

Fulfillment Analytics

Automation ROI Analysis