1. Advanced Pivot Tables: Introduction

• Introduction to Advanced Pivot Tables
• Pivot Tables Recap

2. Advanced Pivot Tables: Importing Data FREE CHAPTER

• Importing Data from a Text File
• Importing Data from Access
• Exercise

3. Advanced Pivot Tables: Preparing Data for Analysis

• Cleaning Data
• Tabular Data
• Exercise

4. Advanced Pivot Tables: Creating and Manipulating Pivot Tables

• Creating and Manipulating a Pivot Table
• Combining Data from Multiple Worksheets
• Grouping and Ungrouping
• Report Layouts
• Formatting the Error Values and Empty Cells
• Exercise

5. Advanced Pivot Tables: Formatting a Pivot Table

• Pivot Table Styles
• Custom Number Formatting
• Exercise

6. Advanced Pivot Tables: Value Field Settings

• Summarizing Values
• Show Values As
• Exercise

7. Advanced Pivot Tables: Sorting and Filtering

• Advanced Sorting
• Advanced Filtering
• Exercise

8. Advanced Pivot Tables: Interacting with a Pivot Table

• Inserting and Formatting Slicers
• Inserting and Formatting Timelines
• Connecting Slicers to Multiple Pivot Tables
• Using Slicers in a Protected Workbook
• Exercise

9. Advanced Pivot Tables: Calculations

• Creating a Calculated Field
• Creating a Calculated Item
• Solve Order and List Formulas
• GETPIVOTDATA
• Exercise

10. Advanced Pivot Tables: Pivot Charts

• Creating a Pivot Chart
• Formatting a Pivot Chart - Part 1
• 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
• Exercise

11. Advanced Pivot Tables: Conditional Formatting

• Highlighting Cell Rules
• Graphical Conditional Formats
• Conditional Formatting and Slicers
• Exercise

12. Advanced Pivot Tables: Dashboards

• Creating an Interactive Dashboard - Part 1
• Creating an Interactive Dashboard - Part 2
• Updating Pivot Charts and PivotTables
• Exercise

13. Advanced Pivot Tables: Summary

• Summary

14. Introduction to Power Pivot and Power Query

• Welcome and Overview
• What is Power Query?
• What is Power Pivot?

15. Getting Started with Power Query

• Exploring the Power Query Editor
• 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
• Practice Exercise

16. Useful Power Query Features

• Unpivoting Columns
• Combining Data from Multiple Tables with Merge Queries
• 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
• Practice Exercise

17. Creating a Data Model

• Enabling the Power Pivot Add-in
• 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
• Practice Exercise

18. Introduction to Data Analysis Expressions (DAX)

• Why Use 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
• Practice Exercise

19. More Data Analysis Expressions (DAX) Measures

• Creating a Date Table in Power Pivot
• Using the CALCULATE Function
• Using the DIVIDE Function
• Using the DATESYTD Function
• Calculating the Percentage of a Total
• Practice Exercise

20. Using Pivot Tables and Slicers

• Creating Pivot Tables and Pivot Charts
• Using Slicers with Pivot Tables
• Creating a Top 10 Pivot Table
• Practice Exercise

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

• Summary

22. Introduction to Power BI

• Welcome and Overview
• What Is Power BI?
• Installing Power BI Desktop
• Tour of Power BI Desktop
• Exploring the Commonly Used Power BI Options

23. 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
• Practice Exercise

24. Power BI: Data Modelling

• Creating a Relationship Between Tables
• 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
• Practice Exercise

25. Introduction to Data Analysis Expressions (DAX) Measures

• Calculating Total Revenue
• Counting the Total Rows of a Table
• Using the CALCULATE DAX Function
• Calculating the Total Revenue for Last Year
• Difference Compared to Last Year
• Practice Exercise

26. Power BI: Adding Visualizations to Your Report

• Showing Summary Information with Cards
• 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
• Practice Exercise

27. Power BI: Report Design

• Adding Text Boxes and Shapes
• Using Themes
• Conditional Formatting
• Practice Exercise

28. Power BI: Editing Interactions and Filters

• Editing Interactions between Visualizations
• Filter Pane to Filter at any Level
• Drilling through to More Detail
• Practice Exercise

29. Power BI Service

• Publishing a Report to the Power BI Service
• Different Ways to Share a Power BI Report
• Practice Exercise

30. Power BI: Summary

• Summary

31. Python: The Workplace Tech Divide

• Which Side of the Divide Are You On?
• Beginners Are Welcome
• Course Overview

32. 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

33. Basic Data Types

• Python Data Types
• Strings
• Integers
• Floats
• Boolean
• Data Types Exercise

34. 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

35. Variables and Functions

• Variables and Functions
• Storing Values as Variables
• Comparing Variables with Operators
• Basic Expressions
• Functions
• Commenting
• Variables and Functions Exercise

36. Errors and Debugging

• What Is an Error?
• Reading a Stack Trace
• Print Function
• Try and Except
• You Are Not Alone
• Errors Exercise

37. Python Keywords

• Python Keywords
• Common Keywords
• Global Keywords
• Keywords Exercise

38. If-Else Statements

• Basic Logic
• Syntax and Inline Evaluation
• Value Evaluation
• Complex If-Else Statements
• If-Else Exercises

39. Storing Complex Data

• Advanced Data Types
• Lists
• Dictionaries
• Looping: Lists
• Looping: Dictionaries
• Advanced Data Exercise

40. Python Modules

• Python Modules
• Python Built-In Modules
• Importing Modules

41. 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

42. 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

43. Summary

• What's Next?

44. 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
• Summary

45. Getting Started in Qlik Sense - Beginner to Master

• Introduction to the Course
• What Is Qlik Sense?
• Qlik Sense Versus QlikView
• Different Versions of Qlik Sense
• Exploring the Qlik Sense Interface
• Loading Data Part 1
• Loading Data Part 2
• Creating and Loading Apps
• Adding Your First Chart
• Editing Your Visualization Part 1
• Editing Your Visualization Part 2
• Publishing and Sharing Apps
• Exercise 01: Loading Data
• Data Assets in Visualization Part 1
• Data Assets in Visualization Part 2
• Types of Charts and Graphs Part 1
• Types of Charts and Graphs Part 2
• Types of Charts and Graphs Part 3
• Types of Charts and Graphs Part 4
• Types of Charts and Graphs Part 5
• Generating Insights and Analysis
• Exercise 02: Build a Chart
• Exercise 03: Types of Charts and Graphs
• Aggregations
• Functions and Expressions Part 1
• Functions and Expressions Part 2
• Date and Time Formatting
• Conditional Functions
• Data Load Script
• Join, Keep, and Concatenate Prefixes
• Set Analysis
• Exercise 04: Numeric and String Functions
• Exercise 05: Inner Join
• Geo Analytics in Qlik Sense
• Qlik Sense Course Conclusion

46. R Programming for Beginners: Includes R Mini-Project!

• Welcome!
• Course Overview
• Why R?
• R for Data Science
• Preparing Workspace
• Guide to RStudio
• Exercise 1 - Introduction to R
• Operations-and-Variables
• Data Types in R
• Coding Style
• Comments
• Exercise 2 - Basics of R programming
• Vector Creation
• Selecting Components from a Vector
• Labeling Vector Elements
• Calculations with Vectors
• Base R Functions to Use with Vectors
• Comparing Two Vectors
• Modifying Vector Components
• Exercise 3 - Vectors
• Matrix Introduction and Creation
• Matrix Metrics and Naming
• Selecting Elements
• Matrix Arithmetic
• Matrices Operations
• Matrix Modification
• Exercise 4 - Matrices
• Array Introduction and Creation
• Array Similarities to Matrices
• Other Array Operations
• Exercise 5 - Arrays
• List Introduction and Creation
• List Naming
• Selecting List Elements
• List Manipulation
• List Operations
• Exercise 6 - Lists
• Factor Introduction and Creation
• Setting Factor Levels
• Ordering Factors
• Converting Factors
• Other Considerations
• Exercise 7 - Factors
• Loop Introduction and Creation
• If-Else Statements
• For Loops
• While Loops
• Repeat Loops
• Loop Comparison
• Exercise 8 - Loops
• Function Introduction and Creation
• Function Arguments
• Nested Functions
• Global Versus Local Variables
• Exercise 9 - Function
• Dataframe Introduction and Creation
• Tidyverse
• Tibbles
• Tidy Data
• Dplyr and Data Transformation
• Summarizing Dataframes
• Introduction to Mini-Project
• Importing Data
• Comprehending the Dataset
• Tidying Data
• Grouping Time Series Analysis Data
• Data Visualization
• Statistical Analysis
• Exercise 11 Mini-Project
• Great Job and Farewell!

47. Tableau for Beginners - Getting Started in Tableau

• Course Introduction
• Tableau Introduction
• Tableau Product Suite Introduction
• Business Intelligence Introduction
• Exploring Tableau
• Tableau Data Concepts
• Connecting to Data Sources
• Data Sources in Tableau
• Tableau Workspace
• Creating a New View
• Using Multiple Data Sources
• Exercise 1
• Selecting a Chart Type Part 1
• Selecting a Chart Type Part 2
• Building a View Part 1
• Building a View Part 2
• Designing Callout Numbers and Tables
• Histograms and Whisker Plots
• Scatter Plot and Correlation Matrix
• Spatial Charts
• Creating a Dashboard
• Presenting a Story
• Publishing and Sharing a Workbook
• Exercise 2
• Exercise 3
• Using Expressions in Tableau
• Numeric Expressions and Automatic Calculations
• String Expressions
• Conditional Expressions
• Analytical Functions
• Exercise 4
• Exercise 5
• Course Conclusion