daily 08/07/2015

• Marimekko Charts – Peltier Tech Blog

  • In a recent tutorial I showed how to make Variable Width Column Charts. A stacked version of this chart type, called a Marimekko chart, is popular in business, particularly where marketing departments analyze segmentation of their markets. The Marimekko chart gets its name from the patterns found in Marimekko fabric.

  • Suppose we have four companies, Alpha through Delta, competing in four segments, A through D, of a particular market. This could be like the companies Dell, HP, and Toshiba competing in the laptop, desktop, and home server segments of the personal computer market. A summary of the data would look like this table. The sum of the segment percentages is 100%, and the market segment shares of the companies in each segment (each row) also sum to 100%.

     

• Waterfall chart – Wikipedia, the free encyclopedia

  • A waterfall chart is a form of data visualization that helps in understanding the cumulative effect of sequentially introduced positive or negative values.
  • Often in finance, it will be referred to as a bridge.
  • Waterfall charts were popularized by the strategic consulting firm McKinsey & Company in its presentations to clients.^[1][2]
  • The waterfall chart is normally used for understanding how an initial value is affected by a series of intermediate positive or negative values. Usually the initial and the final values are represented by whole columns, while the intermediate values are denoted by floating columns. The columns are color-coded for distinguishing between positive and negative values.

• Introducing new and modern chart types now available in Office 2016 Preview – Office Blogs

  • It’s clear to see that the cost of inventory nearly cut net revenue in half while operating costs accounted for an additional third of net revenue.

• Determine Your Lactate Threshold: Put in your best effort with zone training based on your LTHR | SportTracks

  • Go as fast as you can for 30 minutes, but be sure to press the Lap button on your tracking device at the 10 minute mark, and press Stop at 30 minutes. The average heart rate from the last 20 minutes will be used to estimate your LTHR.

     

    As you can see, the test is straightforward. I wouldn’t say it’s simple — because you need to exert maximum effort the entire time. At the end of the test you should be exhausted. If you do it wrong, you will be fatigued and probably not be able to redo the test for a few days, in order to get accurate results.

• Domo Reveals Its Business Software, Raises $200 Million At $2 Billion Valuation – Forbes

  • For a company with a run-rate of $100 million projecting 100% growth and with 1,000 customers,
  • creating a chip on the shoulder of the CEO who built Omniture and sold it to Adobe for $1.8 billion and has raised tens of millions from top firms like Benchmark.
  • Investors see a much bigger opportunity than Omniture’s price tag or even Tableau Software, the business intelligence company trading at a market cap of nearly $7 billion today. That’s led Domo to raise $200 million in a Series D round led by BlackRock, with Capital Group, Glynn Capital and existing investor GGV Capital joining the round. The company’s raised $450 million to date and more than doubled its valuation from $825 million in Feb. 2014 to $2 billion today.
  • provides what the company calls five layers of a data pyramid to translate that raw information into business results.
  • Domo costs about $25,000 a year at minimum (about $2,000 per user for a team of a dozen at its smallest) with some companies spending more than $1 million per year. James says Domo’s revenue retention rate is 150% as customers typically ramp up their seats on the product from one year to the next like the credit card company, which went from 25 seats to 50 to 350 over two years.
  • James himself believes he’s built a startup on a trajectory comparable to Workday, the 10-year-old cloud software company that went public in 2012 and has a market capitalization today of nearly $17 billion.

• Lots of ways to UNPIVOT a table – SQL Server – SQL Server – Toad World

  • I recently read an awesome post on http://www.stackexchange.com questioning how to change columns to rows ie UNPIVOT. One answer demonstrated 4 different ways to unpivot a table including your basic UNPIVOT statement, CROSS APPLY, CROSS APPLY with VALUES and a dynamic SQL version for when you have a large number of columns.

• Developing Oracle Applications Using TOAD – Books24x7

  • TOAD enables you to create Oracle database objects, such as tables, views, indexes, and constraints.
  • Create, browse, or alter Oracle database objects.
  • Build, execute, and tune Oracle queries graphically.
  • Edit and debug PL/SQL and profile stored procedures that include functions, packages, and triggers.
  • Search for objects
  • Find and fix database related problems using constraints, triggers, extents, indexes, and grants.

• A Farewell to the Best Restaurant in New York: The Cloisters' Trie Café 

  It feels show-offy to RT this link but I love @RichJuz very much and I’m so happy I didn’t have to eat this sandwich: http://t.co/YVz20lolNY

• 1. Ballghazi ends with Goodell resigning2. Koch

  1. Ballghazi ends with Goodell resigning

  2. Koch brothers make a call

  3. PRESIDENT GOODELL

• Power Query for Power BI and Excel – Books24x7

  • Duplicating Columns

     

    As with index columns, the ability to duplicate a column in a table isn’t very useful on its own, but it is important when creating other calculations—for example, when you are using one of the built-in transformations described earlier in this chapter and you want to preserve the original contents of a column.

  • The real power of custom columns becomes apparent once you define your own calculations using the M language. A full introduction to the M language will be given later on in this book in Chapter 5, but it is easy to write simple M expressions without needing to know much about the language itself
  • Many different types of calculations, such as sums, can be performed across multiple numeric columns by selecting the columns, clicking the Insert Custom Column button, and then clicking one of the options under the Statistics, Standard, or Scientific drop-down boxes.

Posted from Diigo. The rest of my favorite links are here.