Data Analysis | Business Intelligence 7.0
Course Content
Welcome Onboard
-
Timetable
-
ToolKit – Downloadables before the Training
Data Analysis With Excel
-
Getting Started with EXCEL
48:03 -
Data Cleaning
01:03:39 -
Working with dates
56:41 -
Working with Cells, Ranges, and Tables
01:13:44 -
Text Functions & Data Separation
33:36 -
Statistics/Conditional Functions and Formulas
01:29:27 -
Data Validation
32:20 -
Conditional formatting
42:35 -
List Management
37:57 -
Financial function & Whatif Analysis.
47:42 -
Logical Condition
44:55 -
Advanced Lookup function
01:25:06 -
Advanced lookup function continued
21:57 -
Power Querry
01:26:46 -
Pivot table & Charts | Excel Dashboard
52:18 -
Pivot Table 2
01:10:20 -
Excel
Data visualization with PowerBI
-
Introduction to Power BI Desktop
02:06:06 -
Lab 1: Getting Data into Power BI Desktop
38:43 -
Data preparation Steps in Power BI
02:08:39 -
Lab 2: Data Integration, Preparation & Cleansing using Power Query
-
Data Modelling
01:20:51 -
Lab 3 : Data Modeling in Power BI Desktop using Sales Data.
-
Data Visualization
02:10:50 -
Lab 4: Data Visualization.
-
PowerBi
Data Analysis with SQL
-
Data Analysis with SQL
02:04:30 -
Lab 1: Restoring AdventureWorks Database to SSMS
-
SQL commands
02:03:45 -
Lab 2: SQL Commands using SSMS
-
Aggregate functions
01:17:07 -
Lab 3: Performing Aggregate Functions and Joining Tables
-
Integrating with SQL Database in Power BI.
52:18 -
Lab 4: Importing data from SQL Database into Power BI.
Tableau
-
Tableau Fundamentals
11:09 -
Tableau Fundamentals II
11:39 -
Navigating and Configuring Tableau
01:34:57 -
The Vis :visualizations
11:35 -
Building Dashboard in Tableau
02:11:36 -
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:53:29
Group Presentation
-
Group Presentation
01:01:21
Interview Preparation Session
-
Interview Prep Session 1
01:19:54
Technical & Practical Based Questions
-
Technical & Practical Based Questions
01:41:56
PowerPoint
-
Module 1
01:38:58 -
Module 2
02:03:35
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:45
Final Project
-
PowerBi
-
Excel
-
SQL
Group Project
-
Group Project
-
Group Project Submission
Data Insight Day
-
Data Insight Day
02:21:27
Alumni Community
-
Oct 23- Getting That Job Offer
01:49:30 -
Nov 23- Getting NHS Job Sponsorship
01:47:10 -
Dec 23: Accessing Remote Job Opportunities Across Borders
01:20:07 -
Jan 24: Landing a UK Civil Service role in 2024
01:20:06 -
Feb 24: Navigating Uk Immigration Laws
01:24:44 -
March 24- Applying to NHS Jobs
02:06:42 -
April 24: Leveraging and Getting Jobs During Recruitment Peak Periods
01:05:02 -
May 24: All About the UK Global Talent Visa
01:03:33 -
June 24: Harnessing the Power of Storytelling on Linkedin
02:06:11 -
July 24: Building an Outstanding Portfolio
01:27:18 -
August 24: Winning Job Application Strategy
01:07:21 -
September 24: An Evening With the CEO: Career Advancement & Jo Application Strategies
01:29:18 -
Oct 24: Roadmap to Global Talent Visa
01:53:10
Student Ratings & Reviews
No Review Yet