Developing a Power BI data model is more than just designing tables and their relationships. You can construct new data in the form of calculated tables and columns to augment the design, making report design and use easier for report authors and users. This course will show you how.
Learning Objectives
- Learn how to leverage Power BI's built-in hierarchy feature to add greater drill-down functionality to your reports
- Secure data and data model's schema objects with roles
- Implement context-sensitive data with security filtering, and set up Q&A so users can interrogate data with natural language questions
Intended Audience
This course is intended for anyone who wants to enhance their Power BI data model development skills.
Prerequisites
To get the most out of this course, you should be familiar with the use of DAX or Excel functions. It would also be beneficial to have some awareness of basic data model design principles.
Hi, welcome to this Power Bi Developing a Data Model course. This course focuses on features that add functionality to your data model, making it easier to author reports, for end-users to navigate, and making information available to appropriate users. I will use a series of demonstrations to illustrate these features with practical examples. To get the most out of this course, you should be familiar with the use of DAX or Excel functions. It would also be beneficial to have some awareness of basic data model design principles. However, the features discussed here can be applied to any data model no matter how good or bad its structure is.
The demonstrations will mainly involve Power Bi desktop, but I will be making use of DAX Studio, Tabular Editor, and publishing reports to Power Bi.com.
My name is Hallam Webber, and I'll be your instructor for this course. We welcome all comments and feedback, so please feel free to reach out and get in touch with us at support@cloudacademy.com with any feedback, positive or negative. Let's dive in.
Hallam is a software architect with over 20 years experience across a wide range of industries. He began his software career as a Delphi/Interbase disciple but changed his allegiance to Microsoft with its deep and broad ecosystem. While Hallam has designed and crafted custom software utilizing web, mobile and desktop technologies, good quality reliable data is the key to a successful solution. The challenge of quickly turning data into useful information for digestion by humans and machines has led Hallam to specialize in database design and process automation. Showing customers how leverage new technology to change and improve their business processes is one of the key drivers keeping Hallam coming back to the keyboard.