The Key Differences Between Business Intelligence & Visual Intelligence [Plus Free Whitepaper Download]


Important business decisions are made every day. Data is the lifeblood of these decisions. We live in a world where the volume of data is as immense as the number of sources it comes from.

So how can you make the right choices when you’re sitting on a mountain of disconnected information spread throughout your business?

Making the best decisions possible not only requires the best data, but the best way of interpreting that data. What good is all of that information if you cannot look past the rows, columns, tables and stats to see trends, outliers, issues and opportunities?

Business intelligence just isn’t enough, organizations need visual intelligence.

Dashboards are a powerful visual intelligence tool because of their ability to display data from multiple sources and communicate the message behind the numbers. Dashboards break down data silos and help tell the story in a way that everyone can understand.

In our latest whitepaper, we explain the science behind data visualization and how you can use visual intelligence to help streamline reporting, easily analyze KPIs from across your business and make better decisions more swiftly.

To learn more, click here to download our newest whitepaper.


Bookmark and Share

Data Source Connectivity: Can I Directly Connect To My Back-End?

Often times, the topic of data source connectivity comes up when prospects inquire about iDashboards software. Specifically, they would like to know if we have any experience connecting to a particular CRM, EHR, ABC Accounting/Finance system, or any other myriad of data sources on the back-end.

Let’s explain the criteria iDashboards uses to determine if a direct connection can be made.

When discussing data source connectivity, it is important to understand that iDashboards is “data agnostic.” We can potentially connect to any data source that utilizes an ODBC or JDBC driver. For the non-technical prospect, this stands for Open Data Base Connectivity or Java Data Base Connectivity.

These ODBC and JDBC drivers are the key component that must be available for your particular data source if you wish to have a real-time connection to your back-end data and display it live.


Let’s take it a step further and look at some examples:

iDashboards has the capability to connect to any relational data source. This includes (but is not limited to) the following: SQL Server, MySQL, Excel, Access, Oracle, DB2, Flat Files and Cache systems.

Furthermore, iDashboards also includes real-time connectivity to Salesforce, Google Analytics, Facebook, Twitter and MS OLAP Cubes.

Here are a couple of different scenarios:

  1. I have EPIC software as my back-end, can I connect directly? EPIC software supports an ODBC driver. So YES, iDashboards would be able to directly connect and deliver real-time dashboards displaying EPIC KPIs and Metrics.
  1. I have SAP, as a back-end data source, would I be able to directly connect with iDashboards and display real-time data? As of right now, SAP does not have an ODBC or JDBC driver, so we would not be able to directly connect. However, we would be able to connect secondarily, meaning that you would need to export the SAP data into something like Excel, Access, SQL or some other relational data source, at which point iDashboards would connect to the secondary source. The end result would be the same—SAP data being displayed through iDashboards. However, it would only be as real-time as when that nightly, weekly, monthly, etc., export takes place.

Given the multiple data sources and back-end systems that are utilized between all industries and verticals in business today, iDashboards is able to take that data and turn it into dashboards.

The key question that must be answered though is this: Does the data source I am looking to turn into dashboards support an ODBC or JDBC driver?

If the answer is YES, then iDashboards will theoretically be able to directly connect to that data source.

If the answer is NO, then you must ask yourself: Can I export the data from this back-end data source into something that does support an ODBC or JDBC driver, with the understanding that the dashboards will only be as “real-time” as when that export takes place?

But how will I know if there is a driver available? Here are 3 possible answers:

  1. Your system administrator/IT will more than likely know what type of platform your data source resides on (i.e. SQL, Oracle, MySQL, OLAP Cubes, etc.).
  2. You can go right to the source and contact the data source creator themselves.
  3. You can download a free 30 day trial and utilize one of the many ODBC or JDBC connectors we have available and, with the help of our support team, determine if there is a driver that will allow for this connection. To contact our support team, email

Interested in more information about data connectivity? Click here.


Bookmark and Share

The Real Scoop on Dashboards

The term “dashboards” in the business world still generates a lot of confusion. Unfortunately, many decision makers don’t know what dashboards are, what they do, and, subsequently, how these products can help them make better business decisions that lead to enhanced efficiency and an improved bottom line.

When it comes to gathering critical business data, most employees will rely on what’s worked for them before—emails, reports, Excel spreadsheets, meetings, or even getting up to go ask a co-worker questions on a certain topic. When one or more of these tactics is employed to gather data, it can often be time consuming and a drain on resources—but employees use these strategies because they don’t know how else to do it, or they aren’t aware of other options. Not to mention that when employees are under a tight deadline, they may overlook certain pieces of information that could help them develop their opinion on a subject matter. Is this really how you want your employees making key decisions that affect the company’s bottom line?

Do you know how your employees make these decisions?

Dashboards simplify the information-gathering process. A robust dashboard solution takes all of the tactics above and condenses it into one easy-to-navigate solution that provides timely insight into business data. By opening one tool, decision makers can identify any necessary information, drilldown into granular statistics, and make more educated decisions—ultimately leading to increased productivity by not having to jump through as many hoops to gather the necessary data. Plus, by having all of this data available at their fingertips, decision makers have the required information to, well, make better decisions.

This goes for anyone making decisions—from junior level employees and managers to directors and C-suite executives. These are the folks making decisions all day long, and you want these decisions to be made with the most accurate and current data available.

Get started in three steps:

  1. Gather your decision makers in a room to determine what data is most important for making critical business decisions.
  2. Determine where those metrics are stored, whether it’s Excel spreadsheets, public servers, emails, etc.
  3. Decide which employees will see what level of metrics.

Once these steps are complete, it makes it easier to create your unique dashboard that fits your business model specifications.

Dashboards will help employees drill into data quicker, saving time and resources, and allow them to make better business decisions with all of the critical business data easily accessible.

Bookmark and Share

Not Just for Closets – Organizing Dashboard Charts

Everybody can appreciate ‘less complicated’ sometimes. An easy-to-use Business Intelligence tool that enables you to create charts and dashboards very quickly should be no exception – and is not an exception with iDashboards

With that in mind, one part of keeping charts organized is to have a good chart naming system and overall goals. Within iDashboards, charts and dashboards are saved into so-called categories (folders), allowing you to put charts and dashboards into logical “buckets.” Even though the charts and dashboards are saved separately, they are linked together within the iDashboards repository database. So in the iDashboards system, you could have saved a lot of charts within a certain category (see below image):

The charts shown above are sorted in alphabetical ascending order, but there is no indication to what dashboard(s) the charts in the category “Not Organized” belong to.

My suggestion is to add a prefix to the chart name to show what dashboard(s) the charts are linked to. In the example below, I used a string of seven characters (three letters, a number, a space, a dash and another space) to indicate the dashboard name. With a prefix added to the chart name, charts with the same prefix are now sorted together, as shown below for the category “Organized.”

You have also the ability to search by prefix, as seen below, allowing you to easily find all the charts in a dashboard.

We aim for simple and this idea is easy to implement, helping to better organize the charts within the iDashboards system.

Aziz Sanal – Sr. Technical Consultant, iDashboards

Bookmark and Share

Dashboarding Through the “Fog of DATA War”

I apologize in advance for this total ‘blog geek out’ about to happen, but bear with me – there is an analogy and purpose. If you’ve ever played any type of RTS or Strategy PC game in the past couple decades, you might be familiar with the term ‘Fog of War.’*If you’re not familiar, let me explain. In the PC gaming world, this essentially represents the part of the screen, dungeon, cosmic empire, etc. that you can’t see. The information is out there, but you just can’t see it yet. In the video game world, most of that information tells us essentially where the bad guys (and sometimes good guys) and your special resources are.

Businesses across the world, big and small, are collecting a lot of data. They have information funneling in from CRM, Accounting Applications, Marketing, Point of Sale systems and numerous other sources and reports. It is good news that we have a lot of data out there, data that we can use to make those immediate adjustments to improve our processes and ultimately our objectives and goals. What are we going to access all of this information with? How do we cut through the “Fog of *Data* War” and see what’s truly out there?

We have reports and resources that can tell us what’s going on in any given area of business, but let’s not kid ourselves – when you take into account that the average executive (and by that I mean the person who can respond and make the appropriate changes based on this massive amount of information) works roughly fourteen hours per day, how many more hours can he or she dedicate to sifting through multiple reports and spreadsheets? You’re never going to see the whole landscape when you track a bit here and there no matter how hard you try (back to the Fog of War metaphor). Sometimes you can spend an entire game searching for that threat or resource or you can cheat, turn off the Fog of War and focus your energy on that particular area. Businesses both big and small do a lot of work sifting through multiple reports, searching for that ‘special something’ or breakdown in structure. Sometimes, we catch a crisis early because we’re savvy and lucky. Sometimes, we don’t put out the proverbial fire in time and end up having to fight a (data) fire.

There’s a way cut through the (data) fog though – hooray for technology! Call it dashboards or data visualization; ultimately, it is a tool to easily see what you do not see every day. It is a way to immediately recognize that resource or threat before it goes away or potentially hurts your business. When you’re playing a video game, exploring the unknown and facing new threats from outside worlds can be all kinds of fun. In the real world, it is aggravating and many times, costly. So turn off the ‘fog,’ see your entire landscape and take action swiftly – dashboard through your data fog. Be the hero. Always get to the next level.


*The original term can be attributed to military theorist Carl von Clausewitz -War is an area of uncertainty; three quarters of the things on which all action in War is based are lying in a fog of uncertainty to a greater or lesser extent. The first thing (needed) here is a fine, piercing mind, to feel out the truth with the measure of its judgment…

Dylan Johnston – Account Manager, Cloud Sales, iDashboards

Bookmark and Share

Practice What You ‘Product Preach’: How iDashboards Uses iDashboards

After our highly successful Users Conference in Nashville last month, I am just in awe at all of the incredible ideas and purposes our customers have for iDashboards. Our customers have such creative and innovative ideas on how to best visualize their data, how to use iDashboards to tell real stories. The customer panels were phenomenal! Sharing ideas and seeing how creative people can be on the visual side of things is great, but when you hear that organizations or institutions are using iDashboards to make decisions that save them millions of dollars – that is remarkable!

In that same spirit of sharing, I thought I would share how iDashboards uses iDashboards.

At iDashboards, we use our product in multiple ways – lobby dashboards, sales performance dashboards, marketing dashboards and technical services metric dashboards. We also integrate with our phone system, Google Analytics and Salesforce to display metrics throughout the office. Regardless of the dashboard, each provides insight and purpose.

In our lobby, we have a large LCD monitor cycling through a number of dashboards that portray our company – people, customers and recognitions. It has become part of the iDashboards culture to have new employees introduced through a dashboard of information, pictures and an Image Plot chart of the office showing where new employees sit (see below).

Also using our Image Plot chart type, we have a large US Map showing our customers’ location. Anyone can look at that dashboard and see where our greatest concentration of customers are located.

Occasionally, it is likely that new dashboards with current activities also become part of the sequence of dashboards in the lobby. For example, our very recent Users Conference had a dashboard displaying registration details, as well as a countdown clock to the event.

In the lobby, we also have a few Sales Performance dashboards, and more specifically, the top performers. These dashboards provide both recognition to the top performers and motivation to others, supporting colleagues and the company overall.

Our lobby allows us to broadcast information to the masses, connecting the company to the ‘outside world.’ More importantly, though, they communicate successes and recognize top performers in a visual manner. It’s not always what you say – in this case, it’s how you SHOW it.

Those lobby dashboards are only one example of the approach we take with using iDashboards internally though. As I walk the halls at the iDashboards offices, there are a number of LCDs on the walls showing departmental dashboard metrics. These displays are showing live call metrics for our Sales teams and are tied directly to the phone system database. These set of dashboards allow all to see how many calls they are making, call duration and how they are performing in comparison to their peers.

A similar dashboard exists for monthly number of calls and the average call duration over the last 30 days. From these dashboards, it becomes easier to see not only who is making the most calls, but also what time of the day the most successful calls are taking place.

Other dashboards are built for departmental contests, territory coverage maps and customer licensing, whether active or inactive. Secure access is given to these departmental dashboards to allow our account managers to see a focused list of their customers and help them understand how they are performing as an individual or as part of the larger team.

Our technical services and support teams also have their own dashboards, tracking customer satisfaction, support tickets and type of activities being performed by technical resources over time, using input parameters to filter on time range, type of activity and technical resource.

As you can probably tell by now, at iDashboards we track nearly everything using iDashboards – we practice what we ‘product preach’ (I didn’t even talk about the dashboard developed to track what is the most cost-effective way to provide coffee to the masses!). Each department, each person at iDashboards will somehow utilize our internal dashboards daily, and we are proud of that.

How does your organization utilize iDashboards internally? Please add a comment and share your story!

Jerry Stowe – Sr. Systems Consultant, iDashboards

Bookmark and Share

“Visual Intelligence” vs. “Business Intelligence”

The difference between making good decisions and bad decisions is the quality of information used when making that decision. In many businesses today, decisions are being made based on data that is old or incomplete because there is no easy way to extrapolate data and communicate the findings in a timely manner.

Dashboards help aggregate data from various sources, display that data in a visual format, communicate the message behind the numbers and encourage action on the information that is presented. The amount of data generated today can be overwhelming. While “Business Intelligence” is a field that tries to make sense of the data, there is often a breakdown when that “intelligence” cannot be communicated in a way that is understandable, or data is stored in systems that fail to interact with each other.

How do we get real time data to stakeholders in a format that is understandable? How do we dig through the data to find outliers that need to be managed? How do we develop Key Performance Indicators (KPIs) that are common across the organization and communicated in a way that is understood by all – even when data is compartmentalized? In other words, how do we make Visual Intelligence out of our Business Intelligence? A visual dashboard takes information out of rows and columns and puts the information into charts and graphs that people can understand.

Frank Anscombe, the founding chair of the statistics department at Yale University, illustrated the importance of visualizing data prior to analysis based on research done in the 1970’s. Using four similar data sets, Anscombe developed what is commonly known today as “Anscombe’s Quartet” which shows the effect of “outliers” within the data set when put in to a graphic representation of that data. All four have the same linear progression line, but graph very differently.














Visual dashboards that take the information from rows and columns and puts it in to a “picture” (or graph) assist businesses in finding disruptive outliers, managing them accordingly. For example, one client was using multiple data sources with no common denominator. Many people reported in Excel spreadsheets, with each department having their own database and their own Enterprise Resource Planning software, with no common reporting tool between the departments. They had no way to measure and monitor KPIs that were common across the organization.

By implementing a visual dashboard, the client was able to integrate their ERP databases and spreadsheets into a single visual format. They can now see common KPI trends, conduct “what if” analyses with those KPIs, ultimately making more informed executive (leadership) decisions because the quality of information is better.

Another client is pulling from their financial software, HR databases, Marketing (Google Analytics), and other ERP databases, none of which are tied together. Their dashboards give them a complete “picture” of their business for the first time and are updated automatically with real-time data.

Is it possible to communicate these results in a multi-page Excel report of rows and columns? Of course it is; however, a visual dashboard provides an intuitive tool that spots trends, provides analysis and calls for action at a glance. Best of class dashboards are real-time, pull from multiple data sources and provide complete mobility so decisions can be made on the fly.

To avoid drowning in a sea of Business Intelligence (BI), build a dashboard and turn the BI into Visual Intelligence (VI). When your business is able to spot trends and make analyses in an easy-to-use format in real-time, you will make better decisions based on better information that will result in cost savings, clear communication and achieving standardized KPIs across the organization. Now that is intelligence.

Tim Barr – Director of Cloud Sales, iDashboards

Bookmark and Share

New Features, New Product Fun with v8.5 Release

iDashboards v8.5 is about to be released! New product releases are a big deal when you work at a software development company (around here, we are now saying ‘8.5!’). Many tasks need to be managed, executed and held to a tight timeline. In addition, all employees must be expert product users of the software…at the time of launch.

After having my hands on the ‘beta’ internal version of the software for a few months, I’ve been able to see all the new features get constantly fine-tuned. We have found that the new features are ‘nice,’ some are ‘pretty cool’ and the flagship features are deemed ‘awesome.’ I imagine both existing  and new users of iDashboards will be attracted to different features in the release of v8.5.

As an expert user, I have really become smitten with our new Point-and-Click Chart Designer. The new Chart Designer is a more unified and streamlined experience overall, and more advanced. I am experiencing a dramatic decrease in time when creating charts with this new Chart Designer. For example, it is not unusual for me to build a basic Bar Chart within 10-15 seconds, 20-30 seconds if I need to add filters and 30-60 seconds if the chart also needs to be visually customized (yes, I timed myself). Below is a quick example to show how the new point-and-click Chart Designer can streamline the chart building process.

For new users of iDashboards, I think there will be a natural attraction to our flexible viewing options, capable of delivering dashboards with our traditional Adobe Flash interface or the new HTML5 interface.  iDashboards now has the highest quality HTML5 dashboards on the market, and this is only our first release with HTML. This option will eventually eliminate the need for apps and will certainly allow our mobile users to have a better experience viewing dashboards. Below is a dashboard comparison between the Flash and HTML5 interface.

New or existing users should not ignore what is the most advanced, flexible, creative and custom chart in the dashboard industry: the Image Plot Chart. This is not a traditional analytics chart, but instead a platform for building your own chart by layering dynamic points on any custom image. Now, our users can build their own custom GPS maps, interactive illustrations and more. Below are some examples of what’s possible with the Image Plot Chart.





























Ken Rose – Product Marketing Leader, iDashboards

Bookmark and Share

Beware of Scale Bias – and Prevent It with Interactive Intelligence

On the road, I often see some amazing dashboard designs. Sometimes when we make charts and graphs though, we combine too much information into one chart. I regularly see charts that have measurements of many items against one X axis. See the chart below for an example of this – the number of people in a city and the amount of rain (in centimeters) the city has had in the last year.





We can see that the number of people in the city greatly exceeds the number of centimeters of rain.  When we put this into a chart, it looks like this:









Image Caption: Left out of the rain, it makes it look like these cities are all in arid climates and didn’t receive any rain at all.

The above chart renders the data as it should, and displays the information; however, this chart really does not do a decent job showing if there is a correlation between the amount of rain a city receives and its population. This makes a classic case for a need of the iDashboards Interactive Intelligence feature. I like to tell my course participants that if a scale bias is introduced into the dashboard decision-making process, the consequential choice might be a poor one if the decision-maker sees a chart like this. What would happen if emergency water rationing went into place in a city that was actually experiencing a flood year as a result of this chart?

Instead, we apply chart object recycling, and we can now see the same chart, but with one “Y.”

We took the chart above, and in the middle frame created these charts:

Left: X of City, Y1 of Population (Hidden), Y2 of CM of Rain (Hidden) Y3: an expression to compute population numbers to rain
Middle: X of City, Y1 of Population
Right: X of City, Y1 of Rain in CM

Now this dashboard tells a story! We can see that even though Denver received the least amount of rain, it also has the highest population, indicating that this city is in real trouble. We can make that correlation somewhat easily by looking at the chart at the right to show rainfall, and the chart at the left that shows us how many people are counting on a single centimeter of rain. A single chart tells facts, but a whole dashboard tells a story.
Dashboard on!

Brad Hines – Sr. Technical Consultant, iDashboards

Bookmark and Share

Before the Browse: Dashboard First Impressions

iDashboards allows organizations to deliver unique experiences to every user – charts and dashboards they get to see and how they can be edited. Too often, though, little thought is given to what users see even before they begin to browse their available dashboards.

A Startup Dashboard is like a user’s homepage – it is the dashboard that is automatically loaded when a user signs in. Since user needs differ, a Startup Dashboard is a personal setting, configured through the User Settings screen.

By setting up a Startup Dashboard, users can save time and clicks, starting their days off more productively. For example, immediately upon login, a CEO could be viewing an Executive Scorecard while an IT Analyst could be focused on Helpdesk Tickets.

What if a user needs to look at three dashboards every morning? There is only one Startup Dashboard, but users can also bookmark dashboards and make use of dashboard launcher panels to have their favorites just a click away.

These are a few different ways to put important metrics in front of the right users faster. What has worked for your organization? Let’s hear it in the comments.

Warren Singh – Sr. Technical Consultant, iDashboards

Bookmark and Share