Data Modelling For Beginners
4.2 (19 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
4,151 students enrolled

Data Modelling For Beginners

Hands -on Data Modelling from scratch
4.2 (19 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
4,151 students enrolled
Last updated 4/2020
English
English [Auto]
Current price: $41.99 Original price: $59.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 2 hours on-demand video
  • 1 downloadable resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
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
Expand all 20 lectures 01:49:45
+ Introduction and Setup
6 lectures 31:35
What is Power BI Desktop
03:40
Installing Power BI Desktop
07:39
Power BI Desktop quick tour
06:07
+ Power BI Overview
7 lectures 30:45
Power BI Overview -Part 1
04:24
Power BI Overview -Part 2
04:05
Power BI Overview -Part 3
04:49
Components of Power BI
02:57
Exploring Power BI Desktop Interface
06:06
Exploring Power BI Service
04:28
What are Power BI Apps
03:56
+ Data Modelling
7 lectures 47:25
What is Data Modelling
00:42
Connecting to Microsoft Access Sample Database
05:20
Creating and Managing Data Relationship
11:53
Creating calculated columns
10:49
Optimizing Models for Reporting
11:02
Time intelligence
04:20
Applying Filters on Visuals
03:19