Python Modules | Data Analysts' Toolbox - Excel, Python, Power BI, PivotTables, Alteryx, Qlik Sense, R, Tableau

Book Overview & Buying
Table Of Contents

Data Analysts' Toolbox - Excel, Python, Power BI, PivotTables, Alteryx, Qlik Sense, R, Tableau

By : Simon Sez IT

Buy this Video

Data Analysts' Toolbox - Excel, Python, Power BI, PivotTables, Alteryx, Qlik Sense, R, Tableau

By: Simon Sez IT

Buy this Video

Overview of this book

This course offers a complete journey through the modern data analyst’s toolset, covering Excel PivotTables, Power BI, Power Query, Python, Alteryx, Tableau, Qlik Sense, and R. Start with advanced Excel techniques—from data importing and cleaning to dashboards and charts—then move into Power Query and DAX to automate and model data. Python is introduced step by step, guiding learners through basic programming, error handling, and scripting for data tasks. Next, explore Alteryx for workflow automation and predictive analytics, build interactive dashboards in Power BI, and use DAX measures for dynamic reporting. Learn Qlik Sense for associative data modeling and storytelling, and R programming for data science basics and mini-projects. Visual storytelling is reinforced through Tableau, teaching data blending, expressions, and dashboard design. With practical exercises and real-world scenarios, this course ensures learners build cross-platform fluency and confidence in transforming raw data into meaningful insights across industries.

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 Data Types

Strings

Integers

Floats

Boolean

Data Types Exercise

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

Print Function

Try and Except

You Are Not Alone

Errors Exercise

Python Keywords

Common Keywords

Global

Keywords Exercise

If-Else Statements

Basic Logic

Syntax and Inline Evaluation

Value Evaluation

Complex If-Else Statements

If-Else Exercises

Storing Complex Data

Advanced Data Types

Lists

Dictionaries

Looping: Lists

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!

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!

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

Data Analysts' Toolbox - Excel, Python, Power BI, PivotTables, Alteryx, Qlik Sense, R, Tableau

By : Simon Sez IT

Data Analysts' Toolbox - Excel, Python, Power BI, PivotTables, Alteryx, Qlik Sense, R, Tableau

By: Simon Sez IT

Overview of this book

Confirmation

Buy this book with your credits?

Submit Your Feedback

Create a Free Account To Continue Reading

Sign in to activate your 7-day free access