• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Quality Indicators

Hdabbas

New Member
Greetings,

My name is Dabbas and I am from Atlanta GA.
Is it possible to create a dashboard based on the sample data file attached? Id so, what type of dashboard is best for this type of data?
Regards
 

Attachments

  • DB Sample.xlsx
    10.5 KB · Views: 4
Please disregard my original post. Let me start all over since I did not explain that overall picture.

My name is Dabbas and I am from Atlanta GA.

Is it possible to create a dashboard based on the sample data file attached? If so, what type of dashboard is best for this type of data?
I work with Healthcare vendors. Each vendor submits a quarterly report for every market they operate in. The report is the same for all vendors.
I am new to this and not sure where to start.

Regards
 

Attachments

  • DB Sample.xlsx
    14.8 KB · Views: 1
Hi ,

My first suggestion is that you change the data layout so that the data is in the columns C through J in chronological order , so that summarising the YTD totals for the current and previous years is simpler than with the present layout.

The order would thus be :

Column C : 1st QTR previous year

Column D : 2nd QTR previous year

Column E : 3rd QTR previous year

Column F : 4th QTR previous year

Column G : 1st QTR current year

and so on.

Narayan
 
Thank you. Data looks much better now. What is the best approach to visualize the data?

Regards
 

Attachments

  • DB Sample.xlsx
    20.9 KB · Views: 10
Hi ,

Not knowing anything about your business , I cannot really advise you the best approach to visualize your data. All I can give is an opinion.

1. You have around 105 items of data , which will have quantifiable information , that you will be collecting over time.

You need to decide which of these 105 items are very significant / crucial to give you or your management an idea of how your business is performing. Thus , an organization , in addition to collecting sales information , will also be collecting employee attendance information. However , the latter will be of interest only to the HR manager , and not to the Board of Directors.

2. Once you have selected at most 20 items of data , which are significant , you need to categorize these into categories which you believe are either related , or which will make more sense when they are related.

Thus , seasonal variations may be useful when you are looking at goods such as air-conditioners , whose sale is generally up during summer ; however , trying to relate sale of pencils to the seasons may not be a sensible exercise.

3. Thereafter , we can get down to how you wish to visualize the data ; do you wish to show trends , or do you wish to show significances e.g. do you want to show how sales have increased over the past one year or do you wish to show what portion of your sales is to the different regions ? Based on what you want to show , we can decide on the best type of chart for that representation.

See the following links for more detailed information :

http://extremepresentation.com/tools/

http://labs.juiceanalytics.com/chartchooser/index.html

http://www.storytellingwithdata.com/2013/04/chart-chooser.html

4. The actual implementation of the various types of charts is explained in Jon Peltier's several blog posts at :

http://peltiertech.com/jons-excel-and-chart-pages/

When you are done with all the reading , and have a difficulty in the implementation , please post back here with your specific problem / questions.

Narayan
 
Back
Top