Best combination of Multiple Dashboards which covers all the specified sectors

Created by: kbryant414

 

Finance Dashboard:-It is used to present the fiscal performance. This dashboard is used to show how much revenue generated in the year, quick ratio, and short term assets. The idea behind the dashboard of any executive officers isthat just by one "look" you can get information about the need to drive the business forward.

Basically financial dashboard provide the information about the company’s performance. Through this dashboard we can analyze the company’s performance and growth. On the basis of financial analysis management take the decisions for the Company’s growth and take the appropriate decision about the goals and targets to the company.

Below shown dashboard is presenting the Financial Analysis.

img1
 
In this dashboard we have the Revenue generation report, comparisons.

img2
 
Pie Chart:- In the Pie chart we can see how the revenue is contributed by all the regions and in the 2nd Pie chart we can see the contribution of every product.

img3
 
In the first table we can see the comparison in between estimated revenue and actual revenue for Sales persons.

In the second table we can see the comparison between estimated revenue and actual revenue for every department.

img4
 
In all the charts we can see the graphical comparison between Actual revenue and estimated revenue.

  • First column chart is showing the revenue comparison by region.
  • Second column chart is showing the revenue comparison by product.
  • Third column chart is showing the revenue comparison by Industry.
  • Fourth column chart is showing the revenue comparison by Sales person.

img5
 
Doughnut chart used to show the actual v/s estimated revenue year wise.

Human resources dashboards are useful to analyze the performance and improvement areas of resources, employee satisfaction. We can finalize the salary standard for every levels and designation accordingly.

img6
 
Human resource dashboard is usedto present the department, all employees, all salaries, and all hire dates.

img7
 
Pie chart used to show the headcount share to every department. Through this chart we can see that Customer support is having very less share of headcount compared to other departments.

img8
 
Here we can present the salary break down as per the Salary, Bonus, and overtime. Through the chart we can present the department wise report as per Employee, Max Salary, and Average Salary.

img9
 
Bar chart is used to present the number of employee according to salary criteria. Through this chart we can see that large number of employees are taking 70,000($) salary.

img10
 
Doughnut chart is used to show the ratio by hire date.

Team performance dashboardanalyses the team performance. By using the team performance dashboard we can see individual performance and make improvements in the performance on the basis of data.It helps us to forecast the next vision of targets and achievement and managing things like how we can improve sales, how we can generate revenue etc.

img11
 
Team performance dashboard will present the report according to all teams, all team members, all products, and all regions.

img12
 
In this table top 10 Team members are showing according to the talk time, revenue, CSAT of Excellent, Good, Fair, and Poor.

img13
 
In this table we have CSAT % team wise and Revenue filtered team wise.

Graphical picture used to show the CSAT % region wise.

img14
 
Column Chart used to show the login hours, Total talk time and Total hold time team wise.

img15
 
Pie chart is used to show the revenue contribution by the every team and doughnut chart is used to show the CSAT ration overall.
Sales performance dashboard is useful to analyze the performance of sales. By using the sales performance dashboard we can see the individual performance and make improvement in the performance on the basis of data.It helps us to forecast the next vision of targets and achievement and managing the things like how we can improve sales and how we can generate revenue etc.

img16
 
Team performance dashboard will present the report according to all sales representatives, all products, all regions, full data range, and year round.

img17
 
In this table we can see the summary of sales in terms of Total sales, best-selling, worst-selling, top sales rep, and bottom sales rep.

img18
 
Pie charts are used to show the sales contribution product and region wise.

img19
 
Line chart is used to show the sales number to every sales person.

Stock Dashboard is useful to show the share trend, that how the share is performing in the last year, last month and last day. It is useful to analyze where we should invest our money.
 
img20
 
img21
 
In the first table we can see top traders by volume, closed At, and %age.

In the second table we can see the comparison in between Previous and current day’s highest, lowest and average trade value with percentage.

img22
 
Pie used to show the volume contribution.

img23
 
Column chart used to show the graphical picture of Top 10 Stocks with volume.

img24
 
Column chart used to show the graphical picture of bottom 10 Stocks with volume.
 
image 48

 

If you liked our blogs, share it with your friends on Facebook. And also you can follow us on Twitter and Facebook.

We would love to hear from you, do let us know how we can improve, complement or innovate our work and make it better for you. Write us at info@exceltip.com 

 

 

Comments

  1. Thanks for the Data Validation note advice above.
    Another area I'm unable to solve is how to make a Tab selection via a macro.
    Are you able to supply a sample or some guidance please?

    • How to make a tab selection in VBA? That part is easy enough:

      Sheets("SheetName").Select

      In actuality, the different dashboards in here are all on the same tab, though. They're each in a different range of columns. What I'm doing, each time the switch macro is clicked, is hiding all 5 dashboards, then unhiding the one that was clicked, like this:

      Sheets("SheetName").Range("AA:EZ").EntireColumn.Hidden = True
      Sheets("SheetName").range("BA:BZ").EntireColumn.Hidden = False

      • Thanks for the response.
        Yes I recognise what you have stated above.
        What I'm looking to achieve is the pretty bits where it would be possible to change the bar graph indicator to the full length of the revised selection, and adjust the other lengths.
        I see how the lengths adjust. I'm looking for how to place the trigger for - this is the one to be the full length.
        As part of this I will make the workbook default to the display I want to be seen whenever it is opened.

        • Not to worry, challenged to work something out I've come up with a cheats way by dropping in default values to the dataset.
          Thanks again for your impressive workbook.

      • Erik Suurmond

        Dear K bryant 414,

        I'm also impressed by the dashboard you have developped. I am specofically very curious how you made the graphs interactive. I made a couple of dashboards my self too, by using slicers. If I could turn slicers into graphs like you did I can further improve my dashboard. So could you let me know hoe you did that?

        Your answer will be highly appriciated.

        Gr,
        Erik Suurmond

  2. Hi Kbryant and well done, this is mesmerizing!

    How do i add new data on the raw tabs so it updates data tabs and graph data please?

    I'm just afraid to leave something out.

    Thx

  3. Great work
    Something simple within. Where Ben, MaraisV, and DB have been referring to the notes that appear on the sheet when various cells are selected.
    They don't appear to be "Comments".
    What is this note method called?
    How do I edit?
    How do I add for future?

    • Those are done via Data Validation.

      On the Excel ribbon, go to Data, then Data Validation. The second tab, Input Message, will display when the cell is selected.

  4. Hi Kbryant - thanks for responding and let me 1st say what an amazing dashboard. It really is so intuitive.

    I am referring to the input message on the Data Tabs cell;
    “The DATA tabs have parsed and calculated data. These are based on the RAW tabs and should not be altered directly.

    To update data, add new data to the RAW tabs and use the Update button.”

    Just wondering if because the data is parsed on the tables you had VBA in there to automatically update it?

  5. A good effort, some great ideas which I will definitely recycle. From experience I have learnt that the use of colours are very important. How will your dashboard look on the big screen in the boardroom - is there enough contrast to show information clearly? Remember your 70 year-old CEO may not have the sharpest eyesight any more!

    The worst presentation here - sales by employee. Really, it shows a pile of meaningless lines.
    Best feature? Too many to mention!

  6. Amazing work! So well thought out.
    Can somebody please tell me where the "update button" is? The author of the dashboard refers to it in the comment for the DATA Tabs Hidden field. Thanks!

      • Author here. I'm not sure what 'update button' you're referring to.

        DATA Tabs Hidden is an on/off toggle to show or hide the DATA tabs. I used a circle shape as the button to trigger this -- and change the transparency of the shape's fill to indicate whether it's currently on or off. Was this what you meant?

        • Hi Kbryant - thanks for responding and let me 1st say what an amazing dashboard. It really is so intuitive.

          I am referring to the input message on the Data Tabs cell;
          “The DATA tabs have parsed and calculated data. These are based on the RAW tabs and should not be altered directly.

          To update data, add new data to the RAW tabs and use the Update button.”

          Just wondering if because the data is parsed on the tables you had VBA in there to automatically update it?

          • Ah! Sorry, I thought I had removed that note.

            Originally, I intended to take this a little further. If I had done so, you would have pasted the new data into the RAW tab, hit the Update button, and it would then update the DATA tables and all of the charts with the new data. It's a simple method I use frequently when building reports because it allows other users to easily update a report, after it's been built.

            However, with the deadline approaching, and realizing this wouldn't factor into the contest, I opted to leave that part out. Sorry for the confusion.

        • Excellent work no words to praise your work kbryant, would if possible you can tell us how to unlock and update new data and update dashboards. Congrats again on your work amazing.

  7. Awesome work done, really good. Very pleasing to eyes as well.. A bit of though and you can have everything you want

    Great Work..

  8. I love this dashboard, it is amazing. I downloaded the file and did not see all features that are shown in the images above. Will this ever become available?

  9. I dream in Excel - seriously - and I stand in awe. This is going to give me sweet, sweet dreams. Hats off to you, us mere mortals have a long way to go.

  10. Fantastic demonstration of Dashboard capabilities within Excel. Third Parties charge a fortune for this style of data interpretation, so I take my hat off to you all.

    It's also good for the "rest of us" to know that we still have lots to learn, as Excel has so much more depth now than ever before.

  11. congratulation!!
    very excellent......the layout design, color combination, chart type, interactive, easy to understand...give me so much idea...thanks 🙂

  12. It's awsome,Congrats!. please also mention it has been developed with in excel or VB also used? and if possible please provide us the copy of file.

Leave a Reply to paulmacro Cancel reply

Your email address will not be published. Required fields are marked *

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.