Dashboards are a collection of visual elements that represent reporting on current business data. Just like you look at the dashboard of your car to determine whether you need fuel or oil, a dashboard can help inform key decisions in your everyday business processes. One way to create a reporting tool like this is to use Microsoft Excel. In this session, we’ll learn how to:Create and access multiple data sets to assemble the underlying data sourceCreate multiple pivot tables and charts as the building blocks of the dashboardAssemble the components into a visually effective reporting toolAdd interactivity to allow users to see precisely the information in which they are interestedWhile there are very sophisticated dashboarding tools available, if your needs are simple, Excel may be the best tool to use.Areas CoveredAccessing multiple data sourcesConnecting data sources using PowerQueryPivoting multiple data sourcesCreating charts and graphsTips and tricks to get a polished and professional look to your dashboardBest practices for keeping data up to date and accurateCourse Level - Intermediate to AdvancedWho Should AttendData analyst, compliance analyst, production analyst, managers, supervisors, human resource professionals, accountant, controller, financial analyst, administrative professionalsWhy Should You AttendIf you’ve struggled to use complicated dashboarding tools when all you want is a simple, interactive report of key performance indicators, Excel may offer all the power you need to generate an easy to use easy-to-manage dashboard solution. You could page through screens and screens of data or page after page of the report and still not get the insights you need to derive from your business data. And, by the time you get done correlating and aggregating data the long way, the information has changed and you have to start all over. So, let’s begin with a tool you already know how to use and show you how to deliver what you need. Not only will you learn how to build a dashboard, but manage the underlying data in such a way as to always give you an up-to-the-moment snapshot of the most important decision factors in your world.