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
Tag: Power BI
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