To test my Tableau knowledge, I attempted the Tableau product certification and got the “Tableau Desktop 8 Qualified Associate” certificate.
Take a look at the following chart, do you see any issues with it?
Notice that the month values are shown as “distinct” values instead of shown as a “continuous” values and it misleads the person looking at the chart. Agree? Great! You already know based on your instincts what continuous and discrete values are, it’s just that we will need to label what you already know.
In the example used above, the “Date & Time” shown as a “Sales Date” is a continuous value since you can’t never say the “Exact” time that the event occurred…1/1/2008 22 hours, 15 minutes, 7 seconds, 5 milliseconds…and it goes on…it’s continuous.
But let’s say you wanted to see Number of Units Sold Vs Product Name. now that’s countable, isn’t it? You can say that we sold 150 units of Product X and 250 units of product Y. In this case, Units sold becomes discrete value.
The chart shown above was treating Sales Date as discrete values and hence causing confusion…let’s fix it since now you the difference between continuous and discrete variables:
To develop effective data visualizations, it’s important to understand the data types of your data. In this post, you saw the difference between continuous and discrete variables and their importance in data visualization.
I attended “Enabling Familiar, Powerful Business Intelligence“ hosted by PASS BA VC last week & I got to listen to Microsoft where they shared their vision for the BI space, so I thought of posting this quick note about it:
“Corporate BI” has been around for may years. This space has established players like Microsoft, SAP, IBM, Oracle. But in recent times, “Self Service BI” space has been gaining momentum. Players like Qlikview & Tableau that lead the Self Service BI space have been ranked as leaders in the Gartner 2014 magic quadrant. Microsoft has also been making serious advancements in this space since last few years & with their latest offering called “Power BI” they have shown that they putting their bets on Self Service BI space. So, as Microsoft said in the event, they view themselves as the only player that offers a full suite of Corporate BI as well as Self Service BI:
you can watch the recorded session here: http://www.youtube.com/watch?v=0yKhxSPlykg
Here are my notes from the Atlanta BI user group that I attended today:
Topic: Head-to-Head on Maps: Mapping Twitter in Tableau and Power View
|Setup/Installation?||Office 2013 [Professional Plus editions], SharePoint 2010 onwards [Enterprise Editions]||Public, Online, Desktop, Server|
|Licensing||Get applicable office/SharePoint license||Tableau Public is Free.Tableau Online is $500 per user/year.
Tableau Server has Per-User or Per-Server-Core model
*Note that if you’re using Tableau server’s per-user model the cost is $1000 per named user/consumer (min. 10 users) and $2000 seat for 1 developer.
**Contact Tableau Sales. Please don’t evaluate the product based on the information provided here as the information might change in future
|Data Sources||[SharePoint] Power Pivot Model, Analysis Service Cubes[Excel 2013] You can connect to data sources that excel supports and then create power view report on top of it.||Tableau Public Supports Excel, Access & Text filesOther version of Tableau can connect to a variety of data sources.|
|Product Category||Ad-hoc reporting a.k.a Self Service Business Intelligence||Ad-hoc reporting|
|Ease of use||easy||easy|
|Custom Shape Files||No||Limited|
|Product maturity||Power View is new to the game||Tableau is a leader in data visualization space|
|Additional Notes||Power Map is an add-in by Microsoft that focuses on “Mapping”. It’s part of the newly announced Power BI suite.||–|
Data cleaning is a major part of any analytic’s/data-visualization undertaking. If data cleaning is ignored then it leads to inaccurate data reporting & thus suboptimal business decisions.
To that end, if you create a Tableau’s Geographic map, please check the accuracy of your data by going to:
Menu Bar > Map > Edit Locations
Let me give you some examples:
Now, I have “states/province” as my geographic role for the variable and when I created a geographic map, I created a geographic map it didn’t show any state for New York State! See Before:
So what did I do?
I navigated to Menu bar > Map > Edit locations:
So I fixed it!
In the past, I’ve also have entered Latitude & Longitude if need be. This is when it was not able to recognize few US cities and it was saying “ambiguous” – I inputted Latitude & Longitude to clean the data:
In this post, I described how you should check the data accuracy of a Tableau Geographic Map.