Data Analyst / Business Intelligence Analyst 3.0
Course Content
TimeTable
-
TimeTable
Taster Session
Tool Kit – Downloadables before the Training
Laptop Specification
Downloadables before the Training
-
Tools
Data Analysis with MS Excel
Our Microsoft Excel training will take you on an Excel journey that will remodel your existing skills. We will teach you in-demand Excel strategies that will allow you to transform your career.
This Microsoft Excel course is designed for those who want to advance their skills and focus on core Excel competencies
Through the use of real-world business scenarios, this training aims to make you an expert user of Microsoft Excel, dashboard creation, and business data analysis. It helps participants advance their skills in MS Excel and data analysis from the intermediate and advanced levels in a relatively short yet effective time frame
-
Getting Started with EXCEL
39:38 -
Data Cleaning
28:21 -
Working with dates
26:48 -
Working with Cells, Ranges, and Tables
50:49 -
Statistics/Conditional Functions and Formulas
34:12 -
Text Functions & Data Separation
08:48 -
Data Validation
08:38 -
Data Validation 2
01:25 -
Conditional formatting
14:39 -
Logical Condition
17:53 -
Advanced Lookup function
45:10 -
Power Querry
34:02 -
Power Querry 2
14:14 -
List Management
30:57 -
Financial function & Whatif Analysis.
37:13 -
Pivot table & Charts
42:01 -
EXCEL DASHBOARD
46:19 -
Excel Formulas
-
Excel Shortcuts
-
Mac Book Excel Shortcuts
-
Assignments
Data Visualization with Power Bi
-
Introduction to Power BI Desktop
01:28:00 -
Lab 1: Getting Data into Power BI Desktop
-
Lab 2: Data Integration, Preparation & Cleansing using Power Query
-
Data Modelling
01:00:30 -
Lab 3 : Data Modeling in Power BI Desktop using Sales Data.
-
Data preparation Steps in Power BI
01:46:15 -
Data Visualization
38:36 -
Lab 4: Data Visualization.
01:46:09 -
Data Visualization 2
46:38 -
Data Visualization : Power Service
01:05:34 -
Assignments
Data Analysis with SQL
-
Data Analysis with SQL
01:38:06 -
Lab 1: Restoring AdventureWorks Database to SSMS
-
SQL commands
01:27:29 -
Lab 2: SQL Commands using SSMS
-
Aggregate functions
23:53 -
Aggregate functions 2
01:51:58 -
Lab 3 : Performing aggregate Functions and Joining Tables
-
Integrating with SQL Database in Power BI.
01:11:14 -
Lab 4: Importing data from SQL Database into Power BI.
36:19 -
Assignments
Tableau
-
Tableau Fundamentals
01:50:32 -
Connection and Preparation of Data
01:48:39 -
Exploration of Data
01:05:05 -
Managing, Sorting and Grouping of Data
-
Configuring Filter
Python
-
Why should we learn Python?
43:27 -
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:44
Interview Preparation Session
Landing your First Data Analyst Job:
Soft Skills Required By Data Analyst
Technical Skills Required by Data Analyst
Visa Sponsorship Strategies
Interview Preparation
-Competency Based Questions
-Technical Questions & Answers
-Practical Questions
-
Interview Preparation Session
01:53:04
Group Project
-
Group Project
01:25:49 -
Group Project 2
01:04:12
FINAL PROJECT
-
SQL
-
SQL Assessment
-
Power BI
-
Power BI Assessment
-
Excel
-
Excel Assessment
-
Resubmit Excel Assessment
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
00:00
Alumni Community
-
Oct 23: Getting that Job Offer
01:49:30 -
Nov 23: Getting NHS Visa Sponsorship Jobs
00:00 -
Dec 23: Accessing Remote Job Opportunities
01:20:07 -
Jan 24: Landing a UK Civil Service role in 2024
01:20:06 -
Feb 24: Navigating Uk Immigration Laws
00:00 -
March 24- Applying to NHS Jobs
01:47:10 -
April 24: Leveraging and Getting Jobs During Recruitment Peak Periods
00:00 -
May 24: All About the UK Global Talent Visa
01:03:33 -
June 24: Harnessing the Power of Storytelling on Linkedin
00:00 -
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