Articles Comments

Free Excel Dashboards » Archive

A Look At Dashboard Reporting Time Frames

Our friends at Klipfolio provided the following look at Dashboard Reporting Time Frames An essay on time frame comparison metrics. We take an close, in-depth examination of 3 common ways of applying time frames and comparative values with an organization’s key performance indicators (KPIs). Once your organization has adopted a KPI dashboard, the next steps – to truly make the metrics work for you – may not be as obvious. A great starting point is our article on the anatomy of a KPI, where we look at how consciously designing your KPIs can influence the way you interact and act on them. The next item to consider is what type of time frame paradigm you want to use when tracking your Key Performance Indicators. This article will examine 3 important models: historic, X-to-Date, and moving/rolling metrics. Historic … Read entire article »

Filed under: Dashboard, Excel Dashboard, Excel Dashboard Software, IT, Service

Groupsite Enterprise Dashboard

Dashboard Spies love it when I show them business intelligence dashboard project artifacts. Here’s a look at a high fidelity mockup of the recently developed enterprise dashboard for Groupsite. It allows an enterprise to have a bird’s eye view of the digital communities spread across an organization. This description is from the internal document that was leaked to me: With the coming release of Groupsite’s Enterprise Dashboard, organizations are now empowered to gain actionable insights from all communities across their enterprise to spot trends, opportunities and potential problems. With Groupsite’s Enterprise Dashboard, marketing units now have the data at their fingertips to shape offerings and increase sales and brand engagement. Groupsite is the industry’s leading SaaS platform for engaging external stakeholders of any organization. Leading companies, educational institutions, associations and government agencies … Read entire article »

Filed under: Dashboard, Excel Dashboard, Excel Dashboard Software, IT, Service

School District Dashboard

This performance dashboard example features metrics and key performance indicators relevant to the measurement of school district performance. As you can see from the screenshot of the dashboard example, it shows student achievement in the areas of State Performance, National Performance, ACT Test Performance, Graduation Rate, Academic Rigor and AP Class Enrollments. The “Climate” metrics measure job satisfaction, learning environment, safety, respect, internal communication, discipline, professional development and diversity. The other major buckets addressed by this school dashboard revolve around the concepts of Parent and Community Relations (e.g. would be Overall Quality of Education, Board of Education, Community Awareness, Parent Involvement, Parent Communication, and Fiscal Responsibility) and Finance and Resources (Example shows Fund Balance, but there are other categories such as Operating Expense per Student, Tax Rate, Pupil/Teacher Ratio, Teachers … Read entire article »

Filed under: Dashboard, Excel Dashboard, Excel Dashboard Software, IT, Service

The Selling Out of Infographics

For quite a while now, Dashboard Spy readers know that I’ve been warning people about the “dark side” of infographics. I had a long conversation with someone who took me to task for being so cynical. Here’s basically how the conversation went. This person LOVES INFOGRAPHICS. I asked him to show me the kinds of infographics he loved – and I ABSOLUTELY AGREE. These were real, legitimate information visualizations with lots of care and effort put into it. When done right, and with respect to the very real principles behind information visualization, there is nothing like an infographic to turn on that light bulb over the viewer’s head. However, my side of the story was that the SEO (Search Engine Optimization) industry has found that infographics are awesome traffic magnets. The presence … Read entire article »

Filed under: Dashboard, Excel Dashboard, Excel Dashboard Software, IT, Service

Dashboard Whitepaper on Agile BI

Here’s an interesting white paper on “self-service” business intelligence. Here’s the link: “Agile BI: Power to the People” About 175 IT leaders were surveyed about their business intelligence agility and implementations. It defined the 20 percent of users as best-in-class, 50 percent as average, and the remaining as “laggards.” The authors, White and Castellina, suggested that avenues toward self-service functionality show the clearest path toward agile BI. On that front, BI endeavors returned the most rewards when they moved beyond the traditional static reports and into collaboration between business and IT. Sixty-five percent of BI users across best-in-class enterprises reported that data sources were understood and documented, compared with 33 percent of other enterprises that shared that same comprehension, according to the Aberdeen report. An even wider difference was found in … Read entire article »

Filed under: Dashboard, Excel Dashboard, Excel Dashboard Software, IT, Service

Add Economic Data to Your Excel Dashboards

All Excel users should take note of this new product. It’s really, really cool. You can easily add data and calculations from more than 40 million data series about the economy and public companies. Use this link to learn more: KydWeb Watch this video to see how. KydWeb represents several firsts… It’s the first Excel add-in that powers Excel formulas to return web data for business analysis, forecasting, and reporting. Within minutes after a user discovers a web page with useful data, her KydWeb functions can display the data in a report. And when the data updates, so will the report the next time it’s loaded. (For performance reasons, web data is cached during a session of Excel.) It’s the first product Charley Kyd created that directly addresses our “crazy economy.” As he says, … Read entire article »

Filed under: Dashboard, Excel Dashboard, Excel Dashboard Software, IT, Service

Business Intelligence Analogy to Human Anatomy

Business Dashboard Topic: Can business intelligence be compared to human anatomy? Here’s a video from SAP that compares business intelligence to human anatomy. That’s right, watch the video and you’ll see that the parallels can indeed be made. The “foot” is equivalent to Enterprise Information Management; the “legs” and “arms” are Collaboration; the “torso” is akin to Data Warehousing, the “upper body” is business intelligence, the “ears” are Analytic Applications and Predictive Analytics and the “head or brain” is Performance Management Risk and Compliance. BTW, the video is a recording of the Day 2 keynote presented at the 2011 ASUG SBOUC in Orlando, Florida. For more, see http://blogs.sap.com/analytics … Read entire article »

Filed under: Dashboard, Excel Dashboard, Excel Dashboard Software, IT, Service

How to Create Two-Dimensional Lookups in Excel Formulas

This figure illustrates a great Excel question that a friend asked today. His original question was, “In this table, how can I return the date where the lowest value occurs?” More generally, however, he was asking how to look up a value in two dimensions. This is a different challenge than most Excel lookups, which [...] For more information visit How to Create Two-Dimensional Lookups in Excel Formulas … Read entire article »

Filed under: Dashboard, Excel Dashboard, Excel Dashboard Software, IT

Washington State Government Employees salary Dashboard

    Check out the interactive dashboard at http://washingtongovernmentsalaries.com/ … Read entire article »

Filed under: Dashboard, Excel Dashboard, Excel Dashboard Software, IT, Sales

How One Excel User Is Making a Great Living From Excel Reports

I talked recently with an Excel user who’s making a great living from Excel reports. Because many Excel users are looking for jobs, I thought someone else could use a similar idea. The idea is based on one that I first heard about as a teenager. My best friend’s father owned a car dealership. One [...] For more information visit How One Excel User Is Making a Great Living From Excel Reports … Read entire article »

Filed under: Dashboard, Excel Dashboard, Excel Dashboard Software, IT