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