Milwaukee Tableau User Group (TUG)

Milwaukee area Tableau users,

Good news, the Milwaukee TUG returns next week with another event!  Come one, come all on Thursday, May 11th from 1:00 P.M. - 4:00 P.M. at Johnson Controls in downtown Milwaukee. 

This quarter the group will be doing a live Tableau session, so be sure to bring your laptop.

The address is: Johnson Controls, 507 E Michigan Street, Milwaukee, WI 53202

If you would like to register for the event you can do so at the link below.

https://www.eventbrite.com/e/q2-2017-milwaukee-tableau-user-group-tickets-31486107796

See you there!

Author: Chris Bick

Business Intelligence and Analytics Symposium Wrap-up

The fourth annual BI&A Symposium is in the books!  We here at AE would like to thank all of our wonderful presenters, as well as those of you who attended for helping to make this the best one yet!

If you would like to review any of the content presented links to the PowerPoint presentations are below.

AE Business Solutions - Introduction

Alteryx - Evolution of Self-Service Analytics

AE Business Solutions - IoT Sphero Ball Demonstration

HortonWorks - HortonWorks Overview

HPS - Implementing BI from Scratch

IBM - Making Self-Service Analytics a Reality

MGIC - Elevating Enterprise BI

Tableau - Building an Analytics Culture

Author: Chris Bick

Business Intelligence and Analytics Symposium (April 20th)

Tableauza Community,

AE is proud to announce the fourth annual Business Intelligence and Analytics Symposium! 

On April 20th at the Harley-Davidson Museum AE will be hosting guest speakers from a wide variety of industries and backgrounds to discuss their BI&A Journeys.

There is no fee for attendance, so if you are interested please reach out to us for details at tableau@aebs.com!

Author: Chris Bick

Tableau 10

Tableau 10 is new and improved!

Here is what you need to know:

1. New look and feel!

Tableau 10 has a new crisp, clean, and inviting interface. Its design is updated with new colors and a slick feel. The visualizations have new themes that minimize clutter and maximize insight. The interface is clean and simple; it lets your data shine with a "less is more" mentality. Tableau 10 offers cleaner visualizations with less "non-data ink". This "Smooth" default setting allows users to focus on what is important.

The Old Look

The Old Look

The New Look!

The New Look!

2. Highlighter

Tableau 10's highlighter lets you quickly find and highlight data while preserving the context of the data in the view. It allows the user to maintain a holistic view AND capture important details. After selecting "show highlighter" from the discrete field on the marks card, then search for data you're interested in seeing. This new feature has the ability for text search, dropdown menu options, and multiple highlighters per viz. For additional insight, the highlighter tool can be paired with reference lines, bands, mark labels, and parameters.

Here the highlighter is being used to show the copiers and fax sub-category against two benchmarks for sales and profit. This can allow for additional understanding of the data without filtering out important information.

Here the highlighter is being used to show the copiers and fax sub-category against two benchmarks for sales and profit. This can allow for additional understanding of the data without filtering out important information.

3. Drag and Drop Clustering

Tableau 10 uses the k-means clustering algorithm with a variance-based partitioning method that ensures consistency between runs. Clustering can be used on any type of visualization - scatter plots, maps, bar charts, etc. Tableau clusters with a recommended number of nodes, but the user can specify the number as well.

Without clustering

Without clustering

With Clustering

With Clustering

4. Custom Territories

There are two ways to create custom territories within Tableau 10 - groups or assigning a territory field as a geographic role. These territories can be created ad-hoc by selecting and grouping areas right on the map (seen below) or by including geographic information in the data and assigning it to a geographic role.

The above photo shows custom made United State regions. This viz shows 5 regions, but another option could specify 4 regions: Northeast, Midwest, South, and West. Some people consider Kentucky as a Midwestern state, some consider it a Southern state - all of these options are customizable in Tableau 10 by using the freeform lasso select tool and creating custom territories.

The above photo shows custom made United State regions. This viz shows 5 regions, but another option could specify 4 regions: Northeast, Midwest, South, and West. Some people consider Kentucky as a Midwestern state, some consider it a Southern state - all of these options are customizable in Tableau 10 by using the freeform lasso select tool and creating custom territories.

5. Device Designer

With this new feature, dashboards can be designed and previewed to fit numerous different desktops, tablets, and phones. The list includes iPad, Amazon Kindle, Google Nexus, Samsung Galaxy Tab, Samsung Galaxy S6, iPhone 6, Nokia Lumia, and many more! This simple feature is extremely powerful when trying to optimize viewing across all devices. 

Above is an Amazon Kindle Fire HD device preview with the layout set to "Fit All".

Above is an Amazon Kindle Fire HD device preview with the layout set to "Fit All".

Here is a Galaxy note 4 device preview with the layout set to "Fit All".

Here is a Galaxy note 4 device preview with the layout set to "Fit All".

6. Cross-database Joins

Now you can create, share, explore, and analyze an entirely new data source from disparate data sources such as SQL Server, CSV, Google Sheets and more! 

This picture above shows a number of different examples of cross-database joins. From Excel, MySQL, and CSV Files to Access, Google Sheets, and Text Files...cross-database joins are now a fully functional feature of Tableau 10!

This picture above shows a number of different examples of cross-database joins. From Excel, MySQL, and CSV Files to Access, Google Sheets, and Text Files...cross-database joins are now a fully functional feature of Tableau 10!

7. More data source options

With Tableau 10, users have more data source options including: Google Sheets, Kognitio, MemSQL, Presto, and Quickbooks Online.

8. Format THE entire workbook

Tableau 10 offers the functionality to format the entire workbook with just the click of a button. No more tedious clicking through each worksheet, dashboard, and story. Now formatting can be done with one single click!

If you haven't already done so - you MUST check out Tableau 10.0!

 

AUTHOR - TARA LAURITSEN

 

Welcome to Tableauza!

Thanks for stopping by our site and welcome!  To give you an idea of what "Tableauza!" is, the word is a combination of “Tableau” and “Wowza”.  The exclamation point (!) is included to show excitement when working with data visualization and Tableau Software.

The purpose of this blog is to stay updated on events and continue learning about Tableau!

Here at AE Business Solutions, we are actively involved in the Tableau Community. We truly believe in Tableau and its ability to help all different industries, sectors, and environments. We are members of both the Milwaukee Tableau User Group (MKE TUG) and the Madison TUG as well. The sense of community around data exploration and analytical thinking is what draws us to this amazing tool. We hope you join us in staying up to date and learning more about what Tableau can do for you!

AUTHOR – TARA LAURITSEN

Madison TUG

Join us Thursday, September 22nd from 12:00 PM to 4:30 PM (CDT) for Madison Tableau User Group. 

Agenda

12:00 - Birds of a Feather Groups 

  • New to Tableau - Clare Huhn
  • TC16 Planning - Nicole Kraft
  • Dashboard Containers - Jo LeDuc
  • Data Governance - Abbigail Posey
  • Tableau 10  - Bill Grout

1:00 - Intros

1:15 - Tableau Learning Resources

1:30 - TC16 Speaker Selection & Preview: Raising our Tableau Baby, Sarah Weber

2:00 - Keeping Bulldozers Running w/ Tableau - Ryan Milanowski, John Deere

2:30 - Break/Networking

2:45 - Architecting Tableau Server for External Access - David Blumhagen, ACT

3:45 - Networking/Tableau Doctor

Location

125 South Webster Street, Madison, WI 53703-3474

Register Here:

http://www.eventbrite.com/e/madison-tableau-user-group-tug-september-2016-tickets-25890980620?aff=es2

Tableau Conference 2016

What: Tableau Conference 2016

Where: Austin, Texas

When: November 7th - 11th

Why?

At TC16, you’ll eat, sleep, and breathe data the Tableau way, advancing the power of insights to help people achieve great things. It’s a strong community of change-makers and catalysts: those who aren’t afraid to look for the “why” behind the “what.”

You’ll learn from Tableau experts, partners, and customers, not to mention dozens of great sponsors who can help you make the most of your Tableau investment.

Craft your personal learning journey from over 400 sessions, more than 100 Hands-On Training labs, inspiring keynotes, Tableau Doctor sessions and meetups.

Just be sure to leave a little room for spontaneous good times with your fellow data people!

To learn more visit:  http://tc16.tableau.com/

 

POST BY: TARA LAURITSEN

Upcoming Viz Wars Data Sets

And here we are: the much-anticipated data for those participating in our VizWars Competition this Thursday!

For those who are not aware, AE Business Solutions is hosting a VizWars Competition at the Potawatomi Hotel & Casino in Milwaukee, WI on September 24th, 2015. This contest is bright and early  (8:00 AM)  and lasts for two hours. One hour is for visualization creation on the spot and the last hour is for judging. We will be given out prizes to 1st, 2nd, and 3rd place contestants. If interested there is still time to register! Click here for more information:

Register for VizWars

For those who are participating, we are finally releasing the data sets! While these data sets seem to be unrelated, we would like to see if YOU can find any relationships between the data given. Your first data set explores information about the passengers on the Titanic. The next gives information about the percentage of women holding a seat in parliament. The last data set utilizes information about CO2 Emission per country. Within the zipped file are three documents, each describing the fields of one of the data sets given. Questions are welcome and should be sent to erin.middlemas@aebs.com. 

Please download the data sets in order to be prepared for tomorrow's competition:

VizWars Data Sets

Rules

  1. 1-Hour for development
  2. All development has to be done on the spot. No bringing files of stuff you have worked on the night before.
  3. You must bring your own laptop. A full or trial version of Tableau and/or Alteryx is required. (See Links Below)
  4. Use only Tableau and/or Alteryx as your development tools
  5. Must use at least 1 of the above data sets. You can bring your own data sets as long as you use one of the AE provided data sets in a prominent way.
  6. You must be willing to present your creation in front of the group to be eligible for prizes.
  7. You will be judge by presentation, visualization appearance, data-driven insight, and level of difficulty for the end product.
  8. Common data inconsistencies and obstacles are purposely built into the data.

NOTE:

Free Trials of Tableau and Alteryx can be downloaded at the following links:

TABLEAU:

http://get.tableau.com/partner-trial.html?partner=29082

ALTERYX:

http://pages.alteryx.com/free-trial.html

Good luck tomorrow!

 

2015 VizWars

AE Business Solutions 2015 VizWars - March Madness

For those of you competing in the 2015 AE Business Solutions VizWars, below are the data sources and description of terms for this years ViZWars.

Data Sources

There are 3 main CSV data sources for this year's VizWars:

  1. 2015_Game_Stats_March_Madness.csv - This data set contains 2015 March Madness Wins and Losses.
  2. 2015_Team_Stats_Pre_March_Madness.csv - This data set contains overall team stats going into the 2015 March Madness Tournament. It does not contain tournament data.
  3. 2015_University_Stats_March_madness_Teams.csv - This data set contains university information, such as location, incoming test scores, and retention for the 68 teams in the 2015 March Madness Tournament.

All three of the above data sources can be join/blended on Unique ID.

There are 2 additional Excel files that can be used in this year's VizWars

  1. 2015_Individual_Player_Pre_Tournament.xlxs - This data set contains player statistics going into the 2015 March Madness Tournament. It does not contain tournament data.
  2. NCAA_Mens_March_Madness_Historical_Results_1985-2012.xlsx - This data set has WIns and Losses for March Madness tournaments from 1985 through 2012.

These two data sources above do not have an ID that can be easily blended/joined on.

Contestants must use at least one of the data sets above. Any combination of the data sets is allowed. Contestants are not expected to use all 5 data sources. Blending in external data is alright, but the data above should be the focus of your visualizations.

Data sources above may contain inconsistencies. As an analyst/developer, you are expected to address these inconsistencies. 

Terminology

For those of you less familiar with basketball, below is a list of some of the terminology you may see.

Terms

  • Seed – a competitor or team in a sports or other tournament who is given a preliminary ranking for the purposes of the draw.
  • Round – the NCAA March Madness Tournament has the following rounds in order:
    • Opening Round
    • Round of 64
    • Round of 32
    • Sweet 16
    • Elite 8
    • Final 4
    • National Championship
  • Region – region is a grouping of 16 teams that are ranked/seeded 1 thru 16. Does not imply geographic region of team playing.
  • Neutral Site – a location where neither teams have an apparent home court advantage
  • Game Type – Whether the division 1 team played against another division 1 team or a non-division 1 team
  • Minutes Rank – ranking of a player on their own team of average minutes played per game
  • Stats Terms - http://www.basketball-reference.com/about/glossary.html#blk
    • Pos – Position
      • G – Guard
      • C – Center
      • F – Forward
      • Combinations of the above can exist
    • G – Games
    • MP – Minutes Played
    • FG – Field Goals
    • FGA – Field Goal Attempts
    • 2P – 2-Point Field Goals
    • 2PA – 2-Point Field Goal Attempts
    • 3P – 3-Point Field Goals
    • 3PA – 3-Point Attempts
    • FT – Free Throws
    • FTA – Free Throws Attempt
    •  ORB – Offensive Rebounds
    • DRB – Defensive Rebounds
    • TRB – Total Rebounds
    • AST – Assists
    • STL – Steals
    • BLK – Blocks
    • TOV – Turnovers
    • PF – Personal Fouls
    • PTS – Points
    • PPG – Points Per Game
  • ·Strength of Schedule (SOS) – difficulty or ease of opponents compared to other teams opponents 
  • BPI Rank – College Basketball Power Index (an ranking of College Basketball Teams)
  • KenPom Rank – another college basketball ranking system based on a popular website

 

AE Business Intelligence and Analytics Annual Symposium

Advanced Analytics: The Data Drive Advantage

Join us at the Harley-Davidson Museum in Milwaukee Wisconsin for AE Business Solutions' 2nd Annual Business Intelligence and Analytics Symposium on April 21st, 2015.

Our key note speaker is Jason Fishbain, who is UW-Madison's Chief Data Officer. He will be discussing the emerging role and need of CDO within organizations.

We will also about IBM PureData System for Analytics, Alteryx, and Tableau. Following the symposium, AE will be hosting our second annual VizWars. This is where Tableau data artists compete for prizing by making the best visualizations within 1 hour from an unknown data sets. Fabulous prizes are up for grabs!

Registration for the Symposium and VizWars can be found here.

Post by Alex Christensen

Tableau Conference Session - Hug a TUG

Hug a TUG: Starting and Making the Most of Your Tableau User Group

We are pleased to announce that our very own Sarah Nell will be moderating a session at this years Tableau Conference. Check it out here!

Here's the description of the session:

From Seattle to Sydney, Philadelphia to Paris, local Tableau customers are meeting up all over the world. What does it take to run a successful Tableau User Group (TUG)? In this panel discussion, User Group leaders will share their stories and answer questions about what it takes to foster a local community. Whether you want to start your own User Group or just learn more about how they work, this is your chance to get a behind-the-scenes look at the vibrant global network of Tableau User Groups.

Post by Alex Christensen

Session by Sarah Nell

 

Hello, Stranger!

Hello, Stranger!

Thanks for stopping by and welcome to Tableauza!  You are probably asking yourself, "What the heck is Tableauza!?”  To be honest, the word has no significance other than being an amalgamation between “Tableau” and “Wowza”.  As an example, "Wowza, Tableau is awesome!”  It will also always have the exclamation point (!) to convey the excitement we feel when working with data visualization and Tableau Software.   At its core, Tableauza! is a happy word that is said with emphasis and lots of gesticulation.