In my last post I described how I've helped a London Borough to visualise neighbourhoods issues for elected councillors and members of the public. One of the areas covered in…
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…
Use thupdated live Power BI report in this post to compare the incidence of COVID-19 in your own area of England with rates of growth in other parts of the UK.
Use the live Power BI report in this post to compare the incidence of COVID-19 in your own area of England with rates of growth in other parts of the UK.
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.
A full-featured Power BI case study illustrating how a telecoms network service provider manages a global network outsourcing contract for profit and service quality.