Business Data Analytics Bootcamp: Transform Data Into Intelligent Insights
How to ask great questions
Business Data Analytics Bootcamp: Transform Data Into Intelligent Insights
0%
Completed
Getting Started
Introduction
Video - 00:02:51 mins
Start on Windows, MacOS, and Linux
Video - 00:01:58 mins
How to ask great questions
Video - 00:01:49 mins
faq's
Video - 00:01:30 mins
Course Materials & Solutions
Reading
Introduction to Business Data Analytics
What is Business Analytics
Video - 00:08:32 mins
Importance of data analytics in decision-making
Video - 00:02:55 mins
Real-world applications of Business Analytics
Video - 00:04:48 mins
Overview of tools: Excel, SQL, Power BI, Python (Pandas)
Video - 00:06:44 mins
Excel Data Basics
Worksheet Basics
Video - 00:21:44 mins
Data Structuring and Formulas
Video - 00:11:55 mins
Data Formats
Video - 00:09:32 mins
Data Handling Basics – Cut Copy and Paste
Video - 00:06:28 mins
Save and Print in Excel
Video - 00:10:07 mins
Excel Ranges
Video - 00:04:40 mins
Mastering Excel with ChatGPT: AI-Powered Productivity and Automation
Video - 00:07:47 mins
Excel Formula and Functions
Basic Formula Operations
Video - 00:06:07 mins
Mathematical Functions Level1
Video - 00:19:47 mins
Mathematical Functions Level2
Video - 00:12:16 mins
Text Functions Level1
Video - 00:09:00 mins
Text Functions Level2
Video - 00:12:49 mins
Logical Functions (AND, OR, XOR)
Video - 00:10:56 mins
Date Time Functions
Video - 00:06:13 mins
Lookup Function - VLOOKUP
Video - 00:12:05 mins
Lookup Function - HLOOKUP
Video - 00:04:00 mins
HLOOKUP + Match Formula
Video - 00:08:27 mins
Match + Index Formula Combination
Video - 00:05:14 mins
Excel XLookup Only for Excel and Office 365
Lookup Function - XLOOKUP
Video - 00:07:32 mins
Handling #NA and Approximates match in XLOOKUP
Video - 00:10:24 mins
Wildcard matching in XLOOKUP
Video - 00:06:05 mins
Excel Data Transforming and Importing
Split Text into columns
Video - 00:06:56 mins
Flash Fill
Video - 00:06:57 mins
Remove Duplicates
Video - 00:07:39 mins
Data Validation
Video - 00:06:27 mins
Get - Import Data from Text
Video - 00:05:31 mins
Get - Import Data from CSV
Video - 00:03:15 mins
Excel Data Formatting and Table Design
Formatting Font
Video - 00:04:08 mins
Formatting Alignment
Video - 00:05:57 mins
Formatting Number
Video - 00:04:30 mins
Formatting Date
Video - 00:03:22 mins
Formatting Tables
Video - 00:05:06 mins
Excel Data Analysis with Pivot Tables
Creating PivotTables for Summarization
Video - 00:06:37 mins
Value Field Settings
Video - 00:03:59 mins
Number Format
Video - 00:02:20 mins
Pivot Table Design
Video - 00:03:13 mins
Excel Charts and Data Visualization
Excel Charts – Categories
Video - 00:02:23 mins
Elements of a chart
Video - 00:04:05 mins
Creating dynamic charts
Video - 00:01:48 mins
Column or Bar charts
Video - 00:04:46 mins
Formatting charts
Video - 00:03:30 mins
Line charts
Video - 00:02:06 mins
Area charts
Video - 00:01:46 mins
Pie and Doughnut charts
Video - 00:03:40 mins
Format Area Plot or XY chart
Video - 00:07:26 mins
Scatter or Bubble charts
Video - 00:02:01 mins
Microsoft SQL Server Setting Up
Microsoft SQL Server Installation
Video - 00:17:55 mins
SQL Server Management Studio (SSMS) Installation
Video - 00:08:12 mins
Connecting MS SQL (Windows Authentication)
Video - 00:03:37 mins
Connecting MS SQL (SQL Server Authentication)
Video - 00:03:10 mins
Download and Restore Sample Database
Video - 00:07:23 mins
Mastering SQL with ChatGPT: AI-Powered Skills and Automation
Video - 00:10:13 mins
SQL Azure Data Studio
What is Azure Data Studio
Video - 00:06:22 mins
Azure Data Studio Installation Steps
Video - 00:07:14 mins
Azure Data Studio to Connect SQL Server
Video - 00:08:57 mins
Create a Database
Video - 00:06:29 mins
Create a Table
Video - 00:08:44 mins
Insert Data Rows
Video - 00:06:33 mins
Getting Data using SQL Query
Video - 00:03:02 mins
SQL Database Basics: Getting Started with SSMS
Overview of Databases
Video - 00:10:38 mins
Creating Database
Video - 00:04:49 mins
SQL Data Types
Video - 00:03:20 mins
Column Data Types on SSMS
Video - 00:03:52 mins
Creating Table
Video - 00:09:06 mins
Overview of Primary Key and Foreign Key
Video - 00:04:01 mins
Primary Key
Video - 00:04:02 mins
Foreign Key
Video - 00:06:48 mins
Creating Temporary Tables
Video - 00:06:26 mins
SQL Statement for Data: Querying, Modifying and Managing Information
Insert Query Statement
Video - 00:08:22 mins
Update (Modifying) Query Statement
Video - 00:05:03 mins
Delete Query Statement
Video - 00:03:09 mins
SQL Statement Basics
SQL Statement Basic
Video - 00:03:15 mins
SELECT Statement
Video - 00:07:20 mins
SELECT DISTINCT for UNIQUE Data Reports
Video - 00:02:39 mins
SELECT with Column Custom Titles
Video - 00:2:31 mins
Column AS Statement
Video - 00:02:02 mins
Data Management: Data Filtering
SELECT WHERE Clause – Theory
Video - 00:03:36 mins
SELECT WHERE Clause – Practical
Video - 00:07:09 mins
Data Management: Aggregate Functions
Mastering SUM(): Aggregating Data in SQL
Video - 00:07:57 mins
MIN() & MAX(): Finding the Smallest and Largest Values in SQL
Video - 00:05:44 mins
Data Management: SQL Conditional Clause Query Statement
Order By Statement
Video - 00:05:22 mins
SELECT TOP Clause in SQL
Video - 00:04:02 mins
BETWEEN Command
Video - 00:08:05 mins
IN Operator
Video - 00:04:01 mins
Wildcard Characters and LIKE
Video - 00:04:50 mins
Data Management: SQL Group by Statement
Group by – Theory
Video - 00:03:08 mins
Group by – Practical
Video - 00:05:25 mins
HAVING Statement
Video - 00:03:29 mins
Data Management: JOINS in SQL – Combining Data Across Tables
Overview of JOINS in SQL
Video - 00:01:53 mins
Understanding JOINS: Combining Data Across Tables
Video - 00:02:12 mins
INNER JOIN: Retrieving Data from Multiple Tables
Video - 00:07:52 mins
LEFT JOIN: Retrieving All Records from Left Table
Video - 00:2:46 mins
Right JOIN in SQL: Retrieving Data from the Right Table
Video - 00:02:15 mins
FULL OUTER JOIN: Combining Results from Both Tables
Video - 00:01:57 mins
CROSS JOIN in SQL: Producing Cartesian Products
Video - 00:03:07 mins
SQL Server Azure Data Studio Visualization
Installing SandDance Extension
Video - 00:02:33 mins
Visualization Charts
Video - 00:04:53 mins
Multiple Table Data Charts
Video - 00:05:58 mins
SQL Server Azure Studio SQL for Data Analysis
Type Decision for Data Analysis
Video - 00:13:09 mins
Data Analysis with Case Statement and String Text
Video - 00:09:11 mins
SQL Server Importing & Exporting Data
Importing Text - Flat File
Video - 00:05:00 mins
Importing CSV or Excel file
Video - 00:02:37 mins
Export Data to Excel or any Format
Video - 00:06:04 mins
SQL Server Secure Backup and Restore Database
Creating Secure Database Backup
Video - 00:03:49 mins
Restoring Secure Backup Database
Video - 00:03:31 mins
Microsoft Power BI: Introduction
Business Intelligence and Power BI
Video - 00:06:40 mins
Overview of Power BI
Video - 00:06:53 mins
Importance of Data Visualization
Video - 00:07:04 mins
Components of Power BI
Video - 00:02:32 mins
Mastering Power BI with ChatGPT: AI-Powered Insights & Automation
Video - 00:05:01 mins
Power BI: Setting up Desktop Enviourment
Downloading and Installing Power BI Desktop
Video - 00:13:02 mins
Overview of Power BI Desktop Interface
Video - 00:08:55 mins
Basic Settings and Navigation
Video - 00:09:40 mins
Power BI: Connecting and Shaping Data
Types of Data Sources (Excel, SQL Server, Web Data, etc.)
Video - 00:04:56 mins
Connecting Power BI to Excel and CSV Files
Video - 00:13:02 mins
Using Power Query to Transforming Data
Video - 00:09:25 mins
Introduction to Power Query Editor
Video - 00:06:43 mins
Cleaning and Shaping Data
Video - 00:17:41 mins
Combining and Merge (Join) in Power Query
Video - 00:09:39 mins
Managing Relationships Between Data Tables
Video - 00:12:31 mins
Power BI: Data Modelling
Power BI: Data Modelling
Overview of Data Modelling
Video - 00:04:46 mins
Creating Relationships Between Tables
Video - 00:07:10 mins
Optimizing Data Models with Relationships
Video - 00:10:52 mins
Best Practices for Data Modelling
Video - 00:07:56 mins
Power BI: Data Analysis Expression (DAX)
Basics of Data Analysis Expressions (DAX)
Video - 00:03:11 mins
Create Calculated Columns using DAX formula
Video - 00:07:05 mins
Create Measures using DAX Formula
Video - 00:04:53 mins
Use DAX Calculations in Visualizations
Video - 00:03:17 mins
DAX Functions for Aggregations
Video - 00:14:52 mins
Filtering and Conditional Calculations
Video - 00:02:57 mins
Power BI: DAX – Time Intelligence Functions
Prepare Data for Functions
Video - 00:03:37 mins
Year-to-Date (YTD) Sales
Video - 00:02:39 mins
Month-to-Date (MTD) Sales
Video - 00:02:24 mins
Quarter-to-Date (QTD) Sales
Video - 00:01:39 mins
Year-Over-Year (YOY) Growth
Video - 00:02:24 mins
Use Measures in Visualizations
Video - 00:04:11 mins
Power BI: Data Visualization
Types of Visualizations in Power BI
Video - 00:02:16 mins
Creating Bar Charts
Video - 00:03:40 mins
Creating Pie Charts
Video - 00:03:59 mins
Creating Tables and Formatting
Video - 00:07:01 mins
Power BI: Interactive Dashboards (Sales Data – Case Study)
Best Practices for Dashboard Design
Video - 00:05:18 mins
Loading Dashboard Sample Data
Video - 00:02:40 mins
Total Revenue Card for Dashboard
Video - 00:02:42 mins
Revenue by Region Bar Chart for Dashboard
Video - 00:03:21 mins
Units Sold Over Timeline Chart for Dashboard
Video - 00:02:21 mins
Product Distribution Pie Chart for Dashboard
Video - 00:02:48 mins
Adding Slicers for Interactive Dashboard
Video - 00:07:37 mins
Save and Publish the Dashboard
Video - 00:3:11 mins
Power BI: Exporting – Publishing and Sharing
Export Power BI Template
Video - 00:03:23 mins
Export to Create PDF file
Video - 00:02:05 mins
Publishing to Power BI Service
Video - 00:04:47 mins
Sharing Reports and Dashboards
Video - 00:03:01 mins
Power BI: Mobile App Reporting
Design Mobile Dashboard layouts
Video - 00:03:35 mins
Viewing Reports on Mobile Devices
Video - 00:03:30 mins
Power BI Cheat Sheet
Reading
ChatGPT OpenAI: Introduction
What is ChatGPT AI
Video - 00:03:32 mins
Set Up an Account with ChatGPT
Video - 00:03:49 mins
How to Use ChatGPT Gen AI
Video - 00:05:30 mins
ChatGPT For Your day-to-day Tasks
Video - 00:05:12 mins
Python Setting Up Local Development Environment
Python App Installation step by step
Video - 00:07:03 mins
Python Code Editor IDE (PyCharm) Installation
Video - 00:12:19 mins
Getting Started First Python Project
Video - 00:08:28 mins
First Welcome “Hello World” Program
Video - 00:04:47 mins
Python Basics Using ChatGPT AI for Faster Learning
Use ChatGPT to Write Variables
Video - 00:05:43 mins
Use ChatGPT to Write Datatypes
Video - 00:04:26 mins
Use ChatGPT to Write Type casting
Video - 00:03:50 mins
Use ChatGPT to Write Strings
Video - 00:05:42 mins
Use ChatGPT to Write Operators
Video - 00:05:08 mins
Python Intermediate Using ChatGPT: Beyond the Basics
Use ChatGPT to Write If else Statements
Video - 00:03:07 mins
Use ChatGPT to Write While Loop
Video - 00:05:41 mins
Use ChatGPT to Write for loop
Video - 00:03:06 mins
Use ChatGPT to Write a Nested loop
Video - 00:02:58 mins
Exercise and Solution for It (Pyramid Pattern)
Video - 00:03:45 mins
Python Games Using ChatGPT
Use ChatGPT to Write Guessing Game
Video - 00:03:40 mins
Use ChatGPT to Write a Car Racing Game
Video - 00:03:12 mins
Python OOPS Mastery: Advanced Concepts with ChatGPT
Use ChatGPT to Write Functions
Video - 00:04:28 mins
Use ChatGPT to Explain Object Oriented Programming
Video - 00:06:02 mins
Use ChatGPT to Write Class Object Programs
Video - 00:03:20 mins
Use ChatGPT to Write Inheritance
Video - 00:05:41 mins
Use ChatGPT to Write Polymorphism
Video - 00:04:50 mins
Use ChatGPT to Write Abstract Classes
Video - 00:02:51 mins
Use ChatGPT to Write Encapsulation
Video - 00:03:38 mins
Python Pandas: Data Analysis Made Easy
What is Pandas and Why is it Essential for Data analysis?
Video - 00:05:06 mins
Installing and Importing Pandas
Video - 00:13:05 mins
Pandas Create and Loading Data
What is Pandas Data Frame
Video - 00:05:34 mins
Creating DataFrames Manually in Python Pandas
Video - 00:08: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:04:08 mins
Working with JSON: Loading and Reading Data Using Pandas
Video - 00:02:37 mins
Exploring Data Efficiently with Pandas: Key Techniques and Insights
Quick Data Preview: Retrieving the First 5 Rows in Pandas
Video - 00:03:35 mins
Exploring Data: Retrieving the Last 5 Rows in Pandas
Video - 00:01:49 mins
Identifying Data Types and non-null values
Video - 00:04:13 mins
Data Insights at a Glance: Generating Summary Statistics in Pandas
Video - 00:02:49 mins
Navigating Data Frames: Retrieving Rows and Columns in Pandas
Video - 00:01:59 mins
Understanding Your Data: Identifying Column Names in Pandas
Video - 00:01:54 mins
Pandas Data Cleaning: Handling Missing Values, Duplicates
Data Cleaning in Pandas: Preparing Your Data for Analysis
Video - 00:06:49 mins
Renaming Columns on Your Report Views
Video - 00:03:10 mins
Changing Data Types on Loading DataFrame
Video - 00:04:32 mins
Removing Duplicates from DataFrame Data
Video - 00:05:34 mins
Pandas Data Transformation
Applying Lambda Function
Video - 00:03:50 mins
Pandas Data Aggregation and Grouping
Basic Aggregation Functions
Video - 00:05:33 mins
Data Aggregation Made Easy: Mastering the GroupBy Function
Video - 00:04:33 mins
Pandas Data Merging and Joining
Combining Data Efficiently: Merging Two DataFrames in Pandas
Video - 00:06:37 mins
Pandas and Matplotlib Data Visualization
Bringing Data to Life: Data Visualization Charts with Pandas & Matplotlib
Video - 00:06:41 mins
Conclusion
Thank You
Reading
More
Announcements
Reviews
Course Info
Hide similarities
Highlight differences
Select the fields to be shown. Others will be hidden. Drag and drop to rearrange the order.
Image
SKU
Rating
Price
Stock
Availability
Add to cart
Description
Content
Weight
Dimensions
Additional information
Click outside to hide the comparison bar
Compare
