Data Analytics Master Program
Master data analytics, cloud computing, and DevOps from the comfort of your home.
We Provide The Best Courses For You
Are you ready to become a data expert? Our Data Analyst Master Program is designed to empower you with the skills and knowledge to excel in the world of data analytics.
Start Your Data Analytics Journey Today!
Don’t wait to build the career of your dreams. Enroll now and take the first step toward becoming a skilled data analyst.
Phone Number
+91-74837-29403
Syllabus
Complete Python with Important Libraries
- Introduction to Python
- Python Basics-Syntax And Semantics
- Identifiers In Python
- Variables In Python
- Operators In Python
- Data types In Python
- Coding Exercise And Assignments
- List And List Comprehension In Python
- List Practice Code And assignments
- Tuples In Python
- Tuple Assignment And Practice Code
- Sets In Python
- Sets Assignment and Practice Code
- Dictionaries In Python
- Dictionaries Assignments and Practice
- Real world use case of List
- Conditional Statements(if,elif,else)
- loops in python
- Coding Exercise and Assignments
- Getting Started With Functions
- Types Of Functions : Parameterized Function and Non-Parametrized Functions
- Return Keywords In Functions
- Different Types of Arguments
- Args and Kwargs Parameters In Functions
- Nested Functions
- Lambda Functions
- Map Functions In Python
- Filter Functions In Python
- Reduce Functions In Python
- Function Assignments With Solution
- Generators and Generator Comprehension
- Import Modules And Packages In Python
- File Operation In Python
- Exception Handling
- Loggings
Data Analysis with Python
- Introduction to Python
- Reading data from Various DataSources
- Understanding the Data
- Checking Duplicates
- Dropping Unwanted Columns
- Transformation
- Handling The Missing Values
- NumPy
- Data Visualization with Matplotlib
- Data Visualization with Seaborn
Getting Started With Statistics
- Introduction To Statistics
- Types Of Statistics
- Population And Sample Data
- Types Of Sampling Techniques
- Types Of Data
- Scales Of Measurement of Data
Descriptive Statistics
- Measure Of Central Tendency (Mean,Median and Mode)
- Measures Of Dispersion (Range,Variance,Standard Deviation)
- Why Sample Variance is divided by n-1?
- Random Variables
- Percentiles And Quartiles
- Number Summary
- Histogram And Skewness
- Covariance And Correlation
Probability Distribution Function and Types Of Distribution
- Pdf, PMF, CDF
- Types OF Probability Distribution
- Bernoulli Distribution
- Binomial Distribution
- Poisson Distribution
- Normal or Gaussian Distribution
- Standard Normal Distribution
- Uniform Distribution
- Log Normal Distribution
- Central Limit Theorem
Feature Engineering with Python
- Feature Engineering-Handling Missing Data
- Feature Engineering-Handling Imbalanced Dataset
- Feature Engineering-SMOTE
- Handling Outliers With Python
- Data Encoding-Nominal/One Hot Encoding
- Label And Ordinal Encoding
- Target Guided Ordinal Encoding
Exploratory Data Analysis
- Red Wine Dataset EDA
- EDA Flight Price Dataset
- Part 1-Data Cleaning Google Playstore Dataset
- Part 2-EDA Google Play Store Dataset
Introduction to MySQL Database
- Download and Installation
- What is Data and types of Data
- What is Database and types of Database.
MySQL Basics
- SQL DDL Commands
- CREATE command
- ALTER command
- TRUNCATE command
- DROP command
- RENAME command
- MySQL Data Types
- SQL DML commands
- INSERT command
- UPDATE command
- DELETE command
- Constraints
- PRIMARY KEY , NOT NULL, UNIQUE, CHECK, FOREIGN KEY
- SQL DQL command
- SELECT command
- SQL Where Clause
MySQL Advance Querying
- Sorting Data (ORDER BY).
- Filtering Data (LIKE, IN, BETWEEN, NOT IN, > , < , >=, <=,!=).
- Using Aggregate Functions:
- COUNT, SUM, AVG, MIN, MAX
- Grouping Data with GROUP BY.
- Filtering Groups with HAVING.
- Subqueries and Nested Queries.
MySQL Set
- Union
- Intersect
- Minus/Except
MySQL Joins
- Introduction to Joins.
- Types of Joins:
- Inner Join.
- Left Join.
- Right Join.
- Full Outer Join.
- Cross Join.
- Self-Joins.
MySQL Functions
- String Functions: CONCAT, SUBSTRING, REPLACE.
- Numeric Functions: ROUND, FLOOR, CEIL.
- Date Functions: NOW, CURDATE, DATEDIFF, DATE_ADD.
- Control Flow Functions: IF, CASE.
MySQL Advanced Functions
- Rank, Dense Rank & Row Number Window Functions – 1
- Rank, Dense Rank & Row Number Window Functions – 2
- Window Functions – Lead Function
- Window Functions – Lag Function
- ISNULL & Coalesce Functions
- Common Table Expressions – 1
- Common Table Expressions – 2
MySQL other objects
- Views in MySQL and Types of Views
- Store Procedure and types of Stored Procedures
Data Import/Export
- Importing Data using LOAD DATA INFILE.
- Exporting Data to CSV/SQL Files.
POWER BI Course Introduction
- Microsoft Power BI Course Introduction
Introduction to Power BI
- General Workflow Power BI
- Download and Installing PowerBI Desktop
Data Visualization
- Creating a Bar Chart
- Creating a Column Chart
- Creating a Line & Area Chart
- Creating a Pie & a Donut Chart
- Creating a Clustered Column & Bar Chart
- Creating a Ribbon Chart
- Creating a line & stacked column chart
- Creating a Line & Clustered Column Chart
- Creating a Scatter Plot
- Creating a Bubble Map Visual
- Creating a Table & Matrix Visual
- Formatting Table & Matrix Visual
- Creating a Funnel Chart
- Gauge chart & KPI Visual
- AI Visuals in Power BI
Power Query Editor
- Detecting Data Types in Power BI Desktop
- Data Profiling
- Column Distribution Example
- Appending Queries
- Merge Inner Join
- Left Outer Join
- Right Outer Join
- Left & Right Anti Join
- Full Outer Join
- Group By in Power Query Editor
- Add/Transform Columns
- Pivot, Unpivot & Transpose
Power Query Editor
- DAX Lecture 1
- DAX Lecture 2
- DAX Lecture 3
- DAX Lecture 4
- DAX Lecture 5
- DAX Lecture 6
Project 1 : Sales Data Analysis
- Business Requirements
- Loading Data to PBI Desktop
- Data Profiling & Data Transformations Part 1
- Data Transformations Part 2
- Primary & Foreign Key
- Cardinality
- Star Schema
- Different types of Filter in Filter Pane
- Top Bottom 5 products By Sales,Qunatity and Profit
- Sales Trends Over Time
- Other Requirements
- Requirement 4 DAX
- Requirement 4 Edit Interactions
- Other Remaining Requirements
- Changing Filter Behavior for Dimension Table Slicers
Project 2: Insurance Data Analysis
- Downloading & Installing MSSQL Server
- Importing Data to MSSQL Server
- Loading Data to Power BI Desktop
- Table View & Data Profiling
- Adding Slicers & Text
- Adding New Cards Visuals
- Adding a Multi Row Card & a Ribbon Chart
- Adding a Bar & a Line Chart
- Adding a Donut Chart & Matrix Visual
Project 2: Insurance Data Analysis
- Publishing the Report to Power BI Service
- Scheduling Refresh
- Drill Through Filter
- Testing Scheduled Refresh & Publishing the updated report
- Creating & Testing Roles in PBI Desktop
- Testing & Implementing RLS in Power BI Service
- Power BI Reports & Dashboards
- Sentiment Analysis Power Query
- Sentiment Analysis Adding Visuals to the Report
Excel Dashboard 1
- Pivot Tables Lecture 1
- Pivot Tables Lecture 2
- Creating & Formatting the Column Chart
- Creating & Formatting the Bar Chart
- Creating & Formatting a Line Chart
- Creating & Formatting an Area Chart
- Creating & Formatting a Pie Chart
- Creating the Dashboard
Excel Dashboard 2
- Data Understanding and cleansing
- Data Transformation (Removing Data Quality Issues using VLookUp Function)
- Adding Age Group & Production Cost Per Unit Column
- Adding a 3D Column Chart
- Adding a 3D Bar Chart
- Adding a 3D Line Chart
- Adding a 3D Pie Chart
- Creating Dashboard
Power Query Editor in MS Excel
- Data Profiling (Column Distribution)
- Data Profiling (Column Profile & Column Quality)
- Combining Queries
- Inner Join Concept and Examples
- Left Join Concept and Examples
- Right Outer Join Concept and Examples
- Full Outer Join Concept and Examples
- Left & Right Anti Join Concept and Examples
- Nulls in SQL Server & Power Query Editor
- Appending two tables
Importing Data from MySQL Server
- Importing Data to SQL Server
- Importing Data to Excel From SQL Server
- Data Understanding & Creating the Pivot Table
- Adding Category Slicer
- Adding Other Slicers & Formatting Slicers & Pivot Table
- Refreshing the Report
