Data Analysis | Business Intelligence 11.0
Course Content
Welcome Onboard
-
ToolKit – Downloadables before the Training
16:00 -
How To Navigate Basecamp
20:14 -
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
44:21 -
Working with Cells, Ranges, and Tables
01:01:32 -
Data Cleaning
01:09:09 -
Data Cleaning Cont’d
40:30 -
Text Functions & Data Separation
50:28 -
Working with dates
29:59 -
Statistics/Conditional Functions and Formulas
01:26:36 -
Conditional formatting
37:00 -
Data Validation
52:22 -
List Management
01:08:02 -
Group Project Presentation 1
-
Financial function & Whatif Analysis.
20:42 -
Excel
-
Logical Function
53:33 -
Advanced Lookup function
44:52 -
Advanced lookup function cont’d
40:33 -
Advanced lookup function (Recap)
30:38 -
Group Presentation
29:31 -
Power Querry
01:28:27 -
Power Qwery Contd
29:22 -
Pivot table & Charts | Excel Dashboard
02:01:12 -
Application of VLOOKUP
-
Working with cells, ranges and tables cont’d
56:32
Data visualization with PowerBI
-
Introduction to Power BI Desktop
02:00:28 -
Lab 1: Getting Data into Power BI Desktop
-
Merging Columns
29:18 -
Data preparation Steps in Power BI
-
Lab 2: Data Integration, Preparation & Cleansing using Power Query
-
Data Modelling
01:15:40 -
Lab 3 : Data Modeling in Power BI Desktop using Sales Data.
-
Data Visualization
01:02:28 -
Lab 4: Data Visualization. (DAX)
01:05:09 -
Group Presentation
43:36 -
Power BI Series
-
PowerBi
Data Analysis with SQL
-
Data Analysis with SQL
02:25:24 -
Lab 1: Restoring AdventureWorks Database to SSMS
-
SQL commands
02:30:41 -
Lab 2: SQL Commands using SSMS
-
Aggregate functions
01:56:49 -
Aggregate functions cont’d
02:07:52 -
SQL for Data Analyst
02:03:49 -
Lab 3: Performing Aggregate Functions and Joining Tables
-
Integrating with SQL Database in Power BI.
-
Lab 4: Importing data from SQL Database into Power BI.
Tableau
-
Tableau Fundamentals
02:02:40 -
Navigating and Configuring Tableau
02:01:16 -
Navigating and Configuring Tableau
02:14:15 -
Arrangements of sheets
01:15:17 -
The Vis :visualizations
-
Connection and Preparation of Data
-
Exploration of Data
-
Managing, Sorting and Grouping of Data
-
Configuring Filter
AI In Data Analysis
-
AI In Data Analysis
57:09
Python
-
Why should we learn python
43:28 -
Naming Convention for variables
-
Built in Data Types and Type Casting
-
Scope of Variables
Alteryx
-
Alteryx
Technical & Practical Based Questions
-
Technical & Practical Based Questions
02:26:55
PowerPoint
-
Module 1
41:26 -
Module 2
02:03:35 -
Module 2 Cont’d
-
Module 3
32:43 -
Module 3 Contd
01:23:42 -
Module 3 – 3
29:06 -
Group presentation / Case studies
36:21
Pre-Project Phase
-
Pre-Project Phase
Final Project
-
PowerBi
-
Excel
-
SQL
Data Insight Day
-
Data Insight Day
02:21:27
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