Data Analyst / Business Intelligence Analyst 5.0
Course Content
TimeTable
-
TimeTable
Free Career Workshop
-
Workshop
ToolKit – Downloadables before the Training
-
Tools
-
SQL
15:59
Data Analysis with MS Excel
-
Getting Started with EXCEL
52:25 -
Data Cleaning
56:01 -
Working with dates
07:01 -
Working with dates 2
44:45 -
Working with Cells, Ranges, and Tables
36:06 -
Working with Cells, Ranges, and Tables 2
54:53 -
Text Functions & Data Separation
40:31 -
Statistics/Conditional Functions and Formulas
40:06 -
Data Validation
31:14 -
Conditional formatting
31:47 -
List Management
48:01 -
Financial function & Whatif Analysis.
39:52 -
Logical Condition
33:49 -
Advanced Lookup function
28:29 -
Pivot table & Charts | Excel Dashboard
01:51:14 -
Power Querry
55:09 -
Excel
Data Visualization with Power Bi
-
Introduction to Power BI Desktop
56:39 -
Lab 1: Getting Data into Power BI Desktop
-
Data preparation Steps in Power BI
01:57:14 -
Lab 2: Data Integration, Preparation & Cleansing using Power Query
38:57 -
Data Modelling
01:06:34 -
Lab 3 : Data Modeling in Power BI Desktop using Sales Data.
49:44 -
Lab 3 contd : Data Modeling in Power BI Desktop using Sales Data.
17:19 -
Data Visualization
01:18:32 -
Lab 4: Data Visualization.
28:41 -
PowerBi
-
Power BI Analysis
38:12
Data Analysis with SQL
-
Data Analysis with SQL
01:58:30 -
Lab 1: Restoring AdventureWorks Database to SSMS
-
SQL commands
01:59:21 -
Lab 2: SQL Commands using SSMS
-
Aggregate functions
01:59:02 -
Lab 3: Performing Aggregate Functions and Joining Tables
20:17 -
Integrating with SQL Database in Power BI.
01:41:01 -
Lab 4: Importing data from SQL Database into Power BI.
Tableau
-
Tableau Fundamentals
01:30:34 -
Tableau Fundamentals 2
01:57:36 -
Navigating and Configuring Tableau
25:25 -
Connection and Preparation of Data
-
Exploration of Data
-
Managing, Sorting and Grouping of Data
-
Configuring Filter
Python
-
Why should we learn python
-
Naming Convention for variables
-
Built in Data Types and Type Casting
-
Scope of Variables
Powerpoint
-
Day 1
01:38:58 -
Day 2
02:03:35
Alteryx
-
Alteryx
02:00:45
Interview Preparation Session
-
Landing your first Data Analyst | Business Analyst Job
01:07:09 -
Technical Interview Session
Group Project
-
Group Project
01:32:41 -
Submission
FINAL PROJECT
-
Excel
-
Power BI
-
SQL
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
00:00 -
AI: A leverage to securing your desired role 25/8/2024
50:18
Alumni Community
-
Oct 23: Getting that Job Offer
00:00 -
Nov 23: Getting NHS Visa Sponsorship Jobs
01:47:10 -
Dec 23: Accessing Remote Job Opportunities
01:20:07 -
Jan 24: Landing a UK Civil Service role in 2024
00:00 -
Feb 24: Navigating Uk Immigration Laws
00:00 -
March 24- Applying to NHS Jobs
00:00 -
April 24: Leveraging and Getting Jobs During Recruitment Peak Periods
00:00 -
May 24: All About the UK Global Talent Visa
00:00 -
June 24: Harnessing the Power of Storytelling on Linkedin
00:00 -
July 24: Building an Outstanding Portfolio
01:27:17 -
August 24: Winning Job Application Strategy
00:00 -
September 24: An Evening With the CEO: Career Advancement & Jo Application Strategies
01:29:18 -
Oct 24: Roadmap to Global Talent Visa
00:00
Student Ratings & Reviews
No Review Yet