Freakalytics®Practical Analytics for Better Decisions |
|
Who said that analytics can’t be a fun way to start your day? Tableau animated our dashboard at http://www.freakalytics.com/snp-pub-freak/ and set it to the music of Journey! Awesome job Tableau and a great way to kick-off the conference!
Click here to watch the video!
Add Your Comment HereThe following article features Tableau 6
Whether you are exploring your data for new insights, answering specific questions or even deciding what questions to ask, Tableau gives you unprecedented control to investigate, communicate and take action with the valuable information hidden in your data! Tableau has it all – a wide variety of options to graph your data, the ability to adjust your data so that you are using the right data in the right form for the questions at hand, and a user-friendly interface that’s designed around how people think about analysis, allowing you to follow your thoughts as you question and explore your data. You can work with every major data source, from Excel workbooks to the largest databases. You can even extract data from larger sources into a local “extract” file that will make your data exploration more efficient and allow offline analysis when you are away from the office.
Profit and planned profit by product
Red is below plan, green is above
Percentage is actual versus plan
Black line in 2010 shows prior year profit amount
Displaying profit versus sales by region and customer segment Average profit ratio = size of bubble;
Minimum and maximum percents labeled per region
Colors are customer segments
We just launched a new website to share analysis of this critical topic at http://www.usdeficitstats.com/.
TWB - Tableau WorkBook file 
1) A text file, to be more specific, an XML file, which is a highly structured text file that contains
a) Data connection information
b) View layout definitions
c) And thumbnails or snapshots of each view
TWBX – Tableau packaged WorkBook file
1) Everything contained in a Tableau WorkBook file
+PLUS+
It is fascinating how much information you can uncover with just a few years of price data in Tableau. In this example, we use just two data items to examine the history of Netflix stock price (NASDAQ NFLX.) The data items used are date and closing price, adjusted for splits.
→ 2 Comments- Add Yours
A complimentary preview of the 1st two chapters, the table of contents and the book index is available for download here.
NOTE- the book is now available at Amazon, after correcting logistical issues.
Rapid Graphs with Tableau Software 6 is now available for purchase on Amazon in print and in e-book format for Kindle readers – on the Kindle device, PC, Mac, iPad and iPhone! Note that the print version has slightly better layout and readability due to the graphic-intensive nature of this book and the automated layout of e-book readers. This e-book is published in color for Kindle users on the PC, Mac, iPad and iPhone. Kindle device readers may have difficulty interpreting some of the graphs due to the native black and white reading experience.
This update from the 1st version of the book required changes across nearly every page and significantly expanded the size of the book with coverage of many new features added- both from Tableau 6 and earlier releases. Other additions include an index and expanded examples in several chapters.
Comments OffA Marimekko chart created in Tableau by Joe Mako, inspired by Jon Peltier
Joe Mako recently created a Tableau version of a Marimekko chart inspired by an example from Jon Peltier, an Excel charting expert.
When I first saw this chart, I was curious as to the utility of this chart type for regular business decision-makers. I agree that for advanced analysts, it can offer a compact, contained means to present information across two categorical items (dimensions in Tableau) and metric (a measure in Tableau.) You can see this in the Marimekko chart created by Joe Mako in the left half of the dashboard below. When you examine the Marimekko chart you can see the dominant cities and the relative share of each segment within each city. You can also select the city names above the view to highlight a specific city. For example, you can easily discern that Almond Lovers are the biggest group of customers for this company and Delicious-n-new are the smallest group.
However, it is somewhat challenging to ascertain within Gainesville, FL which segment is the largest and smallest for this city. If you hover over each Gainesville, FL value in the original chart, you will see that two segments are identical in size; this is very hard to see without the hover values. This is due to the varying width and length dimensions for each tile in the chart.
After considering this interesting example,
Read the rest of this entry »
Growth rate
Winners- Microsoft, Oracle and IBM
Laggards- SAP and SAS
Market share
Winners- SAP, Oracle and SAS
Laggards- IBM and Microsoft
Growth combined with market share (using three-year ranks)
Winners- Oracle, SAP and Microsoft tied at 2nd
Laggards- IBM and SAS
From the recent Gartner press release, “There was little change year-on-year in terms of vendor rankings. SAP remained the No. 1 vendor in combined worldwide BI, analytics and PM software revenue in 2010, accounting for 23 percent of the market (see Table 1), followed by Oracle, SAS Institute, IBM and Microsoft.” I find this fairly interesting since the vast majority of companies I work with all cite Excel as the most frequently used analytics tool, by a long-shot. For more details on this thought, please review our second analysis that includes Excel in the “Analytics” market.
 |
 |
Without further delay, here is a dashboard summarizing the results, we have added data from 2008 for additional context and insight.
Add Your Comment Here
Follow Freakalytics on Twitter
RSS for Freakalytics.com
RSS for new course registration alerts
