Business Analytics for Trade (SME) Part 2
Hi guys, part 2 is here! If you haven’t read the part 1, Click here.
Our Business Intelligence Tool:
Name: QLIKVIEW
Website: http://prod.qlik.com/us
We also have very good tools like Excel, Power BI, tableau etc.
In this presentation, I’ll be making use of one of the leading BI tools called QLIKVIEW.
Why Qlikview?
It is one of the best and I have used it professionally for a client project.
Leading BI Tool: https://prod.qlik.com/us/resource-library/gartner-magic-quadrant-business-intelligence-bi-platform?ga-link=Gartnermq_HP1_US
What is Qlikview?
Qlikview is a leading Business Discovery Platform. It is very powerful in visually analyzing the relationships between data
Restaurant Business Case Study.
This example will show how Business Intelligence will add value to a restaurant business.
Business Requirement from Management:
1. How can i improve the sales for my restaurant?
2. Which product sells more for my restaurant?
3. Who is my highest sales customer?
4. Where do i spend most for expense?
Checks List:
- Do we have business data? YES
- What data do we need for this business intelligence application?
As a business intelligence analyst, you need to know the answer to the questions
- Which data do I need for this solution? Do I have it ?
Data Categories:
- Sales record by product and customer
- Expense record.
Things to note for analysis:
Qlikview is a new topic on it’s own but i will be explaining two major terms to understand our chart. Dimensions and Measures.
- Dimension − It is a descriptive field in the data set which represents few distinct values. Examples − Month, Year, Product ID etc.
- Measures − It is a numeric field on which some calculations are performed for each distinct value of dimension.
Dimensions and Measures Image
Solution Dashboard Screenshot
Restaurant Analysis
Business Intelligence Analysis Scenarios
Chiffy Analysis for 2018 and 2019
What did we analyse for chiffy?
- We have analysed how much Chiffy spends on furniture expense which is 54,600 and we will compare this to other expense categories to know where they spend more money. This will help Chiffy reduce cost in their expense category that is not a priority.
2. 2018 Analysis for Chiffy.
We can see Chiffy made 833,000 in 2018 revenue and spent 73,500 for expense. We can also see the top customers that spent more. Tony — Olatunji — Babatunde — Phebian in descending order.
We can also see that a lot of customer bought meal type Z.
What can we infer from this?
Better inventory or dinner making decisions. Since we know meal type Z makes most of our revenue we could make more of meal type Z or look for ways to improve the meal serving client experience.
3. Hubmart wants to know
Who is my highest sales customer? Steph
Which product sells more for my restaurant? Meal type A
4. The place revenue analysis by time.
We noticed that total sales made by 9:58Pm for The place sums up to 480,000 and the meal type highest in demand by this time is meal type Z. As a manager I can infer that there is never a downtime in electricity by this time and also the customer that buys by this time is Steph. This analysis shows us our customer buying pattern for meal type Z.
5. The Place analysis for 2018 and 2019
- Who is my highest sales customer? Steph and Tony
- Which product sells more for my restaurant? Meal type z
5. The Place analysis for 2019
- Who is my highest sales customer? Steph and Olatunji
- Which product sells more for my restaurant? Meal type Z
- What can Business intelligence make us infer? We noticed in 2018 and 2019 customers don’t buy meal type K and A we can look for a way to improve this meal type.
From the restaurant examples generally, I can add value to this business by-
1. Making them improve on products customers really don’t buy.
2. Improve on customer service for products customers really love.
3. Identify customer’s buying pattern like Steph that buys at 9:58 pm every time from the same place.
4. Identify top to lower expense category and how expense in low level priority areas can be reduced.
4. Use past financial record to properly advise on how much should be allocated for budget to several expense categories.
I would like to ask my question again.
Would you buy Business Intelligence to add value to your business? YES / NO / NOT SURE
You can reach me via fagboreolatunji@gmail.com
“No man takes knowledge to the grave, knowledge is shared to make the world a better place.” — Fagbore Olanrewaju Olatunji 2019
Reference
A.Wikipedia [A]
B. Forbes Aritcle : https://www.forbes.com/sites/forbesbusinessdevelopmentcouncil/2018/08/07/what-you-need-to-know-about-business-intelligence/#2b5340992ef7
C. Ranjan, 2008
D. http://insights.btoes.com/resources/what-is-business-intelligence-definition-introduction
E. TutorialsPoint.com
