5 in 1 Data Analysis Video Courses Bundle

(Instant Download course) Language: English

Price is mentioned in USD $9 equals to R149 ZAR

30+ Hours of Hands on Training Recorded Lectures in Data Analysis

"Learn Data Analysis from Scratch with This 5-in-1 Video Course Bundle –

Whether you're learning to code or exploring new tools for your next project, this beginner-friendly video courses covers everything you need to get started in data analysis. Dive into Excel, Python, SQL, Power BI, Tableau, and VBA through step-by-step video lessons, practical exercises, and real-world use cases — all designed to make complex concepts simple and actionable.

Unlock the Power of Data & Skyrocket Your Career with Our 5-in-1 Data Analysis Video Course Bundle for Beginners

Here is What You'll Get In This

1. Excel with AI & ChatGPT

Course Intro:

Unlock the true potential of Excel with AI-powered features and learn how ChatGPT can save you hours of work! Master automation, advanced formulas, and how to leverage AI to make smarter data-driven decisions

Course Details

20+ Modules |

Topics Covered

1. Excel Basics & Navigation

• Interface, ribbon, tabs, workbook & worksheet navigation.

1. Workbook & Worksheet Management

• Creating, saving, renaming, copying, grouping, moving, and viewing multiple sheets/workbooks.

1. Data Entry & Formatting

• Entering text/numbers/dates, formatting cells, merging/wrapping, fonts, colors, alignment.

1. Formulas & Functions

• Basic math, IF, SUMIF, COUNTIF, TEXT, DATEDIF, BODMAS, IFERROR, referencing (absolute/3D).

5. Formula Management & Auditing

• Displaying formulas, formula text, copying formulas, watch window, named ranges.

1. Data Tools

• Sorting, filtering, removing duplicates, find/replace, text to columns, data validation, flash fill.

1. Charts & Data Visualization

• Creating charts, formatting chart elements, trendlines, sparklines, quick/recommended charts.

1. Pivot Tables

• Creating, using, referencing pivot tables, drilling down, managing pivot data.

1. Tables & Lists

• Creating tables, using fill handle, autofill lists, pick lists, custom styles.

1. Conditional Formatting

• Rules, icon sets, color scales, top/bottom rules, custom formatting.

1. Printing & Page Setup

• Print areas, titles, margins, orientation, scaling, headers/footers, controlling print settings.

1. Date & Time Management

• Inserting static/dynamic dates, time calculations, duration over 24 hours.

1. Protection & Security

• Worksheet protection, password-protecting workbooks, locking data entry areas.

1. Charts & Graphics

• Shapes, SmartArt, screenshots, inserting images, formatting objects.

1. Keyboard Shortcuts & Productivity Tips

• Ctrl keys, ribbon shortcuts, drag/drop, customizing toolbar & ribbons.

1. Review & Collaboration

• Comments, spell check, sharing files, SkyDrive, tracking changes.

1. Templates & Themes

• Using and creating templates, applying themes.

1. Advanced Tools

• Goal Seek, What-If scenarios, scenario manager, Watch window.

1. File Info & Layout Views

• Displaying file/sheet names, using layout/page break views.

1. Miscellaneous Features

• Hyperlinks, SmartArt, fill handle, format painter, autofill, object grouping.

2. VBA Macros - Basic to Advanced:

Course Intro: Automate repetitive tasks and free up your time by learning VBA Macros from the ground up. Save hours every week and increase your productivity like never befor

1. Macro Security and Setup

Learn how to manage macro security, assign macros to ribbons, and set up a personal macro workbook.

2. Customizing the Ribbon

Create and customize your own ribbon and buttons for quick macro access.

3. Creating and Running Macros

Understand how to create, record, and run your first macro, plus assign triggers like buttons or keyboard shortcuts.

4. User Interaction

Use MSGBOX, INPUTBOX, and UserForms for user input and interaction within your macros.

5. Writing and Debugging Code

Master debugging techniques, error handling, and using the Visual Basic Editor to refine your code.

6. Working with Data

Learn to manipulate arrays, ranges, and data formatting, plus work with Excel’s date functions.

7. VBA Control Structures

Use IF-ELSE, SELECT CASE, DO WHILE, and FOR NEXT loops to control the flow of your program.

8. UserForm Design

Design UserForms with controls like buttons and text boxes to collect and validate user input.

9. Handling Variables and Constants

Declare and manage variables, set their scope, and use constants for fixed values.

10. Triggering Macros

Trigger macros through keyboard shortcuts, ribbon icons, and workbook or worksheet events.

11. Function and Sub Procedures

Create and call functions and sub procedures to improve code organization and reuse.

12. Worksheet and Workbook Events

Automate actions with events like opening, saving, and activating sheets.

13. Range and Cell Manipulation

Manipulate cell data and formatting using Range methods like OFFSET and FONT.

14. VBA Functions and Methods

Use Excel functions in VBA and learn how to apply operators for calculations and comparisons.

15. Optimization and Speeding Up VBA

Optimize your code for speed and efficiency using tips like relative vs absolute referencing.

3. Python & SQL for Data Analysis:

Course Intro:

Learn Python and SQL from scratch and harness their power to manipulate, clean, and analyze large datasets.

Unlock deep insights that can transform your decision-making process.

30+ Modules | 65+ Videos |

Topics Covered:

01 – Introduction To Data Analysis

02 – MASTER EXCEL FOR DATA ANALYSIS

03 – Managing and Analyzing Data

04 – Sorting Data

05 – Creating Automatic Subtotals In Sorted Lists

06 – Filtering Data

07 – Advanced Filtering

08 – Eliminating Duplicate Data

09 – MASTER SQL FOR DATA ANALYSIS

10 – SQL INSTALLATION

11 – SQL Overview

12 – FUNDAMENTAL CONCEPTS

13 – RELATIONSHIPS

14 – STRINGS

15 – NUMBERS

16 – DATES & TIME

17 – AGGREGATES

18 – TRANSACTIONS

19 – TRIGGERS

20 – VIEWS & SUBSELECTS

21 – CRUD APPLICATIONS

22 – DATA REPORTING AND ANALYSIS IN SQL

23 – Use SQL To Report Data

24 – Grouping Your SQL Results

25 – Merge Data From Multiple Tables

26 – More Advanced SQL

27 – Introduction

28 – Data Analysis With Python

29 – Statistical Operations In Python

30 – HANDS-ON DATA ANALYSIS PRACTICE WITH PYTHON

4. Power BI for Data Analysis:

Course Intro: 

Create stunning, interactive dashboards that will wow your colleagues and clients. Learn how to visualize complex data with ease and tell compelling stories that drive action.

Topics Covered: 

Power BI Part 1:

1. Introduction & Setup: Overview of Power BI, interface, and creating your first report.
2. Data Prep & Transformation: Use Power Query to clean, transform, and enrich data.
3. Modeling & DAX Basics: Set up data models, create calculated columns, and learn basic DAX.
4. Advanced DAX & Time Intelligence: Practice time-based DAX functions, like cumulative sums.
5. Report Creation & Navigation: Finalize your report, apply dynamic ranking, and explore scenario analysis.

Power BI Part 2:

1. Interface & Data Preparation: Tour the Power BI interface and clean data using Power Query.
2. Enriching Data & DAX: Import date tables, create measures, and use advanced DAX functions.
3. Time Intelligence & Advanced DAX: Implement running totals, dynamic sales rankings, and advanced DAX techniques.
4. Final Report & Insights: Create a polished report with advanced features and scenario analysis.

Power BI Part 3:

1. CALCULATE Function: Learn to apply CALCULATE for advanced filtering and context.
2. Using Filters & Time Intelligence: Work with multiple filters and apply time intelligence with CALCULATE.
3. Advanced DAX & Sales Analysis: Use CALCULATE for sales classification, context transition, and dynamic selection.

Power BI Bonus Section:

1. Custom Visuals & Publishing: Enhance reports with custom visuals and learn how to publish.
2. DAX & Interview Tips: Create Dates tables with DAX and prepare for Power BI interview questions.
3. Customer Insights & Sales Thresholds: Identify key customers and set dynamic sales thresholds.

5. Tableau - Basic to Advanced:

Course Intro:

Master Tableau and create impactful data visualizations that transform raw data into meaningful insights. Impress stakeholders with your polished, professional reports. 

12+ Modules |

Topics Covered:

Beginner: Introduction to Tableau

1. Course Intro: Overview of Tableau and course structure.
2. Tableau Files: Access exercise files for practice.
3. Tableau Basics: Introduction to Tableau and BI concepts.
4. Data Connection: Connect Tableau to data sources.
5. Workspace & Views: Explore Tableau workspace and create views.
6. Multiple Data Sources: Work with multiple data sources.
7. Exercise: Hands-on practice with basic features.

Beginner: Bringing Data to Life

1. Chart Types: Choose appropriate charts for data.
2. Building Views: Create and design data views.
3. Histograms & Scatter Plots: Visualize data with histograms and scatter plots.
4. Spatial Charts & Dashboards: Create geographic charts and dashboards.
5. Publishing & Sharing: Share workbooks and present stories.
6. Exercises: Practice through additional exercises.

Beginner: Calculations and Expressions in Tableau

1. Expressions: Learn to create custom expressions.
2. Numeric & String Calculations: Use numeric and string expressions.
3. Conditional & Analytical Functions: Create conditional expressions and apply analytics.
4. Exercises: Practice using calculations in exercises.

Advanced: Calculations & Functions

1. Advanced Techniques: Learn complex calculations and functions.
2. Parameters: Use parameters for dynamic visualizations.
3. Level of Detail & Groups: Apply LOD expressions, groups, and sets.
4. Geospatial & Advanced Filters: Work with geospatial charts and advanced filters.
5. Table Calculations: Master table calculations for data manipulation.

Advanced: Improving Dashboards

1. Actions & Animation: Add interactivity and animation to dashboards.
2. Advanced Charts: Create complex chart types and visualizations.
3. Geospatial & Marketing Dashboards: Build specialized dashboards for specific insights.
4. Sales Dashboard: Create a dynamic sales dashboard.

Advanced: Exercises

1. Exercises: Apply advanced concepts in practical exercises.

🎥 Course Type: Video lessons

📩 Delivery: after payment You’ll receive a PDF with the private Google Drive access link in next page and also an email will be sent for access link

🧠 Contents:30+ Hours of Step-by-step video tutorials, lifetime access

🚫 Note: This is not an eBook, it’s a video course