Data Analysis | Business Intelligence 9.0
By Oloruntoba Fasakin
Uncategorized
Course Content
Welcome Onboard
-
Welcome Onboard Links
-
ToolKit – Downloadables before the Training
16:00 -
How To Navigate Basecamp
20:15 -
How To Navigate Basecamp 2
01:13:04 -
How To Navigate LMS
02:12 -
Installing SQL server
08:35
Data Analysis With Excel
-
Getting Started with EXCEL
01:16:19 -
Working with Cells, Ranges, and Tables
01:33:20 -
Data Cleaning
59:41 -
Text Functions & Data Separation
01:06:13 -
Working with dates
01:04:49 -
Statistics/Conditional Functions and Formulas
01:07:41 -
Conditional formatting
43:03 -
Data Validation
49:54 -
List Management
46:09 -
Group Project Presentation 1
-
Financial function & Whatif Analysis.
54:12 -
Excel
-
Logical Condition
37:25 -
Advanced Lookup function
35:15 -
Application of VLOOKUP
01:15:59 -
Power Querry
16:17 -
Power Query Cont’d
55:04 -
Pivot table & Charts | Excel Dashboard
01:12:27 -
Pivot table & Charts | Excel Dashboard Cont’d
01:21:54 -
Group Presentation 2
Data visualization with PowerBI
-
Introduction to Power BI Desktop
41:34 -
Lab 1: Getting Data into Power BI Desktop
42:59 -
Data preparation Steps in Power BI
-
Lab 2: Data Integration, Preparation & Cleansing using Power Query
01:35:14 -
Data Modelling
01:24:30 -
Lab 3 : Data Modeling in Power BI Desktop using Sales Data.
-
Group Presentations
42:11 -
Assignment Briefing
51:48 -
Data Visualization
01:29:17 -
Lab 4: Data Visualization. (DAX)
41:33 -
Lab 4: Data Visualization (DAX) CONT’D
01:04:58 -
Power BI Series
01:05:26 -
PowerBi
-
Group Presentation 3
Data Analysis with SQL
-
Data Analysis with SQL
36:50 -
Lab 1: Restoring AdventureWorks Database to SSMS
01:42:51 -
SQL commands
02:16:56 -
Lab 2: SQL Commands using SSMS
-
Aggregate functions
01:11:46 -
Lab 3: Performing Aggregate Functions and Joining Tables
-
Integrating with SQL Database in Power BI.
44:14 -
Lab 4: Importing data from SQL Database into Power BI.
Tableau
-
Tableau Fundamentals
01:23:11 -
Tableau Fundamentals II
02:01:30 -
Navigating and Configuring Tableau
-
The Vis :visualizations
-
Connection and Preparation of Data
-
Exploration of Data
-
Managing, Sorting and Grouping of Data
-
Configuring Filter
PowerPoint
-
Module 1
01:38:58 -
Module 1 Cont’d
41:26 -
Module 2
02:03:34 -
Module 2 Cont’d
01:08:41 -
Module 3
32:43 -
Module 3 Contd
01:23:42 -
Module 3 – 3
29:06 -
Group presentation / Case studies
36:20
AI In Data Analysis
-
AI In Data Analysis
01:49:21
Python
-
Why should we learn python
43:28 -
Naming Convention for variables
-
Built in Data Types and Type Casting
-
Scope of Variables
Technical & Practical Based Questions
-
Technical & Practical Based Questions
01:41:56
Analytical Thinking case study
-
Analytical Thinking Casestudy
02:19:43
Interview Preparation Session
-
Interview Prep Session 1
58:06 -
Interview Prep 2
01:51:54 -
Interview Prep 3
02:01:53
Alteryx
-
Alteryx
02:00:44
Final Project
-
PowerBi
-
Excel
-
SQL
Pre-Project Phase
-
Pre-Project Phase
Group Project
-
Finance: Quantum Sphere Consulting Ltd
-
Submission 1
-
HR: Principal Jones Consulting
-
Submission 2
-
Tech: Synaptix Digital Solutions Ltd
-
Submission 3
-
Marketing: TFT Marketing Agency
-
Submission 4
-
Healthcare: Core Success Medical Centre
-
Submission 5
Data Insight Day
-
Data Insight Day
02:21:27
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