-
Tabular Editor for Power BI

What is Tabular Editor? Tabular Editor (TE) is a lightweight external tool that lets you peek under the hood of a Power BI data model and modify it in ways the standard Power BI Desktop interface can’t. In simple terms, it’s an editor for your Power BI semantic model – you can create or edit…
-
Doug Ford’s Return-to-Office Mandate: What Research Says About Hybrid Work in Ontario

Premier Doug Ford wants all Ontario civil servants back in the office five days a week by January. He argues we need to physically mentor staff and revitalize downtowns “to bring the public service closer to the people they serve”. Talk about a bold move… or a gamble. So, should the rest of us saddle…
-
10 Must-Know Power Query Tips for Power BI Users (Beginner to Advanced)

Power Query is the powerhouse behind Power BI’s data transformations. It’s like the kitchen where raw ingredients (data) get chopped, cleaned, and seasoned for analysis. Below, I’ve compiled ten must-know tips, divided by skill level, to help you work smarter in Power Query. Beginner Level Tips (Getting Started with Power Query) Intermediate Level Tips (Taking…
-
Most Valuable Art Pieces vs. Most Inspiring Artworks

Art can be “valuable” in different ways. On one hand, the art market assigns staggering monetary prices to certain masterpieces with a handful of paintings selling for hundreds of millions of dollars. On the other hand, some artworks hold incalculable cultural or inspirational value, shaping history and society in ways that can’t be measured in…
-
Homer Watson: Canada’s First Landscape Artist

Step into the forest. The air is thick with mist, the river glows with amber light, and a storm stirs above the pines. Somewhere, across the field, a lone painter captures it all with brush and oil. His name is Homer Watson. The Boy Who Painted with Wind and Memory Before he ever held a…
-
Invisible Women: What Happens When You Design With Blinders On

In Invisible Women, Caroline Criado Perez delivers something all too rare: a book about gender that’s really about data, how we collect it, who we collect it from, and what happens when entire populations are left out of the picture. The premise is deceptively simple: when women aren’t counted, they don’t count. And across nearly…
-
On Joining OTIP and Seeing the Long Game Unfold

*These are my personal reflections, not an official company statement. When I joined OTIP, I was prepared to ease into a new routine, learn their ways, and maybe decorate my desk with something silly like an artistic mousepad. What I wasn’t expecting was to find myself rethinking what leadership looks like and how a workplace…
-
📊 Top 10 Must-Have Websites for Data Analysis

📈 Data Visualization & Dashboard Tools 📚 Datasets & Public Data Repositories 🎨 Artistic & Aesthetic Data Inspiration 🔥 Bonus Pick Data is Beautiful (Reddit)
-
Top 10 Essential DAX Formula Combinations

Data Analysis Expressions (DAX) is a powerful formula language used in Microsoft Power BI, Excel Power Pivot, and SQL Server Analysis Services (SSAS). It allows users to create calculated columns, measures, and custom tables to derive insights from their data. While there are many DAX functions, some are far more essential than others. This article…
-
Power BI: Uncovering Shortcuts and Hidden Gems

In Power BI, finding a hidden feature or shortcut can feel like stumbling upon a rare artifact in an RPG—unexpected, powerful, and immediately useful. For those of us immersed in data, Power BI is a bit of a playground. Sure, it’s a tool, but it’s also a powerful interface that helps transform data into stories,…
