Re: EXcel Dashboards Graphs

[onncheng07]

I'm from F&B (Restaurant) line and need to prepare some reports for the management. I'm looking for reports such as Excel Dashboards

1) total monthly sales analysis

2) items food summary, top 10 items sales analysis

3) suppliers summary

and etc.

Do you have any templates related or how can i start to build up the dashboards? I'm running out of time to prepare the reports.

TQ

 

[Faseeh]

Hi onncheng07,


Welcome to the forums, If you could some sample data or sample file, the dashboard can be built for you. Please upload sample file that every one and donwload and share its link on this thread.


Regards,

Faseeh

 

[onncheng07]

Hi Faseeh,


Do you have any sample file to share?


TQ

 

[Faseeh]

Hi onncheng07,


You can find number of dashboards here on the forum, but unfortunately i have never made one for restaurant, i will need at-least some data sample.


Faseeh

 

[onncheng07]

Hi Faseeh,


I would like to work out a chart to compare the sales before and after changed new menu.

The new menu started on 03/02/13.


Example:Feb 2013


1) 01/02/13 -$1000

2) 02/02/13 -S1220

3) 03/02/13 -$1300

4) 04/02/13 -$1900

5) 05/02/13 -$2000


Thanks

onncheng

 

[Faseeh]

Hi onncheng07,


You can simply create a line chart!! BTW if you Google for dashboard for resturents,you will find many exmaples of how dashboard for resturent should look like:


http://www.google.com.pk/search?q=executive+dashboard+for+restaurants&hl=en&tbm=isch&tbo=u&source=univ&sa=X&ei=ectEUeCvDoT4sgbFqoCYDQ&sqi=2&ved=0CDMQsAQ&biw=1366&bih=667


Regards,

 

[guna_sekar87]

hI FASEEH,


iF U DONT MIND,,CAN U PLEASE GIVE ME UR EMAIL ID ,,,,


OR SENT A MESSGAE TO MY EMAIL ID GUNA_SEKAR87@YAHOO.CO.IN

 

[Faseeh]

Hi guna_sekar87,


You can email at faseeh10@hotmail.com


Composing a post in upper case means you are shouting, so please avoid this


Faseeh