Video description
Being able to understand, harness, and use data is no longer a skill reserved for a handful of well-paid 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 error-free 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 easy-to-learn and hands-on software training. It offers over 8000 video tutorials on a range of software programs. Simon Sez IT ensures stress-free 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.
Publisher resources
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 Built-In Functions
- Chapter 35 : Variables and Functions
- Chapter 36 : Errors and Debugging
- Chapter 37 : Python Keywords
- Chapter 38 : If-Else 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 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
-
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 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!
-
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
Microsoft Power BI - The Complete Masterclass [2023 EDITION]
Microsoft Power BI is an interactive data visualization software primarily focusing on business intelligence, part of …
video
Master SQL for Data Analysis
SQL is a popular language for extracting, stacking, and querying data from databases. Master SQL to …
video
Practical Python: Learn Python Basics Step by Step - Python 3
Python is one of the most popular programming languages and gives a lot of scope and …
book
Hands-On Machine Learning with Scikit-Learn, Keras, and TensorFlow, 2nd Edition
Through a series of recent breakthroughs, deep learning has boosted the entire field of machine learning. …