Professional Dashboards in Excel and Tableau

Complete Dashboards: Excel, Tableau, Pivot Tables, Slicers, Filters, Design, Templates

What you'll learn
Techniques for choosing an appropriate visualization based on your data
Approaches for selecting the best colors scheme for a professional presentation
How to build stunning interactive dashboard reports
Methods to use real-world data sets to solve a business problem from the FMCG sector
How to master Excel Pivot Tables and the Developer tab
Ways to create custom based time Filters in Tableau
Skills to style and format a presentation-worthy dashboard
How to successfully interpret the results from a report in Excel and Tableau

Requirements
You have Excel installed on your computer (we’ll guide you through installing Tableau)
You have some experience with writing basic formulas in Excel and are comfortable with the spreadsheet environment
You are motivated and eager to enhance your data visualization skills
Description
What you’ll learn in this course?

Professional Dashboards in Excel and Tableau will teach you how to create visually compelling reports with both Excel and Tableau!

Whether you prefer working with Excel or Tableau, this course will enable you to create beautiful reports from scratch!

Dynamic and meaningful visual reports have now become the focus of most business interactions. With dashboards, you can gain crucial insights from the company’s data and present information to investors or clients. That makes building a compelling dashboard a highly demanded skill which can make or break your chances of securing a place in the strategic team of your company. So, if you are looking for ways to improve your data visualization proficiency and boost your career prospects, look no further!

Professional Dashboards in Excel and Tableau will show you not only how to create reports, but also how to style them to perfection and interpret them with ease. You’ll also have access to the elegant color template we work with during the lessons, so you can apply it to your future reports for a professional and cohesive look. In addition, we’ll help you with advice on how to create your own dashing templates using the best free online platforms out there.

Here’s what you will find in this unique course

· Introduction into the main principles of data visualization

We discuss topics such as color theory, how to choose the right visualization based on your data, and showcase a few online platforms that can aid you on your data visualization journey.

· The entire process of making a dashboard in Excel

Starting from the very beginning, we’ll show you techniques that you can successfully apply to every Excel report. We work on real-world data and create a report based on data from a real firm, operating in the fast-moving consumer goods sector.

· Creating a dashboard in Tableau

Again, our data comes from the real-world FMCG industry. In the process of crafting the components, we’ll get familiar with a wide range of techniques for building charts and other elements available in Tableau.

But it doesn’t end there!

You’ll also learn how to add custom time filters on both Excel and Tableau. Creating a time filter in Excel is a technical task, but with a well thought through idea and a neatly planned execution, everything is possible. This type of filter can then be applied to any report featuring time series data. So, you can transfer this knowledge to all future reports you’re in charge of.

In Tableau, we’ll see various software options for customizing and styling filters. There are numerous possibilities to design and style filters in Tableau, and integrating it into a dashboard is easy and intuitive. Even if you’ve never worked with the software before, you’ll quickly become the master of creating dazzling charts and reports.

Who is this course for

People who want to level up their career with data visualization skills

Anyone who wants to improve their Excel and Tableau skills

Anyone interested in dynamic visualization techniques

People who are looking for a career in business intelligence or analytics

Who this course is for
People interested in enhancing their data viz skillset
Anyone who wants to gain a valuable skill
The course is also ideal for beginners, as it starts from the fundamentals and gradually builds up your skills