Home Posts About FAQ? Tip jar

About me and this site

I am not profound. This site is the opposite of profound.

I enjoy solving tricky problems. I have a small farm. Understanding is incredibly important to me.

License things

All prose on the site is CC BY-NC 4.0. In short, feel free to share, copy, redistribute, adapt, and remix, so long as you do provide attribution and do not commercialize the content.

All code in code blocks is covered by the MIT License, unless otherwise noted. In short, feel free to use the code however you wish, but make sure to include the license if you redistribute the code.

If you have any questions about this, or if you'd like to use any content you see, please feel free to contact me.

Find me elsewhere in person and online

This section includes contributions in other online venues (e.g., guest posts, docs contributions, guest appearances and more) and in person at conferences. If you found me somewhere other than this site, it is probably listed below. I do not list activity on various social media or fora below.

2024

March

2023

October

September

  • Power BI Next Step: 2023-09-21--2023-09-22; Copenhagen
    • Beyond the GUI: Power Query and M techniques

July

June

  • Seattle Modern Excel + Power BI User Group: 2023-06-15 12:00
    • Beyond the GUI: Techniques in M and Power Query
  • NJ SQL Data Platform User Group: 2023-05-17 18:00; Robert Half, 10 Woodbridge Center Dr., Woodbridge, NJ 07095
    • Columnstore and VertiPaq: intro to the former and deep dive into the latter

May

  • PPDM New Data Ecosystem Expo: 2023-05-09--10; Houston
    • Presented "Data Modeling for Modern, Self-Service Analytics": a review of data modeling techniques
  • SQL Saturday NYC: 2023-05-06; New York City
    • Presented:
      • "Let's talk about your model": a review of dimensional modeling techniques for Power BI and Analysis Services
      • "Expert Tabular and Power BI development": a review of tools for more effective development workflows

April

  • Updated gateway troubleshooting docs: GitHub PR
  • Power BI Cruise: 2023-04-24--26; Copenhagen, Oslo, and the seas in between
    • Presented "Optimizing models": a deep dive into VertiPaq and Tabular internals
  • Kratos BI livestream: 2023-04-05; virtual
    • "Revolutionize Your Business with Argus PBI: The Ultimate Power BI Monitoring Solution - Management"
      • Nota bene: the generous title was provided by Chris (:

March

  • Oklahoma PUG: 2023-03-23; virtual
    • "Power BI Operations: Monitoring and Administration at Scale": a review of the operational concerns for Power BI and the tools available for monitoring the same
    • recording link
  • Reid Havens livestream: 2023-03-15; virtual
    • "Report/Dataset Lifecycle Management for Power BI": a discussion of Power BI operations and some delightful tangents

2022

December

October

  • Iowa PUG: 2022-10-05; virtual
    • "Beyond the GUI: Techniques in M and Power Query": a rapid-paced and demo-laden exploration of M
    • recording link

March

  • Chicago PUG: 2022-03-30; virtual
    • "Hacks on Hacks with DAX": a delightful romp through a series of optimization approaches that defy the obvious approach
    • recording link

2021

April

  • Oklahoma PUG: 2021-04-15; virtual
    • "Data Modeling in Power BI: Why ‘Columnstore’ matters": an overview of data storage in VertiPaq

2020

May

March

  • Power Platform World Tour: 2020-03-03--05; Washington DC
    • "You don't know DAX, but you will!"
    • "Let's Make a Model"
    • Experts panel

February

  • Power Platform World Tour: 2020-02-11--12; Atlanta
    • "Power BI-ginnings: A gentle introduction to Power BI"
    • "You Don't Know DAX, but You Will"
    • "Beyond the GUI: Advanced Power Query and M Techniques"
    • Experts panel
  • Power Platform World Tour: 2020-02-04--05; Houston
    • "Let's talk about your model"
    • "Beyond the GUI: Advanced Power Query and M Techniques"
    • "Managing complexity in Power BI solutions"

2019

October

  • Power Platform Summit: 2019-10-13--18; Orlando
    • "Advanced data modeling"
  • SQL Trail: 2019-10-04; Virginia
    • "Expert SSAS Development"
    • "Advanced data modeling for analytics and reporting"

April

  • Power Platform World Tour; 2019-04-09--10; Chicago

    • Power BI portion of keynote
    • "Let's Talk About Your Model: Data Modeling Techniques for Power BI"

  • Power Platform World Tour: 2019-04-01--02; Washington DC

    • Power BI portion of keynote
    • "Let's Talk About Your Model: Data Modeling Techniques for Power BI"
    • "Techniques for Managing Complexity in Power BI"
    • Expert panel

February

  • Power Platform World Tour;: 2019-02-19--21; Silicon Valley
    • "Let's Talk About Your Model: Data Modeling Techniques for Power BI"
    • "Techniques for Managing Complexity in Power BI"
    • "You Don't Know DAX, but You Will"

January

  • Power Platform World Tour: 2019-01-21--22; Tampa
    • "Automate your world with Microsoft Flow"
    • "Introduction to Data Modeling for Power BI"

2018

November

  • Power Platform World Tour: 2018-11-28--29; Dallas
    • "Techniques for Managing Complexity in Power BI"
    • "Let's talk about your model - data modeling techniques for Power BI"
    • "Beyond the GUI - Advanced Power Query Techniques"

October

September

  • Power Platform World Tour: Charlotte
    • "Let's talk about your model"

April

  • SQL Saturday: 2018-04-21; Philadelphia
    • "Simple Modeling Solutions to Complex Measure Problems"
    • "DAX More Than Measures: An Introduction to DAX as a Query Language"

2017

September

  • Power BI World Tour: 2017-09-19--20; New York City
    • Organizing committee
    • "Simple Modeling Solutions to Complex Measure Problems"

2016

April

  • SQL Saturday: 2016-04-30; Baltimore
    • "Let's Talk About Your Model: Simple Modeling Solutions to Complex Problems"

2015

October

  • SQL Saturday: 2015-10-03; Pittsburgh
    • "Agile BI with Power BI"

May

  • SQL Saturday: 2015-05-02; Dallas
    • "A Date With DAX: Time Intelligence in Tabular and PowerPivot"

2014

October

  • SQL Saturday: 2014-10-25; Minneapolis
    • "A Date With DAX: Time Intelligence in Tabular and PowerPivot"