Keep Calm and Chart On

I’ll let you in on a secret. Your charts don’t have to be perfect. There, I’ve said it, so now you know. Go forth, build charts, and let me know your thoughts in the comments.

Oh, you are still reading? OK, let me explain. Charts and dashboards should evolve, so don’t spend too much time worrying about Version 1.0. When you are prototyping quickly you don’t need to worry about creating the perfect charts, layouts, or colors on the first try. As your data comes to life with visual dashboards, your storyboards can and will change. If storyboarding was a one-shot deal we would carve them in stone instead of drawing them on whiteboards.

“Save As” is my second most-used feature in iDashboards (my favorite is the “Preview” button, which lets me test design tweaks on the fly). Every time I train new users, I compare iDashboards to a digital camera. Years ago, you had to worry about the cost of film but with a digital camera, you can take as many pictures as you like. With iDashboards you are not paying per chart or per dashboard, so make as many as you like! When you are done, you can go back and delete any charts/dashboards/pictures that you really do not need.

Saving multiple versions of dashboards and charts is a key part of my workflow, and I highly recommend the same for yours. Whether it’s trying out different layouts or overhauling existing dashboards with new metrics, it’s always good to keep backups of your older designs. Select “Save As” from the right-click menu, and simply increment the version number of your dashboard or chart. You never know when you might show off a new design to your end users and they say “Oh you know what, the old version was better.” If you overwrote it, you might have to rebuild it from scratch! Of course, not every change has to be versioned; you can make a judgment call on how significant the change is.

I always remember the user who added a version number to his first practice dashboard, not as ‘v1’ or ‘v01’, but ‘v001’. Seeing my confused look, he said, “I know I will make that many versions!” It may have been overkill, but he definitely had the right attitude from the start. Don’t be afraid to make new charts, and don’t be afraid to try new things.

In the future, we will share other design tips, tricks, and shortcuts to simplify your dashboard development. In the meantime, Keep Calm and Chart On!

Warren Singh- Technical Consultant, iDashboards

Bookmark and Share

Cascading Parameters Solution

The new drilldown type “Dashboard Parameters” in v8.0 will allow a chart type to pass parameter values to every other chart on the dashboard if it is designed to do so. Subsequently, this allows use of a ViFrame chart for nothing more than to contain pivots which cascade values. For instance, if a dashboard has two fields (Brand & Hotel), each with a pivot, as the end user selects a Brand from the first pivot then the second pivot will only show Hotels in the Brand selected.

I have set up a simple example with only two fields in which both are pivots (Image Below). One key thing to keep in mind is that this is limited to 3000 records, so take note that there is a count in order to return distinct combinations of the values. Also, please note that the “Update Button” is merely an image used to execute the drilldown, this means that a person could create their own descriptive button if they would like.

In looking at this dashboard, a few other things are apparent that may not have been seen before such as Color Range Sets on a ViFrame. Please feel free to take a look at how it is configured with expressions.

There are many commonly requested features that have viable solutions with a bit of creativity. Many of these solutions have been posted in articles on the iDashboards Support Portal – commonly known as OSKAR. If you have not yet logged into OSKAR, I highly recommend that you do as you may find solutions that address your needs.

Zach Breimayer- Technical Consultant, iDashboards

Bookmark and Share

Calling All Hoteliers: What is your data doing for you?

I recently returned from a trip to Minneapolis after attending this year’s HITEC show. As an HFTP member (Hospitality Financial & Technology Professionals), it’s always a pleasure to connect with peers and discover what they’re doing at their properties. However, I couldn’t help but notice one underlying and unfortunate vein that ran through almost every conversation I had: “Tom, my company generates an exceptional amount of data, but that data is un-centralized and often inaccessible. I’m swimming in a sea of numbers!”

Within hospitality and lodging/resort management in particular, there is an overabundance of systems which collect and generate data (PMS, POS, CRM, ERP, etc.). However, there is also a concurrent and perplexing lack of systems which will centralize data and facilitate data-driven decisions. Perhaps that’s because no one has taken the time to pioneer such a product, or perhaps, within this arena, the necessity for data to be integrated is so crucial that it’s been too intimidating for anyone to approach. My guess is the latter, and it’s time that changes.

Let’s assume the role of General Manager to explore this further. As GM, it’s not only my responsibility to ensure that day-to-day operations are carried out, but also ensure that my property remains solvent and my brand image is carefully and meticulously maintained well into the future. In order to do that effectively, I need data – data that tells a story. Let’s say that RevPAR is below my benchmarked goal. Do I drop my ADR? Generally, we want to avoid that and find alternative, more creative ways to increase occupancy percentage. But how possible is that if I can’t see data from all areas of my property’s operation? Maybe the best approach would instead be to increase awareness of my property’s additional offerings. Example: Has the spa been fully utilized? Is there an area of my customer base that has not been properly marketed to? Are there untapped revenue streams I could be accessing?

The fact is that within hospitality, we don’t just have data, we have lots of data. That data, however, when put into the right hands and with the right system, can translate to effective and efficient decisions. That’s where dashboards come in. While dashboards aren’t a genie in lamp (although the best dashboarding software will allow you to run predictive analyses), they will provide a way to quickly and easily integrate data from all areas of your company so that even the smallest of decisions in any area can be evidence-based and tied directly to the company’s (rather than just the department’s) overall direction and goals.

You wouldn’t build a hotel without a front door, would you? No one would be able to get in. So why should you build a data system without an efficient means for accessing and understanding what happens behind those doors? Within hospitality, everything we do comes down to one factor: the guest experience. It’s time we make our data just as focused. It’s time for dashboards.

Tom Butler Cloud Account Manager

Bookmark and Share

Identity Theft

Just a few weeks ago, you may have been known as the resident “Dashboard Designer”. But with the launch of v8.0, your identity has been stolen by a feature called “Dashboard Designer”. Sorry for the late notice if you’ve already ordered new business cards but you are now a “Dashboard Builder”.

Before iDashboards v8.0:

Dashboard Designer = You

After iDashboards v8.0:

Dashboard Designer = Feature

Dashboard Builder = You

The Dashboard Designer is a new and extensive environment offered to end users who want to make changes to the appearance of a dashboard. If you’re already an iDashboards user, you can read up on the details in the updated product documentation. However, I’ll provide an overview of our new frame borders. Frame borders are no longer a technical necessity, but rather an artistic accent. Look at the before-and-after screenshots below. Prior to v8.0, it was a strong suggestion to turn off the visibility of frame borders because they revealed the details how the dashboard was constructed. Now, we have the ability to leverage the frame borders with a variety of colors, thicknesses, and transparencies to further enhance the appearance of the dashboard. The screenshot taken after v8.0 is using a wider (20) frame, set to 100% transparent so the background picture is more prominent.

Here is a cheat-sheet of the different features within the Dashboard Designer. All of the buttons and features have mouse-over descriptions to help you learn the new layout.

Well, I hope you don’t mind your new job title after seeing your replacement. Think of your new title as a promotion!

Ken Rose - Technical Consultant, iDashboards

Bookmark and Share

April Data Brings May Dashboards

We live in a world of clichés and sayings. I spend over 50% of my time travelling to customer engagements and I hear a lot of regional sayings while teaching people how to visualize their data with iDashboards. And, I recently realized that a saying that is so relevant in my Midwest home this time of year – “April Showers bring May flowers” doesn’t apply in all the different locales where I travel. Plant life is alive and kicking without any April showers in Southern California or Georgia. When I made the statement “April showers bring May flowers” to a group I was training in Southern California I quickly realized they had no point of reference to understand what that meant, because as native Californians they had only seen real showers in early February. And, those showers didn’t seem to result in flowers, the way one begets the other in the Midwest.

So, I realized I needed a new universal cliché to “break the ice” (another cliché…) with the audience I was training. I decided to use a recurring statement I make during training – “It’s all about the data”. Sure, I feel like iDashboards visualizes data better than anybody, but without the data, we’ve got nothing – “It’s all about the data”.

On a recent engagement, a CFO came into the training room and expected to see his investment in dashboard technology pay off. After realizing the data analyst had not prepared the appropriate data to show the CFO any dashboards, I started to put together some staged data, just to show him what we could do if we had the data. He was not impressed. He did, however, acknowledge my comment as he was walking out of the room “It’s all about the data”. Regardless, he was not impressed. However, two days later, at the end of our engagement we were able to show him significant dashboards with his data. He was impressed. I thought to myself “It’s all about the data”. And then I thought, maybe I should trademark my ‘go to’ saying. “It’s all about the data”. Next up are Tshirts and hats. I’ve got big plans.

And, now during my engagement this week my saying has become cliché. How many times have I said “It’s all about the data” this week looking to get acknowledgement, looking for someone to latch on to my soon to be trademarked saying and tell two people, who would tell two more, and so on and so on? As I pondered my floundering soon to be fame, I thought back to the time when I said “April showers bring May flowers” and how that emoted the same empty response from my Southern Cal as my new cliché. And once again I found myself in search of a new catchy ice breaking cliché.

Maybe I need to borrow another cliché and adjust it slightly for the dashboarding environment. Maybe “April data brings May dashboards”? Not catchy enough. Maybe I just need to make my saying more rhythmic, maybe something that rhymes like “showers” and “flowers”. What rhymes with data? Beta? Hmmmm.

So, I’m setting out on a mission to create my next catchy cliché – something that everyone training to create dashboards can relate to.

Here’s a few that I am considering…

“There’s not a custom SQL chance in Excel”.

“You have to grab the bull by the column headers”.

“You have to take it one chart at a time”.

“A picture is worth a thousand lines of data”.

“The early chart gets the data”.

“Let sleeping data lie”.

“Life is a bowl of chart types”.

OK, ok, enough. I’ve got to wave the white chart background here. I think I’ve dug myself into a drilldown. I guess if I can’t stand the heat I better stay out of the dashboard designer…

Jerry Stowe – Technical Consultant, iDashboards

Bookmark and Share

Data ≠ Wisdom

“Data is not information, information is not knowledge, knowledge is not understanding, understanding is not wisdom.” – Clifford Stoll, famous author and astronomer

So what’s the trick? How do we turn data into information and ultimately into wisdom?

We could collect as much data as possible and load it into spreadsheets, but then what? It’s astonishing how easily accessible our data is yet, the relevant information is often overlooked. Have you ever heard the phrase “work smarter, not harder”? Well, that’s exactly what we want to do with our data. We don’t need to waste our time monitoring every indicator, rather we should focus on the essential metrics that affect our performance, quality and profitability.

Storyboarding is a great way to break down your key performance indicators (KPIs) and determine what metrics need greater attention. Let’s say you’ve already went through the storyboarding process and your KPIs have been chosen wisely, but the data still doesn’t translate correctly. This could be explained by a disconnect in data sources, outdated reports, data collusion or numerous other factors. A way to resolve these issues is to implement secure dashboards that unify your data into concise interactive dashboards. Color coded spreadsheets can shed some light but dashboards can bring life to flat reports, connect your data sources, and drilldown into specific KPIs to discover correlations enabling wise, informed decisions based off your data.

Check out the Planning your Dashboard Project Whitepaper for more information regarding KPIs, storyboarding and dashboard implementation.

Alicia Sasse- iDashboards

Bookmark and Share

“Black Swan”

I’m about half way through a book right now called Black Swan, a book that explores the unknown, the uncertain, and the unexpected. I personally find myself fascinated by mankind’s inability to ever fully comprehend the complexity of a situation, not to mention the ramifications of the decisions we make. It’s an odd concept to step back for a moment and try to think about the results we expect never take to place. How can we be expected to know the unknown, expect the unexpected?

It’s almost an oxymoron, except that often times it’s our own fault. Failure can’t be placed entirely on the inability; we have to start accepting that a lot of what we don’t know is our own fault, our own inability to spend the time and resources analyzing the less obvious. Its not as if we begin things expecting catastrophic events to transpire; wars to erupt, businesses to file for bankruptcy; yet these are issues our civilization has dealt with throughout history and we still choose to assume it’s not going to happen again, not going to last, or at the least be different this time.

Surely there have to be signs in the world, signs we’re ignoring, things we aren’t paying attention to. While we’re busy paying statisticians to conduct polls or collect sample data sets and studying the obvious, we’re also busy ignoring the outliers and casting aside the statistically improbable; the numbers tell us the odds are not in their favor. Yet every catastrophic event could likely be tied to some analysis somewhere that stated that event was an outlier and had little merit, if any. Working in the Business Intelligence space, where quite literally people are trying to anticipate results, has provided a unique opportunity to weigh the “Black Swan” against exactly what it is myself, and our customers are trying to accomplish.

This narrative simply put, is an opportunity to make you think. Not about the obvious, certainly not about which software to buy or what decision to make next but instead to think about what you aren’t thinking about. Take into account the unexpected for a moment, look at something you wouldn’t have otherwise given a second thought to; perhaps the recognition isn’t the same for averting a disaster no one ever knew about, but in the end what’s better, disaster with recognition for repair OR the silent truth of knowing you saw what no one else did and got it right when it really counted?

Jason Wolan- Professional Services Manager, iDashboards

Bookmark and Share

“Let’s increase the sales, better serve customers and bring efficiency. Yeah right!”

If you are an executive in today’s ever-changing technology environment, it is likely that you are often faced with questions such as, “How will we stay on point with the strategic plans and keep customers happy? Of course businesses know about the social media buzz, but another popular tool that helps businesses achieve tremendous results is dashboard technology.

Over the past several years, dashboard technology has matured and is ready to serve the market demands. Dashboard technology has been proven to be of immense value with great ROI in various sectors such as Finance, Manufacturing, Government, Healthcare, High Tech and so on.

On my recent engagement with a company, I worked with a marketing department and its executive team. Together, they strategized a plan to increase value for customers, create new ways to engage customers, and strengthen the revenue model with minimal impact on the existing business processes. The team came up with a solution to provide a dashboard to the customers. This dashboard would provide various metrics in an easy to understand format. Customers no longer needed to sift through multiple systems to track various aspects of the business viz. sales, billing, usage, tech support etc.

Simple dashboards for customers provide a differentiator from the competition. The marketing and sales team was able to leverage it by winning new business and greater loyalty from existing customers.

The simplicity of the dashboards brought greater value to their customers. The dashboards not only simplified the overall picture for the customers but it also enforced the internal teams’ procedures to align for the single customer entry point into the system through the dashboard software. Teams are now more aware of the impact of their individual performance in relation to the overall impact.

When the dashboard technology is applied, it can certainly produce results.

Do you think dashboards technology can help your organization?

Zahid Ansari – Principal Consultant, iDashboards

Bookmark and Share

Going the Extra Mile

It seems like wherever I go on my engagements, my clients are really excited about the fact that they are going to be able to use a “state of the art” dashboard development tool. Typically, an engagement starts out with what is called “knowledge transfer”, which basically means that I show the clients a number of things: how the dashboard building process works, what the available functionalities are (e.g. interactive intelligence and input parameters) and what kind of chart types come with the product. There are also hands-on workshops that give the clients the opportunity to familiarize themselves with the product and deepen their understanding about the product.

Now, depending on the type of engagement, there is usually additional time for dashboard development. The idea here is to storyboard out how the client’s data could be visualized with the product and then to actually build dashboards. In some cases, data is available but there are also instances where the clients have an idea about the metrics, but the data is not ready (e.g. missing database views). In those cases mock data can be used to develop dashboards. This is really not a big issue because once the “real” data sources become available, connecting existing dashboards to those data sources can be done with little effort.

From what I have described so far, it is obvious that there is some effort required by the client during an engagement. The ultimate goal here is to put them into a position where they are able to build dashboards without any further guidance and I can honestly say that goal is reached by the time I leave the client. But what I wanted to point out, though, is the fact that I don’t want the client to be already content with what they have built so far. I don’t want the client to stop there, I want them to “go the extra mile” and explore the different options that the product offers. If time was already invested in understanding the product and building dashboards, why not spend some more time to “perfect” the dashboards? Why not use different colors than the default colors? Why not use different chart types and not always column charts? Why not use available functionalities like interactive intelligence to make the dashboards more interactive? This may very well be the difference between “ordinary dashboards” and “extraordinary dashboards”!

Aziz Sanal – Technical Consultant, iDashboards

Bookmark and Share

Dashboards for HR Professionals: Embrace the Performance Reality

Embrace the performance reality; you have seven minutes to leave a lasting impression.

I think all HR professionals would agree that in today’s business environment, there is an ongoing challenge to transform the perception of the human resources department from a cost center to a strategic partner within their organization’s leadership team. HR is consistently being challenged to increase their impact through metrics to improve the productivity of the organization’s workforce. The human resources’ function can have a significant impact on a business’ day-to-day performance. Business leaders understand this and that measurement is the key to improvement.

In order for any HR professional to be successful in making their functions’ perception transform from a cost center to a partner, it will require them to demonstrate the ROI achieved as a result of their efforts enabling secure buy-in from all parties. They will need to be part “statistician” and part “story teller”. As a “statistician,” they must leverage the vast amount of data sources available to define and measure the HR metrics which align with their organization’s business goals. It’s not surprising that organizational leaders are moving more C-Level executives from finance into HR, based on the need for metrics and the strategic interest to collaborate the two departments. Equally as important, the “story teller” skill set within the HR professional will recognize the need to frame the information into a very simple, easy to consume, format. The leaders at any time can then take a quick pulse on their company’s most important asset – their people.

Compounding this challenge is a rapidly changing technology landscape, ever increasing volumes and complexity of data, and continuously changing business strategies. Since these factors are in a constant state of flux, it is critical to maintain perspective by collaborating outside of your organization to leverage best practices and benefit from others’ experiences. This can lead to greater insight in navigating new technologies, discovering new approaches to managing data, or finding alternatives on the best method of relaying the metrics that matter most to your organization.

Dashboards can serve as an excellent means for HR professionals to report important metrics to their executives in snapshot format with an interactive experience. Dashboards can read like scorecards, providing a graphical representation of the current status as well as historical trends. The power to leverage the forecasting analytic capability of this reporting tool has proven very useful to express the possibilities to leadership in planning for the company’s future success. However, it’s critical not to overlook the importance of the mechanism in delivering these metrics as this will significantly contribute to the elevation of your function as a strategic partner to supply perspective within the organization.

My introduction to this entry, “Embrace the performance reality; you only have seven minutes to leave a lasting impression,”was a result of a takeaway from a book about public speaking written by Susan Weinschenk, 100 Things Every Presenter Needs To Know About People. During a presentation, a person’s attention span is generally seven minutes. If the audience is not engaged in the topic, the attention span can be even less. It’s not always obvious when an audience’s attention span may be waning. As a presenter, you need to be aware that you are having a very different experience than your audience.

Dashboards provide the “Wow Factor!” when delivering the key HR metrics portion of your story to the audience and allow for flexibility within your presentation. You can deliver short, quick concise bites that can be easily digested by your audience or examined at their convenience with a deeper dive, should they want the full course meal. Dashboards are the preferred muse of HR professionals as they cater to the appetite of any stakeholder within an organization. Aside from their ability to gather information from disparaging data sources and make it readily available in a very user friendly format, the dashboards resonate and command respect. The inherent nature within all of us is to have information on our terms. We all want what we want, in the way that we want it, and more importantly, when we want to have it. Having the discernment to make information readily available to those challenged with the seven minute attention span, and doing so in a way that accommodates the needs your audience, is the key to HR professionals securing their proverbial seat at the strategic partner table.

Michael Carlesimo - Account Manager, iDashboards

Bookmark and Share