Microsoft Fabric Quickstart - From Data To Report

Load data, model relationships, create a report and automate the processes

What you'll learn

Learn how to use Microsoft Fabric to load data into the environment using a Lakehouse, Datawarehouse or Power BI Dataset

Become familiar with where to transform data and model relationships in Microsoft Fabric

Learn where to create reports and best practices around when to use Power BI Desktop

Be able to refresh data and reports automatically

Requirements

No experience required although Power BI Desktop knowledge is beneficial

Description

This hands on technical course shows you how to load your data into the environment, have the ability to transform your data and model data relationships. We’ll then go on to connect that data to a Power BI report so you can share insights with your stakeholders and support your organisation leveraging the value of it’s data. Finally we’ll look at some different options of how to schedule data refreshes so you can automate processes and save valuable time.It's intended to be a quick start course that gets you started using Microsoft Fabric within just a few hours. This course differs from other courses in that we won’t be looking at MS Fabric in terms of lots of individual elements leaving you to figure out how to piece it all together so that you can make it work for you. We all know that we are aiming to share our data with people in our organisations in the most efficient way and that is at the heart of this course.The course also includes an overview of key terms within Microsoft Fabric to ensure you understand the overarching landscape. In addition to understanding the individual experiences we'll also cover concepts like OneLake and Delta tables so you can see how it all works together. You'll also learn about how the platform uses coding options like Apache Spark and T-SQL as well as having the option to use no-code tools like Dataflows Gen(2) and Data Pipelines.

Overview

Section 1: Introduction to quick start set up in Microsoft Fabric

Lecture 1 Introduction

Section 2: The Lakehouse

Lecture 2 Lakehouse Intro

Lecture 3 Create Lakehouse and Load in data

Lecture 4 Model relationships online

Lecture 5 Create online report

Lecture 6 Create Power BI Desktop report

Lecture 7 Automating data and report refreshes

Lecture 8 Lakehouse Summary

Section 3: The Datawarehouse

Lecture 9 Datawarehouse Intro

Lecture 10 Create datawarehouse and load in data

Lecture 11 Model relationships online

Lecture 12 Create online report

Lecture 13 Create Power BI Desktop report

Lecture 14 Automating data and report refreshes

Lecture 15 Datawarehouse Summary

Section 4: Power BI Datasets

Lecture 16 Power BI Dataset Intro

Lecture 17 Create datasets

Lecture 18 Create reports

Lecture 19 Automating data and report refreshes

Lecture 20 Power BI Dataset Summary

Section 5: Understanding Microsoft Fabric - key features and terminology

Lecture 21 Intro

Lecture 22 What is OneLake

Lecture 23 What is a lakehouse

Lecture 24 What is a datawarehouse

Lecture 25 What is realtime Analytics

Lecture 26 What is data factory

Lecture 27 What is data science

Lecture 28 How to administer Microsoft Fabric

Lecture 29 Summary

Section 6: Conclusion

Lecture 30 Conclusion

Anyone wanting to know how to get started in Microsoft Fabric