18 Sep 2018
9:40 am - 10:30 am


BizInsight 5 Advanced: Dynamic Reporting with BizInsight

BizInsight 5 Advanced takes you to the next level of reporting with BizInsight tools. Save time with BizProperty, make drilldowns dynamic and preserve Analysis Sets. As a bonus, we’ll demonstrate the benefits of running BizInsight 5 side-by-side with the new BizInsight 7. In this session, you will learn how to apply BizInsight 5 best practices and tips to optimize your reports.

BizInsight 7 Advanced: Report Writing with Connected and External Data

The BizInsight 7 Advanced session demonstrates how you can leverage your existing connected ERP Data with other imported external data. Enhance the way you manage your reporting needs with BizInsight 7 and take advantage of the data management and optimization tools to maximize real-time reports. In this session, we will demonstrate how to incorporate imported data from external sources and fully utilize the BizInsight Query editor and the Navigation Pane to preserve frequently used tables and functions.

Charting & Data Visualizations in Excel

Learn how to create perfect charts in one keystroke. Take a tour of the data visualization tools such as Data Bars, Color Scales, and Icon sets. Create tiny, cell-sized charts with Sparklines.

Introduction to the Excel Data Model

The Excel Data Model is an in-memory, multi-dimensional (OLAP) data engine available in all versions of Excel 2013 and 2016. With the Data Model, users can 1) relate multiple Excel tables, 2) build PivotTables on multiple Excel tables, and 3) analyze PivotTable reports using Quick Explore, which allows users to drill up, down, and around in reports. This session will provide the knowledge and skill necessary to take full advantage of the Excel Data Model.