Grow Data Skills

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

LanguageEnglish
Validity 1 Year
Mode Recorded

Demo Class Video

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

⚠️ Important Notice :

The video may not work on Linux due to DRM restrictions. It is only accessible on Chrome when using Windows or macOS.

Workaround: To access the video on Linux, you can create a Windows virtual machine (VM) and watch the video through the VM. Alternatively, you can use our Android or iOS application to view the video on your mobile device.

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.