All businesses store critical information in multiple systems but capturing true business insight requires connecting these islands of information into a consolidated view. Until now this capability has been the preserve of large organizations with deep pockets.
Today, business intelligence software company Antivia revealed that its new software DecisionPoint™ For Excel combines perfectly with Microsoft Power Query for Excel. Together, the two products provide organizations of all sizes with an affordable way to create a big picture view of their business to support data driven decision-making.
Antivia's CEO, Mark Hudson, said: “Most businesses today want to make sense of all the data they have, but the reality is that important business data is everywhere - in the cloud, in corporate databased and stored locally. To be able to make effective decisions we need a view that cuts across all of these platforms."
Hudson continued: "The beauty of Power Query is that it allows you to quickly combine data from multiple sources and shape it into a form that's ready for reporting. And in a matter of minutes, DecisionPoint™ For Excel allows people familiar with Excel or PowerPoint to easily and affordably transform this output into a stunning interactive dashboard that can be shared with anyone through a web browser, on a tablet or on a smart phone."
Anyone who has ever tried to bring together data into Excel and get it into a consistent format, for example in order to report across different social media channels, or who has tried to augment data in Excel with data from other sources knows that you often end up needing a black belt in Excel formula jujitsu to knock your data into shape.
A video produced by Antivia shows how the combination of Power Query for Excel and DecisionPoint™ For Excel dramatically simplifies this process and helps businesses move from raw data to finished dashboard and business insight in a matter of minutes.
Microsoft's Power Query for Excel is an add-in for Microsoft Excel that provides seamless data transformation and enrichment capabilities, enabling Excel users to combine data from multiple disparate data sources and shape it for further analysis and reporting.
DecisionPoint™ For Excel is a rapid dashboard creation tool that lets non-programmers turn their Excel data into beautiful dashboards that can be shared with anyone on a web browser, tablet or smart phone.
The Power Query and DecisionPoint For Excel video can be viewed here and a trial of DecisionPoint for Excel may be downloaded for free at antivia.com/decisionpoint-excel.