iDashboards Roadshow Visits 4 Cities for Complimentary Seminars

2015 iDashboards Roadshow

The iDashboards team is traveling to four cities this month as part of the iDashboards Roadshow. Our Roadshow is a seminar that educates business and technology professionals on the benefits of and best practices for implementing and utilizing dashboards.

The iDashboards Roadshow will provide attendees with a clear understanding of how well-constructed dashboards allow users to better monitor, analyze and identify trends in their data. The seminar is free to attend and will include dashboard education as well as a 45-minute presentation on the “Lifecycle of a Business Intelligence Dashboard Project.”

There will also be a product demonstration and a Q-and-A session. One of the highlights will be a customer panel, where current customers of iDashboards provide real world stories and insight into their own experiences with dashboards.

For leaders looking for enhanced ways to make sense of their critical data and drive better business decisions, the iDashboards Roadshow is a perfect opportunity to see and hear firsthand about the power of dashboards. Dashboards help decision-makers understand their disparate data, and this presentation will not only show them how, but also provide real world examples from customers who have experienced the benefits of dashboards.

I’ll be leading the four seminars at the end of this month. We hope to see you at one of our Roadshow stops!

The iDashboards Roadshow will visit:

  • Boston, MA: Hilton Boston Downtown/Faneuil Hall, 8:30 a.m. April 27, 2015
  • New York City, NY: Hilton Times Square, 8:30 a.m. April 28, 2015
  • Philadelphia, PA: Hilton Garden Inn Philadelphia Center City, 8:30 a.m. April 29, 2015
  • Washington, D.C.: Washington Hilton, 8:30 a.m. April 30, 2015

For more information on the iDashboards Roadshow, visit


Bookmark and Share

Meet Your New Favorite Tool: The iDashboards Excel Data Assistant

Sometimes, the data in the Microsoft Excel spreadsheets you’re using to build dashboards just doesn’t flow easily into the charts. In fact, data is often not formatted correctly to be able to build a chart in the manner and the style you are looking for – while at the same time providing the needed functionality. Data manipulation inside the spreadsheet is often required to get the raw scores or numbers into a format that will offer a more complete picture.

In an effort to make data manipulation a smoother and simpler process for dashboard implementation, we are now offering the iDashboards Excel Data Assistant. This new Excel add-in offers customers the ability to do more direct and simplified manipulation of Excel data from any client machine. This means that tasks such as importing data from other formats into Excel, manipulating data and dates, as well as managing Excel named ranges can now be done in a more intuitive manner.


While working with our customers on a regular basis, both on location and over the phone, we are often asked to assist with the process of getting their data formatted correctly to prepare for dashboard building. The iDashboards Excel Data Assistant can help any Excel user make the process simpler, allowing for a more successful and functional finished dashboard.

This tool is now available for download from the OSKAR portal. It can be simply installed on any client machine with Excel already installed by running the downloaded installer and then opening Excel and clicking on the iDashboards tab.

Have you used the iDashboards Excel Data Assistant yet?

Bookmark and Share

Big News for Big Data in 2015


With a growing number of organizations using multiple data sources as part of their daily business, 2015 is quickly becoming the year of “Big Data.” Growth is the only certainty; terabytes are now small change compared to the petabytes and the exabytes (and beyond), so in order for users to structure their own data blends, a slew of new resources are appearing on the market.

Data Visualization
Previously, big data could only be understood (and perhaps appreciated) by data scientists, which left other employees and clients – who also needed to evaluate that information – out of the loop. These earlier tools were also known for being time-consuming to curate while essentially lacking structure. As a result, businesses have been spending copious amounts of time and resources wrestling with data, rather than analyzing it and using it to improve their ROI.

Throughout 2015, data visualization will grow in importance. Creating an intuitive dashboard is an essential next step for sifting through big data, allowing users with multiple professional backgrounds to spend less time preparing data and more time analyzing and understanding it.

Silver Linings on the Cloud
According to a Gartner survey, over 55% of CIOs suggested they would be hosting their companies’ entire group of critical apps in the cloud by 2020. With an ever-expansive amount of data being stored on the cloud, the question of security will become even more imperative over the next year. Traditional security, which is typically complex and buried in your infrastructure, can get in the way of growth or quick, real-time decisions.

Putting Big Data to Work
Up until now, big data has functioned like a chaotic shot in the dark: companies have been virtually grasping at straws in hopes of finding information that is useful. In the coming year, the focus will shift to not only analyzing valuable information, but also on utilizing that information to increase returns. In essence, turning that data into business intelligence dashboards.

With the explosion of the “Internet of Things” (IoT), personal technology will bridge the gap between the company and the client. This will include actionable insights, such as having your SUV send reminders about oil changes, or your favorite vending machine making new recommendations according to your previous choices.

2015 will be less about collecting data, and more about putting it to work.

Bookmark and Share

Higher Education Dashboards Make the Grade for Reporting

iDashboards Higher Education

“Reports” is a vague word these days.

It’s common for administrators at an institution of higher education to inquire about “reporting” tools and their interest comes from a variety of different places. Pressure to produce accurate reports can come from the board, accreditation organizations, system office, Deans, parents, donors or alumni. It also stems from a lack of relevant information about how well administrators have progressed toward realizing strategic planning goals. Many institutions have settled for antiquated tools and methodology, resulting in numbers and information with different versions of the data.

If you were to ask two different cabinet members about the current enrollment this week versus last year, chances are you’ll hear different answers. And, most likely, you’ll hear a number of questions before a shaky answer comes out. “All students or just Full Time? Online learners too? What about our Part Time students? What about Awards or Certificate students? Do we count those as Part Time?”

So let’s fast-forward to the part where it has been determined that “We need insight into our data for better and more accurate decision making!”

Sounds good, right?
The next logical step is that a committee is formed, comprised of executives, data champions, IT & IR, key faculty and additional administrative employees. Many educational organizations want to include opinions and expertise from all areas of campus. It is important to understand who all the stakeholders are and what they want out of the available data.

Still sounds good, so far.
Committees from higher education institutions should address what’s important to monitor, who should have access and what capabilities different people should have with the “reporting” tool. In many instances, IT and IR departments typically start looking in the market for industry leaders and possibly talk to peers in their network about what reporting tools they use on their campus.

Sounds like we are making solid traction, right?
Now it’s time to test the different reporting tools. During product evaluations, the project managers will see many differences in these tools. The most glaring difference is the distinction between “reporting” tools and dashboard tools. Many systems have different core competencies and, sure, there is some crossover functionality, but the truth is that any reporting tool with a charting add-on or component is going to be too limited and won’t sustain heavy editing. Any dashboard tool that claims to have an enterprise ready, ad-hoc reporting tool to satisfy all reporting needs may not be representing itself as accurately as one would hope. A tool that works wonders for one campus might become “shelfware” on another.

What do we need?
It’s all about what your needs require. People use the word “report” interchangeably and it can mean a number of different things. “Reports” could be dashboards, spreadsheets, summarized data, KPIs, or scorecards…

Do you want a 30 second, at-a-glance tool that users can quickly access without requesting anything from IT or IR? Implement a higher education dashboard. Do you want a data analyst to build queries, summarize it and send out those people in a .pdf? Well, a reporting tool might just be a fit. What a number of higher education institutions find is that they need more than one tool in their business intelligence (BI) toolkit. Chances are you need both reporting and higher education dashboards for different users and audiences.

OK, so we need both. Now what?
One vendor will not satisfy an education institution’s needs for predictive modeling, ad-hoc reporting, dashboards, warehousing, data manipulation and so on. Some of the big BI companies claim to have modules to satisfy these needs. After a few years of potentially heavy IT and consultant development, often upwards of a $1M investment, late nights, countless lost weekends and missed deadlines, most higher ed institutions will seek out the specialized tools that focus and deliver on what they do best.

Where do you get your sushi?
I always go to a sushi restaurant when I’m craving spicy tuna rolls. It would be nice if within the same restaurant, my friend could order a top-notch cheeseburger and we could have Italian gelato for dessert. Unfortunately, this magical restaurant only exists in my culinary dreams. The most successful sushi restaurants aren’t the greatest at making cheeseburgers or Italian cuisine. They solely focus on what they do best and perfect it.

The same goes for reporting tools. It makes sense to use an organization for your higher education dashboard and reporting tools that is an expert in the field. It is important to trust your critical data to the masters – quality matters in reporting, just like in sushi. It may take bit of extra attention up front, but using a few different and strategic tools in your BI toolkit will set you up for a successful business intelligence dashboard initiative.

Bookmark and Share

March College Basketball Madness Comes Alive with Dashboard Technology



At iDashboards, we’ve been counting down the days until Selection Sunday and the official kickoff to March Madness. To celebrate the 2015 NCAA Men’s Basketball Tournament, we’re launching our March Madness dashboard on March 16.

The dashboard offers college basketball fans in-depth insight into the participating teams’ statistics throughout the tournament. Some of the stats you can explore include season average points scored per game, field goal percentage, free throw percentage, three-point percentage, blocks, rebounds and more. We also feature an interactive map illustrating where each team’s school is located, and graphs displaying total wins versus total losses during regular season play.

Our complimentary March Madness dashboard offers sports enthusiasts a really fun and unique way to enjoy every game throughout the tournament and get into the statistics on a deeper level. We create the dashboard annually and think it’s a great way for fans to understand the power of data visualization and the ability drilldown into critical data. Just like dashboards can help you make better business decisions, they can also help you make better bracket decisions for March Madness.

March Madness fans can access the dashboard for free at beginning March 16. Stats and data for each team will be updated throughout the progression of the tournament.

What team are you rooting for during March Madness?


Bookmark and Share

Are You Experiencing Smartphone Dashboard Overload?


Data visualization dashboards have a lot of uses for different situations, but the goal is always the same—to provide insight into key data at-a-glance, with the ability to drilldown into the details as needed. For example, think of the information that is important to you personally.

The dashboards that I use most often are actually on my smartphone. A dashboard is, after all, a place to show the data that is most important to you and that is what my cell phone screen does. My smartphone (after much trial and error) has two screens and three dashboards that show me information I have identified as important for my day.

My first two smartphone dashboards show sports scores, family events, birthdays of friends and more. The third one, however, is my notification center, which alerts me to new emails, missed phone calls, date, time, weather and more. This allows me to take immediate action based on what I see. For instance, when I look at the notifications on my smartphone dashboard and see the weather, it helps me decide if I should wear a polo shirt or a sweater.

Much like I condensed and organized my smartphone dashboards based on what information was most important for me to see at-a-glance, business decision-makers need to decide what data is most important for them to see in a dashboard. We have all kinds of data from many different sources available to us. We need to decide what the focus of each dashboard is. Once we decide the focus, we will be able to figure out the information that means the most to us.

What data will help us make the best business decisions? We probably do not need to know all the details of every appointment we have, but rather just knowing that we have things planned is good enough. We can always drilldown into enhanced details when we need to.

So, the next time you are looking to build a dashboard, just think to yourself: what is going to help me make the best business decisions? After you decide what data you would like to see, think about what the story it is telling. If the story makes sense, can you get to the details, or data, that make that story? If so, it sounds like you have a great start to a very powerful dashboard.

Have you created smartphone dashboards? What stories do you tell on your mobile device?

Bookmark and Share

Why Use Healthcare Dashboards to Track Data?


The healthcare industry is increasingly dependent on accurate, timely data in order to meet government standards and work towards improvement goals. Many hospitals, surgical centers and emergency services providers have unique needs and a complicated organizational structure, which means there are many people who need to understand many different sets of data.

Risk management and service quality are considerations with uniquely serious ramifications in the health care industry. The stakes are high when it comes to patient outcomes; and with compensation tied directly to certain industry key performance indications (KPIs), there is a vital need to provide practitioners with rapid and actionable insights.

There is no shortage of data in the healthcare industry. But there is a shortage of understanding and contextualization of the data being collected.

How can we help find the important connections that exist between disparate data sources? How can decision-makers at healthcare organizations drilldown into their data more efficiently and effectively to make better business decisions?

Healthcare dashboards provide a visual centric method for contextualizing data, increasing the visibility of and emphasis on KPIs while promoting transparency within a hospital of healthcare facility.

Examples of healthcare dashboards we have designed for clients and metrics measured include:

  • Clinical Dashboards can be used to measure nursing unit censuses, current patient loads for emergency rooms and bed occupancy rates. These dashboards can also help you track public health outbreaks, like the current flu epidemic, to better plan staffing needs.
  • Hospital Dashboards assist your organization in tracking admissions and ER wait times. These include dashboards that highlight departmental spending, quarterly income and cost of care, helping everyone in the hospital work toward financial goals.
  • Patient Dashboards make it possible to see the average length of stay for patients, total numbers of current patients and lab turnaround time.
  • Physician Dashboards can help physicians track their number of patients, patient satisfaction and number of new patients, all in real-time.
  • Quality & Risk Management Dashboards can help monitor and simplify complex compliance issues. These dashboards assist you in managing core quality metrics, patient safety data and comparing internal performance versus industry benchmarks.

By implementing data visualization healthcare dashboards, employees in various positions can all access the same data and understand how it affects their department. In a complex industry like healthcare, being able to make more informed decisions is a vital part of a successful business strategy.

Bookmark and Share

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

iDashboards-Business Intelligence -vs-Visual intelligence

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.

Data Source Connectivity

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 data source 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 source 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 unique dashboards that fit 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