KPI Dashboards: How To Go From Pivot Tables to Excel Interactive, BI Dashboards

Presented by Mike Thomas

This training focuses on what you need to know to create an interactive professional-looking dashboard using Excel. No matter what business you are in, a dashboard is a critical tool in your communication armory and as with any communication tool, a presentation is everything. Although there are many tools that can be used to create a dashboard, Excel is commonly used due to its power, its flexibility, and the fact that most people have it installed on their computer.

In this training session, you'll learn how to create a stunning, interactive professional-looking dashboard using Excel. This training will provide you with a solid foundation that you can use to build your own dashboards and reports.

The 5 Best Ways To Approach KPI Development And Trending

Presented by Dr. Ben Locwin

By properly defining business needs, internal processes, and performance outcomes, your organization can benefit from much more scientific management of resources and better decision-making. Unfortunately, many companies purvey totally useless, spurious, and erroneous KPIs to drive internal business decision-making. The reason why you don’t hear about this more often in business intelligence publications is that corporations don’t collect data on their own internal flaws with designing KPIs and how they perform (actual) versus what they expected. This would drive their shareholders mad! Though in actual fact, shareholders would love to know this information – it would make their investment decisions that much more accurate and timely.

Key Performance Indicators (KPIs) are used in every major company across the world that has achieved any level of success, and with good reason – You can’t know where to invest next to improve the future if you don’t have proper measures of where you are ‘now’!. In this course, you will hear from industry leader Dr. Locwin discuss the best methodologies to employ in initial KPI development, as well as practical approaches and tools for monitoring KPIs for adverse trends.

Mike Thomas has worked in the IT training business since 1989. He is a subject matter expert in a range of technologies including Microsoft Office and Apple Mac. In 2012 Mike founded theexceltrainer.co.uk where he has produced nearly 200 written and video-based Excel tutorials. He has recorded several Excel training courses for pluralsight.com and in his career delivered hundreds of courses and webinars on a wide variety of technology-related topics. Mike is a Fellow of The Learning and Performance Institute and has worked with and for a large number of global and UK-based companies and organizations across a diverse range of sectors. In addition to training, he also designs and develops Microsoft Office-based solutions that automate key business tasks and processes.

Dr. Ben Locwin has been an executive in the pharmaceutical industry and the healthcare industry, playing a key role in the development and implementation of Regulatory and Quality guidance for over 20 years. In this time, he has also consulted for many of the Top 10 pharma companies, as well as having been involved in several successful biotech and pharma startups, who were looking to successfully achieve market approval for their new therapeutic products. He has also taught programs on Evidence-Based Medicine to hospital systems and clinical centers in the US and Europe. Dr. Locwin has been featured in top media such as The Wall Street Journal, Forbes, USA Today, The Associated Press, and many others.