A complete data warehousing and business intelligence solution.
The Challenge
Kennards Hire, a large Australian retailer with over 150 branches and almost 1,000 employees Australia-wide had increased their volumes of data by over 50% in the past 5 years. The retailer struggled with reporting and was unable to draw even the most basic insights from their data. In the past, managers had relied on guesswork and their gut feeling to make critical business decisions, with business data simply unavailable.
To create simple, static monthly reports it took IT professionals between a few hours for ad-hoc reports up to several days for monthly reports.
Management recognised the need for a complete Business Intelligence (BI) solution to meet their needs and complement their existing Enterprise Resource Planning (ERP) system.
“The Microsoft BI solution provides a raft of tangible benefits to our business, but the real benefits are the intangible strategic benefits.”
– Group IT Manager Kennards Hire
The Solution
Antares Solutions proposed a complete data warehousing and BI solution based on the Microsoft technology stack. Using technologies including SQL Server 2008 R2, SharePoint 2010 and Office 2010, Antares proposed a solution that would enable employees, company-wide access to:
- Real-time executive dashboards for management.
Reports updated every 15 minutes available through the intranet. - Sales, inventory and customer reports for all employees- from head office to the shop floor.
- Powerful self-service analytics in a familiar environment.
Summary
A complete data warehousing and Business Intelligence solution based on the Microsoft technology stack. Using technologies including SQL Server 2008 R2, SharePoint 2010 and Office 2010.
Technology
- Business Intelligence
- SharePoint 2010
- Data Warehousing
- SQL Server
