Data Analysis Mentorship Bundle – Complete Package
Categories: Data Analysis
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!
What Will You Learn?
- 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)
-
4.1 EDA – Sorting
08:16 -
4.2 EDA – Filtering
08:23 -
4.3 Table – Slicers
06:03 -
4.4 Advance Filters
08:37 -
4.5 Pivot table for Data Analysis I
22:01 -
4.6 Pivot table for Data Analysis II
21:53
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
-
6.5 Visualization – Waterfall Chart
-
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
-
7.1 Introduction to Macros and VBA
09:35 -
7.2 Recording a Macro
13:47 -
7.3 Automating Repetitive Task
11:10 -
7.4 Generating Excel Macros with AI – I
13:55 -
7.5 Generating Excel Macros with AI – II
10:01
Module 8: Real-World Business Applications
-
8.1 Sales Performance – Descriptive Analysis
30:25 -
8.2 Sales Analysis – Diagnostic and Performance Monitoring
34:19 -
8.3 Sales Analysis – Predictive and Prescriptive Insights
18:02
Module 9: Capstone Project and Certification
-
9.1 Capstone Project
03:33
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 -
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
06:40 -
2. File Upload & Background Formatting
14:18 -
3. Formatting & Exporting a Chart
14:42 -
4. Formatting, Measures & Units
11:43 -
5. Power BI Charts 1
14:56 -
6. Power BI Cards
05:51 -
7. Power BI Slicer
04:06 -
8. International Distilleries Limited Business Report 1
14:24 -
9. International Distilleries Limited Business Report 2
06:29 -
10. Building a Business Report with DAX
14:56 -
11. Building a Business Report with DAX 2
15:02 -
12. Building a Business Report with DAX 3
14:24 -
13. Building a Report (Data Modeling & DAX)
09:49 -
14. Building a Report (Data Modeling & DAX) 2
14:25 -
15. Building a Report (Data Modeling & DAX) 3
12:23 -
16. Data Cleaning; Rocry Business Report 1
14:57 -
17. Data Cleaning; Rocry Business Report 2
14:53 -
18. Creating a Power BI Corporate Account
15:03 -
19. Publishing Report
05:02 -
20. Advance Chart & Publishing Report
09:02 -
21. Power BI Microsoft Authenticator
10:22
Power BI DAX & Projects
A complete Power BI DAX training
-
1.1 Introduction to Power BI DAX
12:37 -
1.2 Basic Date Functions in Power BI DAX 1
06:52 -
1.3 Basic Date Functions in Power BI DAX 2
04:06 -
1.4 Basic Date Functions in Power BI DAX 3
13:11 -
1.5 Basic Date Functions in Power BI DAX 4
17:12 -
1.6 Basic Date Functions in Power BI DAX 5
06:20 -
2.7 Aggregate Functions I
19:12 -
2.8 Aggregate Functions II
06:08 -
3.9 Logical Function (IF)
06:46 -
3.10 Logical Function (IFERROR)
06:58 -
3.11 Logical Functions (AND OR)
08:42 -
4.12 Data Cleaning 1
11:21 -
4.13 Data Cleaning 2
09:37 -
4.14 Data Cleaning 3
12:05 -
5.15 Data Cleaning With Power BI Power Query 1
12:48 -
5.16 Data Cleaning With Power BI Power Query 2
06:36 -
5.17 Data Cleaning With Power BI Power Query 3
15:15 -
5.18 Data Cleaning With Power BI Power Query 4
06:49 -
6.19 Calculate 1(Count & Sum)
13:51 -
6.20 Calculate 2( Count & Profit)
12:31 -
6.21 Calculate 3 (Date Difference)
13:38 -
6.22 Calculate 4 ( Qtrs, Not Equal)
08:23 -
6.23 Time Intelligence Function 1(Between Dates & MTD)
13:18 -
6.24 Time Intelligence Function 2 ( QTD & YTD)
12:19 -
6.25 Time Intelligence Function 3(Checking answers)
11:21 -
7.26 Data Modeling 1
13:04 -
7.27 Data Modeling 2
08:07 -
7.28 Data Modeling 3
14:56
Database Management with MySQL
A complete beginner to advance mastery course on database analysis and management with MySQL
-
1.1 Course Introduction
04:23 -
1.2 Download & Installation of MySQL
06:04 -
1.3 The Workbench Overview
09:47 -
1.4 The SELECT Statement
08:48 -
1.5 The Select Clause
10:38 -
1.6 The WHERE Clause
07:08 -
1.7 The ORDER BY Clause
06:16 -
1.8 The LIMIT Clause
03:32 -
1.9 The AND, OR and NOT Operator
06:25 -
1.10 The IN Operators
04:51 -
1.11 The BETWEEN Operator
02:55 -
1.12 The LIKE Operator
12:12 -
1.13 The REGEXP Operator
14:04 -
1.14 The NULL Operator
03:48 -
1.15 Inner Join
14:03 -
1.16 Joining Across Database
06:36 -
1.17 Self Join
06:19 -
1.18 Joining Multiple Tables
14:25 -
1.19 Outer joins
09:10 -
1.20 Outer Joins Between Multiple Tables
10:31 -
1.21 Self Outer Join
02:21 -
1.22 The USING Clause
09:55 -
1.23 Natural and Cross Joins
07:44 -
1.24 Unions
13:05 -
1.25 Inserting a Single Row(Column Attributes)
16:42 -
1.26 Inserting a Multiple Rows
06:01 -
1.27 Create a Copy of a Table
08:45 -
1.28 Updating a Single Row
07:15 -
1.29 Updating a Multiple Rows
05:44 -
1.30 Exporting Query Output
11:27 -
2.31 Creating a Database and Table
15:20 -
2.32 Importing Excel file to MySQL Database
10:24 -
2.33 SubQueries in MySQL
07:13 -
2.34 SubQuery across tables
06:09 -
2.35 VIEWS in MySQL Part 1
11:13 -
2.36 VIEWS in MySQL Part 2
11:32 -
2.37 Stored Procedure 1
06:43 -
2.38 Stored Procedure 2
05:01 -
2.39 Stored Procedure 3
07:34 -
2.40 Trigger in MySQL
09:12 -
2.41 Introduction to Function in MySQL
06:56 -
2.42 String Functions in MySQL
13:56 -
2.43 The Number Function in MySQL
05:53 -
2.44 The Date Functions in MySQL
09:35 -
2.45 Aggregate Function in MySQL
04:46
Database Management Internship with MySQL
An end-to-end project based internship in database management with MySQL
-
1. Create a Schema
23:36 -
2. Database Administrator Quick Test
27:05 -
3. Google Form Form Response
22:46 -
4. HR Records
30:32 -
5. Customer Details Task 1
18:45 -
6. Customer Details Task 2
20:34 -
7. Employee Data Task 1
21:19 -
8. Employee Data Task 2
23:33 -
9. Employee Data Task 3
21:15 -
Interview Questions
-
11. Combining Tables
17:03 -
12. Sales Transaction Analysis – Loses
29:40 -
13. Transaction Details – Manager Analysis
35:01 -
14. Transaction Details – Returned Analysis
34:01 -
15. Rush Tech Financials
28:18 -
16. Credit Card Analysis
32:21 -
17. Skibs Enterprise
34:52
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
12:15 -
3. Getting Inputs
12:33 -
4. Download and Installation of Anaconda
07:11 -
5. Working with Jupyter Notebook
06:58 -
6. Data Types
08:01 -
7. Variables
11:56 -
8. List
14:16 -
9. Sorting a List
04:50 -
10. Intro to Data Analysis with Pandas(Loading Data)
09:11 -
11. Basic Tips on Dataset with Pandas
14:07 -
12. Creating Columns and Saving Worked File
07:33 -
13. Result Analysis with Python
13:52 -
14. Percentages
18:04 -
15. Date Functions
11:15 -
16. Filters
14:17 -
17. Multiple Condition Filtering
20:39 -
18. Pivot Table
13:33 -
19. Sorting the Index (Month) Column
06:58 -
20. Introduction to Charts (Bar Chart)
09:53 -
21. Introduction to Charts(Pie)
05:21 -
22. Charts from Pivot Table
08:28 -
23. Line and Area Chart _ Saving
03:14 -
24. Project Work A
13:40 -
25. Project Work B
16:59 -
26. Project Work C
11:19
Business Intelligence with Tableau Desktop
A complete course on Business intelligence with Tableau Desktop
-
1. Tableau Desktop Intro
15:01 -
2. Tableau Desktop Public Installations
11:05 -
3. Tableau Data Types & Interface
07:48 -
4. Formatting Measures
12:51 -
5. Formatting Measures 2
10:10 -
6. Tableau Filters
13:23 -
7. Tableau Charts 1
10:57 -
8. Tableau Charts 2
14:54 -
9. Tableau Charts 3
15:02 -
10. Tableau Mark Cards
14:13 -
11. Tableau Formatting
13:06 -
12. If Statement
14:14 -
13. Tableau Calculation (Count, CountD, CountIF)
13:27 -
14. Tableau Calculation – SumIF, SumIFS
10:05 -
15. Tableau Calculation – Date Yr, Mnt, Qtr
11:25 -
16. Tableau Calculation – Date Functions
10:20 -
17. Tableau Calculation – String
14:50 -
18. Tableau Calculation – String Split
11:53 -
19. Tableau Dashboard 1
14:12 -
20. Tableau Dashboard 2
14:51 -
21. Tableau Dashboard 3
15:03 -
22. AK Dashboard 1
14:43 -
23. AK Dashboard 2
15:02 -
24. AK Dashboard 3
14:25 -
25. Global Sales Dashboard 1
14:46 -
26. Global Sales Dashboard 2
14:56 -
27. Global Sales Dashboard 3
14:53
Power BI Internship
End-to-end project internship with Power BI
-
Project 1Krest Recruitment I
14:28 -
Project 1 Krest Recruitment II
14:45 -
Project 1 Krest Recruitment III
13:03 -
Project 2 The London Metal Exchange I
13:26 -
Project 2 The London Metal Exchange II
14:31 -
Project 3 – AK Technology I
13:52 -
Project 3 – AK Technology II
07:29 -
Project 4 – Presh Technology I
14:44 -
Project 4 – Presh Technology II
15:01 -
Project 5 Sales Transaction Data Analysis 1
13:53 -
Project 5 Sales Transaction Data Analysis 2
15:00 -
Project 6 Norlands e-Commerce Store 1
14:49 -
Project 6 Norlands e-Commerce Store 2
09:28 -
Project 7 Sales Data Executive Reporting 1
14:31 -
Project 7 Sales Data Executive Reporting 2
11:37 -
Project 8 Shopping Analysis of Istanbul 1
15:03 -
Project 8 Shopping Analysis of Istanbul 2
14:05 -
Project 8 Shopping Analysis of Istanbul 3
08:47 -
Project 9 RushTech Financials 1
15:03 -
Project 9 RushTech Financials 2
07:18 -
Project 10 African Population by Sub Region 1
09:38 -
Project 10 African Population by Sub Region 2
14:16 -
Project 10 African Population by Sub Region 3
11:42 -
Project 20 – Skibs Enterprise
-
Project 21 – Freelance Gig (4 Projects)
Student Ratings & Reviews
No Review Yet