For a long time I've been working with PowerPoint for presentations and dashboard wireframes. I even rebuilt the 820 grid for web design in PowerPoint, which is why the Duarte Slidedocs style really appeals to me. In practicing this style, I've tried translating some infographics samples that I've found around the web using this format with native PowerPoint objects. Furthermore I've attempted to make as many elements data driven as I could.
Read on for some tips and to download a copy of the file.
Creating simple dashboards with Tableau is very fast and easy. I'm trying to understand the full limits of more customized dashboards compared to what I would have done in the past with Xcelsius/SAP Dashboards or even Excel. Today I have finally recreated my career path dashboard on Tableau Public, and I admit that it was a bit tricky to build the 30 different parameters into the one skill chart on the bottom right.
Click the image above or the following link: http://public.tableausoftware.com/profile/#!/vizhome/CareerPath_0/CareerPath
Now that I'm working with Tableau on a regular basis at work, I've also decided to recreate my existing dashboard examples so I can better understand the exact differences (pros/cons) between Tableau and SAP Dashboards / Xcelsius. This first posting on the topic covers the simple mobile sales dashboard that I originally posted about here.
The main point of this exercise is to leverage design elements from PowerPoint to create a more polished looking dashboard on a mobile device. I experimented with the new transparency options in Tableau 8.1, but found that my dashboard would crash when trying to layer transparent sections over graphics in the dashboard. Trying an alternative approach, I used version 8.0 and just set the backgrounds of each section to match the image.
I had to make a page for each KPI (budget, actual, variance) because putting them into a single table wouldn't show correctly over the graphic bubbles. Other than that, it was much faster to build this dashboard in Tableau and the separate pages wasn't much of an inconvenience. I was also able to use the x/y positioning and exact sizing of elements to make sure that they were all aligned correctly and easily.
The 'sales rep' quick filter at the top adjusts all of the numbers, and the entire dashboard is mobile ready by default... so I'm pretty happy with the outcome on this one!
Today I'm going to show you a slide-out menu using the Inovista component suite. One key thing to note is that many of the 'mobile' components can add good value to your desktop dashboards. In trying to review what I've done in this example, I've found that there are a lot of details, so I'm going to summarize the process and provide the source file.
You can view this on the iPad by downloading the 'Dash Reader' app from Invoista. Then you load this URL. http://data-ink.com/dashboards/dashboards.xml
Click on the image to see the desktop version in action.
I've had a request come in to see how to make the flat UI style tabs that are used in my Balanced Scorecard dashboard. Here is how you can make those tabs by layer core out-of-the-box components.
Some dashboards have a lot going on and maybe a simple loading spinner doesn't cut it. One solution would be to use a loading bar. If you have several queries, you could count the number of them that have returned data to update the overall progress. Or, if you know roughly the speed to update the dashboard, you can just ballpark the loading progress using the SAP Dashboards / Xcelsius history component. Want to know more?
I've had a number of people reach out in response to my teaser post about the capabilities of Inovista add-ons. Before I jump into things like the concept of sliding panels, we need to cover some of the basics.
If you are going to invest in the Inovista add-ons, I highly recommend that you get the full developer suite for $999. Remember, this is only required for the developers and not the end users, so it grants a lot of extra features without being a big deal if you have a couple hundred end users. Usually I recommend that organizations have at least 2 licenses because everyone needs a back-up. If you end up building a lot of mobile dashboards with Inovista, they have another option that allows you to package your own apps. I haven't reached that point myself, but their mobile app reader is a great way to get started.
Here are some of the packages in the suite:
- Advanced Shapes
- Mobile Components
- iOS Components
- SVG / Image Controllers
- Inovista Mobile Charts
- Inovista Grids
- Inovista Microcharts
My friends over at InfoDiagram let me know that they have some PowerPoint holiday icons (not to mention other great stencil & icon sets). If you want to download these holiday icons for free, you can use the coupon code: JoshWishesHappy2014 here: HOLIDAY ICONS
Continue on to the post if you want to try out my cheesy animated tree-trimming dashboard!
In looking to improve the quality of my Xcelsius/SAP Dashboard data visualizations and incorporate UX in line with current web trends, I have been working with Inovista over the past few months to better understand their add-on suite. I would say that there is a lot of power here, with many hidden gems. The mobile options hold some cool tricks, and you don't have to be using their mobile stand-alone app to enjoy the benefits.
While my personal specialization is in dashboard design and data visualization, I'm finding that there are a lot of tools and options to choose from. Although I have focused on several of these, it is important to understand the overall market trends and the benefits/comparison to the alternatives. Gartner's 2013 BI Magic Quadrant is a great place to start, but I thought it would be interesting to take a look at the corresponding job market for some of these tools. To accomplish this analysis, I used the trends feature on Indeed.com. For a current snapshot, the following chart shows the number of listed openings by term searched. I'm sure that there are duplicated positions and such, but it gives us a nice order of magnitude demand for these skills. The accompanying comments and opinions below are my own.