Book Image

Data Analysts' Toolbox - Excel, Python, Power BI, Alteryx, Qlik Sense, R, Tableau [Video]

By : Simon Sez IT
Book Image

Data Analysts' Toolbox - Excel, Python, Power BI, Alteryx, Qlik Sense, R, Tableau [Video]

By: Simon Sez IT

Overview of this book

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
Table of Contents (47 chapters)
Free Chapter
1
Advanced Pivot Tables: Introduction
2
Advanced Pivot Tables: Importing Data
3
Advanced Pivot Tables: Preparing Data for Analysis
5
Advanced Pivot Tables: Formatting a Pivot Table
6
Advanced Pivot Tables: Value Field Settings
7
Advanced Pivot Tables: Sorting and Filtering
13
Advanced Pivot Tables: Summary
14
Introduction to Power Pivot and Power Query
21
Power Pivot, Power Query, and Data Analysis Expressions (DAX): Summary
30
Power BI: Summary
43
Summary
46
R Programming for Beginners: Includes R Mini-Project!
Chapter 1
Advanced Pivot Tables: Introduction
Section 1
Introduction to Advanced Pivot Tables
This video introduces you to advanced pivot tables in Excel.