Updating data in pivot table

24-Feb-2020 06:04 by 2 Comments

Updating data in pivot table

Tableau Server introduced so people can see visualizations through browser over intranet or internet.

Tableau was spun out of Stanford in 2003, from project Polaris, led by professor Pat Hanrahan and Chris Stolte.

Another problem (in Tableau 3.0) was that views in dashboard updated sequentially and not in-parallel.

By 2007 Tableau employed just 50 people but it was just a beginning: In 2007 the Tableau Software company got lucky, because TIBCO bought Spotfire that year and it greatly restricted the ability of Spotfire to lead Data Visualization field.

In Excel it is quite easy, just copy the data and paste as Transpose, but in SQL server we have various methods by which we can achieve same results.

Consider a scenario, where we have a table “transactions” which give datewise data about how many transactions were done in a country and total amount value.

Overall for last 5 years Tableau had explosive (and unsustainable by industry standards) 75% or above growth; that Yo Y revenue growth (and Tableau expects 0M for entire 2015) presented in bar chart below: The text below is based on recent Tableau’s attempt to re-write own history, version by version.

Also I reused some posts from this blog – I already covered in my blog versions 6.0 (in 2010) and then 6.1, 7.0, 8.0, 8.0 Desktop, 8.0 server, 8.1, 8.2, Tableau Online, Tableau Reader, Tableau Public.

I will follow this pattern with one exception (and I promise to avoid the marketing BS like “revolutionary innovation”).

I will start with something which is still is not here yet at the end of 2015.

It was originated at Stanford as a government-sponsored (Do D) research project to investigate new ways for users to interact (including Viz QL) with relational and OLAP databases. In 2005, Hyperion (now Oracle owns Hyperion) began to offer a Tableau under the name “Hyperion Visual Explorer“.

By end of 2010 Tableau had 4 products: Tableau Desktop (99 for Pro edition), Tableau Server (000 for 10 users), Tableau (free) Reader and Tableau (free web service) Public.

Another luck for Tableau was a strategic mistake by both Qliktech and Spotfire to leave development teams in Sweden while placing their HQs, sales, marketing etc. Tableau got lucky one more time later thanks to gift from Qliktech but I will discuss it later in Part 3 or 4 of this blog-post.