Data Modeling in Power BI : Build powerful data models

Data Modeling in Power BI : Build powerful data models

Data Modeling in Power BI : Build powerful data models

Learn the key concepts of data modeling on Power BI: Build powerful data models with DAX

Language: english

Note: 0/5 (0 notes) 256 students  New course 

Instructor(s): Bluelime Learning Solutions

Last update: 2022-10-31

What you’ll learn

  • Create model relationships
  • Configure data tables
  • Create calculated columns
  • Enforce row -level security
  • Create models with DAX formulas
  • Create measures

 

Requirements

  • Power BI Desktop required. ( The installation is covered in the course)

 

Description

Data modeling is the process of creating a simplified diagram of a software system and the data elements it contains, using text and symbols to represent the data and how it flows. Data models provide a blueprint for designing a new database or reengineering a legacy application. Overall, data modeling helps an organization use its data effectively to meet business needs for information.

A data model can be thought of as a flowchart that illustrates data entities, their attributes and the relationships between entities. It enables data management and analytics teams to document data requirements for applications and identify errors in development plans before any code is written.

Alternatively, data models can be created through reverse-engineering efforts that extract them from existing systems. That’s done to document the structure of relational databases that were built on an ad hoc basis without upfront data modeling and to define schemas for sets of raw data stored in data lakes or NoSQL databases to support specific analytics applications.


Why is data modeling done?

Data modeling is a core data management discipline. By providing a visual representation of data sets and their business context, it helps pinpoint information needs for different business processes. It then specifies the characteristics of the data elements that will be included in applications and in

 

Who this course is for

  • Beginners to Power BI Data Modeling

 

Course content

  • Power BI Setup
    • Introduction
    • What is Power BI
    • What is Power BI Desktop
    • Install Power BI Desktop
    • Exploring Power BI Desktop Interface
    • Download Sample Power BI File
    • Set Power BI Desktop Options
  • Data Modelling with Power BI
    • What is data modelling
    • Data Modelling Types
    • Create Model Relationships
    • Configure the Product table
    • Configure the Region table
    • Configure the Reseller table
    • Configure the Sales table
    • Bulk update properties
    • Review the model interface
    • Create quick measures
    • Create a many-to-many relationship
    • Relate the Targets Table
    • Enforce row-level security
  • Introduction to creating measures using DAX in Power BI
    • What is DAX
    • Create a Salesperson calculated table
    • Create a date calculated table
    • Create calculated columns
    • Complete the data table design
    • Mark the data table
    • Creating measures

 

Data Modeling in Power BI : Build powerful data modelsData Modeling in Power BI : Build powerful data models

 

Don’t miss any coupons by joining our Telegram group 

Udemy Coupon Code 100% off | Udemy Free Course | Udemy offer | Course with certificate