Grow Data SKills | Most Affordable Courses | Become Top Data Professional

Light
Dark

Data Analyst Mastery With Business Intelligence

Sophia Jaymes

By Shailja In Grow Data Skills

Self Paced
English
Completion Certificate

Demo Class Video

Education Images

1 Year

Validity (From the date of Enrollment)

60 Hours

Duration

25

Sessions

3

Projects

INR 6200

This course includes

Content Duration60 Hours
Total Video Sessions25
Total Industry Projects3
Azure Cloud
Quality Assignments & quizzes after each module
Interview preparation guide
Dedicated placement assistance
Resume & Linkedin profile making
Doubt support on private discord community
Certificate of completion

Show More

Tech stack you'll learn

Card image

Course Content

✅ Class - 1

What is Database?
Difference between Transactional Databases and NoSQL databases
What is DBMS & RDBMS?
Transactions & ACID Properties
Setup MySQL Workbench
Data Types in SQL
DDL, DML, DQL, DCL
Create, Insert, Alter, Delete, Drop, Truncate Operations
Integrity Constraints

✅ Class - 2

Primary Key vs Foreign Key
Referential Integrity
Select Query, Aliases
UPDATE Command
Auto Increment in create table
Limit & Offset
WHERE Clause
Operators in SQL
Pattern Matching using LIKE and REGEXP
Order By Clause

✅ Class - 3

IS NULL, IS NOT NULL
Group By, Having Clause
Group Concat, Group RollUP
Sub Queries, IN and NOT IN
CASE-When
SQL Joins

✅ Class - 4

Exists and Not Exists
Window Functions
Frame Clause
Coalesce Function
Common Table Expressions - Iterative and Recursive

✅ Class - 1

Introduction to Excel
Data Cleaning Techniques: Using text-to-columns, Flash Fill, and Find/Replace
Sorting and Filtering: Custom sorting and advanced filtering
Conditional Formatting: Dynamic rules for highlighting data trends
Named Ranges: Simplifying formulas and navigation
Cell References: Relative, absolute, and mixed cell references
Logical functions: IF, AND, OR, IFERROR
Lookup functions: VLOOKUP, HLOOKUP, INDEX, MATCH

✅ Class - 2

Pivot Tables
Grouping data and adding calculated fields
Data Visualization in Excel
What-If Analysis Tools: Data Tables, Goal Seek and Scenario Manager
Data Validation: Creating drop-down lists, input restrictions, and error messages

✅ Class - 3

Excel’s Integration with Power Query
Recording and editing MACROS
VBA for automation
Python in Excel
AI-Powered Features in Excel

✅ Class - 1

Introduction to Descriptive Statistics
Differentiating descriptive and inferential statistics
Measures of Central Tendency: Mean, median, mode: When to use each and their implications
Measure of Dispersion - Range, Variance, Standard Deviation, Interquartile Range
Measure of Relationship - Correlation and Covariation
Skewness and kurtosis
Analyzing a real-world Case study for central tendency and dispersion

✅ Class - 2

What is A/B testing?
Hypothesis testing
Defining goal and KPIs
Sample size determination
Randomization and ensuring unbiased groups
Hypothesis formulation (null vs alternative hypothesis)
P-value, confidence intervals
T-tests for comparing means
Chi-square test for categorical data
Interpreting Results

✅ Class - 1

Power BI: Introduction and Setup
Power BI ecosystem: Power BI Desktop, Service, and Mobile
Load and connect Data from different sources
Data Warehouse Vs Database
OLTP vs OLAP
Star Schema Vs Snowflake Schema
Fact Vs Dimension Table
Build data models in Power BI
Defining and managing relationships between tables
Cardinality and cross-filtering

✅ Class - 2

Transform data in Power Query Editor -
Data Cleaning and Filtering
Dealing with duplicates
Splitting columns
Merging and appending datasets
Power query best practices
Hands-on Real-life Case Studies on Power Query

✅ Class - 3

Measures Vs Columns
Row context vs Filter context
Overview of DAX (Data Analysis Expression)
Use DAX to create calculated columns and measures

✅ Class - 4

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
Row-Level Security (RLS)
Deploying the Solution in Power BI Service -
Power BI service Overview, Report sharing and Apps
How to set up Automatic Data Refresh
Hands-On Real-Life Case Study on DAX

✅ Class - 1 (Recorded)

Python Introduction
Intro to Jupyter Notebook and installation
Variables, Data Types and Operators in Python
Data Structures in Python: Tuple, List, Dictionary & Set
If -else in Python
Looping: While and For Loop
Break and Continue Statements
Functions in Python
Lambda Functions
Python Object oriented programming- Classes and Object

✅ Class - 2

Introduction to Pandas and its role in data analysis
Series and Dataframe
Loading and saving data: Reading from CSV, Excel, and JSON files
Saving DataFrames to files
Pandas In Built functions:
.head(), .tail(), .info(), .shape(), .columns
Summary statistics with .describe()
Handling missing data (fillna(), dropna()).
Filtering and selecting data
Creating and modifying columns
Sorting and grouping data

✅ Class - 3

Introduction to NumPy
Creating NumPy arrays
Indexing, slicing and reshaping arrays
Mathematical operations on arrays
Data Visualization with Matplotlib and Seaborn
Advantages of Seaborn over Matplotlib
Combining Pandas with Visualization Libraries
End-to-end EDA using Pandas, NumPy, Matplotlib and Seaborn

✅ Class - 1

Introduction to cloud computing
Why we need cloud computing
Cloud services
Types of cloud providers
Cloud Computing Service Models: IaaS, PaaS, SaaS
Introduction to Microsoft Azure Cloud

✅ Class - 2

Data Ingestion
Data Modeling and Storage
Data Transformations
Data Analysis using Azure Synapse Analytics

✅ Class - 1

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
Use of AI in data analysis tools
Excel Copilot
Power BI Copilot
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

✅ Class - 1

Definition and purpose of BI in decision-making
Difference between BI and Business Analytics
BI tools overview and comparison (Power BI, Tableau, QlikView)
Key Components of BI Systems
Dashboards and visual reporting
How data flows through BI systems
Real-time vs batch reporting
Use cases of BI in various industries

✅ Class - 2

Definition and importance of Business Analytics in strategic decision-making
Types of analytics: Descriptive, Predictive, and Prescriptive
Key Frameworks in Business Analytics
CRISP-DM (Cross-Industry Standard Process for Data Mining): Phases and application
Balanced Scorecard: Connecting performance metrics with strategy
SWOT and PESTLE analysis: Analytical tools for business environments
Examples of frameworks used in marketing, operations, and finance
Data-Driven Decision Making
Importance of using data in strategic planning
Examples of successful data-driven companies
Developing Data-Driven Strategies
Collecting and analyzing relevant business data
Identifying Key Performance Indicators (KPIs)
Building actionable insights from data
Implementing Strategies

Project - 1: Amazon Web Scraping and Data Analysis
Tech Stack: Python, Statistics, Power BI
Project - 2: AI-Powered Sales Analysis and Strategic Planning
Tech Stack: SQL, Excel, Power BI
Project - 3: Streaming Data Insights for Business Optimization
Tech Stack: Python, Power BI

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:

60 Hours

Total Sessions:

25

Total Projects:

3

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.

Instructor

Shailja Mishra

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

Data Analyst Mastery With Business Intelligence

INR 6200

Copyright © 2024 Regex Data Learning Pvt Ltd. All Rights Reserved.

Enquiry