In my last post I gave you a brief explanation of Business Intelligence (if you missed the post you can read it here). But what has this got to do with the small business or the employee? I can tell you that Business Intelligence is not just for the multi nationals and large organisations. This Business intelligence case study shows it can help any size company.
Business Intelligence Case Study.
Joe worked for a small family run organisation. He was a forward thinking employee that worked in marketing. He wanted an increase in budget for marketing and to expand the sale department.
Joe needed to prove something to the owners. He knew potential size of the market and the current market size was far greater than company’s market share. If he could prove this, he would be able to secure this investment from the owners.
Joe approached Lisa, the sales manager looking for some information. Lisa was able to provide a Text file that contained the customer count for each region for all sales made online. She was also able to provide an Excel file which she kept herself. This file had many worksheets. One worksheet for each sales rep. Each worksheet was further broken down by region and the total customer count for each month. The data was in a bit of a mess, but it was all that Joe could get. Lisa told him it would take a few hours to sort the data in a meaning full way for his purpose.
Next Joe went online. With a little research, Joe found an open data sources that could provide insights to the potential size of the market and the actual market size. This data source contained a lot of irrelevant information, and would need some work just to extract what he needed.
All Joe needed to do was sort this data and get it ready for his presentation. Lucky enough Joe had access to an easy to use Business Intelligence System. Within an hour, Joe established the potential market size, current market size and the actual company’s market share. Have a look at the chart he produced for his presentation.
Not only was Joe able to establish the Potential Market Size, the Actual market size, the company’s market share, and the % market share. He was also able to do this by region, so could identify regions where there was room to capture a larger market share.
Joe got the increase in budget that he required, and the following year the company enjoyed 56% growth. Joe got a financial bonus that he never expected.
Read another interesting Business Intelligence Case Study
So what’s all this got to do with the Excel User and does it have anything to do with Accountants? Well hell yea, but you will have to wait and find out in my next post.
Don’t want to miss out on my next post? Sign up for my newsletter to get load of Tip and trick on Excel and Business intelligence
Do you know we offer the Best suite of online Excel courses around…check them out now…..