https://www.youtube.com/watch?v=k5FMfvPmkv4&t=626s In Power BI, the matrix visual is a core visual, but what happens when you need advanced customization? Specifically, if you require your measures as columns in the first-level column hierarchy followed by other dimensions in the second level? Furthermore, what if you also need to sort a specific measure column and arrange the … Continue reading Unlock Dynamic Data Display in your Power BI Matrix
Insurance Triangles In Power BI
Insurance triangles are an indispensable tool in the insurance sector. They offer critical insights into claim patterns over time, which are key for reserve setting, pricing strategies, risk management, and regulatory compliance. In essence, they enable insurance companies to accurately gauge their liabilities and ensure that their reserves are set correctly. Note: The data mentioned … Continue reading Insurance Triangles In Power BI
Generate Synthetic Data with Power Query
In this blog post I show how to generate synthetic data using Power Query. This data will then serve as the source for the Power BI blog on Insurance Triangles. Synthetic data offers remarkable benefits:1. Eliminates the need for actual data.2. Allows for the simulation of numerous scenarios akin to real-world data. In this example … Continue reading Generate Synthetic Data with Power Query
Create a Star Schema with Power Query
In this blog post I show how to create a star schema from a flat data set. This data will also serve as the source data set for future blogs. What is a Star Schema? A star schema is a type of database schema that is a key concept in dimensional modelling. It organizes data … Continue reading Create a Star Schema with Power Query
Insurance - Data and Insights 