Data Analyst / Business Intelligence Analyst 6.0
Course Content
Welcome Onboard
-
Timetable
-
ToolKit – Downloadables before the Training
16:00
Data Analysis With Excel
-
Getting Started with EXCEL
33:50 -
Data Cleaning
47:25 -
Working with dates
21:12 -
Working with dates 2
44:23 -
Working with Cells, Ranges, and Tables
50:54 -
Text Functions & Data Separation
33:35 -
Statistics/Conditional Functions and Formulas
01:27:04 -
Data Validation
30:34 -
Conditional formatting
24:30 -
List Management
01:04:25 -
Financial function & Whatif Analysis.
57:29 -
Logical Condition
01:03:16 -
Advanced Lookup function
01:54:51 -
Pivot table & Charts | Excel Dashboard
35:28 -
Pivot Table 2
02:08:17 -
Power Querry
01:26:46 -
Excel
Data visualization with PowerBI
-
Introduction to Power BI Desktop
38:12 -
Lab 1: Getting Data into Power BI Desktop
01:26:37 -
Data preparation Steps in Power BI
01:55:53 -
Lab 2: Data Integration, Preparation & Cleansing using Power Query
-
Data Modelling
57:18 -
Data Modeling 2
02:07:33 -
Lab 3 : Data Modeling in Power BI Desktop using Sales Data.
01:08:50 -
Data Visualization
-
Lab 4: Data Visualization.
-
PowerBi
-
Intro to Power Bi Continued
Data Analysis with SQL
-
Data Analysis with SQL
02:02:44 -
Lab 1: Restoring AdventureWorks Database to SSMS
-
SQL commands
02:00:19 -
Lab 2: SQL Commands using SSMS
-
Aggregate functions
01:54:23 -
Aggregate Functions 2
45:33 -
Lab 3: Performing Aggregate Functions and Joining Tables
-
Integrating with SQL Database in Power BI.
01:27:00 -
Lab 4: Importing data from SQL Database into Power BI.
Tableau
-
Tableau Fundamentals
01:58:20 -
Tableau Fundamentals 2
01:30:34 -
Navigating and Configuring Tableau
-
Connection and Preparation of Data
-
Exploration of Data
02:01:42 -
Managing, Sorting and Grouping of Data
-
Configuring Filter
PowerPoint
-
Module 1
01:38:58 -
Module 2
02:03:34
Python
-
Why should we learn python
43:28 -
Naming Convention for variables
-
Built in Data Types and Type Casting
-
Scope of Variables
AI In Data Analysis
-
AI in data analysis
01:59:43
Group Presentation
-
Group Presentation
01:59:43
Alteryx
-
Alteryx
02:00:44
Interview Preparation Session
-
Interview Prep Session 1
58:06 -
Interview Prep (ContD)
01:51:54
Final Project
-
Excel
-
PowerBi
-
SQL
Group Project
-
Group Project
-
Group Project Submission
Data Insight Day
-
Data Insight Day
02:21:27
Career Support Session
-
Visa Sponsorship Strategies 25/8/2024
31:44 -
Landing Your First Project/Product role 25/8/2024
49:33 -
AI: A leverage to securing your desired role 25/8/2024
50:18
Alumni Community
-
Oct 23: Getting that Job Offer
01:49:30 -
Nov 23: Getting NHS Visa Sponsorship Jobs
01:47:10 -
Dec 23: Accessing Remote Job Opportunities
01:20:06 -
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:41 -
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:17 -
August 24: Winning Job Application Strategy
01:07:20 -
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