Data Analyst Masterclass: Learn AI Business Insight
0% Completed
Getting Started
Introduction to Data Analyst
Excel Data Basics
Worksheet basics
Video - 00:21:44 mins
Data structuring and formulas
Video - 00:11:56 mins
Data formats
Video - 00:9:32 mins
Data handling basics – cut copy and paste
Video - 00:6:32 mins
Save and print in excel
Video - 00:10:8 mins
Excel Ranges
Video - 00:4:41 mins
Mastering Excel with ChatGPT: AI-Powered Productivity and Automation
Video - 00:7:47 mins
Excel Formulas and Functions
Basic formula operations
Video - 00:6:7 mins
Mathematical functions level1
Video - 00:19:48 mins
Mathematical functions level2
Video - 00:12:16 mins
Text functions level1
Video - 00:9:1 mins
Text functions level2
Video - 00:12:50 mins
Logical functions (AND, OR, XOR)
Video - 00:10:57 mins
Date time functions
Video - 00:6:14 mins
Lookup function - VLOOKUP
Video - 00:12:5 mins
Lookup function - HLOOKUP
Video - 00:4:1 mins
HLOOKUP + Match formula
Video - 00:8:28 mins
Match + Index formula Combination
Video - 00:5:15 mins
Match + Index formula Combination
Video - 00:5:15 mins
Excel XLOOKUP only for Excel 2021 and Office 365
Excel Data Transforming and Importing
Excel Data Formatting and Table Design
Excel Data Analysis with PivotTables
Excel Data Charts and Visualization
Excel Charts – Categories
Video - 00:2:24 mins
Elements of a chart
Video - 00:4:5 mins
Creating dynamic charts
Video - 00:1:49 mins
Column or Bar charts
Video - 00:4:17 mins
Formatting charts
Video - 00:3:31 mins
Line charts
Video - 00:2:6 mins
Area charts
Video - 00:1:57 mins
Pie and Doughnut charts
Video - 00:3:40 mins
Format Area Plot or XY chart
Video - 00:7:27 mins
Scatter or bubble charts
Video - 00:2:1 mins
Introduction to PostgreSQL
PostgreSQLSetting up Server Environment
SQL Fundamentals
DatabaseSQL Tables
SQL Commands (CRUD functionality) Queries
Mastering the Basics of SQL
Data Management: Data Row Filtering Techniques
Data Management: Aggregate Functions in SQL for Analysis
Using SUM() in SQL: Calculating Total Values
Video - 00:7:19 mins
Calculating Averages with the AVG() Function in SQL
Video - 00:3:21 mins
Finding the Minimum Value with the MIN() Function in SQL
Video - 00:2:48 mins
Extracting the Maximum Value with the MAX() Function in SQL
Video - 00:2:20 mins
Concatenating Values with STRING_AGG() in SQL
Video - 00:5:36 mins
Concatenating Values with STRING_AGG() in SQL
Video - 00:5:36 mins
Analyzing Data Variance with the VARIANCE() Function in SQL
Video - 00:5:44 mins
Calculating Standard Deviation with the STDDEV() Function in SQL
Video - 00:4:41 mins
Counting Unique Values with COUNT(DISTINCT) in SQL
Video - 00:4:45 mins
Data Management: Advanced Aggregate Functions in SQL
Data Management: JOINS in SQL – Combining Data Across Tables
Introduction to JOINS in SQL: Combining Data Across Tables
Video - 00:6:15 mins
Writing INNER JOIN: Retrieving Data from Multiple Tables
Video - 00:16:25 mins
Using LEFT JOIN: Retrieving All Records from Left Table
Video - 00:2:7 mins
Right JOIN in SQL: Retrieving Data from the Right Table
Video - 00:1:33 mins
Using FULL OUTER JOIN: Combining Results from Both Tables
Video - 00:1:42 mins
Self JOIN in SQL: Joining a Table to Itself
Video - 00:5:46 mins
Cross Join in SQL: Producing Cartesian Products
Video - 00:10:10 mins
Data Management: Mastering SQL Constraints for Data Integrity
Enforcing Non-Null Values with the NOT NULL Constraint
Video - 00:11:38 mins
Ensuring Unique Data with the UNIQUE Constraint
Video - 00:8:47 mins
Uniquely Identifying Records with the PRIMARY KEY Constraint
Video - 00:7:48 mins
Maintaining Referential Integrity with the FOREIGN KEY Constraint
Video - 00:11:56 mins
Validating Data with the CHECK Constraint
Video - 00:9:34 mins
Providing Default Values with the DEFAULT Constraint
Video - 00:4:34 mins
Optimizing Queries with the INDEX Constraint
Video - 00:9:6 mins
Optimizing Queries with the INDEX Constraint
Video - 00:9:6 mins
Database Management: Ensuring Data Security with Backup and Restore
Database Management: Capstone Project
Create a Database
Video - 00:1:37 mins
Design the Schema - Company Management System
Video - 00:2:32 mins
Insert Sample Data
Video - 00:2:9 mins
Querying the Data
Video - 00:2:41 mins
Optimizing the Database – Indexing
Video - 00:1:40 mins
Optimizing the Database – Query Analysis
Video - 00:1:42 mins
Optimizing the Database – Vacuum and Analyze
Video - 00:1:6 mins
Optimizing the Database – Partitioning (for Large Data)
Video - 00:1:3 mins
Backup and Restore – Backup the Database
Video - 00:1:33 mins
Backup and Restore – Restore the Database
Video - 00:3:00 mins
Database – Data Management: Managing Users and Roles
Introduction to Power BI
Setting up Power BI Desktop Environment
Connecting and Shaping Data
Types of Data Sources (Excel, SQL Server, Web Data, etc.)
Video - 00:4:56 mins
Connecting Power BI to Excel and CSV Files
Video - 00:13:2 mins
Transforming Data
Video - 00:9:26 mins
Introduction to Power Query Editor
Video - 00:6:44 mins
Cleaning and Shaping Data
Video - 00:17:41 mins
Combining and Merge (Join) in Power Query
Video - 00:9:39 mins
Managing Relationships Between Data Tables
Video - 00:12:31 mins
Data Modelling in Power BI
Data Analysis Expressions (DAX) in Power BI
DAX Aggregations
Data Visualization in Power BI
Project: Designing Interactive Dashboards in Power BI
Best Practices for Dashboard Design
Video - 00:5:19 mins
Loading Dashboard sample data
Video - 00:2:41 mins
Total Revenue Card for Dashboard
Video - 00:2:42 mins
Revenue by Region Bar Chart for Dashboard
Video - 00:3:21 mins
Units Sold Over Time Line Chart for Dashboard
Video - 00:2:21 mins
Product Distribution Pie Chart for Dashboard
Video - 00:2:48 mins
Adding Slicers for Interactive Dashboard
Video - 00:7:34 mins
Save and Publish the Dashboard
Video - 00:3:11 mins
ChatGPT Open AI – Introduction
Python Setting up Local Development Environment
Python Basics Using ChatGPT AI for Fast Learning
Python Intermediate Using ChatGPT: Beyond the Basics
Python Games using ChatGPT AI
Python OOPs Mastery: Advanced Concepts with ChatGPT
Use ChatGPT to write functions
Video - 00:4:28 mins
Use ChatGPT to explain Object Oriented Programming
Video - 00:6:3 mins
Use ChatGPT to write class object programs
Video - 00:3:21 mins
Use ChatGPT to write inheritance
Video - 00:5:42 mins
Use ChatGPT to write polymorphism
Video - 00:4:51 mins
Use ChatGPT to write abstract classes
Video - 00:2:51 mins
Use ChatGPT to write encapsulation
Video - 00:3:39 mins
Python Pandas Using ChatGPT AI: Data Analysis Made Easy
Pandas Create and Loading Data
What is Pandas Data Frame
Video - 00:5:33 mins
Creating DataFrames Manually in Python Pandas
Video - 00:8:43 mins
Mastering Data Import: Loading CSV Files with Pandas
Video - 00:11:21 mins
Seamless Data Import: Loading Excel Files with Pandas
Video - 00:4:9 mins
Working with JSON: Loading and Reading Data Using Pandas
Video - 00:2:37 mins
Exploring Data Efficiently with Pandas: Key Techniques and Insights
Quick Data Preview: Retrieving the First 5 Rows in Pandas
Video - 00:3:35 mins
Exploring Data: Retrieving the Last 5 Rows in Pandas
Video - 00:1:50 mins
Identifying Data types and non-null values
Video - 00:4:14 mins
Data Insights at a Glance: Generating Summary Statistics in Pandas
Video - 00:2:50 mins
Navigating DataFrames: Retrieving in Rows and Columns Pandas
Video - 00:1:59 mins
Understanding Your Data: Identifying Column Names in Pandas
Video - 00:1:55 mins
Pandas Data Cleaning: Handling Values, Duplicates, and Inconsistencies
Pandas Data Transformation
Pandas Data Aggregations and Grouping
Pandas Data Merging and Joining
Pandas & Matplotlib Data Visualization
Finish Course Early?
You have not completed all required lessons and assessments.
Your Progress
0%