Why Excel isn’t Enough for Businesses

Why Excel isn't enough

The article, The File-less Organization: Why Excel Isn’t Enough for Businesses, from Dataversity.net is quite astute in the way it identifies Excel as a problem–noting that each manager gathers his or her own version of the numbers to bring to a meeting.  And so in the meeting everyone has a different version of the state of affairs, and things can easily devolve into an argument over whose numbers are the “most right”.  Sound familiar?

I was so excited when I began reading because this article gets it exactly right in the beginning, but at the end, it seems to recommend dashboards as the solution to this problem. Except that dashboards are usually representations of those same error-prone, manually compiled spreadsheets. The ‘replace-Excel-with-dashboards’ scenario is more of a band-aid theory: once you get past the pretty graphics, you’ll discover that you traded one problem for another! Don’t get us wrong, we love dashboards, but we think they should be real-time, fed from the data source directly. This requires a sophisticated BI solution, which the article confuses a little bit with dashboards.  Typically, dashboards have limited calculation capability. With the newest, advanced business solutions, like Olation, the relational data source is combined with a data calculation engine and modeling solution that, yes indeed, works with Excel, not against it.

5 Essential Components of a Data Strategy

Building a comprehensive data strategy for your organization can be a daunting task. Where do you start, and how do you put all the proper pieces in place for a suitable strategy to bring value to your company from data? The key is to ensure that the strategy focuses on the strengths and needs of the individual company. Evan Levy, vice president of business consulting at SAS, shares the five necessary components for building a data strategy, based on his new course at TDWI.

Image Courtesy of kromkrathog/FreeDitigalPhotos.net

Read Full Article: 5 Essential Components of a Data Strategy

Article Source: Information Management

 

6 Golden Rules to Successful Dashboard Design

Dashboard Rules Image

Dashboards are often created on-the-fly with data being added simply because there is some white space not being used. Different people in the company ask for different data to be displayed and soon the dashboard becomes hard to read and full of meaningless non-related information. When this happens, the dashboard is no longer useful. This article discusses the steps that need to be taken during the design phase in order to create a useful and actionable dashboard.

Read Full Article: 6 Golden Rules to Successful Dashboard Design

Source: Geckoboard

– See more at: http://www.geckoboard.com/building-great-dashboards-6-golden-rules-to-successful-dashboard-design/#sthash.dsl9dSyE.dpuf

6 Golden Rules to Successful Dashboard Design

Dashboard Design: Important Things You Need to Know

Dashboard Design Image

Image Courtesy of: Renjith Krishnan/FreeDigitalPhotos.net

Dashboard design will definitely put your organizing skills into the test. Not only because there are myriads and myriads of parameters to keep in check but because your blog management would definitely depend on it. The Dashboard is basically the admin interface at the back end of web site. This is where you could find everything you need to keep your site running smoothly. Think of it like your car’s dashboard. Dead straight in front of you, you will find the steering wheel, gauges for speed and fuel levels as well as gear number.

Read Full Article: Dashboard Design: Important Things You Need to Know

Source: Dashboard Insight