Data Modelling For Beginners
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + .srt | Duration: 20 lectures (1 hour, 49 mins) | Size: 667 MB
Hands -on Data Modelling from scratch

What you'll learn
Connect to Microsoft Access Database
Install Power BI Desktop
Create and manage data relationship
Create calculated columns
Optimize models for reporting
Implement time intelligence on data
Apply filters on visuals

Requirements

Microsoft Office 365 ( You will learn how to get this on the course)
Power BI ( You will learn how to install it on the course)

Description

A data model refers to the logical inter-relationships and data flow between different data elements involved in the information world. It also documents the way data is stored and retrieved. Data models help represent what data is required and what format is to be used for different business processes

Power BI is a business analytics solution that lets you visualize your data and share insights across your organization, or embed them in your app or website. Connect to hundreds of data sources and bring your data to life with live dashboards and reports.

Data Modeling is one of the features used to connect multiple data sources in BI tool using a relationship. A relationship defines how data sources are connected with each other and you can create interesting data visualizations on multiple data sources.

With the modeling feature, you can build custom calculations on the existing tables and these columns can be directly presented into Power BI visualizations. This allows businesses to define new metrics and to perform custom calculations for those metrics.

What You will Learn includes:

How to connect to Microsoft Access Database File

How to create and manage data relationship

How to create calculated columns

How to optimize models for reporting

How implement time intelligence on data

How to apply filters on visuals

Who this course is for:

Beginners to data modelling