Category: Importing Data

May 1, 2018

How to Create A Real Time Dataset on Power BI.com

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

DAX 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