Data Analyst Masterclass: Learn AI Business Insight
Introduction
Data Analyst Masterclass: Learn AI Business Insight
0%
Completed
Getting Started
Introduction
Video - 00:3:1 mins
Start on windows, macOS, and Linux
Video - 00:00:56 mins
How to ask great questions
Video - 00:1:7 mins
FAQs
Video - 00:00:56 mins
Introduction to Data Analyst
What is a Business Data Analyst
Video - 00:5:50 mins
Importance of data analytics in decision-making
Video - 00:2:55 mins
Real-world applications of Business Analytics
Video - 00:4:38 mins
Overview of tools: Excel, SQL, Power BI, ChatGPT AI, and Python (Pandas)
Video - 00:3:47 mins
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
Lookup function - XLOOKUP
Video - 00:7:33 mins
Handling #NA and Approximates match in XLOOKUP
Video - 00:10:24 mins
Wildcard matching in XLOOKUP
Video - 00:6:5 mins
Excel Data Transforming and Importing
Split Text into columns
Video - 00:6:57 mins
Flash Fill
Video - 00:6:57 mins
Remove Duplicates
Video - 00:7:39 mins
Data Validation
Video - 00:6:27 mins
Get- import Data from Text
Video - 00:5:31 mins
Get - import Data from CSV
Video - 00:3:16 mins
Excel Data Formatting and Table Design
Formatting Font
Video - 00:4:9 mins
Formatting Alignment
Video - 00:5:57 mins
Formatting Number
Video - 00:4:30 mins
Formatting Date
Video - 00:3:22 mins
Formatting tables
Video - 00:5:6 mins
Excel Formatting steps using ChatGPT AI
Video - 00:3:38 mins
Excel Data Analysis with PivotTables
Creating PivotTables for summarization
Video - 00:6:37 mins
Value field settings
Video - 00:3:59 mins
Number format
Video - 00:2:21 mins
Pivot Table Design
Video - 00:3:14 mins
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
What is PostGRE SQL
Video - 00:3:13 mins
Why Choose PostgreSQL? Futures and Benefits
Video - 00:4:41 mins
Understanding the PostgreSQL Ecosystem
Video - 00:2:30 mins
PostgreSQLSetting up Server Environment
Installation and setup PostgreSQL (Windows)
Video - 00:18:17 mins
Installation steps for macOS and Linux
Video - 00:6:14 mins
Exploring pgAdmin and Command-Line Tools
Video - 00:10:1 mins
Downloadable resources for this module for Hands-on practice
Reading
SQL Fundamentals
Relational Database Concepts
Video - 00:6:4 mins
Data Types and Schemas
Video - 00:5:00 mins
Creating and Managing Databases
Video - 00:6:58 mins
DatabaseSQL Tables
CREATE a table using pgAdmin
Video - 00:12:48 mins
ALTER a table (modification)
Video - 00:8:15 mins
DELETE a table
Video - 00:4:24 mins
CREATE a table using SQL script
Video - 00:9:22 mins
Create a table script for product sales using Gen AI
Video - 00:3:59 mins
SQL Commands (CRUD functionality) Queries
CREATE operation (Insert Data)
Video - 00:5:15 mins
READ operation (Select Data)
Video - 00:4:8 mins
UPDATE operation (Modify Data)
Video - 00:4:33 mins
DELETE operation (Remove Data)
Video - 00:2:41 mins
Mastering the Basics of SQL
SQL statement basics
Video - 00:3:7 mins
SELECT statement
Video - 00:2:44 mins
Eliminating Duplicates with SELECT DISTINCT
Video - 00:4:40 mins
DASHBOARDS - COUNT() Column AS statement
Video - 00:2:50 mins
Write SELECT statement using Gen AI
Video - 00:4:11 mins
Data Management: Data Row Filtering Techniques
SELECT and WHERE Clause
Video - 00:3:1 mins
SELECT and WHERE: Filtering Data in SQL
Video - 00:6:48 mins
Sorting Data with the ORDER BY Clause
Video - 00:4:5 mins
Efficient Data Selection with the LIMIT Clause
Video - 00:2:50 mins
Using LIMIT with an Offset
Video - 00:2:15 mins
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
Grouping Data Efficiently with the GROUP BY Clause
Video - 00:10:56 mins
Advanced Data Filtering Leveraging the HAVING Clause in SQL
Video - 00:3:14 mins
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
Mastering Database Backups: Ensuring Data Integrity
Video - 00:6:43 mins
Restoring Databases: Ensuring Business Continuity
Video - 00:5:3 mins
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
Login Group / Roles setup
Video - 00:3:53 mins
Introduction to Power BI
Business Intelligence and Power BI
Video - 00:6:41 mins
Overview of Power BI
Video - 00:6:53 mins
Importance of Data Visualization
Video - 00:7:4 mins
Components of Power BI
Video - 00:2:33 mins
Mastering Power BI with ChatGPT - AI-Powered Insights & Automation
Video - 00:5:2 mins
Setting up Power BI Desktop Environment
Downloading and Installing Power BI Desktop
Video - 00:13:3 mins
Overview of Power BI Desktop Interface
Video - 00:8:56 mins
Basic Settings and Navigation
Video - 00:9:40 mins
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
Overview of Data Modelling
Video - 00:4:46 mins
Creating Relationships Between Tables
Video - 00:7:11 mins
Optimizing Data Models with Relationships
Video - 00:10:53 mins
Best Practices for Data Modelling
Video - 00:7:57 mins
Data Analysis Expressions (DAX) in Power BI
Basics of Data Analysis Expressions (DAX)
Video - 00:3:12 mins
Create Calculated Columns using DAX formula
Video - 00:7:6 mins
Create Measures using DAX formula
Video - 00:4:53 mins
Use DAX Calculations in Visualizations
Video - 00:3:18 mins
DAX Aggregations
DAX Functions for Aggregations
Video - 00:14:53 mins
Filtering and Conditional Calculations
Video - 00:2:58 mins
DAX Formula to get a Total Sales using Gen AI
Video - 00:2:20 mins
Data Visualization in Power BI
Types of Visualizations in Power BI
Video - 00:2:16 mins
Creating Bar Charts
Video - 00:3:40 mins
Creating Pie Charts
Video - 00:4:00 mins
Creating Tables and Formatting
Video - 00:7:1 mins
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
What is ChatGPT AI
Video - 00:3:38 mins
Set up an account with ChatGPT
Video - 00:3:49 mins
How to use ChatGPT GEN AI
Video - 00:5:30 mins
ChatGPT for your day-to-day tasks
Video - 00:5:12 mins
Python Setting up Local Development Environment
Python App Installation step by step
Video - 00:7:3 mins
Python Code Editor IDE (PyCharm) Installation
Video - 00:13:5 mins
Getting started First Python project
Video - 00:8:30 mins
First Welcome “Hello World” program
Video - 00:5:1 mins
Python Basics Using ChatGPT AI for Fast Learning
Use ChatGPT to write variables
Video - 00:5:44 mins
Use ChatGPT to write datatypes
Video - 00:4:27 mins
Use ChatGPT to write Type casting
Video - 00:3:51 mins
Use ChatGPT to write strings
Video - 00:5:43 mins
Use ChatGPT to write operators
Video - 00:5:8 mins
Python Intermediate Using ChatGPT: Beyond the Basics
Use ChatGPT to write if else statements
Video - 00:3:7 mins
Use ChatGPT to write while loop
Video - 00:5:42 mins
Use ChatGPT to write for loop
Video - 00:3:7 mins
Use ChatGPT to write a nested loop
Video - 00:2:59 mins
Exercise and Solution for it (Pyramid pattern)
Video - 00:3:45 mins
Python Games using ChatGPT AI
Use ChatGPT to write Guessing game
Video - 00:3:40 mins
Use ChatGPT to write a Car racing game
Video - 00:3:12 mins
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
What isPandas and why is it essential for data analysis?
Video - 00:5:6 mins
Create Project, Installing and Importing Pandas
Video - 00:00:00 mins
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
Data Cleaning in Pandas: Preparing Your Data for Analysis
Video - 00:7:00 mins
Renaming Columns on your report views
Video - 00:3:10 mins
Changing Data Types on Loading DataFrame
Video - 00:4:32 mins
Removing Duplicates from DataFrame data
Video - 00:5:34 mins
Pandas Data Transformation
Applying Lambda Function
Video - 00:3:51 mins
Pandas Data Aggregations and Grouping
Basic Aggregation Functions
Video - 00:5:33 mins
Data Aggregation Made Easy: Mastering the GroupBy Function
Video - 00:4:33 mins
Pandas Data Merging and Joining
Combining Data Efficiently: Merging Two DataFrames in Pandas
Video - 00:6:38 mins
Pandas & Matplotlib Data Visualization
Bringing Data to Life: Data Visualization Charts with Pandas & Matplotlib
Video - 00:6:42 mins
More
Announcements
Reviews
Course Info
Sign in
Sign up
Sign in
Don’t have an account?
Sign up
Remember me
Lost your password?
Sign up
Already have an account?
Sign in
Finish Course Early?
You have not completed all required lessons and assessments.
Your Progress
0%
Go Back to Course
Complete Anyway
