Excel web query was used in this business dashboard to display and track gasoline prices from AAA’s Daily Fuel Gauge Report.
Excel web query powers this fuel price report dashboard
Kaylan Verma (myxcelsius.com) is the creator of this dashboard and had this to say:
I used Excel Web Queries connected to AAA data. The data is being pulled from http://www.fuelgaugereport.com/. The IQY files were modified to pick up parameters from certain cells and those cells were dynamically changed by the List Box input. So when the user clicks on a state from the list box, it inserts the state value in the destination cell which is linked to the parameter of the Web Query. The web query is set to refresh when there is a change in the parameter cell.
The web query results were mapped to certain cells which make up the source data for the charts. I had to use Lookups since the web query had a state abbreviation in it.
Dashboard for security content logging and data mining
Security management dashboards demand real-time analysis and a clear at-a-glance approach to information visualization. Typical requirements include the logging and reporting of security threats across a spectrum of types.
Regulatory, legal and compliance requirements now force companies to not only understand network activity from a threat perspective, but to proactively manage and mitigate certain protection measures and enforce acceptable use policies.
Here are some screenshots of a web security dashboard called FortiAnalyzer.
Web Security Dashboard
Customized security environment reports and graphs
Be sure to check out these dashboard examples of security management dashboards.
Dsahboards from The Dashboard Spy
Start your own blog about dashboards at http://dashboards.org
Marketing Key Performance Indicator Dashboard
This simple-looking, text-based dashboard tracks Marketing Management KPIs in a very straight-forward fashion.
The Marketing Management dashboard enables the marketing professionals to quickly determine the health of the marketing department. This dashboard contains the KPI region and reports on campaign to cash, campaign ROI, and budgets. The Marketing
Management dashboard facilitates comparing data of the current period with prior periods and helps analyze trends in lead generation, lead conversion, cost per lead, and revenue per lead, thereby providing historic trend data to plan future objectives.
The KPI region includes a snapshot of key performance data and enables marketing professionals to quickly assess the health of the marketing department. The KPIs present information on key marketing areas, such as lead generation, lead conversion, won opportunities amount, booked orders and so on. You can quantify, compare, measure, and track KPIs against prior periods to view historic trenddata. Some KPIs provide additional drill-down details, others display one level of summary data. By selecting a specific link within the region, you can drill down for more details.
Leads from Customers New Leads created during the selected period from existing customers. Customer is a person or an organization with which the company has a selling relationship, regardless of whether anything has actually been purchased or serviced. A customer is a party with a customer account.
Leads from Prospects New Leads created during the selected period from prospects. A prospect is a person or
organization, which the company, does not yet have a selling relationship.
‘A’ Leads Leads created during the specified period and
with a lead rank of ‘A’ as of the sys date.
‘A’ Leads % Leads created during the specified period and
with a lead rank of ‘A’ as of the sys date and as
a % of new leads.
New Opportunities Amount The sum of the sales credit amount of all opportunities with a marketing source created
within the specified period.
Won Opportunities Amount The sum of the sales credit amount of all opportunities with a marketing source that
• Close date within the selected current
• Closed flag set
• Won flag set
Cost Per Lead The marketing budgetary cost of generating all leads.
The Cost Per Lead displays expenses associated to each lead during the selected period. Based on the profile settings, either PTD Cost or Total Cost is displayed. Program cost calculations are defined from either the approved budget amount or the actual cost value.
Revenue Per Lead The booked revenue ratio resulting from all generated leads.
Lead to Opportunity Conversion Percentage of leads converted to opportunities during the specified period irrespective of when the leads were created.
Campaign Started Number of campaigns started during the selected period.
Events Started Number of events started during the selected period.
This dashboard screenshot shows a Project Portfolio Management Dashboard implemented with Microsoft Access. The system front end is constructed using OpenGate Software’s UI Buider for Microsoft Access.
As you see in the dashboard’s screenshot, you can track projects in your portfolio in terms of status and financial metrics. The dashboard system allows for the performance of cost/benefit analysis for the entire project portfolio as well as at the individual project level.
Microsoft Access dashboards make use of Access VB to enable system functionality. A demo for a Project Portfolio Management Template can be downloaded from Opengate.
Microsoft Access Dashboard Screenshot (click to enlarge):
Project Portfolio Management Dashboard Created with Microsoft Access
Tags: Microsoft Access Dashboards for Project Porfolio Tracking and Performance Management, MS Access Dashboard. opengate UI builder for Microsoft Access.
This example of a brand marketing dashboard is meant for a marketing executive to use as a daily check on brand management metrics. Among the high level metrics categories are Brand Metrics, Advertising Metrics, and Purchase Metrics. Here are the KPIs in each category:
- Brand Metrics
- Brand Awareness
- Brand Commitment
- Brand Attributes
- Advertising Metrics
- Advertising Awareness
- Source of Ad Awareness
- Message Association
- Purchase Metrics
- Market Share
- Frequency Profile
- Repeat Purchase
Here is the marketing dashboard screenshot. Click on the image to enlarge it.
This brand marketing dashboard was implemented with Xcelsius
For more marketing dashboards, see:
Marketing Dashboard Best Practices
Also, see these Dashboard Experts
The Dashboard Spy is proud to announce the beta launch of a new dashboarding resource called Dashboards.TV. This unique dashboard video blog will feature videos of business dashboards, KPIs, Metrics, and other business intelligence material.
Use this link to visit the new service:
Video Blog about Dashboards and Business Intelligence
Dashboard Spy readers, let me know what you think. Would you watch videos about dashboards? If you have some good videos on youtube that you’d like me to post to Dashboards.TV, add the link to the comments below.
The Dashboard Spy
Looking for the 2008 Olympic Medal Count? Use this link for the Olympic Scoreboard:
Olympic Dashboard Data now live! The 2008 Summer Olympic Games Medal Count Dashboard is now showing current results.
Visit the iDashboards Beijing Olympics Scorecard.
Here is a screenshot of the medal count page:
Here is the Olympics Scorecard page:
The daily updated dashboard provides a summary of the day’s athletic results and an interactive world map highlights participating countries and corresponding medal tallies. The dashboards’ unique hover-and-click capabilities enable fans to drill down through each country’s results by sporting event and individual athlete performance. For Olympic enthusiasts, an additional dashboard provides even greater detail and the ability to compare results from across the globe with the help of graphic bar charts, speedometers, gauges, interactive country flags, and medals.
Tags: 2008 Olympic Medal Count, Beijing Olympics Dashboard, Olympic Scorecard, Olympic Dashboard, Olympics Dashboard
Did you know that the U.S. Navy consciously runs itself like a business enterprise? That includes embracing the value of enterprise dashboards and other business intelligence tools.
The Navy has an overarching program called Naval Aviation Enterprise (NAE) that is operated much like a $60 billion corporation. It’s overall vision is to “To deliver the right force with the right readiness at the right cost at the right time … today, and in the future.”
“It’s about collaborating, sharing and enhancing our business practices. Not to turn the Navy into a business, but to understand the business of the Navy so that we remain the most effective and efficient Navy in the world.”
— CNO Admiral Gary Roughead, March 2008
Let’s have a look at an enterprise dashboard (what the Navy likes to call Cockpit Charts) that monitors progress to goal in the area of mission readiness.
Here is a screenshot. In the interest of security, I’m showing a low-resolution image. Click on the “read more” link after the screen shot for a discussion of the relevant metrics used in this readiness dashboard.
Enterprise Dashboard used by the US Navy
Let’s have a look at the metrics featured on this enterprise dashboard: