Data Analysis | Business Intelligence 14.0
Course Content
Welcome Onboard
-
ToolKit – Downloadables before the Training
15:59 -
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
02:03:20 -
Working with Cells, Ranges, and Tables
51:02 -
Data Cleaning
01:08:11 -
Data Cleaning Cont’d
-
Text Functions & Data Separation
42:32 -
Working with dates
01:02:13 -
Statistics/Conditional Functions and Formulas
32:42 -
Statistics/Conditional Functions & Formulas (ii)
01:02:18 -
Conditional formatting
40:12 -
Data Validation
34:52 -
List Management
45:54 -
Group Project Presentation 1
-
Financial function & Whatif Analysis.
51:28 -
Excel
-
Logical Function
16:17 -
logical Function Continued
48:14 -
Advanced Lookup function
01:12:40 -
Group Presentation
23:51 -
Power Querry
01:25:43 -
Power Qwery Contd
01:56:59 -
Pivot table & Charts | Excel Dashboard
-
Application of VLOOKUP
Data visualization with PowerBI
-
Introduction to Power BI Desktop
01:37:15 -
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
57:39 -
Data Modelling Contd
-
Lab 3 : Data Modeling in Power BI Desktop using Sales Data.
-
Data Visualization
55:00 -
Data Visualisation Cont’d
43:50 -
Group Presentation
37:19 -
Lab 4: Data Visualization. (DAX)
01:13:36 -
Data Visualisation (DAX) Cont’d
01:52:44 -
Power BI Series
-
PowerBi
Data Analysis with SQL
-
Data Analysis with SQL
02:07:32 -
Lab 1: Restoring Adventure Works Database to SSMS
01:04:09 -
SQL commands
01:14:46 -
Lab 2: SQL Commands using SSMS
-
Aggregate functions
01:38:49 -
Lab 3: Performing Aggregate Functions and Joining Tables
40:13 -
Integrating with SQL Database in Power BI.
01:55:02 -
Lab 4: Importing data from SQL Database into Power BI.
Tableau
-
Tableau Fundamentals
01:31:24 -
Navigating and Configuring Tableau
02:15:57 -
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
01:45:29
Interview prep
-
Overview of a Data analyst/ Interview Prep
02:13:40
Python
-
Why should we learn python
43:28 -
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