Data Analysts' Toolbox - Excel, Python, Power BI, Alteryx, Qlik Sense, R, Tableau: Learn modern ways to analyze huge buckets of data to make informed business decisions

Advanced Pivot Tables: Preparing Data for Analysis

Cleaning Data

Tabular Data

Creating and Manipulating a Pivot Table

Advanced Pivot Tables: Creating and Manipulating Pivot Tables

Combining Data from Multiple Worksheets

Grouping and Ungrouping

Report Layouts

Formatting the Error Values and Empty Cells

Advanced Pivot Tables: Formatting a Pivot Table

Pivot Table Styles

Custom Number Formatting

Advanced Pivot Tables: Value Field Settings

Summarizing Values

Show Values As

Advanced Pivot Tables: Sorting and Filtering

Advanced Sorting

Advanced Filtering

Inserting and Formatting Slicers

Advanced Pivot Tables: Interacting with a Pivot Table

Inserting and Formatting Timelines

Connecting Slicers to Multiple Pivot Tables

Using Slicers in a Protected Workbook

Creating a Calculated Field

Advanced Pivot Tables: Calculations

Creating a Calculated Item

Solve Order and List Formulas

GETPIVOTDATA

Formatting a Pivot Chart - Part 1

Advanced Pivot Tables: Pivot Charts

Creating a Pivot Chart

Formatting a Pivot Chart - Part 2

Creating a Map Chart Using Pivot Data

Creating a Dynamic Chart Title

Include a Sparkline with a Pivot Table

Graphical Conditional Formats

Advanced Pivot Tables: Conditional Formatting

Highlighting Cell Rules

Conditional Formatting and Slicers

Creating an Interactive Dashboard - Part 1

Advanced Pivot Tables: Dashboards

Creating an Interactive Dashboard - Part 2

Updating Pivot Charts and PivotTables

Advanced Pivot Tables: Summary

Exploring the Power Query Editor

Introduction to Power Pivot and Power Query

Welcome and Overview

What is Power Query?

What is Power Pivot?

Getting Started with Power Query

Common Power Query Transformations

Editing an Existing Query

Importing Multiple Files from a Folder

Connecting to Data in Another Excel Workbook

Important: Checking the Location of Your Query's Source

Retrieving Data from the Web

Combining Data from Multiple Tables with Merge Queries

Useful Power Query Features

Unpivoting Columns

Using Merge Queries to Compare Two Tables

Stacking Data into One Table with Append Queries

Duplicating and Referencing Queries

Grouping and Aggregating Data

Adding Conditional Columns in Power Query

Enabling the Power Pivot Add-in

Creating a Data Model

Understanding the Power Pivot Window

Creating Relationships Between Tables

Managing Relationships of the Model

Creating a Pivot Table from the Data Model

Hiding Fields from the Client Tools

Grouping Queries

Why Use Data Analysis Expressions (DAX)

Introduction to Data Analysis Expressions (DAX)

Creating Calculated Columns with Data Analysis Expressions (DAX)

Creating the First Data Analysis Expressions (DAX) Measure

Using the COUNTROWS Function

Using the SUMX and RELATED Functions

Creating a Date Table in Power Pivot

More Data Analysis Expressions (DAX) Measures

Using the CALCULATE Function

Using the DIVIDE Function

Using the DATESYTD Function

Calculating the Percentage of a Total

Creating Pivot Tables and Pivot Charts

Using Pivot Tables and Slicers

Using Slicers with Pivot Tables

Creating a Top 10 Pivot Table

Power Pivot, Power Query, and Data Analysis Expressions (DAX): Summary

Installing Power BI Desktop

Introduction to Power BI

Welcome and Overview

What Is Power BI?

Tour of Power BI Desktop

Exploring the Commonly Used Power BI Options

Power BI: Getting and Transforming Data

Importing Files from a Folder into Power BI Desktop

Getting Data from Excel and Text Files

Referencing Queries to Create Additional Lookup Tables

Merging Queries in Power Query

Preventing Queries from Loading into Power BI Desktop

Creating a Relationship Between Tables

Power BI: Data Modelling

Creating a Dynamic List of Dates

Creating Additional Date Columns for Analysis

Sorting the Month and Weekday Names Correctly

Marking the Table as a Date Table

Hiding Unnecessary Fields from the Report View

Calculating Total Revenue

Introduction to Data Analysis Expressions (DAX) Measures

Counting the Total Rows of a Table

Using the CALCULATE DAX Function

Calculating the Total Revenue for Last Year

Difference Compared to Last Year

Showing Summary Information with Cards

Power BI: Adding Visualizations to Your Report

Comparing Values with Columns Charts

Mapping Visual to Plot Geographic Data

Filtering Reports with Slicers

Key Performance Indicator (KPI) Card to Measure Performance against a Goal

Line Graphs to Visualize a Trend

Showing Details with the Matrix

Top N Lists with Table Visualization

Adding Text Boxes and Shapes

Power BI: Report Design

Using Themes

Conditional Formatting

Editing Interactions between Visualizations

Power BI: Editing Interactions and Filters

Filter Pane to Filter at any Level

Drilling through to More Detail

Publishing a Report to the Power BI Service

Power BI Service

Different Ways to Share a Power BI Report

Power BI: Summary

Which Side of the Divide Are You On?

Python: The Workplace Tech Divide

Beginners Are Welcome

Course Overview

Introduction to Python

What Is Python?

Pythonâ€˜s Comparison to Other Programming Languages

Examples of Python in the Workplace

The Easiest Place to Practice Python

Creating an Account Online

Basic Data Types

Python Built-In Functions

What are Built-In Functions?

Where to Look for the Built-In Functions?

Most Common Built-In Functions

Built-In Functions Exercise

Variables and Functions

Storing Values as Variables

Comparing Variables with Operators

Basic Expressions

Functions

Commenting

Variables and Functions Exercise

Errors and Debugging

What Is an Error?

Reading a Stack Trace

Python Keywords

If-Else Statements

Syntax and Inline Evaluation

Value Evaluation

Complex If-Else Statements

Storing Complex Data

Looping: Dictionaries

Advanced Data Exercise

Python Modules

Python Built-In Modules

Importing Modules

Installing Python and Modules

Python Environments

Installing Python on Mac

Installing Python on Windows

Installing Python on Integrated Development Environments (IDEs)

Installing Python on Integrated Development and Learning Environment (IDLE)

Managing Files and Folders

Executing Scripts

Pip

Project: Automating Data Updates in a Spreadsheet

Project Introduction

Setting Up the Project

Reading and Writing to Excel Files

Working with Comma-Separated Values (CSV) Files

Dynamic File Paths

Transforming and Validating Transactions

Transferring and Saving Transactions

Cleaning Up the Code

Hardening the Script

Summary

What's Next?

Introduction to Alteryx for Beginners

Introduction

Alteryx Essentials

Data Types 101

Getting Started with the Alteryx Designer

Building a Workflow in Designer

The Favorites Tools

Data Filtering for Beginners

Introduction to Alteryx for Excel Users

Alteryx for the SQL Analyst

Introduction to Basic Functions - Part 1

Introduction to Basic Functions - Part 2

Introduction to Basic Functions - Part 3

Basic Parsing Methods

Basic Parsing Methods w/ Dynamic Renaming

Basic VLOOKUP and Append

Working on Multiple Fields in Alteryx

Build an Alteryx Workflow

Basic Tips and Tricks

Alteryx Best Practices - Visualizing Data

Alteryx Best Practices - Visualizing Data with Texts and Charts

Alteryx Best Practices - Layouts and Rendering

Introduction to Analytic Apps

Introduction to Macros

Intro to Data Analysis - Working Spatial Data

Introduction to Data Analysis - Measuring

Introduction to Data Analysis - Spatial Objects

Introduction to Analytics

Introduction to K-Centroid Clustering

Introduction to K-Nearest Neighbor

Introduction to Market Basket Analysis

Introduction to Logistic Regression Analysis

Introduction to Linear Regression Analysis

Introduction to Tree-Based Models Part 1

Introduction to Tree-Based Models Part 2