Business Applications of Excel: 4

Advanced Dashboards: Power BI Desktop

Whether Excel is a daily part of your business or just occasionally used for a quick spreadsheet project, users often find themselves spending hours trying to answer the question, “I know there’s a way to do this in Excel, but how?” Become a more efficient Excel user and learn the most powerful features that the program has to offer in this one-day, advanced course. Highly interactive and hands-on, you will spend the entire time using Excel while an expert trainer walks you through demonstrations and exercises. Topics Include:

• Power Business Intelligence: Power BI is a business analytics add-on provided by Microsoft. It provides interactive visualizations with self-service business intelligence capabilities, where end users can create reports and dashboards by themselves, without having to depend on any information technology staff or database administrator.


• Heat Maps: A unique dashboard to show, with color, the “hot spots” and “cool spots.” This is a tremendous technique.


• Animated Dashboards: How key indicators and data change over time in an animated representation.
  
• Geo-Spatial Maps: How to represent geographical data with maps and towers.