Video description
Discover how to use Excel, Python, and Power BI, to perform complex data analysis
About This Video
- Become confident in cleaning, sorting, and linking data from various sources
- Learn how to write flawless Python scripts for updating the data in a spreadsheet
- Get ready to create amazing visuals, such as clustered column charts, maps, and trend graphs
In Detail
Being able to understand, harness, and use data is no longer a skill reserved for a handful of well-paid data analysts. It's becoming an essential part of many roles. Learning data analysis can sound daunting, but don't worry. This video 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 grips with Power Pivot, Power Query, and Data Analysis Expressions (DAX) and discover how to use Power BI to create striking data visualization. Towards the end, you will learn the Python programming concepts that will help you to write error-free Python scripts for automatically updating data in a spreadsheet.
By the end of this course, you will be able to confidently analyze and visualize huge sets of data using Python, Power Query, Power Pivot, and Power BI.
Who this book is for
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. Working knowledge of Excel is required to get started with this course.
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
Product information
- Title: Data Analysts Toolbox: Excel, Python, Power BI
- Author(s):
- Release date: December 2020
- Publisher(s): Packt Publishing
- ISBN: 9781801075329
You might also like
book
Intro to Python for Computer Science and Data Science: Learning to Program with AI, Big Data and The Cloud
This is the eBook of the printed book and may not include any media, website access …
video
Python Fundamentals
51+ hours of video instruction. Overview The professional programmer’s Deitel® video guide to Python development with …
book
Clean Code: A Handbook of Agile Software Craftsmanship
Even bad code can function. But if code isn't clean, it can bring a development organization …
book
Data Science from Scratch, 2nd Edition
To really learn data science, you should not only master the tools—data science libraries, frameworks, modules, …