![Data Analysts' Toolbox - Excel, Python, Power BI, Alteryx, Qlik Sense, R, Tableau [Video]](https://content.packt.com/V17093/cover_image_small.jpg)
Data Analysts' Toolbox - Excel, Python, Power BI, Alteryx, Qlik Sense, R, Tableau [Video]
Subscription
FREE
Video + Subscription
$29.99
Video
$134.99
What do you get with a Packt Subscription?
What do you get with a Packt Subscription?
What do you get with Video + Subscription?
What do you get with a Packt Subscription?
What do you get with eBook?
What do I get with Print?
What do I get with Print?
What do you get with video?
What do you get with Audiobook?
Subscription
FREE
Video + Subscription
$29.99
Video
$134.99
What do you get with a Packt Subscription?
What do you get with a Packt Subscription?
What do you get with Video + Subscription?
What do you get with a Packt Subscription?
What do you get with eBook?
What do I get with Print?
What do I get with Print?
What do you get with video?
What do you get with Audiobook?
-
Free ChapterAdvanced Pivot Tables: Introduction
-
Advanced Pivot Tables: Importing Data
-
Advanced Pivot Tables: Preparing Data for Analysis
-
Advanced Pivot Tables: Creating and Manipulating Pivot Tables
-
Advanced Pivot Tables: Formatting a Pivot Table
-
Advanced Pivot Tables: Value Field Settings
-
Advanced Pivot Tables: Sorting and Filtering
-
Advanced Pivot Tables: Interacting with a Pivot Table
-
Advanced Pivot Tables: Calculations
-
Advanced Pivot Tables: Pivot Charts
-
Advanced Pivot Tables: Conditional Formatting
-
Advanced Pivot Tables: Dashboards
-
Advanced Pivot Tables: Summary
-
Introduction to Power Pivot and Power Query
-
Getting Started with Power Query
-
Useful Power Query Features
-
Creating a Data Model
-
Introduction to Data Analysis Expressions (DAX)
-
More Data Analysis Expressions (DAX) Measures
-
Using Pivot Tables and Slicers
-
Power Pivot, Power Query, and Data Analysis Expressions (DAX): Summary
-
Introduction to Power BI
-
Power BI: Getting and Transforming Data
-
Power BI: Data Modelling
-
Introduction to Data Analysis Expressions (DAX) Measures
-
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
-
Power BI: Report Design
-
Power BI: Editing Interactions and Filters
-
Power BI Service
-
Power BI: Summary
-
Python: The Workplace Tech Divide
-
Introduction to Python
-
Basic Data Types
-
Python Built-In Functions
-
Variables and Functions
-
Errors and Debugging
-
Python Keywords
-
If-Else Statements
-
Storing Complex Data
-
Python Modules
-
Installing Python and Modules
-
Project: Automating Data Updates in a Spreadsheet
-
Summary
-
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
- 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
About this video
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.
All the resources for this course are available at: https://github.com/PacktPublishing/Data-Analysts-Toolbox-Excel-Python-Power-BI-Alteryx-Qlik-Sense-R-Tableau
- Publication date:
- December 2020
- Publisher
- Packt
- Duration
- 46 hours 14 minutes
- ISBN
- 9781801075329