Software:
Microsoft Windows Server 2003 Enterprise Edition
Microsoft SQL Server 2000
Microsoft Analysis Services
Technologies:
ASP, XML, Javascript, T-SQL, PL/SQL, MDX, Active X
Hardware:
Compaq Server
4 Intel Pentium III Xeon Processor
3.5 GB Ram
60 GB Hard Disk
Full Story:
In January, 2005, the Chief Sales Officer of this Fortune 100 firm sought help from LiveLogic in building a reporting and analysis dashboard. The information contained on the dashboard included the Key
Performance Indicators (KPI) for all sales efforts for the company worldwide.
LiveLogic and the client went through a series of releases, each with new functionality and expanded
information. The first release was rolled out to 85 users within six weeks. The second release, which
incorporated feedback from Phase 1 users, established a scalable foundation that could support further sales analysis needs for years. Subsequent phases continue to expand the dashboard foundation.
The Global Sales Dashboard provides high level, at-a-glance KPI’s that top management views with updated information every day. For more detailed “power users,” it also provides analysis across many dimensions for drilling down to detail all the way to the level of an individual transaction.
What formerly took hours or days for the Global Sales Reporting organization to create for executives now takes minutes or seconds. They are able to look at the information across many different perspectives (including by date, customer, by service offering and product, by competitor, by channel alliance, by sales rep or sales manager, by geography, down to city or up to global region, and many others). The analysis includes actual and target values as well as evaluative analysis of performance against those targets.
"The reactions we’ve received from other business groups prove the value of the dashboard. First, every group that has worked with Global Sales Operations since we implemented the dashboard has commented enthusiastically on our outputs. Second, everyone that has the
opportunity to experiment with the dashboard is impressed and wants access to it. The common feeling is an overwhelming sense of potential for what we can do and learn by using the dashboard."
- Sales Operations Manager
