In the next couple of posts I'll be focussing on some of the work I've been doing for a London Borough since July last year. The Council was keen to…
Learn how to create a more complex Power BI dimension table incorporating related data from a number of different tables in a source OLTP system.
Learn how to create the Revenue Type and Cost Type dimensions in Power BI
How to use Power BI and Power Query to connect to a SQL Server table and transform it into the Service Package dimension table in the Springwater data model.
Using ETL to convert an OLTP data model in Microsoft SQL server into a snowflake schema suitable for business intelligence reporting in Microsoft Power BI.