Video description
Being able to understand, harness, and use data is no longer a skill reserved for a handful of wellpaid data analysts. It is becoming an essential part of many roles. This course unboxes the data analyst toolbox bundle, enabling you to learn the tools needed for data analysis.
The course starts by taking you through the topics of advanced pivot tables. You will learn how to create and manipulate pivot tables, import data from Access and Excel into the tables, prepare data for analysis, sort and filter the data, create an interactive dashboard, and a lot more. Next, you will get to grips with Power Pivot, Power Query, and Data Analysis Expressions (DAX) and discover how to use Power BI to create striking data visualization.
You will then learn the Python programming concepts that will help you write errorfree Python scripts for automatically updating data in a spreadsheet.
Next, you will get introduced to Alteryx, Qlik Sense, R programming, and finally, learn how to create stunning visualizations in Tableau Desktop.
By the end of this course, you will be able to confidently analyze and visualize huge sets of data using Excel, Python, Power BI, Alteryx, Qlik Sense, R, and Tableau.
What You Will Learn
Audience
This course is aimed at intermediate Excel users who want to learn Python, Power BI, Power Pivot, and advanced pivot tables to analyze and visualize data. This course is also designed to get introduced to Alteryx, Qlik Sense, R programming, and Tableau Desktop. Working knowledge of Excel and understanding of data analytics are required to get started with this course.
About The Author
Simon Sez IT: Simon Sez IT has offered technical courses since 2008 for individuals, small businesses, and Fortune 500 companies with thousands of employees who can benefit from the easytolearn and handson software training. It offers over 8000 video tutorials on a range of software programs. Simon Sez IT ensures stressfree eLearning and enhanced employee productivity—whether you implement new software or a technological upgrade in your work environment. With over 600,000 students from 180 countries, Simon Sez IT is the preferred online learning choice for individuals and businesses worldwide.
Table of contents
 Chapter 1 : Advanced Pivot Tables: Introduction
 Chapter 2 : Advanced Pivot Tables: Importing Data
 Chapter 3 : Advanced Pivot Tables: Preparing Data for Analysis
 Chapter 4 : Advanced Pivot Tables: Creating and Manipulating Pivot Tables
 Chapter 5 : Advanced Pivot Tables: Formatting a Pivot Table
 Chapter 6 : Advanced Pivot Tables: Value Field Settings
 Chapter 7 : Advanced Pivot Tables: Sorting and Filtering
 Chapter 8 : Advanced Pivot Tables: Interacting with a Pivot Table
 Chapter 9 : Advanced Pivot Tables: Calculations
 Chapter 10 : Advanced Pivot Tables: Pivot Charts
 Chapter 11 : Advanced Pivot Tables: Conditional Formatting
 Chapter 12 : Advanced Pivot Tables: Dashboards
 Chapter 13 : Advanced Pivot Tables: Summary
 Chapter 14 : Introduction to Power Pivot and Power Query
 Chapter 15 : Getting Started with Power Query
 Chapter 16 : Useful Power Query Features
 Chapter 17 : Creating a Data Model
 Chapter 18 : Introduction to Data Analysis Expressions (DAX)
 Chapter 19 : More Data Analysis Expressions (DAX) Measures
 Chapter 20 : Using Pivot Tables and Slicers
 Chapter 21 : Power Pivot, Power Query, and Data Analysis Expressions (DAX): Summary
 Chapter 22 : Introduction to Power BI
 Chapter 23 : Power BI: Getting and Transforming Data
 Chapter 24 : Power BI: Data Modelling
 Chapter 25 : Introduction to Data Analysis Expressions (DAX) Measures

Chapter 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
 Chapter 27 : Power BI: Report Design
 Chapter 28 : Power BI: Editing Interactions and Filters
 Chapter 29 : Power BI Service
 Chapter 30 : Power BI: Summary
 Chapter 31 : Python: The Workplace Tech Divide
 Chapter 32 : Introduction to Python
 Chapter 33 : Basic Data Types
 Chapter 34 : Python BuiltIn Functions
 Chapter 35 : Variables and Functions
 Chapter 36 : Errors and Debugging
 Chapter 37 : Python Keywords
 Chapter 38 : IfElse Statements
 Chapter 39 : Storing Complex Data
 Chapter 40 : Python Modules
 Chapter 41 : Installing Python and Modules
 Chapter 42 : Project: Automating Data Updates in a Spreadsheet
 Chapter 43 : Summary

Chapter 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 KCentroid Clustering
 Introduction to KNearest Neighbor
 Introduction to Market Basket Analysis
 Introduction to Logistic Regression Analysis
 Introduction to Linear Regression Analysis
 Introduction to TreeBased Models Part 1
 Introduction to TreeBased Models Part 2
 Summary

Chapter 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

Chapter 46 : R Programming for Beginners: Includes R MiniProject!
 Welcome!
 Course Overview
 Why R?
 R for Data Science
 Preparing Workspace
 Guide to RStudio
 Exercise 1  Introduction to R
 OperationsandVariables
 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
 IfElse 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 MiniProject
 Importing Data
 Comprehending the Dataset
 Tidying Data
 Grouping Time Series Analysis Data
 Data Visualization
 Statistical Analysis
 Exercise 11 MiniProject
 Great Job and Farewell!

Chapter 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
Product information
 Title: Data Analysts' Toolbox  Excel, Python, Power BI, Alteryx, Qlik Sense, R, Tableau
 Author(s):
 Release date: June 2022
 Publisher(s): Packt Publishing
 ISBN: 9781801075329
You might also like
video
Data Analysis Fundamentals with Excel (Video)
7+ Hours of Video Instruction This video course takes you—the business user, business analyst, or data …
video
Data Analysis with Pandas and Python
This course begins with the essentials, introducing you to Anaconda and Jupyter Lab setup for Python …
video
Python for Data Analysis: StepByStep with Projects
Data analysis is a critical skill and is getting more popular. Nowadays, every organization has some …
book
Python for Data Analysis, 3rd Edition
Get the definitive handbook for manipulating, processing, cleaning, and crunching datasets in Python. Updated for Python …