Grow Data Skills

Data Analyst Course With Azure, AI & Co Pilot - Basic To Advance (Self Paced)

LanguageEnglish
Mode Recorded
Validity 1 Year
Duration 60+ Hours
Sessions 24
Projects 3

Demo Class Video

INR 5400

Buy Now

This course includes

60+ hours content
3 Industry level real world projects
Learn while solving real life examples in live lectures
Projects will be covered from scratch
Hands on exercises & quizzes after each module
Career & Interview Preparation guidance session
Resume Preparation session
Linkedin Profile Making
Certificate of completion

Tools you'll learn

Course Content

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
Introduction to Excel Copilot: Understanding the basics of AI integration in Excel
Natural Language Queries: Asking questions in plain English to get data insights
Automated Data Analysis: Using Copilot for trend analysis, pattern recognition, and anomaly detection
Data Cleaning
Functions
Cell References: Relative, absolute, and mixed cell references
Lookup Functions: VLOOKUP, HLOOKUP,XLOOKUP, INDEX, MATCH
Conditional Formatting
Data Validation:Creating drop-down lists, input restrictions, and error messages
Pivot Tables
Data Visualization using Excel
Advanced Excel- Macros and VBA
Advanced Excel-What if Analysis, Goal Seek, and Scenario Manager
Python in Excel
Introduction to Statistics
Measures of central tendency- Mean, Median, Mode
Measure of Dispersion - Range, Variance, Standard Deviation, Interquartile Range
Measure of Relationship - Correlation and Covariation
Capstone Project on Excel

Power BI: Introduction and Setup
Introduction to Power BI Copilot
Learn how to use AI-Powered Copilot to identify trends and patterns
Load and connect Data from different sources
Build data models in Power BI - Data Warehouse, OLTP vs OLAP, Star Schema Vs Snowflake Schema, Fact Vs Dimension Table
Transform data in Power Query Editor
Power query best practices
Use DAX & Power Pivot to build measures and calculations
Basic visualization : bar charts, column charts, line charts, pie charts, and scatter plots
Interactive Visualizations: Slicers, filters, buttons and bookmarks
Custom Visualizations
Conditional Formatting to visuals
Design Rules for an effective dashboard
Deploying the Solution In Power BI Service:
- 📍 Power BI service Overview, Report sharing and Apps
- 📍 How to setup Automatic Data Refresh
- 📍 Documentation and Maintenance
- 📍 Optimization of Reports
Capstone Project on Power BI

Python Introduction
Intro to Jupyter Notebook and installation
Variables,Data Types and Operators in Python
Data Structures in Python: Tuple, List, Dictionary & Set
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

Introduction to Microsoft Azure Cloud
Introduction to Azure Copilot for Data Analysis
Identifying trends and patterns using AI on cloud
Data Ingestion
Data Modeling and Storage
Data Transformations
ETL( Extract Transform and Load)
Monitoring and Optimizations

What is Generative AI (or Gen AI)?
What is LLM?
AI Career Roles
Prompt engineering in generative AI models
Use Generative AI tools and techniques in data analytics

- 📍 Project 1: Online Streaming Data Analysis with AI-Enhanced Insights🎬🎥 - Leverage the power of Python for data cleaning, preliminary analysis, and Exploratory Data Analysis (EDA) to uncover the rich insights hidden in online streaming data. Integrate AI/copilot capabilities to automate data preparation and generate predictive analytics. Build a comprehensive Power BI Dashboard enhanced by AI-driven recommendations for deeper insights and actionable intelligence.
- 📍 Project 2: AI-Powered Sales Analysis using SQL, Excel, and Power BI📊📶 - Build an advanced data analysis and visualization system using SQL, Excel, and Power BI to analyze and interpret the performance metrics of a company's sales data. Incorporate AI/copilot functionalities to automate data processing and provide predictive insights. Utilize AI-driven analytics to enable better strategic decisions, optimize sales processes, and drive business growth.
- 📍 Project 3: AI-Enhanced Food Delivery Data Analysis and Visualization using Power BI🌮🍕🥪 - Unveil the flavorful insights by exploring the dynamics of food delivery through Power BI. Build an advanced Power BI Dashboard to analyze the performance of a food delivery company and generate meaningful insights. Incorporate AI/copilot capabilities to automate data analysis and provide predictive recommendations, enhancing the decision-making process with AI-driven insights.

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

Course Duration:

100+ Hours

Total Sessions:

Total Project:

Class Recording Provided:

Yes

Course Validity:

1 year

Programming Language Used:

Python

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.