Getting Started
Course Materials & Solutions
Introduction to Business Data Analytics
What is Business Analytics08:32
Importance of data analytics in decision-making02:55
Real-world applications of Business Analytics04:48
Overview of tools: Excel, SQL, Power BI, Python (Pandas)06:44
Excel Data Basics
Worksheet Basics21:44
Data Structuring and Formulas11:55
Data Formats09:32
Data Handling Basics – Cut Copy and Paste06:28
Save and Print in Excel10:07
Excel Ranges04:40
Mastering Excel with ChatGPT: AI-Powered Productivity and Automation07:47
Excel Formula and Functions
Basic Formula Operations06:07
Mathematical Functions Level119:47
Mathematical Functions Level212:16
Text Functions Level109:00
Text Functions Level212:49
Logical Functions (AND, OR, XOR)10:56
Date Time Functions06:13
Lookup Function – VLOOKUP12:05
Lookup Function – HLOOKUP04:00
HLOOKUP + Match Formula08:27
Match + Index Formula Combination05:14
Excel XLookup Only for Excel and Office 365
Lookup Function – XLOOKUP07:32
Handling #NA and Approximates match in XLOOKUP10:24
Wildcard matching in XLOOKUP06:05
Excel Data Transforming and Importing
Split Text into columns06:56
Flash Fill06:57
Remove Duplicates07:39
Data Validation06:27
Get – Import Data from Text05:31
Get – Import Data from CSV03:15
Excel Data Formatting and Table Design
Formatting Font04:08
Formatting Alignment05:57
Formatting Number04:30
Formatting Date03:22
Formatting Tables05:06
Excel Data Analysis with Pivot Tables
Creating PivotTables for Summarization06:37
Value Field Settings03:59
Number Format02:20
Pivot Table Design03:13
Excel Charts and Data Visualization
Excel Charts – Categories02:23
Elements of a chart04:05
Creating dynamic charts01:48
Column or Bar charts04:46
Formatting charts03:30
Line charts02:06
Area charts01:46
Pie and Doughnut charts03:40
Format Area Plot or XY chart07:26
Scatter or Bubble charts02:01
Microsoft SQL Server Setting Up
Microsoft SQL Server Installation17:55
SQL Server Management Studio (SSMS) Installation08:12
Connecting MS SQL (Windows Authentication)03:37
Connecting MS SQL (SQL Server Authentication)03:10
Download and Restore Sample Database07:23
Mastering SQL with ChatGPT: AI-Powered Skills and Automation10:13
SQL Azure Data Studio
What is Azure Data Studio06:22
Azure Data Studio Installation Steps07:14
Azure Data Studio to Connect SQL Server08:57
Create a Database06:29
Create a Table08:44
Insert Data Rows06:33
Getting Data using SQL Query03:02
SQL Database Basics: Getting Started with SSMS
Overview of Databases10:38
Creating Database04:49
SQL Data Types03:20
Column Data Types on SSMS03:52
Creating Table09:06
Overview of Primary Key and Foreign Key04:01
Primary Key04:02
Foreign Key06:48
Creating Temporary Tables06:26
SQL Statement for Data: Querying, Modifying and Managing Information
Insert Query Statement08:22
Update (Modifying) Query Statement05:03
Delete Query Statement03:09
SQL Statement Basics
SQL Statement Basic03:15
SELECT Statement07:20
SELECT DISTINCT for UNIQUE Data Reports02:39
SELECT with Column Custom Titles02:31
Column AS Statement02:02
Data Management: Data Filtering
SELECT WHERE Clause – Theory03:36
SELECT WHERE Clause – Practical07:09
Data Management: Aggregate Functions
Mastering SUM(): Aggregating Data in SQL07:57
MIN() & MAX(): Finding the Smallest and Largest Values in SQL05:44
Data Management: SQL Conditional Clause Query Statement
Order By Statement05:22
SELECT TOP Clause in SQL04:02
BETWEEN Command08:05
IN Operator04:01
Wildcard Characters and LIKE04:50
Data Management: SQL Group by Statement
Group by – Theory03:08
Group by – Practical05:25
HAVING Statement03:29
Data Management: JOINS in SQL – Combining Data Across Tables
Overview of JOINS in SQL01:53
Understanding JOINS: Combining Data Across Tables02:12
INNER JOIN: Retrieving Data from Multiple Tables07:52
LEFT JOIN: Retrieving All Records from Left Table02:46
Right JOIN in SQL: Retrieving Data from the Right Table02:15
FULL OUTER JOIN: Combining Results from Both Tables01:57
CROSS JOIN in SQL: Producing Cartesian Products03:07
SQL Server Azure Data Studio Visualization
Installing SandDance Extension02:33
Visualization Charts04:53
Multiple Table Data Charts05:58
SQL Server Azure Studio SQL for Data Analysis
Type Decision for Data Analysis13:09
Data Analysis with Case Statement and String Text09:11
SQL Server Importing & Exporting Data
Importing Text – Flat File05:00
Importing CSV or Excel file02:37
Export Data to Excel or any Format06:04
SQL Server Secure Backup and Restore Database
Creating Secure Database Backup03:49
Restoring Secure Backup Database03:31
Microsoft Power BI: Introduction
Business Intelligence and Power BI06:40
Overview of Power BI06:53
Importance of Data Visualization07:04
Components of Power BI02:32
Mastering Power BI with ChatGPT: AI-Powered Insights & Automation05:01
Power BI: Setting up Desktop Enviourment
Downloading and Installing Power BI Desktop13:02
Overview of Power BI Desktop Interface08:55
Basic Settings and Navigation09:40
Power BI: Connecting and Shaping Data
Types of Data Sources (Excel, SQL Server, Web Data, etc.)04:56
Connecting Power BI to Excel and CSV Files13:02
Using Power Query to Transforming Data09:25
Introduction to Power Query Editor06:43
Cleaning and Shaping Data17:41
Combining and Merge (Join) in Power Query09:39
Managing Relationships Between Data Tables12:31
Power BI: Data Modelling
Power BI: Data Modelling
Overview of Data Modelling04:46
Creating Relationships Between Tables07:10
Optimizing Data Models with Relationships10:52
Best Practices for Data Modelling07:56
Power BI: Data Analysis Expression (DAX)
Basics of Data Analysis Expressions (DAX)03:11
Create Calculated Columns using DAX formula07:05
Create Measures using DAX Formula04:53
Use DAX Calculations in Visualizations03:17
DAX Functions for Aggregations14:52
Filtering and Conditional Calculations02:57
Power BI: DAX – Time Intelligence Functions
Prepare Data for Functions03:37
Year-to-Date (YTD) Sales02:39
Month-to-Date (MTD) Sales02:24
Quarter-to-Date (QTD) Sales01:39
Year-Over-Year (YOY) Growth02:24
Use Measures in Visualizations04:11
Power BI: Data Visualization
Types of Visualizations in Power BI02:16
Creating Bar Charts03:40
Creating Pie Charts03:59
Creating Tables and Formatting07:01
Power BI: Interactive Dashboards (Sales Data – Case Study)
Best Practices for Dashboard Design05:18
Loading Dashboard Sample Data02:40
Total Revenue Card for Dashboard02:42
Revenue by Region Bar Chart for Dashboard03:21
Units Sold Over Timeline Chart for Dashboard02:21
Product Distribution Pie Chart for Dashboard02:48
Adding Slicers for Interactive Dashboard07:37
Save and Publish the Dashboard03:11
Power BI: Exporting – Publishing and Sharing
Export Power BI Template03:23
Export to Create PDF file02:05
Publishing to Power BI Service04:47
Sharing Reports and Dashboards03:01
Power BI: Mobile App Reporting
Design Mobile Dashboard layouts03:35
Viewing Reports on Mobile Devices03:30
Power BI Cheat Sheet
ChatGPT OpenAI: Introduction
What is ChatGPT AI03:32
Set Up an Account with ChatGPT03:49
How to Use ChatGPT Gen AI05:30
ChatGPT For Your day-to-day Tasks05:12
Python Setting Up Local Development Environment
Python App Installation step by step07:03
Python Code Editor IDE (PyCharm) Installation12:19
Getting Started First Python Project08:28
First Welcome “Hello World” Program04:47
Python Basics Using ChatGPT AI for Faster Learning
Use ChatGPT to Write Variables05:43
Use ChatGPT to Write Datatypes04:26
Use ChatGPT to Write Type casting03:50
Use ChatGPT to Write Strings05:42
Use ChatGPT to Write Operators05:08
Python Intermediate Using ChatGPT: Beyond the Basics
Use ChatGPT to Write If else Statements03:07
Use ChatGPT to Write While Loop05:41
Use ChatGPT to Write for loop03:06
Use ChatGPT to Write a Nested loop02:58
Exercise and Solution for It (Pyramid Pattern)03:45
Python Games Using ChatGPT
Use ChatGPT to Write Guessing Game03:40
Use ChatGPT to Write a Car Racing Game03:12
Python OOPS Mastery: Advanced Concepts with ChatGPT
Use ChatGPT to Write Functions04:28
Use ChatGPT to Explain Object Oriented Programming06:02
Use ChatGPT to Write Class Object Programs03:20
Use ChatGPT to Write Inheritance05:41
Use ChatGPT to Write Polymorphism04:50
Use ChatGPT to Write Abstract Classes02:51
Use ChatGPT to Write Encapsulation03:38
Python Pandas: Data Analysis Made Easy
What is Pandas and Why is it Essential for Data analysis?05:06
Installing and Importing Pandas13:05
Pandas Create and Loading Data
What is Pandas Data Frame05:34
Creating DataFrames Manually in Python Pandas08:43
Mastering Data Import: Loading CSV Files with Pandas11:21
Seamless Data Import: Loading Excel Files with Pandas04:08
Working with JSON: Loading and Reading Data Using Pandas02:37
Exploring Data Efficiently with Pandas: Key Techniques and Insights
Quick Data Preview: Retrieving the First 5 Rows in Pandas03:35
Exploring Data: Retrieving the Last 5 Rows in Pandas01:49
Identifying Data Types and non-null values04:13
Data Insights at a Glance: Generating Summary Statistics in Pandas02:49
Navigating Data Frames: Retrieving Rows and Columns in Pandas01:59
Understanding Your Data: Identifying Column Names in Pandas01:54
Pandas Data Cleaning: Handling Missing Values, Duplicates
Data Cleaning in Pandas: Preparing Your Data for Analysis06:49
Renaming Columns on Your Report Views03:10
Changing Data Types on Loading DataFrame04:32
Removing Duplicates from DataFrame Data05:34
Pandas Data Transformation
Applying Lambda Function03:50
Pandas Data Aggregation and Grouping
Basic Aggregation Functions05:33
Data Aggregation Made Easy: Mastering the GroupBy Function04:33
Pandas Data Merging and Joining
Combining Data Efficiently: Merging Two DataFrames in Pandas06:37
Pandas and Matplotlib Data Visualization
Bringing Data to Life: Data Visualization Charts with Pandas & Matplotlib06:41
Conclusion
Thank You
faq’s
