Data Analysis | Business Intelligence 12.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:12 -
Installing SQL server
08:35
Data Analysis With Excel
-
Getting Started with EXCEL
01:47:06 -
Working with Cells, Ranges, and Tables
01:01:46 -
Data Cleaning
45:13 -
Data Cleaning Cont’d
-
Text Functions & Data Separation
53:43 -
Working with dates
01:04:47 -
working with dates f cont’d
26:06 -
Statistics/Conditional Functions and Formulas
01:17:46 -
Conditional formatting
18:27 -
Conditional Formatting Cont’d
29:31 -
Data Validation
32:45 -
List Management
33:36 -
Group Project Presentation 1
27:36 -
Financial function & Whatif Analysis.
50:12 -
Excel
-
Logical Function
44:28 -
Advanced Lookup function
22:05 -
Advanced lookup function cont’d
01:12:07 -
Group Presentation
-
Power Querry
01:06:51 -
Power Qwery Contd
02:06:37 -
Pivot table & Charts | Excel Dashboard
02:05:19 -
Application of VLOOKUP
Data visualization with PowerBI
-
Introduction to Power BI Desktop
02:00:50 -
Lab 1: Getting Data into Power BI Desktop
-
Data preparation Steps in Power BI
-
Lab 2: Data Integration, Preparation & Cleansing using Power Query
-
Data Modelling
02:02:39 -
Data Modelling Contd
02:09:27 -
Lab 3 : Data Modeling in Power BI Desktop using Sales Data.
-
Data Visualization
-
Lab 4: Data Visualization. (DAX)
-
Group Presentation
-
Power BI Series
53:58 -
PowerBi
Data Analysis with SQL
-
Data Analysis with SQL
02:26:53 -
Lab 1: Restoring AdventureWorks Database to SSMS
-
SQL commands
02:02:18 -
Lab 2: SQL Commands using SSMS
-
Aggregate functions
02:10:54 -
Lab 3: Performing Aggregate Functions and Joining Tables
02:10:55 -
Integrating with SQL Database in Power BI.
01:59:06 -
Lab 4: Importing data from SQL Database into Power BI.
Tableau
-
Tableau Fundamentals
02:01:31 -
Navigating and Configuring Tableau
02:18:48 -
The Vis :visualizations
-
Connection and Preparation of Data
-
Exploration of Data
-
Managing, Sorting and Grouping of Data
-
Configuring Filter
Technical Soft skills & Practical Based Questions
-
Technical Soft Skills
01:18:25
AI In Data Analysis
-
AI In Data Analysis
01:58:55
Python
-
Why should we learn python
-
Naming Convention for variables
-
Built in Data Types and Type Casting
-
Scope of Variables
Alteryx
-
Alteryx
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