Date Hierarchy [Video]
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 lesson 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 lesson is intended for anyone who wants to enhance their Power BI data model development skills.
Prerequisites
To get the most out of this lesson, 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.
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.