GOLDEN DATA GOD OF WISDOM


Matt Allington Microsoft MVP

Excelerator BI

Matt Allington is an industry recognised expert in Power BI training and has 30+ years experience in using data to deliver business value. Matt is a Microsoft MVP that specialises in Power BI, Power Pivot and Power Query. He brings his business and IT experience to the table to get fast and effective results and help you with general business data problem solving.


DATA GOD QUALIFICATIONS

Matt is the author of the books “Supercharge Power BI: Power BI is Better When you Learn to Write DAX” and “Supercharge Excel: When You Learn To Write DAX For Power Pivot”. You can view Matt’s selection of Power BI Books for sale.

Today is your opportunity to build the tomorrow you want.
Ken Poirot

Great Power BI starts with a great data model. The better the model, the better the insights that people will be able to gain from the reports. Time spent on building that single source of truth is returned a million times over in value. 
TOP 8 REPORT DESIGN TIPS

01

There can be only ONE

You only have one dataset/data model to maintain. This will use less space, use less resources to keep the data up to date, and also eliminate the proliferation of slightly different versions of the data model

02

Simplify

You can maintain and improve the single data model in the Golden Dataset master PBIX and make the changes available to all users and dependent reports.

03

Size Matters

You (and everyone else with access rights) can simply build new ‘thin’ reports connected to the Golden Dataset as needed.

04

Customization

Anyone building a new report in Desktop using the Golden Dataset will be able to add their own “local” measures – local to their thin workbook.

05

One for All

With the implementation of a suitable business process, the best local measures created by users can be retrospectively migrated into the Golden Dataset for the benefit of all.

06

Star-ship Enterprise

You get the benefits of an enterprise solution (kinda like using an SSAS Tabular data model) without having to invest in all that infrastructure.

DATA GOD FUN FACT


Matt learnt to program using BASIC on a HP mini-computer at school, and learnt spreadsheets using the original green screen version of Lotus 1-2-3
Share by: