How to build Excel Dashboards – 9

Previous – Excel Dashboard Tutorial – 8
Finish the Dashboard Design and Development
By now, your dashboard is quite chaotic. You have objects all around your dashboard canvas with different sizes. We will start the process of finishing our design.

 
Before proceeding, we save a copy of the dashboard.

Navigate to menu File ‘ Save As

 
Give a name [...]

How to build Excel Dashboards – 8

Previous – Excel Dashboard Tutorial – 7
Create Pie Chart
We will now create a pie chart by product name

 
It is nice to know that the revenue distribution is not dominated by a single product.

We can now change the “Category name parameter” to see the product distribution for other category

By Category = Beverages

Summary of steps so far
” [...]

How to build Excel Dashboards – 7

Previous – Excel Dashboard Tutorial – 6
Create Bar Chart

Bar charts reveal important trend in your data. The very important reason we split the date into year, quarter, month, week and day components is to see if there is a trend in the sales or order information.

Right click on the Qlet title (”Name” ), and [...]

How to build Excel Dashboards – 6

Previous – Excel Dashboards – 5
Create Year and Category Parameters
Remember, we have not built any charts yet. It is very important that we build our foundation Qlet and its corresponding parameters so that all of the drop down parameters can be leveraged in the charts.

It definitely helps to plan your dashboard development. Since the dashboard [...]

How to build Excel Dashboards – 5

Previous Article – Create Excel Dashboards – 4
Add Date Hierarchy Columns
Most of the data, has some form of date information. Now date is very granular information. Very often, to generate trending information, you need to derive year and month columns.

In the dashboard designer, you can easily generate Date hierarchy columns for any kind of reporting.

In [...]

Freedom of Information Act dashboard

The Department of Justice will create a Freedom of Information Act dashboard to visually demonstrate the progress made by government agencies in processing FOIA requests
http://www.justice.gov/open/plan.html
According to the plan, the DOJ Office of Public Affairs will post court filings as soon as they are filed to make them more accessible to the public.
“The public will often [...]

Warehouse Management Dashboard

The Warehouse Management dashboard features content relating to operational efficiency of a warehouse and capacity utilization. You can view data relating to outbound shipments, such as number of picks, pick release to ship cycle time and pick exceptions, putaway cycle time for incoming material, operation plan performance, and the amount of the warehouse storage that [...]

The buzz about Dashboards – Quick links 1

One of the delicate balances of modern technology is delivering all the relevant information in such a way that it can be taken in at a glance – akin to the car dashboard – while still concentrating on the mission-critical task at hand. Last week we covered the latest advances for the information-intensive battlefield and [...]

Wiki Dashboard

Wikipedia pleased to announce the release of our first research prototype of a social dynamic analysis tool for Wikipedia called WikiDashboard.
The idea is that if we provide social transparency and enable attribution of work to individual workers in Wikipedia, then this will eventually result in increased credibility and trust in the page content, and therefore [...]

Washington DC Launches Performance Dashboard

The site, called TrackDC, is part of an ongoing commitment by DC government to be more accountable to its constituents, Mayor Adrian Fenty said in a statement. Washington already offers an online data catalog (Data.dc.gov) and government statistics site (CapStat).
TrackDC provides performance data on approximately 50 government agencies. The site offers budget and spending information [...]