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
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.
Table of contents
- Title: Data Analysts Toolbox: Excel, Python, Power BI
- Release date: December 2020
- Publisher(s): Packt Publishing
- ISBN: 9781801075329
You might also like
51+ hours of video instruction. Overview The professional programmer’s Deitel® video guide to Python development with …
Head First Design Patterns, 2nd Edition
You know you don’t want to reinvent the wheel, so you look to design patterns—the lessons …
Data Science from Scratch, 2nd Edition
To really learn data science, you should not only master the tools—data science libraries, frameworks, modules, …
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 …