Tag Archives: Viz

Tableau Hold ’em — Part 2 — The Flop Card 2

Featured

Posted on by
1

Remember the need we are trying to answer is: “I want to know if I should bet or not!” 

 

Easiest solution is a YES/NO output, but really?

 

 

Welcome to Part 2:

We will

Import your table to Tableau

Map coordinates

 

Wait! What?

Yes Tableau has a nifty X/Y method that allows you to map out your image and it is a must for this process.

Be sure you have saved your Excel Poker Table as a png ( you can use the Windows Snipping Tool)

 

YouTube walk-through

1 Create a data set in Excel that you can reference — 3 columns

  • Position
  • X
  • Y

Position x y table

2 Open the Poker Table in Paint and look at the properties

the pile4

3 Copy the Width and Height in pixels and enter into Excel

Mapping size

 

Save the Excel file so it can be used as a Tableau Data Source

4 Connect to that data source

connect

5 Open a new worksheet and go to the Map tab at the top of the screen

Select Background images

Mapping Menu.png

6 Add your image

Table image import steps.PNG

7 Place the X/Y pixel counts into the image as X = the right most position and Y = the top most position

mapped x y

8 Create a cross tab with X as column and Y as rows

Things to consider:

In Map >> Background Images be sure you have “Always show Entire Image” selected

Be sure you select “X” and “Y”  when you enter your data

You will now see your Texas Hold ’em table

imported table.PNG

You can hide the headers to make a clean worksheet

Hide Headers.PNG

Up next –> Tableau Hold ’em Part 3

 

Previous steps:

https://excelirate.wordpress.com/2017/09/05/tableau-holdem-series/

https://excelirate.wordpress.com/2017/09/18/tableau-hold-em-part-1-the-flop-card-1/

 

 

Tableau HOLD ’em

Posted on by
2

TexasHoldem table3

Any one seen a Tableau viz?

Were you blown away by the fancy colors and lines, shapes,etc…?

–No? Me neither

Why oh why do corporate entities love it so?

Over the next few weeks I will be publishing what visualizing data means to me. I work with data daily for my job. I love database tables and spreadsheets because I can get to the detail and I know what I am looking at.

Executives, the general public–yes not likely

They need to be able to visualize the details in actionable reports

Jump to Part 1 The Flop …Card 1

Most viz’s fail to live up to the promise and leave you thinking you have Excel 2.0

  • Tableau Hold ’em Represents a step by step approach to making data actionable, understandable and approachable
  • I will have a series of YouTube videos attached to show steps
  • The finished product may or may not ever exist
  • The point is to expand the idea of what visualizing data can be

I want to break you out of the box of eliciting an Excel/PowerPoint to Tableau conversion of previous solutions

Think about it–if they have a solution today, really why then Tableau?

Instead elicit what the executive or manager actually needs to answer and what is holding them up from solving problems and how they can best consume that information

My hope is that Tableau Hold ’em will spark that discussion