BI is all about providing the right insights (to the right people at the right time), so that they could take informed decisions that better their business. The insights they need often change; the question asked today will morph into something else tomorrow. That is why the datasets that provide this information should be designed in a way that answering these questions become simple and flexible. Hence, why data modeling is given so much importance.

In this workshop we will start with analyzing a standard scenario, and identify business intelligence needs, define an architecture, then design your data model. We will then get into the business of querying the source data, transforming it and then building a star-schema based model based on your design. Along the way we will look at tips for effectively transforming different source structures of data, creating reusable transformation logic, defining measures, and configuring security.

Workshop Content
• Understanding and classifying requirements
• Defining an architecture
• Designing a data model
• Defining transformation logic
• Defining the semantic layer
• Defining and integrating security

Technology areas covered
• Power BI Desktop
• Power Query on Dataflows and Power BI Desktop
• DAX
• Row-level Security
• Power BI service

At the end of the workshop, you will be able to understand analytics requirements from business scenarios, design a data model solution and implement it.

Half day workshop.