AI

Master Data Analytics

This 5-month comprehensive course will immerse you in the core concepts and advanced techniques of Data Analytics, including data cleaning, exploration, statistical analysis, and visualization. You'll learn how to leverage the power of data to make informed business decisions and gain hands-on experience with real-world datasets using industry-standard tools such as Python, SQL, Tableau, and Excel.

Request Syllabus Back to Courses
Master Data Analytics
Duration5 months
Lessons250
Levelintermediate
ModeLive Online

What you will learn

  • Introduction to Data Analytics
  • Data Cleaning and Preprocessing
  • Exploratory Data Analysis (EDA)
  • Statistical Analysis and Hypothesis Testing
  • Data Visualization with Tableau, Power BI, and Python
  • Time Series Analysis
  • SQL for Data Analytics
  • Advanced Excel for Data Analysis
  • Big Data and Cloud Analytics
  • Data-Driven Decision Making
  • Reporting and Dashboards
  • Data Ethics and Governance

Corporate training outcomes

  • Completion certificate
  • Practical assignments and project work
  • Mentor support and progress tracking
  • Custom batch options for teams
  • Yes

Requirements

  • Laptop with internet access
  • Basic understanding of programming (preferably Python)
  • Familiarity with mathematics (basic statistics)
  • Curiosity to explore data-driven decision-making
  • Willingness to work with real-world datasets and solve business problems

Curriculum

Course Introduction
  • Welcome to the course
  • Platform Overview
Introduction to the Data Analytics
  • What is Data & Data Analytics?
  • Global Scope of Data Analysis
  • Data Analytics in Different Domains
  • Understanding the vision of stakeholders and asking effective questions
  • Road Map to be a Data Analyst
  • Role Of Data Analyst?
  • Data Analyst vs Business Analyst
  • What is BI and Its Importance?
  • BI Tools and Techniques
  • Data Analysis Methods
  • Types of Data Analysis
  • Data Analysis Process
Data Analysis Jargon
  • Understanding Data Modelling
  • Exploring Data Mining Techniques
  • Importance of Data Wrangling
  • Concept of Data Warehouse
  • Architecture of Data Warehouse
  • Comparing OLTP & OLAP
Data Sources
  • Sources of data and external methods of data collection
  • Primary data collection techniques
  • Secondary data sources
  • Different types of data
Introduction to MySql
  • Overview of Databases and their Types
  • Difference between DBMS and RDBMS
  • Installation process
  • MySQL User Interface
SQL Commands
  • Data Definition Language (DDL)
  • Data Manipulation Language (DML)
  • Data Query Language (DQL)
  • Transaction Control Language (TCL)
  • Data Control Language (DCL)
SQL Data Types
  • Numeric Data Types
  • Character Data Types
  • Date Data Types
  • DateTime Data Types
  • Boolean Data Types
Data Loading
  • Table Import Wizard Tool
  • Query-Based Importing
Operators in SQL
  • Mathematical Operators
  • Comparison Operators
  • Logical Operators
  • Operators for Negating Conditions
Constraints
  • Primary Key Constraint
  • Foreign Key Constraint
  • Unique Constraint
  • DEFAULT Constraint
  • Not Null Constraint
  • Check Constraint
Advanced constraints
  • Artificial Key
  • Composite Key
  • Super Key
  • Indexing Techniques
Set Operators
  • Intersect Operator
  • Except Operator
  • Union Operator
  • Union All Operator
Joins
  • Self Join
  • Inner Join
  • Left Join
  • Right Join
  • Full Outer Join
  • Cross Join
  • Natural Join
Subqueries
  • Using FROM and WHERE Clauses
  • Correlated Subqueries
  • Filtering Query Results from Different Tables
  • Order of Execution in SQL
Case Statement and Temporary Tables
  • Case Statement in SQL
  • Temporary Tables
  • Common Table Expressions (CTE)
  • Recursive CTE in SQL
Window Functions
  • Partitioning in SQL
  • Rank and Dense Rank Functions
  • Row Number Function
  • Lead and Lag Functions
  • Min, Max, Avg, Count Aggregates
  • Unbounded Preceding, Preceding, Following in Window Functions
Stored Procedures
  • Return Type - Non-Parametric Functions
  • Return Type - Parametric Functions
  • Non-Return Type - Non-Parametric Functions
  • Non-Return Type - Parametric Functions
Functions
  • System Functions in SQL
  • User-Defined Functions
  • Predefined Functions
  • Arithmetic Functions in SQL
  • Logical and Error Functions
  • Date Functions in SQL
  • Mathematical Functions
  • Text Functions
  • Statistical Functions
  • Database Functions and Arrays
  • Introduction to Functions
  • Built-In Functions
  • User-Defined Functions (Revisited)
  • Anonymous Functions (Lambda Functions)
  • Recursive Functions
Views and Cursor
  • Views in SQL
  • Cursor in SQL
Triggers
  • Insert Operations in SQL
  • Update Operations in SQL
  • Delete Operations in SQL
Data Modelling
  • Introduction to ER Diagrams
  • Mapping Constraints in ER Modeling
  • Cardinality in ER Diagrams
  • Relational Model Concepts
Normalization
  • First Normal Form (1NF)
  • Second Normal Form (2NF)
  • Third Normal Form (3NF)
  • Boyce-Codd Normal Form (BCNF)
Project & Practice
  • Facebook Database &Analysis Using SQL
Statistics for Data Analytics
  • Types of Statistics
  • Descriptive Statistics
  • Inferential Statistics
  • Population and Sample
  • Parameter and Statistics (Mean, Median, Mode, Std, Variance)
  • Uses of Variables
  • Dependent Variables
  • Independent Variables
  • Types of Variables
  • Continuous Variables
  • Categorical Variables
  • Distribution Types and Skewness
  • Hypothesis Testing
  • Type 1 Error
  • Type 2 Error
  • T-test (One Sample and Sample Comparison)
  • ANOVA & Chi-Square
  • Covariance and Correlation
Introduction to Power BI
  • What is Power BI
  • Power BI Products
  • Components of Power BI
  • Why Power BI - Power BI Vs Other BI Tools
  • Building Blocks of Power BI
  • Power BI Process
  • Power BI Desktop Installation
  • User Interface in Power BI
Power Query Editor
  • Connecting to Local Data Sources
  • Power Query User Interface
  • Data Types in Power BI
  • Home Tab in Power Query
  • Transform Tab in Power Query
  • Add Column in Power Query
  • Other Transformations in Power Query
Visualizations
  • Bar and Column Charts
  • Pie and Donut Charts
  • Waterfall Chart
  • Tree Map
  • Table and Matrix Visualization
  • Ribbon Chart
  • Funnel Chart
  • Line Chart
  • Slicers
  • KPI Visual
  • Area Chart
  • Cards in Power BI
  • Scatter Plot
  • Gauge Chart
  • Maps in Power BI
  • Custom Visuals (Sankey, Sunburst, Playaxis, Wordcloud, Butterfly)
Data modeling
  • Data Models and Their Importance
  • Schema in Data Models
  • Creating and Managing Relationships
  • Optimizing Data Models
DAX: basics
  • DAX and Its Importance
  • Row and Filter Context in DAX
  • Measures and Calculated Columns in DAX
DAX: Aggregation functions
  • SUM Function in DAX
  • SUMX Function in DAX
  • MIN Function in DAX
  • MINX Function in DAX
  • MAX Function in DAX
  • MAXX Function in DAX
  • AVERAGE Function in DAX
  • AVERAGEX Function in DAX
  • COUNT Function in DAX
  • DISTINCTCOUNT Function in DAX
DAX: Filter functions
  • ALLSELECT Function in DAX
  • FILTER Function in DAX
  • CALCULATE Function in DAX
DAX: Relationship functions
  • CROSSFILTER Function in DAX
  • RELATED Function in DAX
DAX: Date & Time functions
  • CALENDAR Function in DAX
  • DATE Function in DAX
  • DATEDIFF Function in DAX
  • MONTH Function in DAX
  • WEEKDAY Function in DAX
  • YEAR Function in DAX
DAX: Time intelligence functions
  • DATEADD Function in DAX
  • DATESBETWEEN Function in DAX
  • TOTALMTD Function in DAX
  • TOTALQTD Function in DAX
  • TOTALYTD Function in DAX
DAX: Text functions
  • CONCATENATE Function in DAX
  • CONCATENATEX Function in DAX
  • FORMAT Function in DAX
  • LEFT Function in DAX
  • RIGHT Function in DAX
  • TRIM Function in DAX
  • FIND Function in DAX
  • SEARCH Function in DAX
DAX: Logical functions
  • AND Function in DAX
  • OR Function in DAX
  • NOT Function in DAX
  • FALSE Function in DAX
  • TRUE Function in DAX
Connectivity
  • Introduction to Using Excel Data in Power BI
  • Exploring Live Connections to Data with Power BI
  • Connecting Directly to Database in Power BI
  • Import Power View and Power Pivot to Power BI
  • Power BI Publisher for Excel
  • Content Packs in Power BI
  • Introducing Power BI Mobile
Creating reports
  • What is a Report in Power BI?
  • Filters in Power BI: Visual Level Filter
  • Filters in Power BI: Page Level Filter
  • Filters in Power BI: Report Level Filter
  • Filters in Power BI: Drill Through Filter
  • Include and Exclude Filters in Power BI
  • Formatting a Report in Power BI
Publishing, sharing & scheduling a refresh
  • What is a Report?
  • Filters: Visual Level Filter
  • Filters: Page Level Filter
  • Filters: Report Level Filter
  • Filters: Drill Through Filter
  • Include and Exclude Filter
  • Formatting a Report
Security
  • Creating an Account on PBI Service
  • Introduction to PBI Service
  • Publishing a Report to PBI Service
  • Creating a Dashboard in PBI
  • Creating a Gateway in PBI
  • Scheduling a Refresh in PBI
PBI mobile app
  • Row level security
M language
  • Introduction
Project
Tableau introduction
  • M Language Functions
Tableau download and Installation
  • Student Survey Analysis
  • City Biker Project Analysis
  • Pricing Model from Smartwatch Company
How To Connect Tableau With Different Data Sources
  • How Tableau Can Be Implemented in the Data Industry
  • Why Tableau?
  • Live vs Extract in Tableau
  • Data Source Overview in Tableau
Tableau Architecture & Products
  • Tableau Desktop Download for Windows
Tableau prep
  • Connecting to Excel and CSV Files
  • Connecting to Microsoft SQL Server
  • Connecting to Microsoft Access
  • Connecting to PDF File
  • Connecting to Google Drive
  • Connecting to MongoDB through ODBC/JDBC
  • Connecting to Web Database Connector (WDC)
In-built Charts
  • Architecture
  • Tableau Server
  • Tableau Cloud (Online)
  • Tableau Public Server
  • Tableau Desktop
  • Tableau Public Desktop
  • Tableau Reader
  • Tableau Mobile
  • Tableau Prep Builder
Advanced charts
  • Introduction to Tableau Prep
  • Tableau Prep Builder UI
  • Data Preparation Techniques Using Tableau Prep Builder Tool
Reference types
  • Area charts
  • Bar chart
  • Bubble chart
  • Box & whisker plot
  • Dual combination chart
  • Bullet graph
  • Heat map
  • Line chart
  • Pie chart
  • Scatter plot
  • Stacked bar chart
  • Treemap
  • Geographic & filled map
Filters
  • Funnel chart
  • Gantt chart
  • Sunburst
  • Lollipop
  • Word cloud
  • Pareto chart
  • Donut
  • Dumbbell
  • Waterfall chart
Tableau calculations using functions
  • Reference lines
  • Reference bands
  • Distribution bands
LOD
  • Types
  • Extract
  • Data sources
  • Dimension & measures
  • Cascading Filter
  • Context Filter
  • Order of operation of filters
Data combining techniques
  • Number function
  • String function
  • Date function
  • Type conversion
  • Logical functions
  • Aggregate functions
  • User function
  • Table calculation function
Groups, Bins, Hierarchies, sets & parameter
  • Include
  • Exclude
  • First
Tableau server
  • Types
  • Joins
  • Blending
  • Union
Dashboarding
  • What are sets?
  • What are groups?
  • What are bins?
  • What are Hierarchies?
  • What are Parameters?
  • Creating and Removing Hierarchies
Tableau Story
  • Introduction
  • Architecture
  • Components
  • Installation of Tableau server using VM VirtualBox
Sharing Reports
  • Tiles vs floating
  • Layout overview
  • Formatting and dashboard creation
User security
  • Tableau Story
Scheduling
  • Sharing Reports
Excel Interface / Basic Parts in an MS-Excel window
  • User security
Row, Column, Cell, Active Cell
  • Scheduling
Entering, editing and formatting
  • Launching Excel
  • Quick access toolbar, Title Bar, Ribbon
  • Menu Bar, Formula Bar, Status Bar
  • Scroll Bar, Column Bar, Row Bar, Leaf Bar
  • Name box, Workspace, Dialog box launcher, Zoom controls, View buttons
  • Tabs - File, Home, Insert, Page Layout, Formulas, Data, Review, View, Help
Worksheets and Workbook
  • Row number, Column Name
  • Inserting and Deleting Columns and Rows
  • Range of cells
  • Inserting & Deleting Cells
  • Inserting Multiple Columns & Rows
  • Modifying Cell Width and Height
  • Hiding and Unhiding Rows and Columns
  • Freeze panes
Look Up
  • Entering and editing data
  • Font, Color fill
  • Alignment
  • Cut, Copy, Paste, Paste Special, Undo, Redo
Data Cleaning
  • Adding, Renaming, Sliding through and hiding worksheets
  • Copying, deleting, grouping, ungrouping worksheets
  • Moving, Copying, Deleting and Hiding Grouped Worksheets
Data Tools
  • Lookup
  • VLOOKUP
  • HLOOKUP
  • XLOOKUP
  • INDEX
  • INDEX and MATCH
  • OFFSET
Data Validation
  • Number Formatting
  • Date Formatting
  • Converting Data into Excel Table
  • Sorting
  • Find and Replace
  • Handling Duplicates
  • Filter and Advance Filter
  • Text to Columns
Visualization
  • Scenario Manager
  • Goal Seek
  • What If Analysis
  • Consolidate
Summarization
  • Type Check
  • Format Check
  • Correctness Check
  • Consistency
  • Uniqueness Check
Macros and VBA
  • Conditional Formatting
  • Charts
  • Charts Formatting
Security Features
  • Pivot Tables
  • Slicers
  • Dashboard creation
  • Formatting Dashboard
Python Introduction
  • What is Macro?
  • Recording a Macro
  • Adding a Developer Tab
  • Macros by button
  • Editing Macros
  • VBA - Subs, Ranges and sheets
  • If statements and conditions
  • Loops
  • Message Boxes and Input Boxes
Python Basic Building
  • Unlocking Cells
  • Worksheet Protection
  • Work Book Protection
  • Password Protecting Excel Files
Python Data Structure
  • Introduction to Python and its Importance
  • Installation guide of Jupyter Notebook and use of Google Colab
  • Working with Python notebooks
Python Loops & Functions
  • Simple Expressions, Variables
  • Data Types/structures
Exception Handling
  • Lists
  • Tuple
  • Dictionary
  • Set
Class& Object
  • Branching (If Else Elif)
  • Range
  • Loops, Indexing
  • Break and Continue
Numpy
  • Exception Handling
Pandas
  • Class& Object
Matplotlib
  • Introduction to Numpy
  • Data types
  • Arange and space
  • Matrix creation
  • Random number generation
  • Reshaping
  • Indexing and slicing
  • Subseting
  • Universal Functions
  • Broadcasting
  • Array Math
Statistical Plot
  • Introduction to Pandas
  • Pandas Operations
  • Read and write from CSV and TSV files
  • Read and write operations from HTML
  • Read and write operations from web API
  • Creating and working with Data frames
  • Date time manipulation
  • Data Cleaning
  • Data manipulation
  • Series manipulation
  • Data frame manipulation
UnStructured Coordinated
  • Introduction to Matplotlib & Seaborn
  • SubPlot, ScatterPlot, Area Plot
  • Bar graph, Stem Plot, Step_plot, fill_Beetween Plot
  • imshow(), pcolor mesh(), Flat shading, contour plot, contourf plot
  • Barps Plot, Quiver, Stream Plot
Project Discussion and Overview
  • Histogram, Box Plot, Error Bar Plot, Violin Plot
  • Event Plot, Hist 2D, Hex Bin Plot, Pie
Market Relevant Projects
  • Tricountr, Tricountf
  • Tripcolor, Trirplot
  • Project Overview