Enhancing Excel reporting with Winshuttle Studio and the Analytics ...

WUG 2016 Enhancing Excel reporting with Winshuttle Studio and the Analytics Add-on Bob Glitch | Winshuttle

Analytics Getting Started • Build your data file for analysis first Get the data out • The data file can be the result of an existing Winshuttle Query, output from a Winshuttle Transaction BAPI or in fact data from any system.

WINSHUTTLE USER GROUP CONFERENCE | LAS VEGAS 2016

2

Query Overview (Demo)

WINSHUTTLE USER GROUP CONFERENCE | LAS VEGAS 2016

3

Query Overview (Demo)

DEMO Will add recorded demo

WINSHUTTLE USER GROUP CONFERENCE | LAS VEGAS 2016

4

Adding Analytics to the Picture Benefits of adding Analytics to Query • Winshuttle Analytics is 100% Excel-based • Execute queries on-demand or via a schedule • Output as PDF, EPS, HTML, MHTML, XPS, CSV, XLS, TEXT • Auto-generate reports based on selection criteria • Share complete reports with embedded data instantly

WINSHUTTLE USER GROUP CONFERENCE | LAS VEGAS 2016

5

Analytics (Demo)

WINSHUTTLE USER GROUP CONFERENCE | LAS VEGAS 2016

6

Analytics (Demo)

DEMO Will add recorded demo

WINSHUTTLE USER GROUP CONFERENCE | LAS VEGAS 2016

7

Better than regular Excel Presentation level filtered data Turns Excel into a report repository Drill down analysis of filtered data Faster formula calculation Complex distribution opportunities with Broadcast Smaller analysis file size Easier listing and filters

8 WINSHUTTLE USER GROUP CONFERENCE | LAS VEGAS 2016

8

Discuss Analytics

WINSHUTTLE USER GROUP CONFERENCE | LAS VEGAS 2016

9

Analytics Wrap-up

WINSHUTTLE USER GROUP CONFERENCE | LAS VEGAS 2016

10

Analytics Wrap-up

Q&A

WINSHUTTLE USER GROUP CONFERENCE | LAS VEGAS 2016

11