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
2. File Upload & Background Formatting
3. Formatting & Exporting a Chart
4. Formatting, Measures & Units
5. Power BI Charts 1
6. Power BI Cards
7. Power BI Slicer
8. International Distilleries Limited Business Report 1
9. International Distilleries Limited Business Report 2
10. Building a Business Report with DAX
11. Building a Business Report with DAX 2
12. Building a Business Report with DAX 3
13. Building a Report (Data Modeling & DAX)
14. Building a Report (Data Modeling & DAX) 2
15. Building a Report (Data Modeling & DAX) 3
16. Data Cleaning; Rocry Business Report 1
17. Data Cleaning; Rocry Business Report 2
18. Creating a Power BI Corporate Account
19. Publishing Report
20. Advance Chart & Publishing Report
21. Power BI Microsoft Authenticator

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

1. Tableau Desktop Intro
2. Tableau Desktop Public Installations
3. Tableau Data Types & Interface
4. Formatting Measures
5. Formatting Measures 2
6. Tableau Filters
7. Tableau Charts 1
8. Tableau Charts 2
9. Tableau Charts 3
10. Tableau Mark Cards
11. Tableau Formatting
12. If Statement
13. Tableau Calculation (Count, CountD, CountIF)
14. Tableau Calculation – SumIF, SumIFS
15. Tableau Calculation – Date Yr, Mnt, Qtr
16. Tableau Calculation – Date Functions
17. Tableau Calculation – String
18. Tableau Calculation – String Split
19. Tableau Dashboard 1
20. Tableau Dashboard 2
21. Tableau Dashboard 3
22. AK Dashboard 1
23. AK Dashboard 2
24. AK Dashboard 3
25. Global Sales Dashboard 1
26. Global Sales Dashboard 2
27. Global Sales Dashboard 3

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

1.1 Course Introduction
1.2 Download & Installation of MySQL
1.3 The Workbench Overview
1.4 The SELECT Statement
1.5 The Select Clause
1.6 The WHERE Clause
1.7 The ORDER BY Clause
1.8 The LIMIT Clause
1.9 The AND, OR and NOT Operator
1.10 The IN Operators
1.11 The BETWEEN Operator
1.12 The LIKE Operator
1.13 The REGEXP Operator
1.14 The NULL Operator
1.15 Inner Join
1.16 Joining Across Database
1.17 Self Join
1.18 Joining Multiple Tables
1.19 Outer joins
1.20 Outer Joins Between Multiple Tables
1.21 Self Outer Join
1.22 The USING Clause
1.23 Natural and Cross Joins
1.24 Unions
1.25 Inserting a Single Row(Column Attributes)
1.26 Inserting a Multiple Rows
1.27 Create a Copy of a Table
1.28 Updating a Single Row
1.29 Updating a Multiple Rows
1.30 Exporting Query Output
2.31 Creating a Database and Table
2.32 Importing Excel file to MySQL Database
2.33 SubQueries in MySQL
2.34 SubQuery across tables
2.35 VIEWS in MySQL Part 1
2.36 VIEWS in MySQL Part 2
2.37 Stored Procedure 1
2.38 Stored Procedure 2
2.39 Stored Procedure 3
2.40 Trigger in MySQL
2.41 Introduction to Function in MySQL
2.42 String Functions in MySQL
2.43 The Number Function in MySQL
2.44 The Date Functions in MySQL
2.45 Aggregate Function in MySQL

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

1. Create a Schema
2. Database Administrator Quick Test
3. Google Form Form Response
4. HR Records
5. Customer Details Task 1
6. Customer Details Task 2
7. Employee Data Task 1
8. Employee Data Task 2
9. Employee Data Task 3
Interview Questions
11. Combining Tables
12. Sales Transaction Analysis – Loses
13. Transaction Details – Manager Analysis
14. Transaction Details – Returned Analysis
15. Rush Tech Financials
16. Credit Card Analysis
17. Skibs Enterprise

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

1. Download and Installation (Python & PyCharm)
2. Introduction to python programming
3. Getting Inputs
4. Download and Installation of Anaconda
5. Working with Jupyter Notebook
6. Data Types
7. Variables
8. List
9. Sorting a List
10. Intro to Data Analysis with Pandas(Loading Data)
11. Basic Tips on Dataset with Pandas
12. Creating Columns and Saving Worked File
13. Result Analysis with Python
14. Percentages
15. Date Functions
16. Filters
17. Multiple Condition Filtering
18. Pivot Table
19. Sorting the Index (Month) Column
20. Introduction to Charts (Bar Chart)
21. Introduction to Charts(Pie)
22. Charts from Pivot Table
23. Line and Area Chart _ Saving
24. Project Work A
25. Project Work B
26. Project Work C

Power BI DAX & Projects
A complete Power BI DAX training

1.1 Introduction to Power BI DAX
1.2 Basic Date Functions in Power BI DAX 1
1.3 Basic Date Functions in Power BI DAX 2
1.4 Basic Date Functions in Power BI DAX 3
1.5 Basic Date Functions in Power BI DAX 4
1.6 Basic Date Functions in Power BI DAX 5
2.7 Aggregate Functions I
2.8 Aggregate Functions II
3.9 Logical Function (IF)
3.10 Logical Function (IFERROR)
3.11 Logical Functions (AND OR)
4.12 Data Cleaning 1
4.13 Data Cleaning 2
4.14 Data Cleaning 3
5.15 Data Cleaning With Power BI Power Query 1
5.16 Data Cleaning With Power BI Power Query 2
5.17 Data Cleaning With Power BI Power Query 3
5.18 Data Cleaning With Power BI Power Query 4
6.19 Calculate 1(Count & Sum)
6.20 Calculate 2( Count & Profit)
6.21 Calculate 3 (Date Difference)
6.22 Calculate 4 ( Qtrs, Not Equal)
6.23 Time Intelligence Function 1(Between Dates & MTD)
6.24 Time Intelligence Function 2 ( QTD & YTD)
6.25 Time Intelligence Function 3(Checking answers)
7.26 Data Modeling 1
7.27 Data Modeling 2
7.28 Data Modeling 3

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

Project 1Krest Recruitment I
Project 1 Krest Recruitment II
Project 1 Krest Recruitment III
Project 2 The London Metal Exchange I
Project 2 The London Metal Exchange II
Project 3 – AK Technology I
Project 3 – AK Technology II
Project 4 – Presh Technology I
Project 4 – Presh Technology II
Project 5 Sales Transaction Data Analysis 1
Project 5 Sales Transaction Data Analysis 2
Project 6 Norlands e-Commerce Store 1
Project 6 Norlands e-Commerce Store 2
Project 7 Sales Data Executive Reporting 1
Project 7 Sales Data Executive Reporting 2
Project 8 Shopping Analysis of Istanbul 1
Project 8 Shopping Analysis of Istanbul 2
Project 8 Shopping Analysis of Istanbul 3
Project 9 RushTech Financials 1
Project 9 RushTech Financials 2
Project 10 African Population by Sub Region 1
Project 10 African Population by Sub Region 2
Project 10 African Population by Sub Region 3
Project 20 – Skibs Enterprise
Project 21 – Freelance Gig (4 Projects)

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

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