Data Analyst / Business Intelligence Analyst 2.0
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
- testing
Course Content
Taster Session
-
Course Intro
30: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
01:33:26 -
Data Cleaning
38:40 -
Working with dates
39:01 -
Working with Cells, Ranges, and Tables
01:09:27 -
Statistics/Conditional Functions and Formulas
25:09 -
Text Functions & Data Separation
01:47:11 -
Data Validation
11:21 -
Conditional formatting
19:33 -
List Management
21:32 -
Financial function & Whatif Analysis.
46:29 -
Logical Condition
27:10 -
Advanced Lookup function
12:41 -
Advanced Lookup function 2
53:04 -
Power Querry
30:40 -
Pivot table & Charts
01:22:29 -
EXCEL DASHBOARD
43:06 -
RECAP – Financial function & whatif analysis ; Logical functions
46:11 -
Excel Shortcuts
-
Excel Formulas
-
Mac Book Excel Shortcuts
-
Assignments
-
Re-Submit Assignments
-
E-Books
Data Visualization with Power Bi
-
Introduction to Power BI Desktop
01:54:33 -
Lab 1: Getting Data into Power BI Desktop
-
Data preparation Steps in Power BI
01:35:39 -
Lab 2: Data Integration, Preparation & Cleansing using Power Query
01:20:37 -
Data Modelling
01:39:00 -
Lab 3 : Data Modeling in Power BI Desktop using Sales Data.
11:49 -
Data Visualization
01:54:29 -
Lab 4: Data Visualization.
-
Assignments
-
ReSubmit Assignments
-
Other Resources
Data Analysis with SQL
-
Data Analysis with SQL
01:38:19 -
Lab 1: Restoring AdventureWorks Database to SSMS
56:17 -
SQL commands
01:50:14 -
Lab 2: SQL Commands using SSMS
-
Aggregate functions
01:52:27 -
Lab 3 : Performing aggregate Functions and Joining Tables
-
Integrating with SQL Database in Power BI.
01:31:05 -
Lab 4: Importing data from SQL Database into Power BI.
01:16:37
Tableau
-
Tableau Fundamentals
01:54:35 -
Connection and Preparation of Data
-
Managing, Sorting and Grouping of Data
-
Configuring Filter
-
Exploration of Data
01:47:26
Alteryx (copy)
-
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
-
Landing your first Data Analyst | Business Analyst Job
01:56:19
GROUP PROJECT
-
GROUP PROJECT
02:04:36 -
Submit Group project
FINAL PROJECT
-
SQL
-
Power BI
-
Excel
-
Tableau
-
Final Project
Drop In Sessions
-
Links
Data Insight Day
-
Data Insight Day
00:00
Career Support Session
-
Visa Sponsorship Strategies 25/8/2024
00:00 -
Landing Your First Project/Product role 25/8/2024
00:00 -
AI: A leverage to securing your desired role 25/8/2024
00:00
Alumni 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
01:47:10 -
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
01:53:10
Student Ratings & Reviews
No Review Yet