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.