create account

Business Intelligence Case Study - The Small Business by theexcelclub

View this thread on steemit.com
· @theexcelclub · (edited)
$3.65
Business Intelligence Case Study - The Small Business
<center>http://theexcelclub.com/wp-content/uploads/2016/09/Powerview.png</center> <br/>In my last post, I gave you a brief explanation of Business Intelligence (<a href="http://theexcelclub.com/what-is-business-intelligence/">if you missed the post you can read it here</a>). 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 multinationals and large organizations.  This Business intelligence case study shows it can help any size company.
<h2>Business Intelligence Case Study.</h2>
<strong>Meet Joe</strong>.

Joe worked for a small family-run organization.  He was a forward-thinking employee that worked in marketing. He wanted an increase in the budget for marketing and to expand the sales department.

Joe needed to prove something to the owners. He knew the potential size of the market and the current market size was far greater than the 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 in 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.

<img src="https://theexcelclub.com/wp-content/uploads/2016/09/marketshare.png" alt="Business Intelligence Case study" width="873" height="455" /><br/>

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 he could identify regions where there was room to capture a larger market share.
<h2>Guess what?</h2>
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  <a href="http://www.zdnet.com/article/case-study-how-one-firm-used-bi-analytics-to-track-staff-performance/">Business Intelligence Case Study</a>

So what’s all this got to do with the Excel User and does it have anything to do with Accountants? Well hell yea.  Check out this next post - <a href="https://theexcelclub.com/bi-for-excel-users-and-accountant/">BI for the Excel user and Accountant</a>

<em>Don’t want to miss out on my next post?  <a href="https://theexcelclub.newzenler.com/f/email-signup">Sign up for my newsletter</a> to get tips and trick on Excel and Business intelligence</em>

<em>Do you know we offer the Best suite of online Excel courses around…<a href="https://theexcelclub.newzenler.com/courses">check them out now</a>…..</em>
<h3><center><strong>Take a FREE course on us!</strong></center></h3>
<a href="https://theexcelclub.newzenler.com/courses/practical-beginner-excel-365" data-elementor-open-lightbox="">
<img src="https://theexcelclub.com/wp-content/uploads/2019/01/beginner-excel.png" sizes="(max-width: 432px) 100vw, 432px" srcset="https://i0.wp.com/theexcelclub.com/wp-content/uploads/2019/01/beginner-excel.png?w=432 432w, https://i0.wp.com/theexcelclub.com/wp-content/uploads/2019/01/beginner-excel.png?resize=259%2C300 259w, https://i0.wp.com/theexcelclub.com/wp-content/uploads/2019/01/beginner-excel.png?resize=410%2C475 410w, https://i0.wp.com/theexcelclub.com/wp-content/uploads/2019/01/beginner-excel.png?resize=100%2C116 100w, https://i0.wp.com/theexcelclub.com/wp-content/uploads/2019/01/beginner-excel.png?resize=275%2C319 275w" alt="FREE beginner excel training" width="432" height="501" /><br/> </a>
<a role="button" href="https://theexcelclub.newzenler.com/courses/practical-beginner-excel-365">
Take FREE course
</a>
<h4></h4>
<h4></h4>
<h4></h4>
<h4><center>SIGN UP FOR OUR NEWSLETTER AND GET EXCEL &amp; POWER BI TIPS TRICKS AND TUTORIAL TO YOUR INBOX</center></h4>
<a role="button" href="https://theexcelclub.newzenler.com/f/email-signup">
SIGN UP NOW
</a>
<h3></h3>
<center>Best Value</center></h3>
<center>Access All Areas – Unlimited Excel and Excel Power Tool Training</center></h4>
<a href="https://theexcelclub.newzenler.com/courses/access-all-areas" data-elementor-open-lightbox="">
<img src="https://theexcelclub.com/wp-content/uploads/2019/09/access-all-areas.png" sizes="(max-width: 438px) 100vw, 438px" srcset="https://i1.wp.com/theexcelclub.com/wp-content/uploads/2019/09/access-all-areas.png?w=438 438w, https://i1.wp.com/theexcelclub.com/wp-content/uploads/2019/09/access-all-areas.png?resize=262%2C300 262w, https://i1.wp.com/theexcelclub.com/wp-content/uploads/2019/09/access-all-areas.png?resize=410%2C470 410w, https://i1.wp.com/theexcelclub.com/wp-content/uploads/2019/09/access-all-areas.png?resize=100%2C115 100w, https://i1.wp.com/theexcelclub.com/wp-content/uploads/2019/09/access-all-areas.png?resize=275%2C315 275w" alt="" width="438" height="502" /><br/> </a> <br /><center><hr/><em>Cross posted from my blog with <a href='https://wordpress.org/plugins/steempress/'>SteemPress</a> : http://theexcelclub.com/business-intelligence-case-study/ </em><hr/></center>          
👍  , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , and 55 others
properties (23)
post_id80,903,264
authortheexcelclub
permlinkbusinessintelligencecasestudy-thesmallbusiness-bng8h1pqz0
categoryexcel
json_metadata{"community":"steempress","app":"steempress","image":["http:\/\/theexcelclub.com\/wp-content\/uploads\/2016\/09\/Powerview.png"],"tags":["excel","stem","palnet","steemleo","tutorials"],"canonical_url":"http:\/\/theexcelclub.com\/business-intelligence-case-study\/"}
created2019-10-15 12:26:54
last_update2019-10-16 09:46:21
depth0
children2
net_rshares14,165,745,569,750
last_payout2019-10-22 12:26:54
cashout_time1969-12-31 23:59:59
total_payout_value1.722 SBD
curator_payout_value1.928 SBD
pending_payout_value0.000 SBD
promoted0.000 SBD
body_length6,046
author_reputation32,525,368,243,130
root_title"Business Intelligence Case Study - The Small Business"
beneficiaries
0.
accountsteempress
weight1,500
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
author_curate_reward""
vote details (119)
@pennsif ·
$0.16
A spreadsheet cliffhanger...  looking forward to find out what happens next.

I wonder if we can use any of this Business Intelligence type approach for marketing Steem...
👍  ,
properties (23)
post_id80,919,532
authorpennsif
permlinkpzfzi0
categoryexcel
json_metadata{"app":"steemit\/0.1"}
created2019-10-16 00:46:48
last_update2019-10-16 00:46:48
depth1
children0
net_rshares863,580,183,107
last_payout2019-10-23 00:46:48
cashout_time1969-12-31 23:59:59
total_payout_value0.081 SBD
curator_payout_value0.081 SBD
pending_payout_value0.000 SBD
promoted0.000 SBD
body_length171
author_reputation419,007,910,578,666
root_title"Business Intelligence Case Study - The Small Business"
beneficiaries[]
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
author_curate_reward""
vote details (2)
@angelak ·
$0.23
huhfe1lmzf
Nice case study.  This is a perfect example of how a small business can use BI.  You just need a little understanding of the business operations and combined with data, Business intelligence can provide a lot of value.  I am looking forward to your follow up article on Business Intelligence for the Excel user and Accountant.
👍  , , ,
properties (23)
post_id80,929,537
authorangelak
permlink1as4t83p9965is9
categoryexcel
json_metadata{"app":"steempress\/2.0"}
created2019-10-16 10:25:18
last_update2019-10-16 10:25:18
depth1
children0
net_rshares1,204,248,668,922
last_payout2019-10-23 10:25:18
cashout_time1969-12-31 23:59:59
total_payout_value0.117 SBD
curator_payout_value0.117 SBD
pending_payout_value0.000 SBD
promoted0.000 SBD
body_length326
author_reputation128,495,787,068
root_title"Business Intelligence Case Study - The Small Business"
beneficiaries
0.
accountsteempress
weight100
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
author_curate_reward""
vote details (4)