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!
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
Data Analysis with Microsoft Excel – Complete Course
Learn data analysis with Microsoft Excel from Beginners class up to Expert level class with capstone projects
-
1.1 Introduction to MS Excel
17:00 -
1.2 Freeze Pane
07:00 -
1.3 Find, Replace & Duplicate
08:00 -
1.4 Formatting 1
19:00 -
1.5 Formatting 2
06:00 -
1.6 Border
11:00 -
1.7 Conditional Formatting
13:00 -
2.8 Formulas and Functions 1
13:00 -
2.9 Formulas and Functions 2
05:00 -
2.10 Formulas and Functions 3
06:00 -
2.11 Formulas and Functions 4
05:00 -
2.12 Date Functions
12:00 -
2.13 Data Validation & Drop Down
09:00 -
2.14 Protecting Sheet
06:00 -
2.15 Consolidation
08:00 -
2.16 Charts
39:00 -
3.17 Sorting
07:00 -
3.18 Basic Filters
08:00 -
3.19 Advance Filters
06:00 -
3.20 Logical Functions
05:00 -
3.21 Hlook Up
05:00 -
3.22 Vlook Up
04:00 -
3.23 Database
15:00 -
3.24 Data Cleaning
04:00 -
3.25 Pivot Tables
16:00 -
3.26 Power Query 1
09:00 -
3.27 Power Query 2
04:00
Data Analysis Internship with Microsoft Excel
An End-to-end Project based internship with Microsoft Excel
-
Project 1 – The Bosh Sales Agency
21:00 -
Project 2 – English Premier League Table Dashboard
17:00 -
Project 3 – Demographic Analysis
32:00 -
Project 4 – Mini Super Store Data Set Analysis Pt 1
20:00 -
Project 4 – Mini Super Store Data Set Analysis Pt 2
22:00 -
Project 5 – MacTouch Global Enterprise
36:00 -
Project 6 – Salaries of Data Scientist Pt 1
10:00 -
Project 6 – Salaries of Data Scientist Pt 2
10:00 -
Project 6 – Salaries of Data Scientist Pt 3
11:00 -
Project 6 – Salaries of Data Scientist Pt 4
19:00 -
Project 7 – School XYZ Students Report Pt 1
26:00 -
Project 7 – School XYZ Students Report Pt 2
10:00 -
Project 7 – School XYZ Students Report Pt 3
23:00 -
Project 8 – Sales Transaction Data Analysis
32:00 -
Project 9 – Sales Data Executive Reporting Pt 1
19:00 -
Project 9 – Sales Data Executive Reporting Pt 2
08:00 -
Project 9 – Sales Data Executive Reporting Pt 3
10:00 -
Project 10 – Kracks Consultant & Infrastructure
30:00 -
Project 11 – Flourish Fish Farms Pt 1
19:00 -
Project 12: Tunia Technologies
45:00 -
Project 13 – Quick Job Applicant Data 1
07:00 -
Project 13 – Quick Job Applicant Data 2
14:00 -
Project 14 – 2023 Presidential Election Poll
21:00 -
Project 15 – Madox Cooperation
31:00 -
Project 16 – RushTech Financials 1
42:00 -
Project 16 – RushTech Financials 2
17:00 -
Project 17 – Credit Card Spending Habit in India 1
23:00 -
Project 17 – Credit Card Spending Habit in India 2
17:00 -
Project 17 – Credit Card Spending Habit in India 3
06:00 -
Project 18 – Data Analysis Assignment – Freelancing
29:00 -
Project 19 – Kace Communications
19:00 -
Project 20 – Data Scraping & Cleaning
29:00 -
Project 21 – UK Test of Excel for a Job
28:00 -
Project 22 – McSmith Recruiting Services
14:00 -
Project 23 – LayKon Designs
19:00 -
Project 23 – LayKon Designs
19:00 -
Project 24 – Vrinda Store Annual Dashboard
49:00 -
Project 25 – Rocry Shopping Company
30:00 -
Project 26 – Facebook Task
12:00 -
Project 27 – Sales Upload Time
15:00 -
Project 28 – Personal Budget Template
22:00 -
Form Entry Data Cleaning With Excel Function & Excel Macro
22:00 -
Project 30 QUESTION – Sales Record Template
05:00 -
Project 30 SOLUTION – Sales Transaction Template
36:00
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
-
Introduction: Account Creation & File Setup
15:00 -
Building your Portfolio I
15:00 -
Building your Portfolio II
15:00 -
Building your Portfolio III
15:00 -
Linking your Portfolio to LinkedIn
05:00
Upwork & Indeed Mastery
A FREE training videos oh how to use Upwork and Indeed for Freelancing
-
Upwork & Indeed Mastery
00:00
Certificate
Request your certificate on completion of this training
Student Ratings & Reviews
No Review Yet