Table of Contents
PART 1: COMPLETE COURSE
Module 1: Introduction to AI & Data Visualization
What is Artificial Intelligence?
What is Generative AI?
What is Data Visualization?
Importance of data visualization
Data vs information vs insights
Role of AI in data visualization
Traditional vs AI-powered visualization
Real-world applications
Benefits and limitations of AI visualization
Responsible use of AI
Module 2: Data Visualization Fundamentals
Meaning of visualization
Types of data
Structured and unstructured data
Categorical data
Numerical data
Time-series data
Importance of visual storytelling
Basic visualization principles
Module 3: Understanding Data
Data collection
Data sources
Data fields and records
Data types
Data quality
Missing values
Duplicate data
Outliers
Data consistency
Preparing data for visualization
Module 4: AI Tools for Data Visualization
Introduction to AI visualization tools
AI-assisted chart creation
AI-assisted data analysis
Prompt-based visualization
Choosing appropriate AI tools
Comparing AI visualization workflows
Advantages and limitations of different approaches
Module 5: AI Prompt Engineering for Visualization
What is prompt engineering?
Basic visualization prompts
Context-based prompts
Role-based prompts
Analytical prompts
Chart-generation prompts
Dashboard prompts
Data-storytelling prompts
Creating reusable prompts
Module 6: Data Cleaning for Visualization
Removing duplicates
Handling missing values
Standardizing data
Correcting data formats
Removing unnecessary columns
Identifying incorrect records
AI-assisted data cleaning
Preparing visualization-ready datasets
Module 7: Excel for Data Visualization
Excel interface
Tables
Sorting and filtering
Formatting datasets
Basic formulas
Excel charts
Recommended charts
AI-assisted Excel visualization
Module 8: Basic Chart Types
Column charts
Bar charts
Line charts
Pie charts
Area charts
Scatter charts
Doughnut charts
When to use each chart
Module 9: Advanced Charts
Combo charts
Stacked charts
100% stacked charts
Histogram
Waterfall chart
Funnel chart
Radar chart
Box and whisker chart
AI-assisted chart selection
Module 10: Choosing the Right Chart
Comparison charts
Trend charts
Distribution charts
Relationship charts
Composition charts
Ranking charts
Common chart-selection mistakes
AI recommendations for chart selection
Module 11: Data Visualization Design Principles
Simplicity
Consistency
Alignment
Visual hierarchy
Appropriate scale
Labels
Titles
Legends
Avoiding misleading charts
Module 12: AI-Assisted Data Analysis
Asking AI analytical questions
Finding trends
Identifying patterns
Finding anomalies
Comparing categories
Summarizing datasets
Generating analytical observations
Converting analysis into visualizations
Module 13: Time-Series Visualization
Understanding time-series data
Daily trends
Weekly trends
Monthly trends
Quarterly trends
Yearly trends
Trend lines
Moving averages
AI-assisted trend analysis
Module 14: Comparison Visualization
Product comparison
Regional comparison
Employee comparison
Salesperson comparison
Year-over-year comparison
Budget vs actual
Target vs achievement
AI-assisted comparison analysis
Module 15: Distribution Visualization
Frequency distributions
Histograms
Box plots
Quartiles
Median
Outlier identification
Distribution interpretation
AI-assisted distribution analysis
Module 16: Relationship & Correlation Visualization
Understanding correlation
Scatter plots
Positive correlation
Negative correlation
No correlation
Trend lines
Correlation interpretation
AI-assisted relationship analysis
Module 17: Geographic & Location Visualization
Geographic data
Regional analysis
State-wise data
City-wise data
Map visualization concepts
Location-based KPIs
AI-assisted geographic insights
Module 18: KPI Visualization
What is a KPI?
KPI selection
KPI cards
Target vs actual
Growth percentage
Achievement percentage
Performance indicators
AI-assisted KPI recommendations
Module 19: Data Storytelling
What is data storytelling?
Story structure
Beginning, middle and conclusion
Finding the main message
Supporting evidence
Visual narrative
AI-generated storylines
Presenting insights effectively
Module 20: Interactive Visualization
Interactive charts
Filters
Dropdowns
Slicers
Drill-down concepts
Interactive reports
User-driven analysis
AI-assisted interaction design
Module 21: Dashboard Fundamentals
What is a dashboard?
Dashboard types
Operational dashboards
Analytical dashboards
Strategic dashboards
Dashboard components
Dashboard layout
Dashboard planning
Module 22: AI-Assisted Dashboard Design
Dashboard requirements
AI-generated dashboard layouts
KPI selection
Chart selection
Filter selection
Visual hierarchy
Dashboard improvement using AI
Module 23: Sales Data Visualization
Sales dataset
Product-wise sales
Region-wise sales
Customer-wise sales
Monthly sales
Sales targets
Sales performance
AI-generated sales insights
Module 24: Financial Data Visualization
Revenue visualization
Expense visualization
Profit visualization
Cash-flow visualization
Budget vs actual
Profit margin
Financial KPIs
AI-assisted financial insights
Module 25: Marketing Data Visualization
Marketing datasets
Leads
Conversions
Campaign performance
Customer acquisition
Marketing ROI
Campaign comparison
AI-generated marketing insights
Module 26: HR Data Visualization
Employee datasets
Department analysis
Attendance
Salary
Employee turnover
Performance
Recruitment
HR dashboards
Module 27: Inventory Data Visualization
Stock levels
Product movement
Inventory value
Low-stock analysis
Reorder levels
Fast-moving products
Slow-moving products
Inventory dashboard
Module 28: AI Forecasting Visualization
Forecasting concepts
Historical trends
Future predictions
Forecast charts
Sales forecasting
Demand forecasting
Forecast interpretation
AI-assisted predictive visualization
Module 29: Advanced Excel Visualization
Advanced formulas for analysis
Dynamic charts
Dynamic ranges
Conditional formatting
Interactive dashboards
PivotCharts
Slicers
AI-assisted Excel visualization
Module 30: Power Query for Visualization
Introduction to Power Query
Importing data
Cleaning data
Transforming data
Combining files
Merging data
Appending data
Refreshable datasets
Module 31: Power BI Fundamentals
What is Power BI?
Power BI interface
Importing data
Data modeling basics
Reports
Visualizations
Filters
Slicers
Dashboards
Module 32: AI + Power BI Visualization
AI-assisted Power BI analysis
Asking analytical questions
Choosing visuals
Generating insights
Report improvement
AI-assisted dashboard planning
Business storytelling
Module 33: Advanced Dashboard Development
Dashboard wireframes
Multi-page dashboards
Navigation
Interactive filters
KPI cards
Drill-through concepts
Dashboard optimization
Professional presentation
Module 34: Data Visualization for Business Intelligence
Business intelligence concepts
Descriptive analytics
Diagnostic analytics
Predictive analytics
Prescriptive analytics
Decision-making dashboards
AI-assisted BI analysis
Module 35: Automated Data Visualization
Automated reports
Refreshable dashboards
Automated chart updates
Recurring reports
Data-refresh workflows
AI-assisted reporting
Reducing manual work
Module 36: AI for Visualization Quality Control
Detecting misleading charts
Checking data accuracy
Identifying unusual values
Checking labels
Checking scales
Improving chart readability
AI-based visualization review
Module 37: Advanced Data Storytelling Project
Selecting a dataset
Identifying the business question
Data preparation
Analysis
Visualization
Story development
AI-generated insights
Final presentation
Module 38: Business Dashboard Project
Dataset selection
Data cleaning
KPI identification
Chart selection
Dashboard development
Interactive controls
AI-assisted analysis
Management summary
Module 39: AI Data Visualization Capstone
Data collection
Data cleaning
AI-assisted analysis
Chart creation
Dashboard development
Forecasting
Business insights
Data storytelling
Final report
Module 40: Professional AI Data Visualization Project
Complete real-world dataset
Data preparation
AI-assisted analysis
Advanced visualization
Interactive dashboard
KPI reporting
Forecasting
AI-generated recommendations
Executive summary
Final presentation
Viva and practical examination
PART 2: COMPLETE ASSIGNMENTS
Assignment 1: Introduction to AI Data Visualization
Assignment 2: Identify Data Types
Assignment 3: Data Understanding
Assignment 4: AI Visualization Tools
Assignment 5: Visualization Prompt Writing
Assignment 6: Data Cleaning Project
Assignment 7: Excel Data Visualization
Assignment 8: Basic Charts Practice
Assignment 9: Advanced Charts
Assignment 10: Right Chart Selection
Assignment 11: Professional Chart Design
Assignment 12: AI Data Analysis
Assignment 13: Monthly Sales Trend
Assignment 14: Product Comparison
Assignment 15: Distribution Analysis
Assignment 16: Correlation Analysis
Assignment 17: Regional Visualization
Assignment 18: KPI Dashboard
Assignment 19: Data Storytelling
Assignment 20: Interactive Visualization
Assignment 21: Dashboard Planning
Assignment 22: AI Dashboard Design
Assignment 23: Sales Visualization Dashboard
Assignment 24: Financial Visualization Dashboard
Assignment 25: Marketing Dashboard
Assignment 26: HR Dashboard
Assignment 27: Inventory Dashboard
Assignment 28: AI Forecasting Visualization
Assignment 29: Advanced Excel Dashboard
Assignment 30: Power Query Visualization Dataset
Assignment 31: Power BI Basic Report
Assignment 32: AI + Power BI Analysis
Assignment 33: Advanced Interactive Dashboard
Assignment 34: Business Intelligence Report
Assignment 35: Automated Visualization Report
Assignment 36: Visualization Quality Audit
Assignment 37: Data Storytelling Project
Assignment 38: Complete Business Dashboard Project
Assignment 39: AI Data Visualization Capstone
Assignment 40: Final Professional Project
Table of Contents
PART 1: COMPLETE COURSE
Module 1: Introduction to AI & Data Visualization
What is Artificial Intelligence?
What is Generative AI?
What is Data Visualization?
Importance of data visualization
Data vs information vs insights
Role of AI in data visualization
Traditional vs AI-powered visualization
Real-world applications
Benefits and limitations of AI visualization
Responsible use of AI
Module 2: Data Visualization Fundamentals
Meaning of visualization
Types of data
Structured and unstructured data
Categorical data
Numerical data
Time-series data
Importance of visual storytelling
Basic visualization principles
Module 3: Understanding Data
Data collection
Data sources
Data fields and records
Data types
Data quality
Missing values
Duplicate data
Outliers
Data consistency
Preparing data for visualization
Module 4: AI Tools for Data Visualization
Introduction to AI visualization tools
AI-assisted chart creation
AI-assisted data analysis
Prompt-based visualization
Choosing appropriate AI tools
Comparing AI visualization workflows
Advantages and limitations of different approaches
Module 5: AI Prompt Engineering for Visualization
What is prompt engineering?
Basic visualization prompts
Context-based prompts
Role-based prompts
Analytical prompts
Chart-generation prompts
Dashboard prompts
Data-storytelling prompts
Creating reusable prompts
Module 6: Data Cleaning for Visualization
Removing duplicates
Handling missing values
Standardizing data
Correcting data formats
Removing unnecessary columns
Identifying incorrect records
AI-assisted data cleaning
Preparing visualization-ready datasets
Module 7: Excel for Data Visualization
Excel interface
Tables
Sorting and filtering
Formatting datasets
Basic formulas
Excel charts
Recommended charts
AI-assisted Excel visualization
Module 8: Basic Chart Types
Column charts
Bar charts
Line charts
Pie charts
Area charts
Scatter charts
Doughnut charts
When to use each chart
Module 9: Advanced Charts
Combo charts
Stacked charts
100% stacked charts
Histogram
Waterfall chart
Funnel chart
Radar chart
Box and whisker chart
AI-assisted chart selection
Module 10: Choosing the Right Chart
Comparison charts
Trend charts
Distribution charts
Relationship charts
Composition charts
Ranking charts
Common chart-selection mistakes
AI recommendations for chart selection
Module 11: Data Visualization Design Principles
Simplicity
Consistency
Alignment
Visual hierarchy
Appropriate scale
Labels
Titles
Legends
Avoiding misleading charts
Module 12: AI-Assisted Data Analysis
Asking AI analytical questions
Finding trends
Identifying patterns
Finding anomalies
Comparing categories
Summarizing datasets
Generating analytical observations
Converting analysis into visualizations
Module 13: Time-Series Visualization
Understanding time-series data
Daily trends
Weekly trends
Monthly trends
Quarterly trends
Yearly trends
Trend lines
Moving averages
AI-assisted trend analysis
Module 14: Comparison Visualization
Product comparison
Regional comparison
Employee comparison
Salesperson comparison
Year-over-year comparison
Budget vs actual
Target vs achievement
AI-assisted comparison analysis
Module 15: Distribution Visualization
Frequency distributions
Histograms
Box plots
Quartiles
Median
Outlier identification
Distribution interpretation
AI-assisted distribution analysis
Module 16: Relationship & Correlation Visualization
Understanding correlation
Scatter plots
Positive correlation
Negative correlation
No correlation
Trend lines
Correlation interpretation
AI-assisted relationship analysis
Module 17: Geographic & Location Visualization
Geographic data
Regional analysis
State-wise data
City-wise data
Map visualization concepts
Location-based KPIs
AI-assisted geographic insights
Module 18: KPI Visualization
What is a KPI?
KPI selection
KPI cards
Target vs actual
Growth percentage
Achievement percentage
Performance indicators
AI-assisted KPI recommendations
Module 19: Data Storytelling
What is data storytelling?
Story structure
Beginning, middle and conclusion
Finding the main message
Supporting evidence
Visual narrative
AI-generated storylines
Presenting insights effectively
Module 20: Interactive Visualization
Interactive charts
Filters
Dropdowns
Slicers
Drill-down concepts
Interactive reports
User-driven analysis
AI-assisted interaction design
Module 21: Dashboard Fundamentals
What is a dashboard?
Dashboard types
Operational dashboards
Analytical dashboards
Strategic dashboards
Dashboard components
Dashboard layout
Dashboard planning
Module 22: AI-Assisted Dashboard Design
Dashboard requirements
AI-generated dashboard layouts
KPI selection
Chart selection
Filter selection
Visual hierarchy
Dashboard improvement using AI
Module 23: Sales Data Visualization
Sales dataset
Product-wise sales
Region-wise sales
Customer-wise sales
Monthly sales
Sales targets
Sales performance
AI-generated sales insights
Module 24: Financial Data Visualization
Revenue visualization
Expense visualization
Profit visualization
Cash-flow visualization
Budget vs actual
Profit margin
Financial KPIs
AI-assisted financial insights
Module 25: Marketing Data Visualization
Marketing datasets
Leads
Conversions
Campaign performance
Customer acquisition
Marketing ROI
Campaign comparison
AI-generated marketing insights
Module 26: HR Data Visualization
Employee datasets
Department analysis
Attendance
Salary
Employee turnover
Performance
Recruitment
HR dashboards
Module 27: Inventory Data Visualization
Stock levels
Product movement
Inventory value
Low-stock analysis
Reorder levels
Fast-moving products
Slow-moving products
Inventory dashboard
Module 28: AI Forecasting Visualization
Forecasting concepts
Historical trends
Future predictions
Forecast charts
Sales forecasting
Demand forecasting
Forecast interpretation
AI-assisted predictive visualization
Module 29: Advanced Excel Visualization
Advanced formulas for analysis
Dynamic charts
Dynamic ranges
Conditional formatting
Interactive dashboards
PivotCharts
Slicers
AI-assisted Excel visualization
Module 30: Power Query for Visualization
Introduction to Power Query
Importing data
Cleaning data
Transforming data
Combining files
Merging data
Appending data
Refreshable datasets
Module 31: Power BI Fundamentals
What is Power BI?
Power BI interface
Importing data
Data modeling basics
Reports
Visualizations
Filters
Slicers
Dashboards
Module 32: AI + Power BI Visualization
AI-assisted Power BI analysis
Asking analytical questions
Choosing visuals
Generating insights
Report improvement
AI-assisted dashboard planning
Business storytelling
Module 33: Advanced Dashboard Development
Dashboard wireframes
Multi-page dashboards
Navigation
Interactive filters
KPI cards
Drill-through concepts
Dashboard optimization
Professional presentation
Module 34: Data Visualization for Business Intelligence
Business intelligence concepts
Descriptive analytics
Diagnostic analytics
Predictive analytics
Prescriptive analytics
Decision-making dashboards
AI-assisted BI analysis
Module 35: Automated Data Visualization
Automated reports
Refreshable dashboards
Automated chart updates
Recurring reports
Data-refresh workflows
AI-assisted reporting
Reducing manual work
Module 36: AI for Visualization Quality Control
Detecting misleading charts
Checking data accuracy
Identifying unusual values
Checking labels
Checking scales
Improving chart readability
AI-based visualization review
Module 37: Advanced Data Storytelling Project
Selecting a dataset
Identifying the business question
Data preparation
Analysis
Visualization
Story development
AI-generated insights
Final presentation
Module 38: Business Dashboard Project
Dataset selection
Data cleaning
KPI identification
Chart selection
Dashboard development
Interactive controls
AI-assisted analysis
Management summary
Module 39: AI Data Visualization Capstone
Data collection
Data cleaning
AI-assisted analysis
Chart creation
Dashboard development
Forecasting
Business insights
Data storytelling
Final report
Module 40: Professional AI Data Visualization Project
Complete real-world dataset
Data preparation
AI-assisted analysis
Advanced visualization
Interactive dashboard
KPI reporting
Forecasting
AI-generated recommendations
Executive summary
Final presentation
Viva and practical examination
PART 2: COMPLETE ASSIGNMENTS
Assignment 1: Introduction to AI Data Visualization
Assignment 2: Identify Data Types
Assignment 3: Data Understanding
Assignment 4: AI Visualization Tools
Assignment 5: Visualization Prompt Writing
Assignment 6: Data Cleaning Project
Assignment 7: Excel Data Visualization
Assignment 8: Basic Charts Practice
Assignment 9: Advanced Charts
Assignment 10: Right Chart Selection
Assignment 11: Professional Chart Design
Assignment 12: AI Data Analysis
Assignment 13: Monthly Sales Trend
Assignment 14: Product Comparison
Assignment 15: Distribution Analysis
Assignment 16: Correlation Analysis
Assignment 17: Regional Visualization
Assignment 18: KPI Dashboard
Assignment 19: Data Storytelling
Assignment 20: Interactive Visualization
Assignment 21: Dashboard Planning
Assignment 22: AI Dashboard Design
Assignment 23: Sales Visualization Dashboard
Assignment 24: Financial Visualization Dashboard
Assignment 25: Marketing Dashboard
Assignment 26: HR Dashboard
Assignment 27: Inventory Dashboard
Assignment 28: AI Forecasting Visualization
Assignment 29: Advanced Excel Dashboard
Assignment 30: Power Query Visualization Dataset
Assignment 31: Power BI Basic Report
Assignment 32: AI + Power BI Analysis
Assignment 33: Advanced Interactive Dashboard
Assignment 34: Business Intelligence Report
Assignment 35: Automated Visualization Report
Assignment 36: Visualization Quality Audit
Assignment 37: Data Storytelling Project
Assignment 38: Complete Business Dashboard Project
Assignment 39: AI Data Visualization Capstone
Assignment 40: Final Professional Project
