Tag Archives: DATA

Transposing Arrays to Columns

I’m currently working on developing network graphs for companines within the software space. I hope to derive insights across 1. what companies compete in the most (or least) impacted industries and 2. systematically “bucket” companies by function

I’ve recently completed populating my database of companies by function. Now, I need to clean my data and prepare to feed in to a clean csv file. Notes for myself below:

Order of Operations

  • Clean data to preserve relationships between nodes
  • build a reusable turk that transforms arrays in to a single column

Parse

  • each row begins with a parent node
  • each row ends with a count of the number of children nodes in a row
  • a = parent (begin)
  • b = number of children in row (end)
  • a2 = b1 + 1
  • results in unique value for each node in system (>400 children)
  • next sheet harbors x…x+n
  • [ next puzzle: toggle between rows ]
  • run index match on b1 through bn (child counter column)
  • matched value is equivalent to row number
  • if match results in error, select last row letter
  • drive indirect to call value
  • [next puzzle: toggling columns]
  • Next column:   Count up number of occurrences of each row number
  • recycle count when last row is not equal to current row

Tableau Competitive Positioning

Question (Brent Bracelin Pacific Crest Securities – Analyst): I just want to drill down there a little bit. What question can you answer that I can’t get Microsoft, PowerBI try to answer, you got to get a concrete example of that.

Response (Francois Ajenstat Tableau Software, Inc. – VP of Product Development): So, a good concrete example, let’s say you want to look at your year-over-year difference in sales, very simple question, what is the difference this year compared to last year? In Tableau, that’s a three second solution. Three clicks, you’re done. And PowerBuoy or even tools like Qlik, you’ll have the right code, you’ll write complex calculations that would get you there. Which means, in order to do that, very few people, only specialists can do it, where what we want to do is expand the opportunities for the number of people that can do that. It’s a very simple question, right. Even in a running sum. What’s our running sum of sales this quarter. Really simple question. Extremely hard to do in any other tool. Three clicks in Tableau.

  • Ajenstat also notes that DATA is available in cloud or on-prem (as well as deployable in AWS). He notes that PowerBI is Cloud-Only (and not AWS compatible) and that Qlik is on-prem only with no cloud option. Note that Qlik was recently acquired by Thoma Bravo