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 9, 2015

Consolidated Worksheets with Power Query

Importing Data
February 3, 2015

Introducing Power Update!

GIS, Mapping, & Geographical Analysis
May 17, 2012

Excel 5-Calendar Date Table

Custom Calendars