Learn to create interactive dashboards in Excel 2013, transforming your organization's data into visual insights that empower decision-making and enhance user experience.
Excel 2013 Dashboard Design teaches you how to create captivating dashboards from your organization’s data. You’ll learn techniques to make your data interactive and engaging, making you a go-to person for decision-makers. It’s all about smart planning, data gathering, and clever visualization.
Create stunning and fully interactive data visualizations in Excel 2013
Excel 2013 Dashboard Design will show you how to turn your organization’s data into a powerful and interactive dashboard. By learning these easy-to-implement, advanced techniques, you can impress and empower the decision-makers in your organization, making you an irreplaceable asset.
Excel 2013 Dashboard Design begins by creating a vision for the dashboard with the help of stakeholders, and then moves on to gathering the data and building each element of the dashboard. The course ends with comparing distribution strategies appropriate for every size and type of organization.
The first section, Outputs and Inputs, covers the strategic aspects of planning your finished product and bringing in all of the necessary data from your database or Excel workbook. We then explore PowerPivot, a powerful bridge between your raw data and Excel. PivotTables will help us slice our data in a flexible manner, and Charts give us at-a-glance comprehension of important metrics and trends. Stylizing and Interactivity enhance the user experience and present the information in a manageable format. Publication can be problematic without proper planning, but we’ll cover the most effective ways to distribute your dashboard to any type or size of audience.
Excel 2013 Dashboard Design will guide you through your entire project, start to finish, covering every part of the process in depth. Since you’ll not only learn how to do each task, but also why it would be beneficial for you, you’ll be able to easily translate your learning into your own dashboard design project.
Tony Kau is a Tableau Desktop 8 Qualified Associate, and he is putting its power to use in his role as a reporting analyst for a Fortune 500 company. His analytical background spans a decade, during which he has used a variety of business intelligence software, though none were better than Tableau. His passion is efficiently leveraging data to inform strategic business decisions.
He holds a degree in Business Administration from the University of Oregon, and his background includes web design, programming, and financial analysis.
In this course, every step is demonstrated on-screen and explained practically, so you can effectively apply the techniques to your own projects. Learning the “why” behind each task is the key to being able to implement what you learn, and this is emphasized with every stride along the way.
5 Lectures
5 Lectures
5 Lectures
5 Lectures
5 Lectures
5 Lectures
Packt are an established, trusted, and innovative global technical learning publisher, founded in Birmingham, UK with over eighteen years experience delivering rich premium content from ground-breaking authors and lecturers on a wide range of emerging and established technologies for professional development.Packt’s purpose is to help technology professionals advance their knowledge and support the growth of new technologies by publishing vital...
I absolutely loved the content and flow of the course. Everything in the course was perfect for my needs and I appreciate the examples used to demonstrate the skills covered.
I would have loved to have more exercises throughout the course after each section to apply the learning.
Tony would benefit from a voice coach to help make his voice more engaging. He spoke clearly and explained everything in appropriate detail. At times, however, I found myself getting distracted because his voice seemed to be bored with the material. Yet he could be an amazing instructor with a bit of coaching.
Thanks, Tony!!! Keep up the great work. Hope to see more from you. :-)
Really worth it
There is an obvious problem when you're advised to Protect the worksheets - it renders the dashboard un-useable! However, this is glossed over and when I reached out for support - I'm ignored. I've only received an update when I've contacted them. I'm still waiting after 3 weeks for them to provide a solution. This is unacceptable and terrible support!
Decent course.
Clear and concise - nice!
Course was well organized, The practice example was excellent. Loved the tip on power view. The course provided a good foundation into creating dashboards. I will be referring back to the lectures as I try to recreate the example. Thank you Tony Kau
It started out overwhelming, but after watching some videos several times and not in the order given, I finally appreciated the wealth of knowledge and seamless presentation!
Straight to the point showcase example on how to build up an Excel Dashboard using data from AdventureWorks sample Database. I particulary like how the teacher shows what he is doing at a natural rythm.
Very well explained.
Your email address will not be published. Required fields are marked *
Roberto H.
Muy buena la explicaciĂłn, detallada y concisa.
Vamos muy bien!
Gracias por este aporte!