As organizations scale their Microsoft Fabric implementations, structuring workspaces and capacities becomes key to maintaining balance between agility, control, and cost. In my latest video, I explore two architecture patterns: 7-Workspace Architecture Bronze: Raw ingestion Silver (Dev/Test/Prod): Curated and transformed layers Gold (Dev/Test/Prod): Business-ready semantic models and reports Optimized using a dedicated Dev capacity [...]
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 platform. Microsoft Fabric is advancing in the same direction, with features like Copilot, AI Functions, and Data Agents - but [...]
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 thinking, “There has to be a better way.” I didn’t want just another chart; I wanted a visual that helped [...]
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 this, I created a method that uses parameterized imports to allow developers to work with only a slice of data—without [...]
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. Have different ingestion scenarios, siloed data architectures, and various data formats and granularities when combining cloud billing data from various [...]
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 to reflect more data in a condensed manner. The result is better story telling, a quicker insight into delta values [...]
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. For example, the first two activities that run in parallel, are the variables that set values to be used. v_table_input [...]
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 you can automate processes, improve data quality and serve several stakeholders at the same time. For this article I have [...]
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.
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!
