We will begin with some dashboard design guidelines, such as understanding your audience and identifying necessary metrics. Then, we will work through creating key performance indicators (KPIs) for the dashboards. You will learn how you can add charts and eye-catching visuals, in order to make your dashboards easily understood. This course focuses on using standard Excel features to create visuals. Although we will introduce new tools like Power BI Desktop, this course is NOT about using Power BI to create visuals.
Learning Objectives:
Use dashboards to make strategic decisions
Create KPI dashboards that graphically represent your data
Use Excel tools to easily create meaningful KPI dashboards
Speakers
Bryan Smith
Bryan serves as a trusted adviser to CPAs in public accounting, as well as business and industry, on all aspects of information technology. Bryan’s expertise includes in-depth knowledge of paperless work flow solutions, the impact of technology on internal controls, strategic IT infrastructure design and information security best practices. As a nationally recognized author and presenter on information technology issues impacting CPAs, Bryan is passionate about the opportunities for CPAs to benefit from safe and secure computing.