https://store-images.s-microsoft.com/image/apps.52642.35ab6ea4-fc0f-4ac9-8868-28a58b90b89c.7d51e005-f43f-45e0-b722-e9fb6adba463.e64af90a-9c55-4c32-884b-98b90b33e37f

Power BI Data Modeling: Data modeling tutorial for Controllers

IT-Logix AG

Our self-paced hands-on tutorial will help you get started with professional controlling based on Power BI with the option of using Excel for evaluations and visualizations.

If you recognize yourself in the following questions, we have just the right tool for you with the Power BI hands-on tutorial for controllers:

  • Do you know which figures are relevant to you, but find it difficult to create a suitable model and link your data in a meaningful way?
  • Do you want a model with your data that you can use to answer your questions, but don't know how to map your processes in the data?
  • You don't dare to take the step to Power BI yet because you don't know where to start and how to map your Excel evaluation?
  • Have you heard of facts and dimensions, but don't know exactly what Ralph Kimball has to do with them?
  • Do you want to enable your team to compile the required data professionally?

AGENDA:

Iteration 1 (Initial Data Mart): Model the core process of invoicing - selling a certain product at a certain time to a certain price

  • Calendar Date Dimensions
  • Denormalized Flattened Dimensions and Dimension Surrogate Keys
  • Transaction Fact Tables, Additive Facts and Fact Table Surrogate Keys
  • Header/Line Fact Tables and Allocated Facts
  • Degenerate Dimensions
  • Numeric Values as Attributes or Facts

Iteration 2 (OLAP-Operations): Enhance your Model with customers, location information, sales manager and budgeting information

  • Balanced Hierarchies (Fixed Depth Positional Hierarchies)
  • Flags and Indicators as Textual Dimension Attributes
  • Null Attributes in Dimensions -Multipass Queries to Avoid Fact-to-Fact Table Joins
  • Nulls in Fact Tables

Iteration 3 (Budget Variance Analysis): Deep-dive into the hierarchies of your product

  • Parent-Child-Hierarchies (Ragged/Variable Depth Hierarchies)

Take advantage of the extended modeling options that Power BI offers you. You can still perform your usual analysis in Excel. If you opt for our tutorial, you can expect the following benefits:

  • After this hands-on tutorial, you will know the most important design patterns and will have implemented them independently.
  • You will have a solid basis for implementing your data requirements independently in the future.
  • You can also use the documents as a reference work for later research.
  • The knowledge is tried and tested and is limited to the most important things that you will encounter in your everyday life.
  • The tutorial provides you with all the tools you need to take your first steps towards professionalization - no frills, no extra costs.

With 20+ years of experience in the field of Data Warehousing and Analytics and exciting customer references across numerous industries, IT-Logix would be delighted to become your trusted data advisor to deliver excellent results and short time-to-value also to your business.

We would love to: Let your data speak!

Vue d’ensemble

https://store-images.s-microsoft.com/image/apps.14906.35ab6ea4-fc0f-4ac9-8868-28a58b90b89c.7d51e005-f43f-45e0-b722-e9fb6adba463.6233908d-c135-422f-b81a-b144c4225576
https://store-images.s-microsoft.com/image/apps.46369.35ab6ea4-fc0f-4ac9-8868-28a58b90b89c.7d51e005-f43f-45e0-b722-e9fb6adba463.8d193346-a55e-4bb3-bee7-2b9b7767aaaa
https://store-images.s-microsoft.com/image/apps.57735.35ab6ea4-fc0f-4ac9-8868-28a58b90b89c.7d51e005-f43f-45e0-b722-e9fb6adba463.628a15b7-7f73-424b-a1f7-566a083d2d6b
https://store-images.s-microsoft.com/image/apps.14275.35ab6ea4-fc0f-4ac9-8868-28a58b90b89c.7d51e005-f43f-45e0-b722-e9fb6adba463.791098f3-f7b3-46bd-84af-3e594501218b