Data Analysis | Business Intelligence 10.0
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:11 -
Installing SQL server
08:35
Data Analysis With Excel
-
Getting Started with EXCEL
58:20 -
Working with Cells, Ranges, and Tables
56:34 -
Data Cleaning
02:07:02 -
Text Functions & Data Separation
01:02:54 -
Working with dates
01:12:02 -
Statistics/Conditional Functions and Formulas
01:36:13 -
Conditional formatting
30:03 -
Data Validation
29:24 -
List Management
01:01:30 -
Group Project Presentation 1
-
Financial function & Whatif Analysis.
49:03 -
Excel
-
Logical Function
59:46 -
Advanced Lookup function
01:14:49 -
Power Querry
01:58:26 -
Pivot table & Charts | Excel Dashboard
01:12:46 -
Group Presentation 2
30:57 -
Pivot Table Cont’d
01:37:59 -
Application of VLOOKUP
-
Questions and Answer
30:10
Data visualization with PowerBI
-
Introduction to Power BI Desktop
22:54 -
Lab 1: Getting Data into Power BI Desktop
43:00 -
Data preparation Steps in Power BI
01:57:39 -
Data preparation steps contd
58:17 -
Lab 2: Data Integration, Preparation & Cleansing using Power Query
-
Data Modelling
51:15 -
Lab 3 : Data Modeling in Power BI Desktop using Sales Data.
-
Lab 4: Data Visualization. (DAX)
01:04:20 -
Data Visualization
-
Power BI Series
22:54 -
Power BI Series Continued
02:24:46 -
PowerBi
Data Analysis with SQL
-
Data Analysis with SQL
02:09:26 -
Lab 1: Restoring AdventureWorks Database to SSMS
-
SQL Commands 1 (complete)
02:16:55 -
SQL commands 2
01:22:33 -
Lab 2: SQL Commands using SSMS
-
Aggregate functions
01:23:51 -
Lab 3: Performing Aggregate Functions and Joining Tables
-
Integrating with SQL Database in Power BI.
01:09:03 -
Lab 4: Importing data from SQL Database into Power BI.
Tableau
-
Tableau Fundamentals
23:41 -
The Vis :visualizations
13:42 -
Navigating and Configuring Tableau
01:24:42 -
Tableau Fundamentals II
01:59:29 -
Connection and Preparation of Data
-
Exploration of Data
-
Managing, Sorting and Grouping of Data
-
Configuring Filter
AI In Data Analysis
-
AI In Data Analysis
02:01:05
Python
-
Why should we learn python
43:27 -
Naming Convention for variables
-
Built in Data Types and Type Casting
-
Scope of Variables
Alteryx (Bonus)
-
Alteryx (Bouns)
02:00:45
PowerPoint
-
Module 1
41:26 -
Module 2
02:03:35 -
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:21
Technical & Practical Based Questions
-
Technical & Practical Based Questions
01:41:55
Pre-Project Phase
-
Pre-Project Phase
01:30:11
Final Project
-
PowerBi
-
Excel
-
SQL
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
Data Insight Day
-
Data Insight Day
02:21:27
Interview Preparation Session
Student Ratings & Reviews
No Review Yet