Data Analysis | Business Intelligence 13.0
By Oloruntoba Fasakin
Uncategorized
Course Content
Welcome Onboard
-
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:34
Data Analysis with Excel
-
Getting Started with EXCEL
44:47 -
Working with Cells, Ranges, and Tables
01:20:34 -
Data Cleaning
02:03:56 -
Data Cleaning Cont’d
01:52:04 -
Text Functions & Data Separation
01:05:14 -
Working with dates
46:25 -
Working with dates cont’d
52:13 -
Statistics/Conditional Functions and Formulas
01:02:18 -
Conditional formatting
40:12 -
Conditional Formatting Cont’d
-
Data Validation
34:51 -
List Management
32:08 -
Group Project Presentation 1
-
Financial function & Whatif Analysis.
01:10:37 -
Excel
-
Logical Function
48:16 -
Advanced Lookup function
01:40:38 -
Group Presentation 1
11:52 -
Group Presentation
16:45 -
Power Querry
01:42:43 -
Power Qwery Contd
13:17 -
Pivot table & Charts | Excel Dashboard
01:43:04 -
Application of VLOOKUP
Data visualization with PowerBI
-
Introduction to Power BI Desktop
-
Lab 1: Getting Data into Power BI Desktop
-
Data preparation Steps in Power BI
02:07:59 -
Lab 2: Data Integration, Preparation & Cleansing using Power Query
-
Data Modelling
01:59:59 -
Data Modelling Contd
-
Lab 3 : Data Modeling in Power BI Desktop using Sales Data.
-
Data Visualization
01:48:10 -
Lab 4: Data Visualization. (DAX)
-
Group Presentation
26:11 -
Power BI Series
-
PowerBi
Data Analysis with SQL
-
Data Analysis with SQL
02:05:56 -
Lab 1: Restoring Adventure Works Database to SSMS
-
SQL commands
01:59:49 -
Lab 2: SQL Commands using SSMS
-
Aggregate functions
02:10:39 -
Lab 3: Performing Aggregate Functions and Joining Tables
02:31:17 -
Integrating with SQL Database in Power BI.
-
Lab 4: Importing data from SQL Database into Power BI.
Tableau
-
Tableau Fundamentals
02:09:42 -
Navigating and Configuring Tableau
02:00:47 -
The Vis :visualizations
-
Connection and Preparation of Data
-
Dashboard
02:09:12 -
Exploration of Data
-
Managing, Sorting and Grouping of Data
-
Configuring Filter
AI In Data Analysis
-
AI In Data Analysis
02:10:50
Interview Prep & Practical Based Questions
-
Interview Prep & Practical Based Questions
02:09:25
Python
-
Why should we learn python
43:27 -
Naming Convention for variables
-
Built in Data Types and Type Casting
-
Scope of Variables
Alteryx
-
Alteryx
02:00:44
Powerpoint
-
Module 1
-
Module 2
-
Module 2 Cont’d
-
Module 3
-
Module 3 Contd
-
Module 3 – 3
-
Group presentation / Case studies
Pre-project Phase
-
Pre-Project Phase
Final Project
-
PowerBi
-
Excel
-
SQL
Data Insight Day
-
Data Insight Day
Group Project
-
Finance: Quantum Sphere Consulting Ltd
-
Submission
-
HR: Principal Jones Consulting
-
Submission
-
Tech: Synaptix Digital Solutions Ltd
-
Submission
-
Marketing: TFT Marketing Agency
-
Submission
-
Healthcare: Core Success Medical Centre
-
Submission
Student Ratings & Reviews
No Review Yet