Perfect Excel Charts: Communicate with data using Excel charts

Nikita Barsukov

NZ$191.99

Video Jul 2018 2hrs 28mins 1st Edition

Nikita Barsukov

NZ$191.99

Video Jul 2018 2hrs 28mins 1st Edition

What do you get with a video?

Download this video in MP4 format

Access this title in our online reader with advanced features

DRM FREE - Read whenever, wherever and however you want

View table of contents

Download Code

Key benefits

• Go through high-level concrete processes on how to make charts clear, concise, and truthful, by focusing on the most typical chart types: line charts, bar charts, scatter plots, and histograms.
• Get a top-down approach in data science by first communicating and then implementing your findings in Microsoft Excel
• Work on real-life datasets to illustrate how to communicate effectively with data and charts

Description

A lot of us who work with data know how to make charts, but don't know how to make effective visualizations that send a clear, efficient, and truthful message. Many of us don't realize what makes charts speak and how to remove noise and focus only on what's important. This course takes a different approach, focusing instead on various data science tools, typical workflows in data projects, algorithms, and the math behind data science. You will work on presenting and communicating with data using visual media such as charts, plots, and histograms with real-world datasets. By working with the four most popular chart types, you will dissect each of them at a microscopic level while using interesting real-world datasets with practical examples in Excel. The aim of the course is to show you where charts work and where they don't and what makes these charts easier to understand. By the end of the course, you will have learned how to implement the principles of effective visual communication using Excel. The code bundle for this video course is available at- https://github.com/PacktPublishing/Perfect-Excel-Charts

Who is this book for?

If you are a business analyst, data scientist, or a data practitioner trying to go beyond the default visualization options, or if you want to figure out how to work with messy real-life datasets, this course is for you.

What you will learn

• Apply a top-down approach in data analysis by starting with high-level questions, sketches, and metric definitions for more effective communication with data.
• Work with real-life noisy data and communicate findings that are relatable to real life with clarity and truthfulness
• Dissect common elements of an ideal chart to get an understanding of how to use it to tell a clear story
• Discover how elements of each chart type serve to add clarity and substance to the chart message
• Build perfect charts using Excel, one of the most popular statistical applications used worldwide

What do you get with a video?