Challenge:
Upgrade and consolidate reporting and analysis, pulling from JD Edwards sub-system and two other
different sources
Provide up-to-date analytical information available at the touch of a button
Wean off of IT dependency for every report
Solution:
SQL Server 2000
SQL Server Analysis Services
SQL Server Data Transformation Services
ProClarity Analytic Server and Web Client
Results:
Employees have more time to focus on marketing and selling objectives rather than preoccupy their
time with administrative work
Management has more complete and accurate analysis, leading to better business decisions
Marketing can create better targeted campaigns, leading to more customers and larger profits
Users have the ability to view the data however and wherever they prefer
Full Story:
In June of 2005, a Dallas/Fort Worth area pharmaceutical distributor consulted with LiveLogic to provide reporting and analysis. This client is a major player in the pharmaceutical industry with over 60 distribution locations. Despite their success, they realized the potential to grow even larger with a more accurate reporting and analysis system. The client hired LiveLogic to overhaul their previously unorganized system.
This client faced a problem common to many companies: they could not analyze sales by customer, product, or even time. What drove profits? Why did Customer A buy Products C, D, and E at Time X? All of these questions were answered with business intelligence applications.
LiveLogic consultants created a system in which users in Sales and Marketing as well as top executives across the company have a convenient and interactive set of views to provide them up-to-date analytical information about their performance. The sales analysis data ties to the JD Edwards general ledger and the views support the functionality to drill back to the level of individual invoice details.
Within six weeks at a services cost of less than $75,000, this client rolled out its first ever BI initiative. With a better understanding of their customers and products, this client is better equipped to increase profits in the future. Lending to the huge success of the project, the client is currently embarking on projects to extend the analysis to include more financial information as well as operational analysis.
