August 2025
Is Snowflake competing directly against Fabric?
Snowflake as a Competitor With the recent introduction of Snowflake Cortex and Snowflake Intelligence, it's evident that Snowflake is investing significantly in integrating retrieval-augmented generation (RAG) and agentic AI capabilities into its SaaS data [...]
Beyond Static Charts: Building an Interactive Pie Chart That Actually Tells a Story
We’ve all seen them—those lifeless pie charts buried in dashboards, silently displaying data with no context, no story, and no spark. A few weeks ago, I found myself staring at one and [...]
Fabric Tutorial – Taming Large Data Models in Power BI
Working with large datasets in Power BI can be challenging, especially during development when importing the full semantic model can slow down performance or even crash your environment. To solve [...]
July 2025
Transforming Cloud Billing: Implementing a Multi-Cloud FinOps Solution with FOCUS™
Managing multi-cloud billing data efficiently is critical for organizations striving to balance cost optimization, transparency, and sustainability. Currently, many organizations struggle to consolidate could billing data from different providers in a single unified solution. [...]
February 2024
New Native Power BI Clustered Column Functionalities
After watching the following tutorial from Injae Park it is clear that the new IBCS standards injection into Power BI visuals (since the Feb 2024 update), including overlapping clustered column chart functionalities, allow us [...]
Microsoft Fabric Pipeline – Copy Data to Warehouse with Dynamic Variables
In this small data copy pipeline, the idea is to dynamically set a table name as a variable and execute activities in the consecutive pipeline activities that use this variable to perform the computations. [...]
January 2024
Microsoft Fabric – Lakehouse – Bronze to Silver – Medallion Architecture Practice
As Microsoft Fabric is offering an analytics engineering certification, I decided to share some of the things I'm learning along the way. I felt particularly motivated when learning about the Lakehouse medallion architecture, as [...]
July 2023
Fabric Tutorial – Lakehouse and Warehouse with Power BI
Credit Github Files: Stephen M. GitHub Files: https://github.com/samaguire/Sqlbi-Contoso-As-Parquet Pick your Contoso parquet file dataset size, as suites you best.
Fabric Tutorial – Let’s get started
Microsoft Fabric is here. This is the first tutorial from PowerÆgg where we look at data ingestion, data transformation and data distribution. Subscribe for more Videos!
April 2023
Power BI – Field Parameters and Use Cases
For this Power BI video tutorial we will look at all the use cases for field parameters I could think of. RLS & OLS Add field parameters. Add field parameter fields to visual. [...]
February 2023
Power BI – R Script Fun with ChatGPT
For this video we will look at using ChatGPT to write an R Script query in Power BI. We will look at creating a mutate function that manipulates the sales fact quantity data [...]
January 2023
Power BI – Dynamic Benchmarking
For this video we will look at benchmarking business years for sales and profit. We will look at modelling the data so that we can compare values by creating references [...]
Power BI – Multiple Fact Tables
For this video we will look at multiple fact tables. We will look at modelling the data so that both fact tables can share dimensions to reduce workload. On top [...]
Power BI – Self-Service Reporting
For this video we will look at building a self-service report. We will provide the user with the freedom to select a visual type from several options and chose what fields to [...]
December 2022
Power BI – Currencies
For this video we will look at building a solution around currencies. We will try and find a way allowing the user to view either all currencies in their right formatting or [...]
Power BI – Log Data and Query Folding
In this video we will transform status log data using m query, DAX and finally SQL. We will try several approaches: Query Editor and Dax, Query Editor and Merges, Native SQL, SQL [...]
Power BI – Buttons, Bookmarks and Formatting
In this video we will build an interactive report where the user has the full app experience using buttons, bookmarks and formatting. The end result is a dynamic interactive report with a [...]
Power BI – What IF Scenario
In this video we will implement a What IF scenario where the user can customize a number of stores added to a country.
Power BI – Dynamic Reporting
In this video we will build a report where the user can choose a timeline, measures, and columns dynamically.
Power BI – Clustering Data in Percentiles
In this video we will find cluster data into percentiles and find a great way to visualise the data.
Power BI – Dynamic KPIs and Formatting
In this video we look at different ways of conditionally formatting dynamic KPIs using various visuals, different DAX formatting options and a KPI tooltip.
Power BI – RLS & OLS In The Same Report – Part 3
Part 3 of the PowerÆgg RLS & OLS videoseries (3 videos) where we try and find the best possible solution for implementing Row Level Security (RLS) and Object Level Security (OLS) in [...]
Power BI – RLS & OLS In The Same Report – Part 2
Part 2 of the PowerÆgg RLS & OLS videoseries (3 videos) where we try and find the best possible solution for implementing Row Level Security (RLS) and Object Level Security (OLS) in [...]
Power BI – RLS & OLS In The Same Report – Part 1
Part 1 of the PowerAegg RLS & OLS videoseries (3 videos) where we try and find the best possible solution for implementing Row Level Security (RLS) and Object Level Security (OLS) in [...]