Data Analyst / Business Intelligence Analyst 4.0

Course Content

TimeTable

Timetable

Taster Session

Tool Kit – Downloadables before the Training

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

01:06:38
Data Cleaning

23:24
Working with dates

01:22:41
Assignments
Working with Cells, Ranges, and Tables

38:57
Working with Cells, Ranges, and Tables 2

01:09:36
Statistics/Conditional Functions and Formulas

50:14
Data Validation

21:03
Text Functions & Data Separation

38:28
Conditional formatting

44:06
List Management

59:47
Financial function & Whatif Analysis.

51:58
Logical Condition

50:19
Advanced Lookup function

01:09:19
Advanced Lookup function contd

45:42
Power Query

49:13
Power Query contd

43:58
Pivot table & Charts

58:05
EXCEL DASHBOARD

01:51:20
Project
Excel Quiz

Data Visualization with Power Bi

Introduction to Power BI Desktop

01:52:21
Lab 1: Getting Data into Power BI Desktop
Data preparation Steps in Power BI

01:51:19
Lab 2: Data Integration, Preparation & Cleansing using Power Query
Data Modelling

01:58:50
Lab 3 : Data Modeling in Power BI Desktop using Sales Data.
Data Visualization

01:56:12
Data Visualization 2

22:01
Lab 4: Data Visualization.

01:14:51
PowerBi

Data Analysis with SQL

Data Analysis with SQL

49:33
Lab 1: Restoring AdventureWorks Database to SSMS

37:22
SQL commands

01:55:45
Lab 2: SQL Commands using SSMS

25:22
Aggregate functions

01:06:28
Lab 3 : Performing aggregate Functions and Joining Tables
Integrating with SQL Database in Power BI.

14:37
Integrating with SQL Database in Power BI. 2

01:12:36
Lab 4: Importing data from SQL Database into Power BI.

31:35

Tableau

Python

Powerpoint

Alteryx

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

Group Project

FINAL PROJECT

Data Insight Day

Career Support Session

Alunmi Community

Oct 23: Getting that Job Offer

00:00
Nov 23: Getting NHS Visa Sponsorship Jobs

00:00
Dec 23: Accessing Remote Job Opportunities

00:00
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

00:00
August 24: Winning Job Application Strategy

00:00
September 24: An Evening With the CEO: Career Advancement & Jo Application Strategies

00:00
Oct 24: Roadmap to Global Talent Visa

00:00

Student Ratings & Reviews

No Review Yet

Course Content

TimeTable

Timetable

Taster Session

Taster Session

Tool Kit – Downloadables before the Training

Tools

SQL

Getting Started with EXCEL

Data Cleaning

Working with dates

Assignments

Working with Cells, Ranges, and Tables

Working with Cells, Ranges, and Tables 2

Statistics/Conditional Functions and Formulas

Data Validation

Text Functions & Data Separation

Conditional formatting

List Management

Financial function & Whatif Analysis.

Logical Condition

Advanced Lookup function

Advanced Lookup function contd

Power Query

Power Query contd

Pivot table & Charts

EXCEL DASHBOARD

Project

Excel Quiz

Data Visualization with Power Bi

Introduction to Power BI Desktop

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

Lab 3 : Data Modeling in Power BI Desktop using Sales Data.

Data Visualization

Data Visualization 2

Lab 4: Data Visualization.

PowerBi

Data Analysis with SQL

Data Analysis with SQL

Lab 1: Restoring AdventureWorks Database to SSMS

SQL commands

Lab 2: SQL Commands using SSMS

Aggregate functions

Lab 3 : Performing aggregate Functions and Joining Tables

Integrating with SQL Database in Power BI.

Integrating with SQL Database in Power BI. 2

Lab 4: Importing data from SQL Database into Power BI.

Tableau

Tableau Fundamentals

Connection and Preparation of Data

Exploration of Data

Managing, Sorting and Grouping of Data

Configuring Filter

Python

Why should we learn python

Built in Data Types and Type Casting

Scope of Variables

Naming Convention for variables

Powerpoint

Day 1

Day 2

Alteryx

Alteryx

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

Landing your first Data Analyst | Business Analyst Job

Technical Interview Session

Group Project

Group Project

Group Project Submissions

Presentation

FINAL PROJECT

SQL

Power BI

Assignments

Data Insight Day

Data Insight Day

Career Support Session

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