Business intelligence tools case study

This process was manually time intensive and often prone to human error due to miscalculations and legibility of times recorded.

Business intelligence use case examples

In addition it provided a means of leveraging the organisation's existing investment in licences for products including Microsoft SQL Server, Windows Server and desktop applications. These business intelligence case studies are provided in PDF format. Reports implemented an interactive worldmap with drill down capabilities which allowed sales for different continents and countries to be easily analysed. For example, is it a prudent investment to construct a gym at another club location. The reports are always there on the web with live information. Problems Typically, licensed clubs rely on a wide range of specialised software applications covering everything from gaming to restaurant management, human resources considerations through to finance. Following the implementation of several bar code shop floor data capture terminals, B. Given the competitive nature of the club industry, Byrne is loathe to give too much away about the mechanics of the campaigns prior to launch, but he mentions activities such as member profiling and marketing activities utilising automatic alerts noting changed behavior. Historically gaming information was manually downloaded and collated by administration staff, before being put into spreadsheets and distributed to management. With the new reporting system however, staff time has been freed up and the data has moved to the web environment where it can be accessed and analysed instantly. The result of this was greater commercial insight for the sales team and increased sales to existing customers. When we shift from blanket marketing to target marketing of our members," he says. The process was prone to delays and periodic inaccuracies. One of the difficulties they were having was in understanding the order profile for different countries and regions throughout the world. This solution provided a return on investment within just 5 months.

Problems Typically, licensed clubs rely on a wide range of specialised software applications covering everything from gaming to restaurant management, human resources considerations through to finance. Monthly reporting took weeks while ad hoc reporting usually required assistance from the owner of whichever particular system was involved.

business intelligence strategy case study

The net result was that jobs were often under quoted due to materials and labour cost overruns. Its aim is to encourage, foster and promote sports, games and recreation activities, and to assist in the provision of playing, training, coaching and teaching facilities.

The data warehouse was readied and populated with data from Mingara's disparate systems.

business intelligence solutions case study

Microsoft Excel access was added for those users who required more than standard reports or who preferred to review their information by spreadsheet.

Mingara Management Accountant, John Byrne, explains, "We couldn't get the information we needed and we weren't using any of the data to intelligently improve our business.

Business intelligence case study ppt

Across the organisation, access to data is easing day-to-day management. Resources have been freed up and redeployed, and the new environment is changing the way people work. The problem is that few of them "talk" to one another. Most importantly, the relationship between the two organisations remains as close as ever. The information derived for each area remains locked in its own application silo. BI will also be used to help identify the spin-off trade from concerts on club premises. These business intelligence case studies are provided in PDF format. This additional resource also allowed the finance team to spend time working on other value adding work for the business. For example, is it a prudent investment to construct a gym at another club location. Individually, these applications hold a great deal of data about every aspect of the business.

Almost every area of Mingara is discovering new information and new ways of achieving efficiencies. It's given us the right information to make the right decision at the right time.

One of the difficulties they were having was in understanding the order profile for different countries and regions throughout the world. That's what the last three years has been about and now we are positioned for the future.

business intelligence case study pdf
Rated 10/10 based on 71 review
Download
Microsoft Business Intelligence Case Study