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.