Data Analysis Mentorship Bundle – Complete Package
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.
100% online · self-paced
69 hours of content
Instructor support
Certificate
Course overview
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
Gain proficiency in Microsoft Excel, Power BI, Tableau, Python, and SQL for data analysis and reporting.
Apply theoretical knowledge to real-world scenarios with internships in Excel, Power BI, and SQL, building hands-on experience.
Learn how to design impactful data visualizations using Power BI and Tableau, enabling clear communication of insights.
Master SQL and Python to query, manipulate, and analyze data effectively, ensuring actionable insights.
Develop a professional portfolio showcasing your data analysis projects, adding credibility to your skillset.
Gain the skills needed to attract clients and secure projects on Upwork, with specialized tips and strategies for data analysis professionals.
Learn how to optimize your CV and LinkedIn profile to stand out in the job market and attract top employers.
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!
Who this course is for
Professionals looking to enhance their data analysis skills for career advancement
Aspiring Data Analysts seeking comprehensive training in industry-standard tools
Business Intelligence professionals aiming to deepen their expertise in data visualization and reporting
Recent graduates in fields related to data science, analytics, or business
Individuals transitioning into data analytics roles from other professional backgrounds
Freelancers interested in building a portfolio and mastering Upwork strategies for data analysis projects
Small business owners wanting to leverage data for better decision-making and insights
Teams and organizations seeking to upskill their workforce in data analysis and business intelligence tools
Requirements
A laptop
Internet connection
Valid email address
What’s included
Learning Resources
Learning Support
FREE CV Revamping
FREE LinkedIn Optimization
FREE Portfolio Kit
FREE Power Point & Infographics Mastery Course
Reference/Recommendation Letter
Job Hunting Insight
Interview Preparation Guide
Professional certificate of completion for FREE
What you’ll 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.
Curriculum
17 modules · 297 lessons · a quiz and assignment to close each module
01 Module 1: Introduction to Data Analysis & Excel Fundamentals 14 lessons
1.1 Introduction to Data Analysis 23 min
Download Learning Resources
1.2 Introduction to Microsoft Excel – Excel interface and navigation essentials 23 min
1.3 Data Types in MS Excel 9 min
1.4 Data Entry in Ms Excel 10 min
1.5 Formatting I 11 min
1.6 Formatting II 10 min
1.7 Formatting III – Conditional Formatting I 9 min
1.8 Formatting III – Conditional Formatting II 8 min
1.9 Structured Datasets 3 min
1.10 Unstructured Datasets 4 min
1.11 Protecting a Sheet 9 min
1.12 Protecting a Document 5 min
1.13 Printing an Excel Document 12 min
Module quiz · 10 questions
02 Module 2: Essential Excel Functions for Analysis 15 lessons
2.1 Number Functions I 20 min
2.2 Number Functions II 18 min
2.3 Consolidation 10 min
2.4 Logical Functions I – IF, SUMIF, COUNTIF 17 min
2.5 Logical Functions II – IFS, SUMIFS, COUNTIFS, MAXIFS, AND, OR 19 min
2.6 TEXT Functions 15 min
2.7 Time and Date Functions I 10 min
2.8 Time and Date Functions II 13 min
2.9 Time Intelligence Functions 18 min
2.10 Lookup Functions – HLOOKUP, VLOOKUP XLOOKUP 11 min
2.11 Lookup Functions – INDEX AND MATCH 9 min
2.12 Lookup Functions – WILDCARDS 7 min
2.13 Error Handling Functions 8 min
2.14 Lookup Functions – Multiple VLOOKUP 7 min
2.15 Other Data Analysis Functions 14 min
Module quiz · 10 questions
03 Module 3: Data Cleaning & Preparation (ETL in Excel) 10 lessons
3.1 Removing Duplicates 5 min
3.2 Removing Blank Rows 9 min
3.3 Removing Blank Columns 7 min
3.4 Text to Columns 6 min
3.5 Find and Replace 3 min
3.6 Data Validation I 17 min
3.7 Data Validation – Custom Formula 20 min
3.8 Searchable Dropdown List 10 min
3.9 Handling Missing and Inconsistent Records 7 min
3.10 Introduction to Power Query 25 min
Module quiz · 10 questions
04 Module 4: Exploratory Data Analysis (EDA) 6 lessons
4.1 EDA – Sorting 9 min
4.2 EDA – Filtering 9 min
4.3 Table – Slicers 7 min
4.4 Advance Filters 9 min
4.5 Pivot table for Data Analysis I 23 min
4.6 Pivot table for Data Analysis II 22 min
05 Module 5: Advanced Excel Tools for Data Analysis 15 lessons
5.1 Power Query – Data Cleaning 8 min
5.2 Power Query – Transformation 6 min
5.3 Power Query – Transpose 2 min
5.4 Power Query – Unpivot 3 min
5.5 Data Scraping with Power Query 8 min
5.6 Multiple Files Combination – Append 14 min
5.7 Multiple Files Combination – Merge 8 min
5.8 Group and Aggregate 4 min
5.9 M Language in Power Query 6 min
5.10 Data Normalization I 7 min
5.11 Data Normalization II 15 min
5.12 Data Modeling 9 min
5.13 What IF Analysis – Scenario Manager 11 min
5.14 What IF Analysis – Goal Seek and Solver 14 min
5.15 What IF Analysis – Data Table 9 min
Module quiz · 10 questions
06 Module 6: Data Visualization & Dashboards 9 lessons
6.1 Introduction to Visualizations 11 min
6.2 Visualization – Pie Charts and Donought Chart 15 min
6.3 Visualization – Column Chart and Bar Chart 6 min
6.4 Visualization – Funnel Chart
6.5 Visualization – Waterfall Chart
6.6 Visualization – Line Chart 9 min
6.7 Visualization – Cards 15 min
6.8 Interactive Dashboard 26 min
6.9 Executive Summary 9 min
Module quiz · 10 questions
07 Module 7: Excel Automation with Macros & AI 5 lessons
7.1 Introduction to Macros and VBA 10 min
7.2 Recording a Macro 14 min
7.3 Automating Repetitive Task 12 min
7.4 Generating Excel Macros with AI – I 14 min
7.5 Generating Excel Macros with AI – II 11 min
Module quiz · 10 questions
08 Module 8: Real-World Business Applications 3 lessons
8.1 Sales Performance – Descriptive Analysis 31 min
8.2 Sales Analysis – Diagnostic and Performance Monitoring 35 min
8.3 Sales Analysis – Predictive and Prescriptive Insights 19 min
Module quiz · 10 questions
09 Module 9: Capstone Project and Certification 1 lessons
9.1 Capstone Project 4 min
10 Data Analysis Internship with Microsoft Excel An End-to-end Project based internship with Microsoft Excel 30 lessons
Introduction 5 min
Project Resources
1. The Bosh Sales Agency – Data Cleanup 11 min
2. Customer Contact Details – Data Cleaning 25 min
3. Friend Request Data Cleaning Task 10 min
4. Dataset Reconciliation Request 20 min
5. Late Submission Analysis 19 min
6. Population Data Extraction and Analysis – Nigerian States 28 min
7. Sales Data Analysis for Rocry Shopping Company 35 min
8. Bank Reconciliation Exercise 17 min
9. Employee Data Adjustment – Madox Cooperation 33 min
10. Mini Super Store Data Analysis 43 min
11. Student Performance Analysis Report – School XYZ 78 min
12. Sales Transaction Data Analysis 37 min
13. Supplier Transaction Record Template Design 71 min
14. Sales Data Executive Reporting 55 min
15. Kracks Consultant & Infrastructure 25 min
16. Quick Job Applicant Data Cleaning 14 min
17. McSmith Recruiting Services – Candidate Selection Analysis 18 min
18. UK Excel Assessment for Data Analyst Role 33 min
19. Kace Communications – Mast Code Extraction 11 min
20. Credit Card Spending Habits in India 52 min
21. RushTech Financials 49 min
22. LayKon Designs & Research Institute 33 min
23. Flourish Fish Farms – Sales Automation & Dashboard 60 min
24. Tunia Technologies – Sales & Performance Dashboard 53 min
25. GreenBrew Ltd Financial Analysis 59 min
26. Creating your Data Analysis Portfolio 77 min
27. Professional CV and Cover Letter 9 min
28. LinkedIn Optimization 23 min
Module quiz · 50 questions
11 Business Intelligence with Power BI A complete Data Analysis & Business Intelligence mastery course with Power BI Desktop 21 lessons
1. Introduction, Download & Installation of Power BI Desktop 7 min
2. File Upload & Background Formatting 15 min
3. Formatting & Exporting a Chart 15 min
4. Formatting, Measures & Units 12 min
5. Power BI Charts 1 15 min
6. Power BI Cards 6 min
7. Power BI Slicer 5 min
8. International Distilleries Limited Business Report 1 15 min
9. International Distilleries Limited Business Report 2 7 min
10. Building a Business Report with DAX 15 min
11. Building a Business Report with DAX 2 16 min
12. Building a Business Report with DAX 3 15 min
13. Building a Report (Data Modeling & DAX) 10 min
14. Building a Report (Data Modeling & DAX) 2 15 min
15. Building a Report (Data Modeling & DAX) 3 13 min
16. Data Cleaning; Rocry Business Report 1 15 min
17. Data Cleaning; Rocry Business Report 2 15 min
18. Creating a Power BI Corporate Account 16 min
19. Publishing Report 6 min
20. Advance Chart & Publishing Report 10 min
21. Power BI Microsoft Authenticator 11 min
Module quiz · 50 questions
12 Power BI DAX & Projects A complete Power BI DAX training 28 lessons
1.1 Introduction to Power BI DAX 13 min
1.2 Basic Date Functions in Power BI DAX 1 7 min
1.3 Basic Date Functions in Power BI DAX 2 5 min
1.4 Basic Date Functions in Power BI DAX 3 14 min
1.5 Basic Date Functions in Power BI DAX 4 18 min
1.6 Basic Date Functions in Power BI DAX 5 7 min
2.7 Aggregate Functions I 20 min
2.8 Aggregate Functions II 7 min
3.9 Logical Function (IF) 7 min
3.10 Logical Function (IFERROR) 7 min
3.11 Logical Functions (AND OR) 9 min
4.12 Data Cleaning 1 12 min
4.13 Data Cleaning 2 10 min
4.14 Data Cleaning 3 13 min
5.15 Data Cleaning With Power BI Power Query 1 13 min
5.16 Data Cleaning With Power BI Power Query 2 7 min
5.17 Data Cleaning With Power BI Power Query 3 16 min
5.18 Data Cleaning With Power BI Power Query 4 7 min
6.19 Calculate 1(Count & Sum) 14 min
6.20 Calculate 2( Count & Profit) 13 min
6.21 Calculate 3 (Date Difference) 14 min
6.22 Calculate 4 ( Qtrs, Not Equal) 9 min
6.23 Time Intelligence Function 1(Between Dates & MTD) 14 min
6.24 Time Intelligence Function 2 ( QTD & YTD) 13 min
6.25 Time Intelligence Function 3(Checking answers) 12 min
7.26 Data Modeling 1 14 min
7.27 Data Modeling 2 9 min
7.28 Data Modeling 3 15 min
13 Database Management with MySQL - A complete Beginner to Advance Mastery course on database analysis and management with MySQL 45 lessons
1.1 Course Introduction 5 min
1.2 Download & Installation of MySQL 16 min
1.3 The Workbench Overview 10 min
1.4 The SELECT Statement 9 min
1.5 The Select Clause 11 min
1.6 The WHERE Clause 8 min
1.7 The ORDER BY Clause 7 min
1.8 The LIMIT Clause 4 min
1.9 The AND, OR and NOT Operator 7 min
1.10 The IN Operators 5 min
1.11 The BETWEEN Operator 3 min
1.12 The LIKE Operator 13 min
1.13 The REGEXP Operator 15 min
1.14 The NULL Operator 4 min
1.15 Inner Join 15 min
1.16 Joining Across Database 7 min
1.17 Self Join 7 min
1.18 Joining Multiple Tables 15 min
1.19 Outer joins 10 min
1.20 Outer Joins Between Multiple Tables 11 min
1.21 Self Outer Join 3 min
1.22 The USING Clause 10 min
1.23 Natural and Cross Joins 8 min
1.24 Unions 14 min
1.25 Inserting a Single Row(Column Attributes) 17 min
1.26 Inserting a Multiple Rows 7 min
1.27 Create a Copy of a Table 9 min
1.28 Updating a Single Row 8 min
1.29 Updating a Multiple Rows 6 min
1.30 Exporting Query Output 12 min
2.31 Creating a Database and Table 16 min
2.32 Importing Excel file to MySQL Database 11 min
2.33 SubQueries in MySQL 8 min
2.34 SubQuery across tables 7 min
2.35 VIEWS in MySQL Part 1 12 min
2.36 VIEWS in MySQL Part 2 12 min
2.37 Stored Procedure 1 7 min
2.38 Stored Procedure 2 6 min
2.39 Stored Procedure 3 8 min
2.40 Trigger in MySQL 10 min
2.41 Introduction to Function in MySQL 7 min
2.42 String Functions in MySQL 14 min
2.43 The Number Function in MySQL 6 min
2.44 The Date Functions in MySQL 10 min
2.45 Aggregate Function in MySQL 5 min
Module quiz · 50 questions
14 Database Management Internship with MySQL An end-to-end project based internship in database management with MySQL 17 lessons
1. Create a Schema 24 min
2. Database Administrator Quick Test 28 min
3. Google Form Form Response 23 min
4. HR Records 31 min
5. Customer Details Task 1 19 min
6. Customer Details Task 2 21 min
7. Employee Data Task 1 22 min
8. Employee Data Task 2 24 min
9. Employee Data Task 3 22 min
Interview Questions
11. Combining Tables 18 min
12. Sales Transaction Analysis – Loses 30 min
13. Transaction Details – Manager Analysis 36 min
14. Transaction Details – Returned Analysis 35 min
15. Rush Tech Financials 29 min
16. Credit Card Analysis 33 min
17. Skibs Enterprise 35 min
15 Data Analysis with Python Programming A complete data analysis mastery course with Python Programming 26 lessons
1. Download and Installation (Python & PyCharm) 5 min
2. Introduction to python programming 13 min
3. Getting Inputs 13 min
4. Download and Installation of Anaconda 8 min
5. Working with Jupyter Notebook 7 min
6. Data Types 9 min
7. Variables 12 min
8. List 15 min
9. Sorting a List 5 min
10. Intro to Data Analysis with Pandas(Loading Data) 10 min
11. Basic Tips on Dataset with Pandas 15 min
12. Creating Columns and Saving Worked File 8 min
13. Result Analysis with Python 14 min
14. Percentages 19 min
15. Date Functions 12 min
16. Filters 15 min
17. Multiple Condition Filtering 21 min
18. Pivot Table 14 min
19. Sorting the Index (Month) Column 7 min
20. Introduction to Charts (Bar Chart) 10 min
21. Introduction to Charts(Pie) 6 min
22. Charts from Pivot Table 9 min
23. Line and Area Chart _ Saving 4 min
24. Project Work A 14 min
25. Project Work B 17 min
26. Project Work C 12 min
Module quiz · 50 questions
16 Business Intelligence with Tableau Desktop A complete course on Business intelligence with Tableau Desktop 27 lessons
1. Tableau Desktop Intro 16 min
2. Tableau Desktop Public Installations 12 min
3. Tableau Data Types & Interface 8 min
4. Formatting Measures 13 min
5. Formatting Measures 2 11 min
6. Tableau Filters 14 min
7. Tableau Charts 1 11 min
8. Tableau Charts 2 15 min
9. Tableau Charts 3 16 min
10. Tableau Mark Cards 15 min
11. Tableau Formatting 14 min
12. If Statement 15 min
13. Tableau Calculation (Count, CountD, CountIF) 14 min
14. Tableau Calculation – SumIF, SumIFS 11 min
15. Tableau Calculation – Date Yr, Mnt, Qtr 12 min
16. Tableau Calculation – Date Functions 11 min
17. Tableau Calculation – String 15 min
18. Tableau Calculation – String Split 12 min
19. Tableau Dashboard 1 15 min
20. Tableau Dashboard 2 15 min
21. Tableau Dashboard 3 16 min
22. AK Dashboard 1 15 min
23. AK Dashboard 2 16 min
24. AK Dashboard 3 15 min
25. Global Sales Dashboard 1 15 min
26. Global Sales Dashboard 2 15 min
27. Global Sales Dashboard 3 15 min
Module quiz · 45 questions
17 Power BI Internship End-to-end project internship with Power BI 25 lessons
Project 1Krest Recruitment I 15 min
Project 1 Krest Recruitment II 15 min
Project 1 Krest Recruitment III 14 min
Project 2 The London Metal Exchange I 14 min
Project 2 The London Metal Exchange II 15 min
Project 3 – AK Technology I 14 min
Project 3 – AK Technology II 8 min
Project 4 – Presh Technology I 15 min
Project 4 – Presh Technology II 16 min
Project 5 Sales Transaction Data Analysis 1 14 min
Project 5 Sales Transaction Data Analysis 2 15 min
Project 6 Norlands e-Commerce Store 1 15 min
Project 6 Norlands e-Commerce Store 2 10 min
Project 7 Sales Data Executive Reporting 1 15 min
Project 7 Sales Data Executive Reporting 2 12 min
Project 8 Shopping Analysis of Istanbul 1 16 min
Project 8 Shopping Analysis of Istanbul 2 15 min
Project 8 Shopping Analysis of Istanbul 3 9 min
Project 9 RushTech Financials 1 16 min
Project 9 RushTech Financials 2 8 min
Project 10 African Population by Sub Region 1 10 min
Project 10 African Population by Sub Region 2 15 min
Project 10 African Population by Sub Region 3 12 min
Project 20 – Skibs Enterprise
Project 21 – Freelance Gig (4 Projects)
How you’ll learn
100% onlineLearn from anywhere, on your laptop or phone — no classroom to travel to.
Self-pacedStart any time and move at your own speed. 69 hours of content.
Instructor supportStuck? Get help from your instructor, plus feedback on every assignment.
How to enrol
01
Enrol
Create your free student account and choose this course.
02
Pay
Pay securely with Paystack. One payment — no hidden fees.
03
Learn
Your portal unlocks immediately — lessons, quizzes, assignments and certificate.
