Grow Data Skills

Data Analyst Course With Azure Data Analytics - Basic To Advance (Self Paced)

LanguageEnglish
Validity 1 Year
Mode Recorded

Demo Class Video

INR 4000

Buy Now

This course includes

80+ hours content
45 minute recorded doubt session after each class
2 Industry level real world projects
Learn while solving real life examples in lectures
Projects will be covered from scratch
Hands on exercises & quizzes after each module
Career & Interview Preparation guidance
Resume Preparation (Recorded)
Linkedin Profile Making (Recorded)
Certificate of completion

Tools you'll learn

Course Content

Python Introduction
Intro to Jupyter Notebook and installation
Variables,Data Types and Operators in Python
Data Structures in Python: Tuple, List, Dictionary & Set
Python Object-Oriented Programming: Class & Object
Searching and Sorting
Data Analysis Libraries in Python - NumPy,Pandas
Data Visualization with Python: Matplotlib,SeaBorn
Data Cleaning and Exploratory Data Analysis(EDA)
Capstone Project

MySQL Installation guide Connection & set up
DDL, DML, DCL in SQL
Data type of SQL
Create, Insert, Update, Alter, Delete, Drop, Truncate Operations
Views in SQL
Operators in SQL
WHERE clause, ORDER BY clause, GROUP BY & Having Clause
Aggregations Group Concat & Roll UP
CASE-WHEN Statement
Joins in SQL - Inner, Left, Right, Full, Self
Correlated subqueries IN, NOT IN, ANY, ALL, EXISTS, NOT EXISTS
Window Functions
Frame Clause in Window Functions
Common Table Expressions - Recursive, Iterative
Capstone Project

Introduction to excel
Phases of Data Analytics Project
Data Cleaning
Functions
Lookup Functions
Conditional Formatting
Data Validation
Pivot Tables
Data Visualisation using Excel
Capstone Project

Introduction to Statistics
Standard Deviation
Correlation and Covariation
Introduction to Probability
Hypothesis Testing
Marginal and Conditional Probability
Normal Distribution

Power BI: Introduction and Setup
Load and clean-up data with Power BI
Build a data model in Power BI
Use DAX & Power Pivot to build measures and calculations
Creating visuals-Answering business questions with Power BI
Customizing visuals & interaction effects
Creating a comprehensive sales performance report
Updating and data refresh process
Advance Data Analysis and Dashboarding on Power BI
Capstone Project

Introduction to Python in Excel
Troubleshoot Python in Excel Errors
Data Security
Python in Excel DataFrames
Create Python in Excel Plots & Charts
Use Power Query data with Python in Excel

Introduction to Microsoft Azure Cloud
Data Ingestion
Data Storage
Data Processing and Transformations
Data Analysis
Monitoring and Optimizations

Supply Chain Data Analytics Projects
IPL (Indian Premier League) Data Analytics Projects

Attention Seeking Resume Preparation and Interview Strategies
Strategies To Crack Tech Interviews

Linkedin Profile Making
How To Expand Your Professional Network On Linkedin
How To Use Various Job Portals
How To Approach For Referrals

Course Schedule

Mode of the Course:

Recorded Mode

Class Recording Provided:

Yes

Course Validity:

1 year

Programming Language Used:

Python

Any Prerequisite? :

Passion And Willingness To Learn

Instructor

Shailja Mishra

Shailja Mishra is a Data and Applied Scientist at Microsoft , mentored over 750+ Students around Data Engineering, Data Analysis and Data science Domain.

Why Data Analyst?

Map your interest to check if Data Analyst profile is a close match for you.

More Similar Courses

Related Courses

View Details

Data Analyst Course With Azure Data Analytics - Basic To Advance (Self Paced)

INR 4000

Buy Now

How can I help you?

Data Analyst Course With Azure Data Analytics - Basic To Advance (Self Paced)

LanguageEnglish

Validity 1 Year

Mode Recorded

Tools you'll learn

Course Content

Course Schedule

Instructor

Shailja Mishra

Why Data Analyst?

Who should become a Data Analyst?

Mandatory skill sets

Career growth of a Data Analyst

Related Courses

Data Analyst Course With Azure Data Analytics - Basic To Advance (Self Paced)

Namaste 🙏

Data Analyst Course With Azure Data Analytics - Basic To Advance (Self Paced)

LanguageEnglish

Validity 1 Year

Mode Recorded

Tools you'll learn

Course Content

Module 1 - Python Programming

Module 2 - SQL

Module 3 - MS-Excel

Module 4 - Statistics

Module 5 - Power BI (Dashboarding)

Module 6 - Python in Excel

Module 7 - Data Analytics on Azure Cloud

Module 8 - Industrial Projects

Module 9 - Resume And Interview Strategies

Module 10 - Guidance For Effective Job Searching

Course Schedule

Instructor

Shailja Mishra

Why Data Analyst?

Who should become a Data Analyst?

Mandatory skill sets

Career growth of a Data Analyst

Related Courses

Data Analyst Course With Azure Data Analytics - Basic To Advance (Self Paced)

Namaste 🙏