Data Analysis Course Bundle

Tableau Basic to Advanced

Beginner: Introduction to Tableau

• Course Intro

• Tableau Files

• Tableau Basics

• Data Connection

• Workspace & Views

• Multiple Data Sources

• Exercises

Beginner: Bringing Data to Life

• Chart Types

• Building Views

• Histograms & Scatter Plots

• Spatial Charts & Dashboards

• Publishing & Sharing

• Exercises

Beginner: Calculations and Expressions in Tableau

• Expressions

• Numeric & String Calculations

• Conditional & Analytical Functions

• Exercises

Advanced: Calculations & Functions

• Advanced Techniques

• Parameters

• Level of Detail & Groups

• Geospatial & Advanced Filters

• Table Calculations

Advanced: Improving Dashboards

• Actions & Animation

• Advanced Charts

• Geospatial & Marketing Dashboards

• Sales Dashboard

Advanced: Exercises

• Practice advanced concepts

Power BI

Power BI Part 1

• Introduction & Setup

• Data Prep & Transformation

• Modeling & DAX Basics

• Advanced DAX & Time Intelligence

• Report Creation & Navigation

Power BI Part 2

• Interface & Data Preparation

• Enriching Data & DAX

• Time Intelligence & Advanced DAX

• Final Report & Insights

Power BI Part 3

• CALCULATE Function

• Using Filters & Time Intelligence

• Advanced DAX & Sales Analysis

Power BI Bonus Section

• Custom Visuals & Publishing

• DAX & Interview Tips

• Customer Insights & Sales Thresholds

Python & SQL for Data Analysis

Python for Data Analysis

• Introduction to Data Analysis

• Master Excel for Data Analysis

• Managing and Analyzing Data

• Sorting Data

• Creating Automatic Subtotals in Sorted Lists

• Filtering Data

• Advanced Filtering

• Eliminating Duplicate Data

SQL for Data Analysis

• Master SQL for Data Analysis

• SQL Installation

• SQL Overview

• Fundamental Concepts

• Relationships

• Strings

• Numbers

• Dates & Time

• Aggregates

• Transactions

• Indexes

• Views & Subselects

• CRUD Applications

• Data Reporting and Analysis in SQL

• Using SQL to Report ROI

• Grouping SQL Results

• Merge Data from Multiple Tables

• More Advanced SQL

Python + SQL Integration

• Introduction

• Data Analysis with Python

• Statistical Operations in Python

• Hands-on Data Analysis Practice with Python

VBA Macros Basic to Advanced

• Macro Security and Setup

• Customizing the Ribbon

• Creating and Running Macros

• User Interaction

• Writing and Debugging Code

• Working with Data

• VBA Control Structures

• UserForm Design

• Handling Variables and Constants

• Triggering Macros

• Function and Sub Procedures

• Worksheet and Workbook Events

• Range and Cell Manipulation

• VBA Functions and Methods

• Optimization and Speeding Up VBA

Excel with AI and ChatGPT

• Excel Basics & Navigation

• Workbook & Worksheet Management

• Data Entry & Formatting

• Formulas & Functions

• Formula Management & Auditing

• Data Tools

• Charts & Data Visualization

• Pivot Tables

• Tables & Lists

• Conditional Formatting

• Printing & Page Setup

• Date & Time Management

• Protection & Security

• Charts & Graphics

• Keyboard Shortcuts & Productivity Tips

• Review & Collaboration

• Templates & Themes

• Advanced Tools

• File Info & Layout Views

• Miscellaneous Features