Data Analysis | Business Intelligence 8.0
Course Content
Welcome Onboard
-
ToolKit – Downloadables before the Training
-
How To Navigate Basecamp
20:14 -
How To Navigate Basecamp 2
01:13:04
Data Analysis With Excel
-
Getting Started with EXCEL
59:02 -
Working with Cells, Ranges, and Tables
01:09:20 -
Working with dates
-
Data Cleaning
44:44 -
Text Functions & Data Separation
47:56 -
Date Function
58:13 -
Statistics/Conditional Functions and Formulas
01:09:38 -
Conditional formatting
38:26 -
Data Validation
27:48 -
List Management
56:50 -
Financial function & Whatif Analysis.
47:59 -
Logical Condition
32:01 -
Advanced Lookup function
39:36 -
Advanced Lookup Function 2
36:43 -
Power Querry
56:28 -
Pivot table & Charts | Excel Dashboard
24:22 -
Pivot Table & chats continuation
02:02:54 -
Excel
Data visualization with PowerBI
-
Introduction to Power BI Desktop
31:01 -
Lab 1: Getting Data into Power BI Desktop
01:30:46 -
Data preparation Steps in Power BI
01:57:39 -
Lab 2: Data Integration, Preparation & Cleansing using Power Query
55:37 -
Data Modelling
01:51:17 -
Lab 3 : Data Modeling in Power BI Desktop using Sales Data.
34:41 -
Data Visualization
53:57 -
Lab 4: Data Visualization.
-
PowerBi
Data Analysis with SQL
-
Data Analysis with SQL
01:58:28 -
Lab 1: Restoring AdventureWorks Database to SSMS
-
SQL commands
01:36:05 -
Lab 2: SQL Commands using SSMS
-
Aggregate functions
21:09 -
Aggregate functions (CONTD)
01:33:58 -
Lab 3: Performing Aggregate Functions and Joining Tables
-
Integrating with SQL Database in Power BI.
30:42 -
Lab 4: Importing data from SQL Database into Power BI.
01:17:32
Tableau
-
Tableau Fundamentals
30:17 -
Navigating and Configuring Tableau
11:03 -
Navigating and Configuring Tableau Contd
01:59:05 -
Connection and Preparation of Data
-
Exploration of Data
-
Managing, Sorting and Grouping of Data
-
Configuring Filter
PowerPoint
-
Module 1
01:38:58 -
Module 2
02:03:35
Python
-
Why should we learn python
43:28 -
Naming Convention for variables
-
Built in Data Types and Type Casting
-
Scope of Variables
AI In Data Analysis
-
AI in data analysis
01:50:22
Alteryx
-
Alteryx
02:00:44
Technical & Practical Based Questions
-
Technical & Practical Based Questions
01:41:55 -
Technical questions 2
01:03:09 -
Practical Questions
55:11
Final Project
-
PowerBi
-
Excel
-
SQL
Pre-Project Phase
-
Pre-Project Phase
01:13:27
Group Project
-
Finance : Ritem Consulting Ltd
-
Submission 1
-
HR: JIRAD Consulting Ltd
-
Submission 2
-
Tech: Sinot Tech Solutions Ltd
-
Submission 3
-
Marketing: TFT Marketing Agency
-
Submission 4
-
Healthcare : Align Medical Centre
-
Submission 5
Data Insight Day
-
Data Insight Day
02:21:27
Interview Preparation Session
-
Interview Prep Session 1
58:06 -
Interview Prep (ContD)
01:51:54
Career Support Session
-
Visa Sponsorship Strategies 25/8/2024
31:43 -
Landing Your First Project/Product role 25/8/2024
49:33 -
AI: A leverage to securing your desired role 25/8/2024
50:18
Student Ratings & Reviews
No Review Yet