Professional Dashboards in Excel and Tableau
Professional Dashboards in Excel and Tableau, available at $54.99, has an average rating of 4.35, with 36 lectures, based on 73 reviews, and has 476 subscribers.
You will learn about 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 This course is ideal for individuals who are People interested in enhancing their data viz skillset or Anyone who wants to gain a valuable skill or The course is also ideal for beginners, as it starts from the fundamentals and gradually builds up your skills It is particularly useful for People interested in enhancing their data viz skillset or Anyone who wants to gain a valuable skill or The course is also ideal for beginners, as it starts from the fundamentals and gradually builds up your skills.
Enroll now: Professional Dashboards in Excel and Tableau
Summary
Title: Professional Dashboards in Excel and Tableau
Price: $54.99
Average Rating: 4.35
Number of Lectures: 36
Number of Published Lectures: 36
Number of Curriculum Items: 36
Number of Published Curriculum Objects: 36
Original Price: $199.99
Quality Status: approved
Status: Live
What You Will 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
Who Should Attend
- 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
Target Audiences
- 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
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 Tableauwill 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
Course Curriculum
Chapter 1: Introduction
Lecture 1: What Does the Course Cover
Lecture 2: Why Learn Data Visualization
Lecture 3: How to Choose the Right Visualization – Popular Approaches and Frameworks
Lecture 4: Choosing the Colors for Your Visualization
Lecture 5: Choosing the Right Data Visualization Color Palette
Chapter 2: Dashboard in Excel
Lecture 1: Dashboard in Excel – Introduction to the Task
Lecture 2: Dashboard in Excel – Getting to Know the Data Set
Lecture 3: Dashboard in Excel – Creating the Design for the Excel Dashboard
Lecture 4: Dashboard in Excel – How to Create a Drop-down List in Excel
Lecture 5: Dashboard in Excel –How to Use the Developer Tab and Make Radio Buttons in Excel
Lecture 6: Dashboard in Excel – Including Additional Columns to the Excel Spreadsheet
Lecture 7: Dashboard in Excel – Introduction to Pivot Tables
Lecture 8: Dashboard in Excel – Tables – Creating Time Filter References in Excel
Lecture 9: Dashboard in Excel – Tables – Adding Month, Year and Selected Dates Fields in Ex
Lecture 10: Dashboard in Excel – Tables – How to calculate Net Sales
Lecture 11: Dashboard in Excel – Tables – How to Calculate Gross Profit Margins and Distribu
Lecture 12: Dashboard in Excel – Tables – Volume by Size
Lecture 13: Dashboard in Excel – Tables – Volume by Client Type – Homework
Lecture 14: Dashboard in Excel – Charts – Making a Bar and Line Combo Graph
Lecture 15: Dashboard in Excel – Charts – Making a Clustered Bar Graph I
Lecture 16: Dashboard in Excel – Charts – Making Clustered Bar Graph II
Lecture 17: Dashboard in Excel – Adding KPIs and a Slicer to the Dashboard
Lecture 18: Dashboard in Excel – Adding a Custom Design to the Dashboard
Lecture 19: Dashboard in Excel – Customizing the Appearance of the Slicer
Lecture 20: Dashboard in Excel – Interpretation
Chapter 3: Dashboard in Tableau
Lecture 1: Dashboard in Tableau – Introduction to the Task
Lecture 2: Dashboard in Tableau – Examining the Data and Preparing the Sheets for the Table
Lecture 3: Dashboard in Tableau – Creating a Bar and Line Combo Graph
Lecture 4: Dashboard in Tableau – Horizontal Bars Graph I
Lecture 5: Dashboard in Tableau – Horizontal Bars Graph II
Lecture 6: Dashboard in Tableau – Introducing KPIs to the Tableau Dashboard
Lecture 7: Dashboard in Tableau – How to make a Dashboard in Tableau and Add a Brand Filter
Lecture 8: Dashboard in Tableau – How to incorporate a Date Filter into the Dashboard
Lecture 9: Dashboard in Tableau – Introducing a Custom Design to the Tableau Dashboard
Lecture 10: Dashboard in Tableau – How to Interpret the Dashboard
Lecture 11: Completing 100%
Instructors
-
365 Careers
Creating opportunities for Data Science and Finance students
Rating Distribution
- 1 stars: 3 votes
- 2 stars: 1 votes
- 3 stars: 7 votes
- 4 stars: 29 votes
- 5 stars: 33 votes
Frequently Asked Questions
How long do I have access to the course materials?
You can view and review the lecture materials indefinitely, like an on-demand channel.
Can I take my courses with me wherever I go?
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!
You may also like
- Top 10 Language Learning Courses to Learn in November 2024
- Top 10 Video Editing Courses to Learn in November 2024
- Top 10 Music Production Courses to Learn in November 2024
- Top 10 Animation Courses to Learn in November 2024
- Top 10 Digital Illustration Courses to Learn in November 2024
- Top 10 Renewable Energy Courses to Learn in November 2024
- Top 10 Sustainable Living Courses to Learn in November 2024
- Top 10 Ethical AI Courses to Learn in November 2024
- Top 10 Cybersecurity Fundamentals Courses to Learn in November 2024
- Top 10 Smart Home Technology Courses to Learn in November 2024
- Top 10 Holistic Health Courses to Learn in November 2024
- Top 10 Nutrition And Diet Planning Courses to Learn in November 2024
- Top 10 Yoga Instruction Courses to Learn in November 2024
- Top 10 Stress Management Courses to Learn in November 2024
- Top 10 Mindfulness Meditation Courses to Learn in November 2024
- Top 10 Life Coaching Courses to Learn in November 2024
- Top 10 Career Development Courses to Learn in November 2024
- Top 10 Relationship Building Courses to Learn in November 2024
- Top 10 Parenting Skills Courses to Learn in November 2024
- Top 10 Home Improvement Courses to Learn in November 2024