1. Advanced PivotTables: Introduction FREE CHAPTER

• Introduction to Advanced PivotTables
• PivotTables Recap

2. Advanced PivotTables: Importing Data

• Importing data from a text file
• Importing data from Access
• Exercise

3. Advanced PivotTables: Preparing Data for Analysis

• Cleaning Data
• Tabular Data
• Exercise

4. Advanced PivotTables: Creating and Manipulating PivotTables

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

5. Advanced PivotTables: Formatting PivotTables

• PivotTable Styles
• Custom Number Formatting
• Exercise

6. Advanced PivotTables: Value Field Settings

• Summarizing Values
• Show Values As
• Exercise

7. Advanced PivotTables: Sorting and Filtering

• Advanced Sorting
• Advanced Filtering
• Exercise

8. Advanced PivotTables: Interacting with PivotTables

• Inserting and formatting Slicers
• Inserting and formatting Timelines
• Connecting Slicers to multiple PivotTables
• Using Slicers in Protected Workbooks
• Exercise

9. Advanced PivotTables: Calculations

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

10. Advanced PivotTables: 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 PivotTable
• Exercise

11. Advanced PivotTables: Conditional Formatting

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

12. Advanced PivotTables: Dashboards

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

13. Advanced PivotTables: Summary

• Summary

14. Introduction to PowerPivot and PowerQuery

• 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
• Import Multiple Files from a Folder
• Connect to Data in Another Excel Workbook
• IMPORTANT: Checking the Location of Your Query's Source
• Get Data From the Web
• Practice Exercise

16. Useful Power Query Features

• Unpivoting Columns
• Combine Data from Multiple Tables with Merge Queries
• Use Merge Queries to Compare Two Tables
• Stack Data into One Table with Append Queries
• Duplicating and Referencing Queries
• Grouping and Aggregating Data
• Conditional Columns in Power Query
• Practice Exercise

17. Creating the Data Model

• Enabling the Power Pivot Add-in
• Understanding the Power Pivot Window
• Creating Relationships Between Tables
• Managing the Relationships of the Model
• Creating a PivotTable from the Data Model
• Hiding Fields from Client Tools
• Grouping Queries
• Practice Exercise

18. Introduction to DAX

• Why Use DAX?
• Creating Calculated Columns with DAX
• Creating the First DAX Measure
• The COUNTROWS Function
• SUMX and RELATED Functions
• Practice Exercise

19. More DAX Measures

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

20. Using PivotTables and Slicers

• Creating PivotTables and Pivot Charts
• Using Slicers with your PivotTables
• Create a Top 10 PivotTable
• Practice Exercise

21. PowerPivot, PowerQuery and DAX: Closing

• Wrap Up

22. Introduction to Power BI

• Welcome and Overview
• What Is Power BI?
• Install Power BI Desktop
• A Tour of Power BI Desktop
• Explore Commonly Used Power BI Options

23. Power BI: Getting and Transforming Data

• Import Files from a Folder into Power BI Desktop
• Get Data from Excel and Text Files
• Changing Query Source
• Reference Queries to Create Additional Lookup Tables
• Merge Queries in Power Query
• Prevent Queries from Loading into Power BI Desktop
• Practice Exercise

24. Power BI: Data Modelling

• Create Relationship Between Tables
• Create a Dynamic List of Dates
• Create Additional Date Columns for Analysis
• Sort the Month and Weekday Names Correctly
• Mark the Table as a Date Table
• Hide Unnecessary Fields from the Report View
• Practice Exercise

25. Introduction to DAX Measures

• Calculate the Total Revenue
• Count the Total Rows of a Table
• Use the CALCULATE Function
• Calculate the Total Revenue Last Year
• Difference Compared to Last Year
• Practice Exercise

26. Power BI: Adding Visualizations to Your Report

• Show Summary Information with Cards
• Columns Charts to Compare Values
• Map Visual to Plot Geographic Data
• Slicers to Filter your Reports
• KPI Card to Measure Performance against a Goal
• Line Graphs to Visualize Trend
• Show Details with the Matrix
• Top N Lists with Table Visualization
• Practice Exercise

27. Power BI: Report Design

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

28. Power BI: Editing Interactions and Filters

• Edit the Interactions between your Visualizations
• The Filter Pane to Filter at Any Level
• Drill through to More Detail
• Practice Exercise

29. Power BI Service

• Publishing your Report to the Power BI Service
• Different Ways to Share your 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
• Create an Account Online

33. Python: Basic Data Types

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

34. Python Built-In Functions

• What is a Built-In Function?
• Where to Look for 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 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 IDEs
• Installing Python on IDLE
• Managing Files and Folders
• Executing Scripts
• PIP

42. Project: Automate Data Updates For a Spreadsheet

• Project Introduction
• Setting Up Project
• Reading and Writing to Excel Files
• Working with CSV Files
• Dynamic File Paths
• Transform and Validate Transactions
• Transfer and Save Transactions
• Clean 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
• Exercise 10 - Dataframe
• 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