Data Analysis Mentorship Bundle – Complete Package

About Course

Unlock a comprehensive learning experience with our Data Analysis Mentorship Bundle, designed for professionals and organizations looking to develop a high-level skill set in data analysis and business intelligence. This all-in-one bundle includes access to key tools and platforms used by top data professionals today, such as Microsoft Excel, Power BI, Tableau, Python, and SQL.

In addition to the technical training, we provide hands-on internships in Excel, Power BI, and SQL, where you can apply your skills in real-world scenarios. This course also comes with valuable bonus packages, including a Free Portfolio Kit to showcase your work, an Upwork Mastery Kit to help you secure freelance gigs, CV Revamping to make your resume stand out, and LinkedIn Optimization to enhance your professional profile.

By completing this bundle, you will gain in-depth knowledge of the most essential tools in data analysis, practical experience through internships, and a fully optimized professional presence, ensuring you’re ready for success in the competitive data analytics field. Whether you’re looking to upskill, reskill, or enhance your organization’s capabilities, this comprehensive package offers everything you need to become a data analysis expert. Join us at Teck-Skills and take the next step toward your career in data analysis!

Here are the learning objectives for the Data Analysis Corporate Bundle course:

Master Key Data Analysis Tools and Techniques
- Gain proficiency in Microsoft Excel, Power BI, Tableau, Python, and SQL for data analysis and reporting.
Develop Practical Skills through Internships
- Apply theoretical knowledge to real-world scenarios with internships in Excel, Power BI, and SQL, building hands-on experience.
Create Compelling Data Visualizations
- Learn how to design impactful data visualizations using Power BI and Tableau, enabling clear communication of insights.
Understand Data Querying and Manipulation
- Master SQL and Python to query, manipulate, and analyze data effectively, ensuring actionable insights.
Build a Strong Data Analysis Portfolio
- Develop a professional portfolio showcasing your data analysis projects, adding credibility to your skillset.
Enhance Freelance Opportunities with Upwork Mastery
- Gain the skills needed to attract clients and secure projects on Upwork, with specialized tips and strategies for data analysis professionals.
Revamp Your CV and Optimize Your LinkedIn Profile
- Learn how to optimize your CV and LinkedIn profile to stand out in the job market and attract top employers.
Demonstrate Industry-Relevant Skills for Data-Driven Decision Making
- Equip yourself with industry-standard tools and techniques that allow you to make data-driven decisions and drive business outcomes.

This course will prepare you with the technical skills, real-world experience, and professional tools necessary to excel in the competitive field of data analysis!

Master essential data analysis tools such as Microsoft Excel, Power BI, Tableau, Python, and SQL.
Gain practical experience through internships in Excel, Power BI, and SQL, applying real-world skills.
Design and create visually compelling data visualizations using Power BI and Tableau.
Develop strong querying and data manipulation skills with SQL and Python.
Build a professional portfolio to showcase your data analysis projects.
Learn strategies for succeeding on Upwork and securing freelance opportunities in data analysis.
Optimize your CV and LinkedIn profile to attract employers and opportunities.
Gain expertise in using data for decision-making, solving business challenges with data insights.

Course Content

Module 1: Introduction to Data Analysis & Excel Fundamentals

1.1 Introduction to Data Analysis

22:35
1.2 Introduction to Microsoft Excel – Excel interface and navigation essentials

22:24
1.3 Data Types in MS Excel

08:24
1.4 Data Entry in Ms Excel

09:07
1.5 Formatting I

10:03
1.6 Formatting II

09:29
1.7 Formatting III – Conditional Formatting I

08:03
1.8 Formatting III – Conditional Formatting II

07:08
1.9 Structured Datasets

02:47
1.10 Unstructured Datasets

03:59
1.11 Protecting a Sheet

08:09
1.12 Protecting a Document

04:01
1.13 Printing an Excel Document

11:12
Download Learning Resources

Module 2: Essential Excel Functions for Analysis

2.1 Number Functions I

19:06
2.2 Number Functions II

17:08
2.3 Consolidation

09:29
2.4 Logical Functions I – IF, SUMIF, COUNTIF

16:45
2.5 Logical Functions II – IFS, SUMIFS, COUNTIFS, MAXIFS, AND, OR

18:30
2.6 TEXT Functions

14:52
2.7 Time and Date Functions I

09:25
2.8 Time and Date Functions II

12:05
2.9 Time Intelligence Functions

17:19
2.10 Lookup Functions – HLOOKUP, VLOOKUP XLOOKUP

10:27
2.11 Lookup Functions – INDEX AND MATCH

08:25
2.12 Lookup Functions – WILDCARDS

06:26
2.13 Error Handling Functions

07:49
2.14 Lookup Functions – Multiple VLOOKUP

06:13
2.15 Other Data Analysis Functions

13:46

Module 3: Data Cleaning & Preparation (ETL in Excel)

3.1 Removing Duplicates

04:51
3.2 Removing Blank Rows

08:17
3.3 Removing Blank Columns

06:53
3.4 Text to Columns

05:19
3.5 Find and Replace

02:59
3.6 Data Validation I

16:52
3.7 Data Validation – Custom Formula

19:03
3.8 Searchable Dropdown List

09:10
3.9 Handling Missing and Inconsistent Records

06:19
3.10 Introduction to Power Query

24:14

Module 4: Exploratory Data Analysis (EDA)

Module 5: Advanced Excel Tools for Data Analysis

5.1 Power Query – Data Cleaning

07:32
5.2 Power Query – Transformation

06:00
5.3 Power Query – Transpose

01:35
5.4 Power Query – Unpivot

02:43
5.5 Data Scraping with Power Query

07:22
5.6 Multiple Files Combination – Append

13:18
5.7 Multiple Files Combination – Merge

07:19
5.8 Group and Aggregate

03:22
5.9 M Language in Power Query

05:17
5.10 Data Normalization I

06:20
5.11 Data Normalization II

14:06
5.12 Data Modeling

08:49
5.13 What IF Analysis – Scenario Manager

10:36
5.14 What IF Analysis – Goal Seek and Solver

13:18
5.15 What IF Analysis – Data Table

08:05

Module 6: Data Visualization & Dashboards

6.1 Introduction to Visualizations

10:41
6.2 Visualization – Pie Charts and Donought Chart

14:44
6.3 Visualization – Column Chart and Bar Chart

05:48
6.4 Visualization – Funnel Chart

04:58
6.5 Visualization – Waterfall Chart

04:15
6.6 Visualization – Line Chart

08:12
6.7 Visualization – Cards

14:42
6.8 Interactive Dashboard

25:55
6.9 Executive Summary

08:30

Module 7: Excel Automation with Macros & AI

Module 8: Real-World Business Applications

Module 9: Capstone Project and Certification

Data Analysis Internship with Microsoft Excel
An End-to-end Project based internship with Microsoft Excel

Introduction

04:33
Project Resources
1. The Bosh Sales Agency – Data Cleanup

10:17
2. Customer Contact Details – Data Cleaning

24:19
3. Friend Request Data Cleaning Task

09:46
4. Dataset Reconciliation Request

19:42
5. Late Submission Analysis

18:25
6. Population Data Extraction and Analysis – Nigerian States

27:22
7. Sales Data Analysis for Rocry Shopping Company

34:30
8. Bank Reconciliation Exercise

16:13
9. Employee Data Adjustment – Madox Cooperation

32:43
10. Mini Super Store Data Analysis

42:37
11. Student Performance Analysis Report – School XYZ

01:17:36
12. Sales Transaction Data Analysis

36:16
13. Supplier Transaction Record Template Design

01:10:27
14. Sales Data Executive Reporting

54:13
15. Kracks Consultant & Infrastructure

24:20
16. Quick Job Applicant Data Cleaning

13:51
17. McSmith Recruiting Services – Candidate Selection Analysis

17:53
18. UK Excel Assessment for Data Analyst Role

32:52
19. Kace Communications – Mast Code Extraction

10:30
20. Credit Card Spending Habits in India

51:03
21. RushTech Financials

48:41
22. LayKon Designs & Research Institute

32:28
23. Flourish Fish Farms – Sales Automation & Dashboard

59:13
24. Tunia Technologies – Sales & Performance Dashboard

52:04
25. GreenBrew Ltd Financial Analysis

58:23
25. GreenBrew Ltd Financial Analysis

58:23
25. GreenBrew Ltd Financial Analysis

58:23
26. Creating your Data Analysis Portfolio

01:16:24
27. Professional CV and Cover Letter

08:21
28. LinkedIn Optimization

22:30

Business Intelligence with Power BI
A complete Data Analysis & Business Intelligence mastery course with Power BI Desktop

1. Introduction, Download & Installation of Power BI Desktop

07:00
2. File Upload & Background Formatting

15:00
3. Formatting & Exporting a Chart

15:00
4. Formatting, Measures & Units

12:00
5. Power BI Charts 1

12:00
6. Power BI Cards

06:00
7. Power BI Slicer

05:00
8. International Distilleries Limited Business Report 1

15:00
9. International Distilleries Limited Business Report 2

07:00
10. Building a Business Report with DAX

15:00
11. Building a Business Report with DAX 2

15:00
12. Building a Business Report with DAX 3

15:00
13. Building a Report (Data Modeling & DAX)

10:00
14. Building a Report (Data Modeling & DAX) 2

15:00
15. Building a Report (Data Modeling & DAX) 3

13:00
16. Data Cleaning; Rocry Business Report 1

15:00
17. Data Cleaning; Rocry Business Report 2

15:00
18. Creating a Power BI Corporate Account

15:00
19. Publishing Report

06:00
20. Advance Chart & Publishing Report

10:00
21. Power BI Microsoft Authenticator

11:00

Power BI DAX & Projects
A complete Power BI DAX training

1.1 Introduction to Power BI DAX

13:00
1.2 Basic Date Functions in Power BI DAX 1

07:00
1.3 Basic Date Functions in Power BI DAX 2

05:00
1.4 Basic Date Functions in Power BI DAX 3

14:00
1.5 Basic Date Functions in Power BI DAX 4

18:00
1.6 Basic Date Functions in Power BI DAX 5

07:00
2.7 Aggregate Functions I

20:00
2.8 Aggregate Functions II

07:00
3.9 Logical Function (IF)

07:00
3.10 Logical Function (IFERROR)

07:00
3.11 Logical Functions (AND OR)

09:00
4.12 Data Cleaning 1

12:00
4.13 Data Cleaning 2

10:00
4.14 Data Cleaning 3

11:00
5.15 Data Cleaning With Power BI Power Query 1

13:00
5.16 Data Cleaning With Power BI Power Query 2

07:00
5.17 Data Cleaning With Power BI Power Query 3

16:00
5.18 Data Cleaning With Power BI Power Query 4

07:00
6.19 Calculate 1(Count & Sum)

14:00
6.20 Calculate 2( Count & Profit)

13:00
6.21 Calculate 3 (Date Difference)

14:00
6.22 Calculate 4 ( Qtrs, Not Equal)

09:00
6.23 Time Intelligence Function 1(Between Dates & MTD)

14:00
6.24 Time Intelligence Function 2 ( QTD & YTD)

13:00
6.25 Time Intelligence Function 3(Checking answers)

12:00
7.26 Data Modeling 1

14:00
7.27 Data Modeling 2

09:00
7.28 Data Modeling 3

15:00

Power BI Internship
End-to-end project internship with Power BI

Project 1Krest Recruitment I

15:00
Project 1 Krest Recruitment II

15:00
Project 1 Krest Recruitment III

15:00
Project 2 The London Metal Exchange I

14:00
Project 2 The London Metal Exchange II

14:00
Project 3 – AK Technology I

14:00
Project 3 – AK Technology II

08:00
Project 4 – Presh Technology I

15:00
Project 4 – Presh Technology II

15:00
Project 5 Sales Transaction Data Analysis 1

15:00
Project 5 Sales Transaction Data Analysis 2

15:00
Project 6 Norlands e-Commerce Store 1

15:00
Project 6 Norlands e-Commerce Store 2

10:00
Project 7 Sales Data Executive Reporting 1

15:00
Project 7 Sales Data Executive Reporting 2

12:00
Project 8 Shopping Analysis of Istanbul 1

15:00
Project 8 Shopping Analysis of Istanbul 2

15:00
Project 8 Shopping Analysis of Istanbul 3

09:00
Project 9 RushTech Financials 1

15:00
Project 9 RushTech Financials 2

08:00
Project 10 African Population by Sub Region 1

10:00
Project 10 African Population by Sub Region 2

15:00
Project 10 African Population by Sub Region 3

11:00
Project 20 – Skibs Enterprise

22:00
Project 21 – Freelance Gig (4 Projects)

45:00

Business Intelligence with Tableau Desktop
A complete course on Business intelligence with Tableau Desktop

1. Tableau Desktop Intro

15:00
2. Tableau Desktop Public Installations

12:00
3. Tableau Data Types & Interface

08:00
4. Formatting Measures

13:00
5. Formatting Measures 2

11:00
6. Tableau Filters

14:00
7. Tableau Charts 1

11:00
8. Tableau Charts 2

15:00
9. Tableau Charts 3

15:00
10. Tableau Mark Cards

15:00
11. Tableau Formatting

14:00
12. If Statement

15:00
13. Tableau Calculation (Count, CountD, CountIF)

14:00
14. Tableau Calculation – SumIF, SumIFS

11:00
15. Tableau Calculation – Date Yr, Mnt, Qtr

12:00
16. Tableau Calculation – Date Functions

11:00
17. Tableau Calculation – String

19:00
18. Tableau Calculation – String Split

12:00
19. Tableau Dashboard 1

15:00
20. Tableau Dashboard 2

15:00
21. Tableau Dashboard 3

15:00
22. AK Dashboard 1

15:00
23. AK Dashboard 2

15:00
24. AK Dashboard 3

15:00
25. Global Sales Dashboard 1

15:00
26. Global Sales Dashboard 2

15:00
27. Global Sales Dashboard 3

15:00

Database Management with MySQL
A complete beginner to advance mastery course on database analysis and management with MySQL

1.1 Course Introduction

05:00
1.2 Download & Installation of MySQL

07:00
1.3 The Workbench Overview

10:00
1.4 The SELECT Statement

09:00
1.5 The Select Clause

11:00
1.6 The WHERE Clause

08:00
1.7 The ORDER BY Clause

07:00
1.8 The LIMIT Clause

04:00
1.9 The AND, OR and NOT Operator

07:00
1.10 The IN Operators

05:00
1.11 The BETWEEN Operator

03:00
1.12 The LIKE Operator

13:00
1.13 The REGEXP Operator

15:00
1.14 The NULL Operator

04:00
1.15 Inner Join

15:00
1.16 Joining Across Database

07:00
1.17 Self Join

07:00
1.18 Joining Multiple Tables

15:00
1.19 Outer joins

10:00
1.20 Outer Joins Between Multiple Tables

11:00
1.21 Self Outer Join

03:00
1.22 The USING Clause

10:00
1.23 Natural and Cross Joins

08:00
1.24 Unions

14:00
1.25 Inserting a Single Row(Column Attributes)

17:00
1.26 Inserting a Multiple Rows

07:00
1.27 Create a Copy of a Table

09:00
1.28 Updating a Single Row

08:00
1.29 Updating a Multiple Rows

06:00
1.30 Exporting Query Output

12:00
2.31 Creating a Database and Table

16:00
2.32 Importing Excel file to MySQL Database

11:00
2.33 SubQueries in MySQL

08:00
2.34 SubQuery across tables

10:00
2.35 VIEWS in MySQL Part 1

12:00
2.36 VIEWS in MySQL Part 2

12:00
2.37 Stored Procedure 1

07:00
2.38 Stored Procedure 2

06:00
2.39 Stored Procedure 3

10:00
2.40 Trigger in MySQL

10:00
2.41 Introduction to Function in MySQL

07:00
2.42 String Functions in MySQL

14:00
2.43 The Number Function in MySQL

06:00
2.44 The Date Functions in MySQL

08:00
2.45 Aggregate Function in MySQL

05:00

Database Management Internship with MySQL
An end-to-end project based internship in database management with MySQL

1. Create a Schema

24:00
2. Database Administrator Quick Test

28:00
3. Google Form Form Response

23:00
4. HR Records

31:00
5. Customer Details Task 1

19:00
6. Customer Details Task 2

21:00
7. Employee Data Task 1

24:00
8. Employee Data Task 2

24:00
9. Employee Data Task 3

24:00
Interview Questions

00:00
11. Combining Tables

18:00
12. Sales Transaction Analysis – Loses

30:00
13. Transaction Details – Manager Analysis

36:00
14. Transaction Details – Returned Analysis

35:00
15. Rush Tech Financials

29:00
16. Credit Card Analysis

33:00
17. Skibs Enterprise

35:00

Data Analysis with Python Programming
A complete data analysis mastery course with Python Programming

1. Download and Installation (Python & PyCharm)

05:00
2. Introduction to python programming

13:00
3. Getting Inputs

13:00
4. Download and Installation of Anaconda

08:00
5. Working with Jupyter Notebook

07:00
6. Data Types

08:00
7. Variables

12:00
8. List

15:00
9. Sorting a List

05:00
10. Intro to Data Analysis with Pandas(Loading Data)

10:00
11. Basic Tips on Dataset with Pandas

15:00
12. Creating Columns and Saving Worked File

08:00
13. Result Analysis with Python

14:00
14. Percentages

19:00
15. Date Functions

12:00
16. Filters

15:00
17. Multiple Condition Filtering

21:00
18. Pivot Table

14:00
19. Sorting the Index (Month) Column

07:00
20. Introduction to Charts (Bar Chart)

10:00
21. Introduction to Charts(Pie)

06:00
22. Charts from Pivot Table

09:00
23. Line and Area Chart _ Saving

04:00
24. Project Work A

14:00
25. Project Work B

17:00
26. Project Work C

12:00

Professional Portfolio Setup Guide
A step by step guide on how to set up your portfolio

Upwork & Indeed Mastery
A FREE training videos oh how to use Upwork and Indeed for Freelancing

Certificate
Request your certificate on completion of this training

Student Ratings & Reviews

No Review Yet

About Course

What Will You Learn?

Course Content

Module 1: Introduction to Data Analysis & Excel Fundamentals

1.1 Introduction to Data Analysis

1.2 Introduction to Microsoft Excel – Excel interface and navigation essentials

1.3 Data Types in MS Excel

1.4 Data Entry in Ms Excel

1.5 Formatting I

1.6 Formatting II

1.7 Formatting III – Conditional Formatting I

1.8 Formatting III – Conditional Formatting II

1.9 Structured Datasets

1.10 Unstructured Datasets

1.11 Protecting a Sheet

1.12 Protecting a Document

1.13 Printing an Excel Document

Download Learning Resources

Module 2: Essential Excel Functions for Analysis

2.1 Number Functions I

2.2 Number Functions II

2.3 Consolidation

2.4 Logical Functions I – IF, SUMIF, COUNTIF

2.5 Logical Functions II – IFS, SUMIFS, COUNTIFS, MAXIFS, AND, OR

2.6 TEXT Functions

2.7 Time and Date Functions I

2.8 Time and Date Functions II

2.9 Time Intelligence Functions

2.10 Lookup Functions – HLOOKUP, VLOOKUP XLOOKUP

2.11 Lookup Functions – INDEX AND MATCH

2.12 Lookup Functions – WILDCARDS

2.13 Error Handling Functions

2.14 Lookup Functions – Multiple VLOOKUP

2.15 Other Data Analysis Functions

Module 3: Data Cleaning & Preparation (ETL in Excel)

3.1 Removing Duplicates

3.2 Removing Blank Rows

3.3 Removing Blank Columns

3.4 Text to Columns

3.5 Find and Replace

3.6 Data Validation I

3.7 Data Validation – Custom Formula

3.8 Searchable Dropdown List

3.9 Handling Missing and Inconsistent Records

3.10 Introduction to Power Query

Module 4: Exploratory Data Analysis (EDA)

4.1 EDA – Sorting

4.2 EDA – Filtering

4.3 Table – Slicers

4.4 Advance Filters

4.5 Pivot table for Data Analysis I

4.6 Pivot table for Data Analysis II

Module 5: Advanced Excel Tools for Data Analysis

5.1 Power Query – Data Cleaning

5.2 Power Query – Transformation

5.3 Power Query – Transpose

5.4 Power Query – Unpivot

5.5 Data Scraping with Power Query

5.6 Multiple Files Combination – Append

5.7 Multiple Files Combination – Merge

5.8 Group and Aggregate

5.9 M Language in Power Query

5.10 Data Normalization I

5.11 Data Normalization II

5.12 Data Modeling

5.13 What IF Analysis – Scenario Manager

5.14 What IF Analysis – Goal Seek and Solver

5.15 What IF Analysis – Data Table

Module 6: Data Visualization & Dashboards

6.1 Introduction to Visualizations

6.2 Visualization – Pie Charts and Donought Chart

6.3 Visualization – Column Chart and Bar Chart

6.4 Visualization – Funnel Chart

6.5 Visualization – Waterfall Chart

6.6 Visualization – Line Chart

6.7 Visualization – Cards

6.8 Interactive Dashboard

6.9 Executive Summary

Module 7: Excel Automation with Macros & AI

7.1 Introduction to Macros and VBA

Data Analysis Internship with Microsoft Excel
An End-to-end Project based internship with Microsoft Excel

Business Intelligence with Power BI
A complete Data Analysis & Business Intelligence mastery course with Power BI Desktop

Power BI DAX & Projects
A complete Power BI DAX training