Skip to content

Spreadsheets 'N Things

Excel, Power BI, and a sprinkling of Linux

  • About
  • Blog
  • Contact
Excel, Power BI, Power Query

Power BI Resources and Reading List

I’m frequently asked by friends and colleagues where to start learning Power BI, data modeling, and the rest. I’ve assembled a few things here to

July 22, 2022July 23, 2022 by jeremy
Self Hosting

How To Set Up A Secure Matrix Registration Portal in Docker

I’ve been using my own self hosted stack for chatting and communication with the Matrix protocol for some time now. It is really cool and

January 7, 2022July 22, 2022 by jeremy
Excel, Power BI, Power Query

How To Scrape SSRS Reports with Power Query

Warning: the below content is not approved by your IT administrator. Once upon a time, data analytics and reporting were considered functions of IT more-so

December 9, 2021July 22, 2022 by jeremy
Do Analysts and Excel Pros Need VBA in 2021?
Excel, Power BI

Do Analysts and Excel Pros Need VBA in 2021?

I started my career as a spreadsheet warrior in 2014. Like many Excel pros, my first job wasn’t actually designing or developing spreadsheets and data

August 20, 2021July 22, 2022 by jeremy
Excel, Power BI, Power Query

How to Get Data from the Big Time API with Power Query

As my inaugural blog post I’ve decided to write about something fairly niche and technical. Foolish, I know, but it’s something I dealt with recently

August 19, 2021July 22, 2022 by jeremy

Search

About This Site

This may be a good place to introduce yourself and your site or include some credits.

Search

Copyright All Rights Reserved 2022
Proudly powered by WordPress | Theme: Polite by Template Sell.