Power BI - Tabular Data Modelling DURATION: 1 Day
Course Overview
Power BI - Tabular Data Modelling DURATION: 1 day INTRODUCTION This course is aimed at people who already have some experience using Power BI who want to focus on building more robust data models for analytical and reporting purposes. Attendees will get the opportunity to use Power BI’s data modelling features to design and arrange their data into industry standard dimensional models, optimised for better reports and dashboards. This is a practical hands-on course with guided walkthroughs in designing a simple data model. The course starts with a look at the basic concepts of data modelling. This is followed by an analysis of the process of loading and profiling data from external sources, shaping that data into appropriate structures that will define our model, and working with key fields.
INTRODUCTION
This course is aimed at people who already have some experience using Power BI who want to focus on building more robust data models for analytical and reporting purposes.
Attendees will get the opportunity to use Power BI’s data modelling features to design and arrange their data into industry standard dimensional models, optimised for better reports and dashboards.
This is a practical hands-on course with guided walkthroughs in designing a simple data model.
The course starts with a look at the basic concepts of data modelling. This is followed by an analysis of the process of loading and profiling data from external sources, shaping that data into appropriate structures that will define our model, and working with key fields.
Tables in a model don’t typically stand in isolation and are instead related by common data that exists in those tables. Module three looks at these relationships, examines the types and cardinality of relationships, and how to create and manage relationships, as well as considering some more advanced topics.
With data in our model, module four then considers the different table and column properties that can be set to improve the model further. This will include a review of the different data types that can be set on column data, configuring a column to behave as an implicit measure, and how to create basic groupings of data.
Very typically in reporting we need to analyse data over time periods. Module five discusses how we can implement date tables into our model, ways in which they can be created, and how they should be structured to provide appropriate analysis of our data.
There are many other considerations to take into account when designing a data model and the final module, time permitting, looks at some more advanced topics, such as dealing with header/detail data tables, table granularity, and considering how to deal with data that changes over time.
Of note, this course is about the concepts of modelling data and does not cover Power Query or DAX in any great depth. There are separate courses tackling the topics of cleansing and transforming data with Power Query, and likewise for extending the data model with the DAX expression language.
Due to the ever-changing nature of this technology, course content may vary to keep the training as relevant and up to date as possible.
PREREQUISITES
Delegates should have previously attended the “Power BI Level 1 – Introduction” and “Power BI Level 2 – Intermediate” courses or possess equivalent knowledge.
Some working knowledge of the DAX expression language would prove beneficial.
COURSE OBJECTIVES
Upon successful completion of this course, students will be able to:
- Understand the Basic Concepts of Data Modelling
- Understand How to Profile and Shape Data
- Understand the Importance of Key Fields in Tables
- Understand Relationships in Data Models
- Create and Manage Relationships
- Configure Table and Column Properties
- Understand the Need for Date Tables in Models
- Create a Date Table
- Understand the Concept of Data Granularity
- Understand Role Playing Dimensions
- Work with Multiple Fact Tables
COURSE SHEDULE
|
1. Data Modelling Basics One Table or Many Tables? Star Schema Snowflake Schema Fact Tables Dimension Tables 2. Loading Data into a Model Loading Data Profiling Data Shaping Data Primary and Foreign keys Creating Key Fields 3. Entity Relationships Creating Relationships Relationship Types Cardinality Cross Filter Direction Active & Inactive Relationships Working With Many to Many Relationships Creating Bridge Tables |
4. Table and Column Properties Column Data Types Formatting Column Data Setting a Column Default Aggregation Categorising Column Data Grouping Data Sorting Columns Adding New Columns Building Hierarchies Other Semantic Model Properties 5. Date Tables Why We Need Date Tables Auto-Created Date Tables Date Dimension Tables Creating a Date Table 6. Data Modelling Advanced Topics Header/Detail Tables Multiple Fact Tables Role Playing Dimensions Table Granularity Hierarchical Data Tracking Changing Data Slowly Changing Dimensions |
Power BI - Tabular Data Modelling DURATION: 1 Day
Course Overview
Power BI - Tabular Data Modelling DURATION: 1 day INTRODUCTION This course is aimed at people who already have some experience using Power BI who want to focus on building more robust data models for analytical and reporting purposes. Attendees will get the opportunity to use Power BI’s data modelling features to design and arrange their data into industry standard dimensional models, optimised for better reports and dashboards. This is a practical hands-on course with guided walkthroughs in designing a simple data model. The course starts with a look at the basic concepts of data modelling. This is followed by an analysis of the process of loading and profiling data from external sources, shaping that data into appropriate structures that will define our model, and working with key fields.
INTRODUCTION
This course is aimed at people who already have some experience using Power BI who want to focus on building more robust data models for analytical and reporting purposes.
Attendees will get the opportunity to use Power BI’s data modelling features to design and arrange their data into industry standard dimensional models, optimised for better reports and dashboards.
This is a practical hands-on course with guided walkthroughs in designing a simple data model.
The course starts with a look at the basic concepts of data modelling. This is followed by an analysis of the process of loading and profiling data from external sources, shaping that data into appropriate structures that will define our model, and working with key fields.
Tables in a model don’t typically stand in isolation and are instead related by common data that exists in those tables. Module three looks at these relationships, examines the types and cardinality of relationships, and how to create and manage relationships, as well as considering some more advanced topics.
With data in our model, module four then considers the different table and column properties that can be set to improve the model further. This will include a review of the different data types that can be set on column data, configuring a column to behave as an implicit measure, and how to create basic groupings of data.
Very typically in reporting we need to analyse data over time periods. Module five discusses how we can implement date tables into our model, ways in which they can be created, and how they should be structured to provide appropriate analysis of our data.
There are many other considerations to take into account when designing a data model and the final module, time permitting, looks at some more advanced topics, such as dealing with header/detail data tables, table granularity, and considering how to deal with data that changes over time.
Of note, this course is about the concepts of modelling data and does not cover Power Query or DAX in any great depth. There are separate courses tackling the topics of cleansing and transforming data with Power Query, and likewise for extending the data model with the DAX expression language.
Due to the ever-changing nature of this technology, course content may vary to keep the training as relevant and up to date as possible.
PREREQUISITES
Delegates should have previously attended the “Power BI Level 1 – Introduction” and “Power BI Level 2 – Intermediate” courses or possess equivalent knowledge.
Some working knowledge of the DAX expression language would prove beneficial.
COURSE OBJECTIVES
Upon successful completion of this course, students will be able to:
- Understand the Basic Concepts of Data Modelling
- Understand How to Profile and Shape Data
- Understand the Importance of Key Fields in Tables
- Understand Relationships in Data Models
- Create and Manage Relationships
- Configure Table and Column Properties
- Understand the Need for Date Tables in Models
- Create a Date Table
- Understand the Concept of Data Granularity
- Understand Role Playing Dimensions
- Work with Multiple Fact Tables
COURSE SHEDULE
|
1. Data Modelling Basics One Table or Many Tables? Star Schema Snowflake Schema Fact Tables Dimension Tables 2. Loading Data into a Model Loading Data Profiling Data Shaping Data Primary and Foreign keys Creating Key Fields 3. Entity Relationships Creating Relationships Relationship Types Cardinality Cross Filter Direction Active & Inactive Relationships Working With Many to Many Relationships Creating Bridge Tables |
4. Table and Column Properties Column Data Types Formatting Column Data Setting a Column Default Aggregation Categorising Column Data Grouping Data Sorting Columns Adding New Columns Building Hierarchies Other Semantic Model Properties 5. Date Tables Why We Need Date Tables Auto-Created Date Tables Date Dimension Tables Creating a Date Table 6. Data Modelling Advanced Topics Header/Detail Tables Multiple Fact Tables Role Playing Dimensions Table Granularity Hierarchical Data Tracking Changing Data Slowly Changing Dimensions |
