Curriculum:

Data Analytics & Value-Added Courses

Formatting options - Font, Alignment,

Lab: Data entry, Fill series options, Copy Paste Special

Referencing, Named ranges, Uses, Arithmetic Functions

Mathematical calculations with cell referencing Arithmetic functions (SUM, SUMIF, SUMIFS,
(Absolute, Relative, Mixed) COUNT, COUNTA, COUNTIFS, AVERAGE,
AVERAGEIFS, MAX, MAXIFS, MIN, MINIFS)
Functions with name range

Lab: Arithmetic and statistical functions

Logical functions

IF NOT
AND IFERROR
OR Usage of mathematical and logical
functions nested together
NESTED IFS
Advanced functions

Combination of arithmetic, logical, lookup functions

Data validation (With dependent drop down)

Lab: Advanced functions

Date and Text Functions

Date functions: DATE, DAY, MONTH, YEAR, YEARFRAC, DATEDIFF, EOMONTH

Text functions:TEXT, UPPER, LOWER, PROPER, LEFT, RIGHT, SEARCH, FIND, MID, TTC, Flash fill

Lab: Date and text functions

SORT
Advanced sort
FILTER

Data Visualization: Conditional formatting, Charts

Charts: Bar, column, lines, scatter, combo, Gantt, waterfall, pie

Lab: Data Visualization: Conditional formatting

Data Summarization: Pivot Report and Charts

Pivot Reports: Insert, Interface, Cross table Reports, Filter, PivotCharts
Slicers: Add, Connect to multiple reports and charts
Calculated field
Calculated item

Lab: Data Visualization: Conditional formatting

Data Summarization: Dashboard Creation, Tips and Tricks

Dashboard: Types, getting reports and charts together, use of slicers

Design and placement: Formatting of tables, charts, sheets, proper use of colours and shapes

Lab: Data Summarization: Dashboard creation

Connecting to Data: Power query, pivot, power pivot within Excel

Power Query: Interface, Tabs

Connecting to data from other excel files, text files, other sources
Data cleaning
Transforming
Loading data into Excel query

Record macro: Name, storage

Record macro to format table (Absolute Ref)
Format table of any size (Relative ref)
Play macro by button, shape, as command (in new tab)
Editing macros
VBA: Introduction to the basics of working with VBA for Excel: Subs, ranges, sheets
Comparing values and conditions, if statements and select cases.
Repeat processes with For loops and Do While or Do Until loops
Communicate with the end-user with message boxes and take user input with input boxes, user form

Lab: Record macro

Interface, Sub-end sub,variable, objects
Message boxes, user form
 MySQL
Introduction to MySQL

Introduction to Databases Different types of RDBMS

Introduction to RDBMS Software Installation (MySQL Workbench)
Explain RDBMS through normalization

SQL Commands and Data Types

Types of SQL Commands (DDL, DML, DQL, DCL, TCL) and their applications
Data Types in SQL (Numeric, Char, Datetime)

DQL & Operators

SELECT: LIMIT, DISTINCT, WHERE, AND, OR, IN, NOT IN, BETWEEN, EXIST, ISNULL, IS NOT NULL,
Wild Cards, ORDER BY

COUNT, SUM, AVG, MIN, MAX, COUNT Date & Time function

Constraints

INOT NULL DEFAULT

UNIQUE Primary key
CHECK Foreign Key (Both at column level and
table level)

Joins

Inner Cross
Left Self joins
Right Full outer join
DDL

Create Truncate
Drop Modify
Alter Comments
Rename

DML & TCL Commands

DML: Insert, Update, and Delete

TCL: Commit, Rollback, Savepoint, and Data Partitioning

Indexes and Views

Indexes (Different Type of Indexes) and Views in SQL

Procedure with IN Parameter

Procedure with OUT parameter
Procedure with INOUT parameter

Window Functions - Rank, Dense Rank, Lead, Lag, Row_number

Union, Intersect, Sub-query

Union Sub Queries

Union all Multiple Query
Intersect

Exception Handling

Handling exceptions in a query

CONTINUE Handler
EXIT

Triggers
 Tableau
Introduction to Tableau

What is Tableau? Data Types, Dimensions, Measures,

Aggregation concept
What is Data Visualization?
Tableau Desktop Installation
Tableau Products
Data Source Overview
Tableau Desktop Variations
Live Vs Extract
Tableau File Extensions

Basic Charts & Formatting

Overview of worksheet sections Text Table, Highlight Table

Formatting: Remove grid lines, hiding the
axes, conversion of numbers to thousands,
millions, Shading, Row divider, Column
divider

Filters

What are Filters? Order of operation of filters

Types of Filters Cascading
Extract, Data Source, Context,
Dimension, Measure, Quick Filters

Lab: Show Bottom 3 Products for Apple

Calculations

Need for calculations

Types: Basic, LOD's, Table
Examples of Basic Calculations: Aggregate functions, Logical functions, String functions, Tableau
calculation functions, numerical functions, Date functions
LOD's: Examples
Table Calculations: Examples
 Data Combining Techniques

What are Data Combining Techniques?

Types
Joins, Relationships, Blending, and Union

Custom Charts

Dual Axis Lollipop Chart

Combined Axis KPI Cards (Simple)
Donut Chart KPI Cards (With Shape)

Lab: Donut Chart

Groups, Bins, Hierarchies, Sets, Parameters

Lab: Parameters in Filters/Sets/Bins

Analytics & Dashboard

Reference Lines
Trend Line
Overview of Dashboard: Tiled Vs Floating
All Objects overview, Layout overview
Dashboard creation with formatting

Lab: Same Dashboard with background image

Dashboard Actions & Tableau Public

Actions: Filter, Highlight, URL, Sheet, Parameter, Set

How to save the workbook to Tableau Public website?

Lab: Filter Action

Power BI
Power BI Introduction and Installation

Understanding Power BI Background

Installation of Power BI and checklist for perfect installation
Formatting and Setting prerequisites
Understanding the difference between Power BI desktop & Power Query

The Power BI user interface, including types of data sources

and visualizations

Getting familiar with the interface BI Query & Desktop

Understanding types of visualization
Loading data from multiple sources

Power BI Artificial Intelligence Visual

Understanding the use of AI in Power BI

AI analysis in Power BI using chart
Q&A chat bot and the use in real life
Hierarchy tree

Lab: Create visuals with the help of AI like Q&A

Smart Narrative
 Power BI Visualization

Understanding Column Chart

Understanding Line Chart
Implementation of Conditional formating
Implementation of Formatting techniques.

Lab: Bar & Column chart differences and Coloring and formatting

Power Query Editor

Loading data from folder

Understanding Power Query in detail
Promote header, Split to limiter, Add columns, append, merge queries, etc.

Lab: Formatting the data and removing unwanted fields

Modelling with Power BI

Lab: Creating relationships with different Cardinality with examples

Power Query Editor Filter Data

Manage Parameter
Introduction to Filter and types of filter
Trend analysis, Future forecast

Lab: Power Query Custom Column (M-Code) and Manage Parameter

Customize the data in Power BI

Understanding tooltip with information

Use and understanding of Drill Down
Visual interaction and customisation of visual interaction

Lab: Usage of drill down & tool tip

 Customize the data in Power BI

Drill through function and usage

Button triggers
Bookmark and different use and implementation
Navigation buttons

Lab: How to create Bookmarks and Navigation buttons

Dax Expressions

Introduction to DAX
Table Dax, Calculated column, DAX measure and difference
Eg:- Calendar, Calendar auto, Summarize, Group by, etc.
Calculated Column

Remove filters, Keep filters, All, Allselected, Time Intelligence Functions,Rolling average,YoY,
Running total

Lab: Creating Visualization and Publishing Power BI Service

Power BI Service

Introduction to app.powerbi.com
Schedule refresh
Data flow and use power bi from online
Download data as live in Powerpoint and more.

Lab: Complete Power BI Online Services

Basic Python Topics
1. Introduction to Python
• History and Features: Overview of Python's background and key
features.
• Installation and Setup: Installing Python, setting up the development
environment, using IDEs.
2. Basic Syntax
• Hello World Program: Writing your first Python script.
• Comments and Docstrings: Single-line comments, multi-line comments,
and docstrings.
• Indentation: Understanding Python's use of indentation to define code
blocks.
3. Variables and Data Types
• Variables: Declaring and assigning values.
• Data Types: Integers, floats, strings, booleans.
• Type Conversion: Converting between data types.
4. Operators
• Arithmetic Operators: +, -, *, /, %, **, //.
• Comparison Operators: ==, !=, >, <, >=, <=.
• Logical Operators: and, or, not.
• Assignment Operators: =, +=, -=, *=, /=, etc.
5. Control Flow
• Conditional Statements: if, elif, else.
• Loops: for, while, break, continue, pass.
6. Data Structures
• Lists: Creating, indexing, slicing, list methods.
• Tuples: Creating, accessing elements, immutability.
• Dictionaries: Key-value pairs, dictionary methods.
• Sets: Creating sets, set operations.
7. Functions
• Defining Functions: Syntax, parameters, return values.
• Arguments: Positional, keyword, default, variable-length arguments.
• Scope and Lifetime: Local and global variables.
8. Modules and Packages
• Importing Modules: Using built-in and third-party modules.
• Creating Modules: Writing and importing custom modules.
• Packages: Organizing modules into packages.
9. File Handling
• Reading Files: Opening and reading files.
• Writing Files: Writing and appending to files.
• File Methods: read(), write(), close(), with statement.
10. Exception Handling
• Try, Except Block: Handling exceptions.
• Finally Block: Code that executes regardless of exceptions.
• Raising Exceptions: Manually raising exceptions.
11. Object-Oriented Programming (OOP)
• Classes and Objects: Defining classes, creating objects.
• Attributes and Methods: Instance and class attributes, instance methods.
• Inheritance: Single and multiple inheritance.
• Polymorphism and Encapsulation: Method overriding, private
variables.
12. Basic Algorithms and Data Manipulation
• Sorting and Searching: Basic sorting and searching algorithms.
• List Comprehensions: Simplified syntax for creating lists.
• Map, Filter, Reduce: Functional programming tools for data
manipulation.
13. Libraries and Frameworks
• Standard Library: Overview of the Python standard library.
• Popular Libraries: Introduction to libraries like NumPy, Pandas,
Matplotlib.
14. Basic Data Science Concepts
• Introduction to Data Science: Basic concepts of data collection,
cleaning, and visualization.
• Basic Statistics: Mean, median, mode, variance, standard deviation.
Advanced Python Topics
1. Advanced Data Structures
• Collections Module: namedtuple, deque, Counter, OrderedDict, defaultdict.
 • Heapq: Heap queue algorithm (priority queue).
• Queue Module: Implementing queue, LifoQueue, PriorityQueue.
2. Advanced Functions
• Decorators: Function decorators and class decorators.
• Generators: Yield, generator functions, generator expressions.
• Closures: Nested functions and closures.
3. Concurrency and Parallelism
• Threading: Creating and managing threads.
• Multiprocessing: Process-based parallelism.
4. File and Data Handling
• CSV, JSON, XML: Reading and writing data in different formats.
• SQL and Databases: Connecting to databases, executing queries.
• HDF5 and Excel: Handling large datasets with HDF5 and Excel files.