Master Data Analytics

MS – Excel

All the type of mathematic works
Table creations
School & collage marksheet
Employee salary statement
Chart
Use of filter
Sheet formatting
Freeze panes
Sort
Pivot table
Employee salary statement maintains with if formula
Lookup formulas
Age calculation
Loan calculation
Total working years calculation
Total working hours calculation
Forecast sheet

Formatting conditional formatting and important Functions

Validation with VLOOKUP formulas
Index with match & index and OFFSET
Consolidation
Intersection LOOKUP
Multiple LOOKUP values
Calculation of running amount
Scenario manager
SUMIF & SUMIFS function
COUNT, COUNTA, COUNT IF, COUNTIFS function

Dashboarding

What is dashboard
Principles of great dashboard design
How to create chart in excel
Chart formatting

Using Macros for Analytics

Mean of data using Macros
Removing Duplicates using macros
Data automatic update in using of macros
Data automatic transfer in more than one sheet

Python Core

Core data types
Print and output
User input
Arithmetic operators
String Methods
Conditional Operators
If/ else /Elif
Collections
For and while loops
Slice operator
Sets
Dictionaries
Comprehensions
Functions
Unpack operators (*args & *kwargs)
Map and filter
F Strings
Reading from and writing to files

Advance Python

Object- Oriented Programming [OOP’s] concept

Class and object
Attributes
Inheritance

Regular expressions

Match function
Search function
Modifiers
Patterns
Array creation

Database

Introduction
Connection
Transactions
Handling error
Merging multiple datasets
Indexing and selecting data

Data visualization using Matplotlib

Line Graphs
Bar plots
Box plot
Stacked plots
Scatter plot
Pie chart
Normal distribution
Introduction to z- text and t- test

MYSQL Fundamentals

Introduction to MySQL:
What is MYSQL? Why use it?
Setting up MYSQL server (installation, configuration)
Basic SQL syntax (SELECT, INSERT, UPDATE, DELETE, etc)
Database and table creation:
Creating databases
Creating tables (defining columns, data types, constraints)
Dropping tables
Data manipulation:
Inserting data into tables
Retrieving data using select statements
Filtering data with where clause
Sorting data with order by
Using operations (AND, OR, NOT, IN, BETWEEN)
Handling NULL values
Updating and deleting records

Advanced SQL (depending on the syllabus level);

Joins (Inner Join, Left Join, Right Join)
Aggregations (Count, Sum, Avg, etc)
Transactions (COMMIT, ROLLBACK)
Indexes (creating, using)

Power BI

Introduction to Power BI:

What is power bi and its components
(desktop, service, Mobile)
The need for business intelligence and the role of Power BI
Installation of Power BI desktop and setting up a Power BI cloud account

Data retrieval and preparation

Connecting to various data sources
(databases, files, cloud services, etc.)
Using power Query editor for data transformation and cleaning
Data types, handling nulls and errors, clearing data using functions.
Importing data from folders

Data Modeling and relationships

Understanding data modelling concepts in power BI
Creating relationships between tables.

Data Analysis Expressing (DAX)

Calculated columns and measures
Row context and filter context in DAX
DAX functions (aggregation, iterator, logical, time intelligence

Report Design and Visualization

Creating compelling visualization (charts, graphs, maps)
Formatting and customizing visualizations.
Using filters, slicers, and drill-downs
Creating interactive reports and dashboards
Using bookmarks and other advanced reporting techniques
Share data with colleagues and others
Publish a report to the web
Manage published reports
Use an app workspace
Create a QR code to share a tile
Embed a report in SharePoint online