47 Chapters

Advanced PivotTables: Introduction

Introduction to Advanced PivotTables

PivotTables Recap

Advanced PivotTables: Importing Data

Importing data from a text file

Importing data from Access

Exercise

Advanced PivotTables: Preparing Data for Analysis

Cleaning Data

Tabular Data

Exercise

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

Advanced PivotTables: Formatting PivotTables

PivotTable Styles

Custom Number Formatting

Exercise

Advanced PivotTables: Value Field Settings

Summarizing Values

Show Values As

Exercise

Advanced PivotTables: Sorting and Filtering

Advanced Sorting

Advanced Filtering

Exercise

Advanced PivotTables: Interacting with PivotTables

Inserting and formatting Slicers

Inserting and formatting Timelines

Connecting Slicers to multiple PivotTables

Using Slicers in Protected Workbooks

Exercise

Advanced PivotTables: Calculations

Creating a Calculated Field

Creating a Calculated Item

Solve Order and List Formulas

GETPIVOTDATA

Exercise

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

Advanced PivotTables: Conditional Formatting

Highlighting Cell Rules

Graphical Conditional Formats

Conditional Formatting and Slicers

Exercise

Advanced PivotTables: Dashboards

Creating an Interactive Dashboard - Part 1

Creating an Interactive Dashboard - Part 2

Updating Pivot Charts and PivotTables

Exercise

Advanced PivotTables: Summary

Summary

Introduction to PowerPivot and PowerQuery

Welcome and Overview

What is Power Query?

What is Power Pivot?

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

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

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

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

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

Using PivotTables and Slicers

Creating PivotTables and Pivot Charts

Using Slicers with your PivotTables

Create a Top 10 PivotTable

Practice Exercise

PowerPivot, PowerQuery and DAX: Closing

Wrap Up

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

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

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

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

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

Power BI: Report Design

Adding Text Boxes and Shapes

Use Themes

Conditional Formatting

Practice Exercise

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

Power BI Service

Publishing your Report to the Power BI Service

Different Ways to Share your Power BI Report

Practice Exercise

Power BI: Summary

Summary

Python: The Workplace Tech Divide

Which Side of the Divide Are You On?

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

Create an Account Online

Python: Basic Data Types

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

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 IDEs

Installing Python on IDLE

Managing Files and Folders

Executing Scripts

PIP

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

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

Summary

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

R Programming for Beginners: Includes R Mini-Project!

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

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

Loop Introduction and Creation

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!

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

Data Analysts' Toolbox - Excel, Python, Power BI, PivotTables, Alteryx, Qlik Sense, R, Tableau: Build End-to-End Data Analytics Skills with Excel, Python, Power BI, Tableau & More

What do you get with a video?

Key benefits

Description

Who is this book for?

What you will learn

Product Details

What do you get with a video?

Product Details

Frequently bought together

Table of Contents

Recommendations for you

People who bought this also bought

About the author

FAQs

Data Analysts' Toolbox - Excel, Python, Power BI, PivotTables, Alteryx, Qlik Sense, R, Tableau: Build End-to-End Data Analytics Skills with Excel, Python, Power BI, Tableau & More

What do you get with a video?

Contact Details

Billing Address

Key benefits

Description

Who is this book for?

What you will learn

Product Details

What do you get with a video?

Contact Details

Billing Address

Product Details

Packt Subscriptions

Frequently bought together

Table of Contents

Recommendations for you

People who bought this also bought

About the author

FAQs