Data Analytics

- Basic Analytics with Excel, Basic functions
- IF function, Vlook up, CountIF, SUMIF
- Condition Formatting , Chart formatting,Sparklines
- Dashboard/ Report in Excel with Pivot charts/tables, slicers, 
- Project : Dashboard of Staff Performance Analysis 

- Python Installation, Anakonda - Jupyter notebook
- Python Core: Objects,Number & Boolean, Strings,Container objects, Mutable objects
- Operators - Arithmetic,Bitwise,comparison andAssignment
- Context Module Sub Header
- Operators,Operators Precedence and associativity.
- Context Module Sub Header
- Conditions(If else,if-elif-else),Loops(While ,for),
- Context Module Sub Header
- Context Module Sub Header, Range functions
- StringObjects and collections
- List object basics
- Tuples,Set,Dictionaries&Functions
- OOPS concepts&WorkingwithFiles
- Objects and Classes ,Classes and Methods
- Visualisation : Mathplotlib,Seaborn, Plotly
- Python pandas: series, dataframe, basic functionality
- Read, write files, load data with pandas
- Exploratory Data Analysis 
- Python Project : Data Analytics

- SQL server Installation
- DDL , DML , DCL concept
- RDBMS , Database , Management studio concept
- Data Types
- Create tables, database
- Fundamental SQL Statements,Select,Update,LIKE,DISTINCT
- Selection Commands: Filtering
- Selection Commands: Ordering
- Subqueries 
- ORDER BY, GROUP BY
- Mathematical Functions 
- Conditional Statement
- Joins, self join, left , right join
- Date and Time Functions 
- String Functions 

·  Business Intelligence (BI) Concepts.
·  Microsoft Power BI (MSPBI) introduction.
·  Power BI introduction and overview.
·  Power BI Architecture Detail.
·  Power BI Pro Premium comparison.
·  Power BI – Building Blocks.
Power BI Desktop Installation
Importing Data into Power BI
• Import data from excel file
• Import data from text
• Import data from csv
• Import data from pdf
• Import data from access files
• Loading data to data model
Transformation in built in query
• In built column transformation
• In built Row transformation
• Filtering selected rows in power query
Other Built in transformations- 1hr
• Text transformation
• Number transformation
• Date transformation
• Conditional columns
Multiple data sources/queries
• Introduction to append/duplicate/ Queries
• Append multiple files individually with different queries
• Importing multiple files from a folder using single query
• Append the data from Multiple excel sheets & Multiple files in folder
Merge queries/Multiple joins in power query
• Inner, Left, Right outer joins
• Left, Right anti joins
• Cross joins
Data Modelling
• Modelling
• How to manage your data relationships
• Create calculated columns
• Optimizing Data Models for Better visuals
• Create measures and work with time-based functions
• Explore Time-Based Data
DAX
• Introduction to DAX
• DAX Calculation types
• DAX Functions
• Using variables in DAX Expressions
• DAX Tables and Filtering
• DAX Functionality Review
• Review Of Calculated Column
• Review Of Measure
• Rules Of DAX Measure
Contexts In Relationships
• Working with Many Tables
• Row Context & Relationships
• Filter Context & Relationships
• Values Function
Time Intelligence Calculations
• Working With Date Tables
• Calculating Operating Periods
• DAX Date Functions
• Advanced Date Functions
• Prior Year Functions
• Moving Averages
Visualizations 
• Create and customize simple visualizations
• How to use Combination Charts
• Create and format slicers
• How to use map visualizations
• How to use tables and Matrixes
• How to used scatter charts
• How to use water fall and funnel charts
• How to use single number card
• How to use single Date card
• How to use single Text card
• How to modify colours in charts and visuals
• Style your Reports with Shapes, Text boxes and Images
• Style your reports with page layout and formatting
• Create Complex Interaction between Visualizations
• Duplicate a Report Page
• Customize visuals with Summarization and Category Options
• Visual hierarchies and drill down behaviour

•  Use quick insights in the Power BI Service
•  Logging in to Power BI Service
•  Publishing and sharing
•  Publish Reports from Power bi desktop
•  Print and Export Power bi dashboard
•  Create and configure a dashboard
•  Ask questions of your data with Natural language
•  Share dashboards with your organization
•  Display visuals and tiles full-screen
•  Get more space on your dashboard
•  Continuing our Work and why we need Power BI Service.
Project : Retail Industry
Project : HR Analytics
Project in Food and Beverage Industry

Getting started with Tableau
• Tableau Product Suit
• Installation of Tableau public
• Tableau Desktop Professional Edition
• Explore Tableau Desktop
• Importing datasets
• Data blending, Relations and Joins, Unions
• Designing principles
• Basic data formatting
• Dimensions and Measures
• Visualization in Tableau.
• Advance visual
• LOD
• String calculations
• data calculations
• Table calculations
• Group, Set
• Data Hierarchies
• Analytics in Tableau
• Filters
• Special types of charts
• Parameters in Tableau
• Sorting with parameters
• Building dashboards with actions
• Building Story
• Publish Dashboards on tableau public
Project : Dashboard and Story on Retail Industry