Wednesday, December 16, 2015

Business Intelligence - real time example

Did anyone ever think of applying business intelligence techniques for a dosa shop?

if so we are like minded.

One of the easiest things human can do is Imagination.

lets assume a Dosa Corner guy, a friend of mine, has 56 Dosa shops in Bangalore.

he'd like to sustain and withstand in Dosa Business at least in Bangalore. of course he has a vision statement to expand business world wide.

he came to me and asked for a BI solution for his wish.

Here is all started with Dosa intelligence.

I convinced him that, with our tools and capabilities we can help him in improving his business a way better.

since I design the transaction application for my friend, here are very simple database overview of his shop transactional DB.


-->
Table Fields Possible Data
Table Fields Possible Data
Item

Shop
Item_ID 1,2,3...
Shop_ID 1,2,3...
Item_Name Idly, Dosa, Vada, Chapati..etc
Shop_Location Madiwala, Indra Nagar, Majestic
Item_Description Idly, Dosa, Vada, Chapati..etc
Address
Item_Price 10, 20, 20, 25





Purchase



Purchase_ID 1,2,3...
Sales

Description Groceries, Vegetables, Transport Charges...
Item_ID 1, 2,3


Quantity 10, 15,1,2


Amount 10,30,3
User
User_ID OO7
User_ID OO1, OO7
Shop_ID 1,2,3...
PIN asdf, asdf
TimeStamp 04/12/15 03:08
Role Admin, Cashier





Expenses



Expense_ID 1,2,3...


Purchase_ID 1,2,3...


Amount 1000,3000,250


User_ID OO7


Shop_ID 1, 2,3


TimeStamp 04/12/15 03:08








above few tables would definitely give a superficial view of what kind of data we are dealing with these dosa shops on daily basis.

Sum(Amount) from sales - Sum(Amount) from Expenses is his profit.

now, we have to apply all our data warehousing business Intelligence logic to help my friend in improving his business.

I'm going to create a data warehouse and a data mart for this application.
with prediction techniques, we will help him to make proper decisions.

watch this space for more., whenever i get time i will spend writing for it..
cheers.




No comments:

Post a Comment