Excel Dashboards

When it comes to building dashboards, there are two options that come to mind that are both excellent and economical.

Pre-Built Excel Templates for Dashboarding

Excel Dashboards

You can get these excel dashboard templates and start using them.

2nd Option

Build your own Dashboards using Excel as Data source

With the new Visual Query Builder . Watch this Video on How to build dashboard

Business Dashboard

Benefits

With this option,

  • you can treat the complete Excel File as a SQL database.
  • Each worksheet in the excel file is treated as a database table.
  • You can query either single excel file or join multiple excel files and create a big SQL query
  • You can create drop down parameters from the Excel file columns
  • Merge information from different Excel Files into same dashboard
  • Merge information from other Database such as Microsoft Access (*.mdf) files into the same dashboard containing the Excel data
  • Publish the Excel dashboard so that it can be accessed from a central file server or webserver (link)

Executive Dashboard

Here is a sample dashboard based on Excel file as Data source

Executive Dashboard

 

Some useful links



Check these related Dashboards

  • Various methods of creating Digital Dashboards – Part 4
  • NetCharts Financial Dashboard from Visual Mining
  • Various methods of creating Digital Dashboards – Part 3
  • Is Excel a BI Duct Tape or a Complete BI solution?
  • Fuel Gauge Dashboard using Excel Web Query

  • Please rate it/strong>
    1 Star2 Stars3 Stars4 Stars5 Stars (2 votes, average: 4 out of 5)
    Loading ... Loading ...

    Create Excel dashboards quickly with Plug-N-Play reports.
    Both comments and trackbacks are currently closed
    Dashboard Zone - Your online community for everything Dashboards