© 2021 RKY Consulting Services LTD – 14083757
UK VAT No: GB460281608
UK Registered Provider Number: 10094682
Payment Methods
Data Analyst / Business Intelligence Analyst
By RKY Tutor
Categories: Data Analysis
About Course
Data analysis and Business Intelligence have continued to prove to be an essential part of every business, as it enables the use of current and historical data to create actionable insights that aid makes better decision, from optimizing performance, improving target marketing, improving and automating processes, developing business strategies, resolving inefficiencies and increasing profitability.
This explains why Data Analysts and Business Intelligence Analysts are in great demand across businesses, industries, and countries.
Training Duration: 8 Weeks Intense Classes
What Will You Learn?
- Data Extraction
- Data Analysis
- Data Visualization
- Data Dashboards
- Business intelligence
Course Content
Taster Session
-
Part 1 – Course Intro
30:16 -
Part 2: Technical Session
39:16
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
57:44 -
Data Cleaning
38:41 -
Working with dates
16:10 -
Working with Cells, Ranges, and Tables
43:43 -
Statistics/Conditional Functions and Formulas
25:08 -
Text Functions & Data Separation
12:28 -
Data Validation
11:21 -
Conditional formatting
19:33 -
List Management
21:32 -
Financial function & Whatif Analysis.
27:09 -
Logical Condition
32:31 -
Advanced Lookup function 1
34:36 -
Advanced Lookup function 2
36:44 -
Power Querry
57:52 -
Pivot table & Charts
21:10 -
EXCEL DASHBOARD 1
50:45 -
EXCEL DASHBOARD 2
54:20 -
E-Books
-
Excel Shortcuts
-
Excel Formulas
-
Assignments
Data Visualization with Power Bi
-
Introduction to Power BI Desktop
01:10:46 -
Introduction to Power BI Desktop 2
49:39 -
Lab 1: Getting Data into Power BI Desktop
-
Data preparation Steps in Power BI
29:37 -
Lab 2: Data Integration, Preparation & Cleansing using Power Query
01:20:36 -
Data Modelling
50:15 -
Lab 3 : Data Modeling in Power BI Desktop using Sales Data.
11:49 -
Data Visualization
14:43 -
Data Visualization 2
01:50:06 -
Data Visualization 3
56:35 -
Lab 4: Data Visualization.
Data Analysis with SQL
-
Data Analysis with SQL 1
01:03:46 -
Lab 1: Restoring AdventureWorks Database to SSMS
56:17 -
SQL commands
01:09:59 -
SQL commands 2
33:50 -
Lab 2: SQL Commands using SSMS
-
Aggregate functions
45:56 -
Aggregate functions 2
26:12 -
Lab 3 : Performing aggregate Functions and Joining Tables
-
Integrating with SQL Database in Power BI.
01:33:11 -
Lab 4: Importing data from SQL Database into Power BI.
01:16:37 -
Bonus
02:00:45
FINAL PROJECT
-
SQL
-
Power BI
-
Excel
-
Final Project
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
57:13 -
Interview Preparation: Technical Questions
01:05:49 -
Landing your first Data Analyst | Business Analyst Job
01:56:19
Group Presentation
-
Group Presentation
02:04:36
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:07 -
Jan 24: Landing a UK Civil Service role in 2024
01:20:07 -
Feb 24: Navigating Uk Immigration Laws
01:24:44 -
March 24- Applying to NHS Jobs
01:47:10 -
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