Data Modelling For Beginners

Hands -on Data Modelling from scratch

Last updated 2022-01-10 | 3.8

- Connect to Microsoft Access Database
- Install Power BI Desktop
- Create and manage data relationship

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

Course content

3 sections • 21 lectures

Introduction Preview 01:04

Signing Up to Office 365 Preview 07:18

What is Power BI Preview 05:47

What is Power BI Desktop Preview 03:40

Installing Power BI Desktop Preview 07:39

Power BI Desktop quick tour Preview 06:07

Power BI Overview -Part 1 Preview 04:24

Power BI Overview -Part 2 Preview 04:05

Power BI Overview -Part 3 Preview 04:49

Components of Power BI Preview 02:57

Exploring Power BI Desktop Interface Preview 06:06

Exploring Power BI Service Preview 04:28

What are Power BI Apps Preview 03:56

What is Data Modelling Preview 00:42

Connecting to Microsoft Access Sample Database Preview 05:20

Creating and Managing Data Relationship Preview 11:53

Creating calculated columns Preview 10:49

Optimizing Models for Reporting Preview 11:02

Time intelligence Preview 04:20

Applying Filters on Visuals Preview 03:19

Thank You Preview 00:09