The amount of data being generated and collected today is staggering—some organizations single-handedly collect petabytes of data within a day. Many organizations are challenged to process and present data in new meaningful ways. Wadeware has taken on this challenge and developed the Dashboard Generator, an automation tool that takes advantage of existing data, processes it, and produces output in highly useable and graphically pleasing formats.
How the Tool Works
The Dashboard Generator collects existing data whether in an Excel workbook or internal database, converts it to XML (Extensible Markup Language—a standard protocol for encoding documents), and then generates customizable PowerPoint presentation or Word document dashboards. You can tailor the Dashboard Generator based on the nature of each individual data specification.
Because of the highly configurable nature of this automation tool, data changes are a simple matter of updating an Excel workbook or database then running the generation process. Layout and design changes for the generated Word document or PowerPoint presentation can easily be accomplished by modifying the Generator template and rerunning the tool.
Functions
The Dashboard Generator provides actionable intelligence to perform the following functions:
- Compute totals and averages
- Customize charts
- Generate marketing materials
- Sort data
- Identify trends
For more information about how your organization can take advantage of the Database Generator, contact us.
A Success Story
One Wadeware client was previously spending more than 40 hours creating more than 100 documents manually every six months to produce a biannual report. This effort entailed finding and replacing text, as well as editing and sorting charts. Mistakes were difficult to locate, and if any data or design changes were made, many more hours were consumed editing each of the documents for the report.
To help this client, Wadeware collected the targeted data from three different databases and then combined it into a location. They created a tool to export the data for use in a Word document and a PowerPoint template, either of which can be used to produce the files in these formats programmatically. With the Dashboard Generator, it now takes the client just an hour to collect all of the required information from the original source documents to produce the report.
