Business Intelligence Blog from arcplan
21Feb/122

arcplan Spotlight: Ad-Hoc Reporting in Your Browser

by

We just created a quick video on arcplan Spotlight, our newest solution for ad-hoc reporting, which I want to share with our readers. Our customers are a mix between those who access static reports and dashboards every day and those who are ad-hoc driven. For the latter, we developed arcplan Spotlight, which enables powerful on-the-fly analysis in any web browser. For the former, arcplan Spotlight is an appropriate next step as user needs evolve since it’s simple enough for non-power-users who want to explore their data without complex BI tools.

arcplan Spotlight goes beyond what most other BI platforms offer, which is simple export to Excel, where the user has to wait for data, write formulas, and then do it all again next week when encountering the same question. arcplan Spotlight allows users to save queries (privately or publicly), export to Excel with a live connection to the data source, export to PDF for sharing query results, customize the look of your query, and undo/redo your last action.

Best of all, it’s free with installations of arcplan Enterprise 7.1, arcplan Edge 2.7.1, and arcplan Engage 1.1 and above.

Have questions? Leave us a comment!

8Nov/110

BI + Excel: A Match Made in Power-User Heaven

by

What’s the most popular reporting and planning tool out there? As much as I’d like the answer to be “arcplan” – it’s not. Even in 2011, it’s “Excel.” Excel has been around for 25 years and believe it or not, it’s still the most often used technology in 60% of the organizations surveyed by Ventana Research in August 2011.

There are so many reasons analysts and planners love Excel: it’s easy to use, adjusting reports takes seconds, it’s the perfect tool for local ad-hoc analysis, and it has an extensive formula and function library to address complex calculations. On the other hand, there are times when Excel falls short. After the manual process of collecting, consolidating and reconciling data, Excel leaves little to no time for actual analysis. And worst of all, you may find that your data is outdated or fraught with errors, which compromises your ability to make business-critical decisions. Unfortunately, Excel also lacks data security, which is a paramount concern for IT professionals.

Truly, I’m not bashing Excel here. I’m a data analyst myself and I help our clients develop Excel-like BI applications, so I understand that Excel has its benefits. Power users are going to want to use Excel, at least for the foreseeable future. So consider this how you can reconcile the use of Excel at your organization. The answer may be as simple as your BI system’s Excel add-in!

Continue reading this post >>