Category Archives: Tools

Big Data Bookshelf : DAX Formulas for PowerPivot

Power­pivot is an addin for Microsoft Excel which enables analy­sis of larger data sets (>1M rows) within Excel and also more sophis­ti­cated analy­sis that typ­i­cally would involve mul­ti­ple SQL queries with com­plex data joins. I blogged about learn­ing Pow­er­pivot last year. One of the dif­fi­cult things is the lack of usable doc­u­men­ta­tion or cook­books on […]

Using Flow Maps to show derivative products

Flow maps show branches of data which form part of a whole and are often used to show deriv­a­tive prod­ucts made from a sin­gle source. These were quite pop­u­lar in the early 20th Cen­tury to show ship­ping traf­fic from ports. In this exam­ple it shows the com­po­nents that con­tribute to the 3M stock price. Post-​its […]

your.Flowing Data: Capturing your life data

New web ser­vice: your.flowingdata enables you to cap­ture events and activ­i­ties in your life, track and visu­al­ize them. The goal is to under­stand life choices bet­ter. It’s an exper­i­men­tal project from Nathan Yao who runs the excel­lent data visu­al­iza­tion site Flow­ing Data . Per­haps there will evolve into a jour­nal sim­i­lar to My Life in […]

Learning Power Pivot

Pow­er­Pivot is a great free add-​in for Excel from Microsoft that enables sophis­ti­cated busi­ness intel­li­gence solu­tions and dash­boards in three ways: Process mil­lions of records from mul­ti­ple data­bases, files, and other data streams Join tables and data in Excel , spec­ify rela­tion­ships with­out need­ing build queries in SQL or Access. Build sophis­ti­cated analy­ses based on […]