Ross Waterston

Power BI – Workspaces

08-Jul-202409-Feb-2021 by Ross Waterston

Modern Workspaces are the main unit of collaboration within Power BI, workspaces are where all your layers of Power BI …

Weekend Work 012: Another Spreadsheet + My First Filter (in Calculate)

08-Jul-202405-Feb-2021 by Ross Waterston

This week we covered a new Spreadsheet that you may want to make part of your Global Due Diligence Process and then looked at how Filter Context can work against you, showing why it is so important to be sure about what your measures are doing.

Power BI – Layers 2 – The Top Layer

08-Jul-202402-Feb-2021 by Ross Waterston

Dashboards are a major part of the Power BI Service, it is something that people often do not fully appreciate. Over the next couple of weeks we’ll go deeper into the Service, Apps and where Dashboards fit into that. This topic is vital to understand if you want to get the most out of Power BI for an Enterprise. Personally, even with Power BI Free, you can get an awful lot out of Power BI Dashboards

Weekend Work 011: DAX to M + Tooltips and Drills

08-Jul-202429-Jan-2021 by Ross Waterston

We’re really exploring the NYC Water Tower Inspection data. This week we go through the process of “Upgrading” our data model to move Calculated Columns into the M using the Query Editor. We then explore using Tooltips and Drill-down within Power BI

Power BI – Layers

08-Jul-202426-Jan-2021 by Ross Waterston

Power BI is all about creating an interactive Data experience for your consumers. this can be a difficult concept to …

Weekend Work 010: Importing Excel and the basics of KPI’s

08-Jul-202422-Jan-2021 by Ross Waterston

When you’re developing solutions in the real world you have to start somewhere often times that will be a pre-existing …

Power BI – Celebrating Differences

08-Jul-202419-Jan-2021 by Ross Waterston

Power BI and by that I mean Tabular Models store data in a particular way, we will keep coming back to this and keep trying to encourage your learning. Databases (and many data sources) are inherently transactional and we talk about single items (rows). However, Tabular Models are analytical and so focused around Columns.