Foundations of Data Analytics

Duration : 3 Hrs
Module Topics Time Allocation
(Hrs)
Definition and importance in decision-making
Introduction to Data
Understand key terminologies related to data - Data ingestion (acquisition), 0.5
Analytics
Data transformation, and Data serving
Structured, unstructured, semi-structured data
Data Types and Data
Basics of data collection and storage 0.5
Sources
Different data sources - databases, APIs, web scraping, etc.
Explore Data repositories like data lakes, warehouses, and pipelines
Data Cleaning and
Overview of ETL process, Data Wrangling, Data Mining etc. 0.5
Preprocessing
Identifying and handling missing values, outliers, and inconsistencies
Data Exploration and Understanding Exploratory Data Analysis (EDA) and its significance
0.5
Visualization Communicating insights through visual representations
Introduction to Data Introduction to Power BI/Tableau/for Visualization
0.5
Analytics Tools Building interactive dashboards
Real-World Applications Real-life examples showcasing the application of data analytics in various
0.5
domains

Microsoft Excel for Data Analysis

Duration : 20 Hrs
Module Topics Time Allocation
(Hrs)
Introduction to Excel Excel for Data Analytics 1
Navigating Worksheets and Cells

Entering and Editing Data

Formatting Cells and Worksheets
Basic Formulas and Functions
Working with Worksheets and Workbooks
Saving and Sharing Workbooks
Basic Functions and Mathematical Functions
2
Formulas in Excel
Statistical Functions
Logical Functions
Text Functions
Date and Time Functions
Lookup and Reference Functions
Data Entry and Sorting and Filtering
Manipulation in Excel 1

Working with Tables

Data Validation
Removing Duplicates
Text-to-Columns and Data Conversion

Combining and Splitting Data

Advanced Functions Logical Functions for Advanced Analysis
2
and Formulas in Excel
Array Formulas
 Financial Functions
Statistical Functions for Advanced Analysis
Date and Time Functions for Advanced Analysis

Text Functions for Advanced Data Manipulation

Data Cleaning and Dealing with Missing Values

1
Preparation in Excel
Removing Duplicates and Handling Inconsistent Data
Correcting Errors and Outliers
Data Transformation and Restructuring
Data Integration and Merging
Data Validation and Quality Checks
PivotTables and Creating a PivotTable
2
PivotCharts in Excel
Analyzing Data with PivotTables
Using Slicers and Timelines
Formatting and Customizing PivotTables
Working with PivotCharts
Data Visualization with
Importance of Data Visualization 1
Excel
Creating Basic Charts
Advanced Chart
Conditional Formatting and Data Bars
Sparklines

Data Visualization with Advanced Column and Bar Charts

Advanced Charts in 2
Excel
Advanced Line and Area Charts
Advanced Scatter and Bubble Charts
Advanced Pie and Donut Charts
Advanced Radar and Spider Charts
Interactive Dashboards with Advanced Charts
Excel Macros and Recording and Running Macros
3
Automation
Editing Macros
Creating User-Defined Functions (UDFs)
Automating Data Import and Export
Interacting with Other Applications
Error Handling and Debugging
Advanced VBA Looping, Conditional Statements, and Functions 3
Connecting Excel to Connecting to Databases, Querying Data, and Managing Data
3
Various Data Sources
Connecting to Python
Connecting to Power BI

Python for Data Analysis

Duration : 30 Hrs
Module Topics Time Allocation
(Hrs)
Introduction to Python Introduction to Python programming language

6
Introduction to Python
Basics of Python
Python packages
6
Variables, data types, and basic operations
Control structures: loops and conditional statements
Functions and basic error handling
Data Analysis with Introduction to NumPy for numerical computing
NumPy and Pandas Manipulating arrays and basic operations with NumPy
6
Introduction to Pandas for data manipulation and analysis
Loading, inspecting, and cleaning data with Pandas
Data Visualization with Introduction to data visualization
Matplotlib and Seaborn Visualization tools - Area Plots, Histogram, Bar chart, Pie chart, Scatter plots etc.
6
Basic plots using Matplotlib
Customizing plots: labels, colors, and styles
Exploratory data analysis using Seaborn
Data Analysis and Data aggregation, grouping, and summarization with Pandas
Statistics with Pandas Statistical analysis with Pandas: descriptive statistics, correlation, and hypothesis testing 6
Time series data analysis with Pandas
Creating Dashboards Overview of dashboards and Plotly
3
with Plotly and Dash Create interactive dashboard

SQL
Duration : 18 Hrs
Module Topics Time Allocation
(Hrs)
Introduction to SQL Data, Datasets, Databases
Difference Between DBMS and RDBMS
Introduction to Datatypes and Constraints
3
Creation of Databases and Tables
Components of SQL - DDL, DML, DCL, TCL, DQL
Difference Between Delete, Drop and Truncate
SQL Querying and Optimization
ALTER, WHERE Clause, ALIAS ,LIMIT
Operators - Arithmetic, Comparison, Logical
GROUP BY and ORDER BY Clause 3
Aggregate Functions and HAVING Clause
NULL and INDEX
Advanced SQL Query CASE WHEN Expression - Simple and Searched
Techniques and Set SET Operators - UNION/UNION ALL/INTERSECT/EXCEPT
3
Operations SUBQUERIES
JOINS - INNER/LEFT/RIGHT/OUTER/CROSS/SELF
Advanced SQL Query Common Table Expressions (CTE)
Optimization and Views
Database Design Windows Function - Row_Number(), Rank(), Dense_Rank(), Lead(), Lag(),
First_Value()
6
Last_Value()
Transaction - ACID Properties
Normalization - 1NF, 2NF, 3NF, BCNF
Order of Execution for the Query
SQL Advanced Topics: Basics of Stored Procedure
Procedures, Triggers, Basics of Triggers
and Integrations Storage Engine
3
Integration of SQL with Excel
Integration of SQL with Python
SQL Advanced Topics:
Procedures, Triggers,
and Integrations
3

Integration of SQL with Power BI

Microsoft Power BI Data Analyst

Duration : 24 Hrs
Module Topics Time Allocation
(Hrs)
Introduction
Overview of data analysis
Discover data analysis 1
Roles in data
Tasks of a data analyst
Introduction
Get started building Use Power BI
1
with Power BI Building blocks of Power BI
Tour and use the Power BI service"
Introduction
Get data from files
Get data from relational data sources
Create dynamic reports with parameters
Get data from a NoSQL database
Get data in Power BI Get data from online services 1
Select a storage mode
Get data from Azure Analysis Services
Fix performance issues
Resolve data import errors
Exercise - Prepare data in Power BI Desktop
Introduction
Shape the initial data
Simplify the data structure
Clean, transform, and Evaluate and change column data types
3
load data in Power BI Combine multiple tables into a single table
Profile data in Power BI
Use Advanced Editor to modify M code
Exercise - Load data in Power BI Desktop
Introduction
Work with tables
Create a date table
Work with dimensions
Design a data model in Power BI 1
Define data granularity
Work with relationships and cardinality
Resolve modeling challenges
Exercise - Model data in Power BI Desktop
Introduction
Create simple measures
Add measures to Power Create compound measures
2
BI Desktop models Create quick measures
Compare calculated columns with measures
Exercise - Create DAX Calculations in Power BI Desktop
Introduction
Add calculated tables
Create calculated columns
and columns to Power 1
Learn about row context
BI Desktop models
Choose a technique to add a column
Use DAX time Introduction
intelligence functions in
2
Power BI Desktop
models
Use DAX time
intelligence functions in Use DAX time intelligence functions
2
Power BI Desktop Additional time intelligence calculations
models Exercise - Create Advanced DAX Calculations in Power BI Desktop
Introduction to performance optimization
Review performance of measures, relationships, and visuals
Optimize a model for
Use variables to improve performance and troubleshooting
performance in Power 1
Reduce cardinality
BI
Optimize DirectQuery models with table level storage
Create and manage aggregations
Introduction
Design the analytical report layout
Design visually appealing reports
Report objects
Design Power BI reports Select report visuals 2
Select report visuals to suit the report layout
Format and configure visualizations
Work with key performance indicators
Exercise - Design a report in Power BI desktop
Introduction to designing reports for filtering
Apply filters to the report structure
Apply filters with slicers
Configure Power BI
Design reports with advanced filtering techniques 1
report filters
Consumption-time filtering
Select report filter techniques
Case study - Configure report filters based on feedback
Design reports to show details
Design reports to highlight values
Design reports that behave like apps
Work with bookmarks
Enhance Power BI
Design reports for navigation
report designs for the 2
Work with visual headers
user experience
Design reports with built-in assistance
Tune report performance
Optimize reports for mobile use
Exercise - Enhance Power BI reports
Introduction to analytics
Explore statistical summary
Identify outliers with Power BI visuals
Group and bin data for analysis
Perform analytics in Apply clustering techniques
1
Power BI Conduct time series analysis
Use the Analyze feature
Create what-if parameters
Use specialized visuals
Exercise - Perform Advanced Analytics with AI Visuals
Introduction
Distribute a report or dashboard
Create and manage Monitor usage and performance
2
workspaces in Power BI Recommend a development life cycle strategy
Troubleshoot data by viewing its lineage
Configure data protection
Introduction
Use a Power BI gateway to connect to on-premises data sources

Manage datasets in Power BI 1

 Configure a dataset scheduled refresh
Manage datasets in Power BI
Configure incremental refresh settings 1
Manage and promote datasets
Troubleshoot service connectivity
Boost performance with query caching (Premium)
Introduction to dashboards
Configure data alerts
Explore data by asking questions
Review Quick insights
Create dashboards in Add a dashboard theme
1
Power BI Pin a live report page to a dashboard
Configure a real-time dashboard
Configure data classification
Set mobile view
Exercise - Create a Power BI dashboard
Introduction
Implement row-level Configure row-level security with the static method
1
security Configure row-level security with the dynamic method
Exercise - Enforce row-level security in Power BI