Category: Importing Data

May 1, 2018

How to Create A Real Time Dataset on Power

Creative Visualizations
January 25, 2018

A Star (Schema) and a SWITCH for Drill-Down Income Statement Design

Accounting and Finance
January 9, 2018

Power Query (M)agic: Consecutive Days

Custom Calendars
February 21, 2017

The Ten Pitfalls of the Data Wrangler (aka the Wielder of M/Power Query)

Importing Data
February 9, 2016

Sort Your Data on Load for Improved Compression

Importing Data
January 5, 2016

Restructure Your Data Table for Improved Compression

December 16, 2015

Quickbooks Analysis via QQube!

Accounting and Finance
July 23, 2015

Connecting to an Oracle Database from Power Pivot

Importing Data
July 9, 2015

Consolidated Worksheets with Power Query

Importing Data
June 11, 2015

Time to revisit the Power Pivot Import Wizard

Importing Data