Microsoft Fabric: End-to-End Project

In this video, we go through the end-to-end Power BI project using various components of Microsoft Fabric. Join us to understand the full scope of Microsoft Fabric's functionalities in real-world applications.

📊 What you'll learn:
- Set up a new Lakehouse in Microsoft Fabric.
- Upload tables from multiple sources using different ways to the Lakehouse.
- Create a data model and calculations directly within the Lakehouse.
- Build a Power BI report using DirectLake mode.

⏱️ Timestamps:
00:00 – Introduction
00:50 – Agenda
01:30 – Create a Lakehouse
02:25 – Different ways to upload data into the Lakehouse
04:00 – Create a shortcut to Fabric Warehouse
05:40 – Create a pipeline
09:54 – Turn CSV files to tables using the “Load to Tables” feature
12:30 – Turn Excel files to tables using Dataflows Gen2
22:24 – Create relationships between the tables
26:36 – Create measures
31:57 – Troubleshoot and build a Power BI report with DirectLake mode

🔗 Useful links and resources:

🤝 Let's Connect:

​​Centida GmbH
34 ​​Kernenhofstrasse​, Oberkirch​​
77704, ​German​​y

#MicrosoftFabric #PowerBI #Training #EndToEndProject

👍 If you found this video helpful, please give it a thumbs up, and consider subscribing to stay updated with our series. Your engagement helps us create more valuable content for the community.

[TinuolaOshinubi]

Thanks for sharing.. earned a new follower

[rgulamhussein]

Thank you! Your teaching style is awesome! This is the first of your videos that I have watched. Can I ask you for some pointers in loading XML files?
Riz

[mustafakamal]

Very Well explained, Thank you so much for sharing this! . Can you also advise on the integration of Azure Key vault in Fabric..

[jenniferokeke]

what I have been looking for, this is great!

[royalpriestly]

I love this so much.

Can I have access to the data used so I could practice it?

Would really love that

[ebywyfs]

Great video. Once the modelling is done, I could also use PBI desktop to connect to the model and build a report, right?

[khan.naved]

instead of using flow for excel we can use notebook to populate data into new tables from excel

[dvrygsn]

Thanks for making this. Fabric seems to be getting traction among enterprises. Do you know when the copilot is out and how can we start using that?

[antonzhong]

Thanks for sharing this. For create relationship, is it better in SQL Analytics Endpoint or by create new dataset (Semantic model). And may I know the pros and cons between the two ? Thanks again.

[tyronefrielinghaus]

Your 'error' on the column data type (price), was actually very instructive...are you sure you didn't do it on purpose (laughs!) Good to see how to problem solve : thanks. OH, and super video. Glad you made it fairly straighforward.

[VenkatprasadYadav]

thanks for the video @centidaBI and I have a question/ How you loaded the factorders.csv file into data warehouse ?

I could see other files as well loaded into warehouse. can you help me with the approach to load the csv files into warehouse ?

[Cantblendthis]

Thank you for this demo. Can you share the Order Details and Fact Orders as a csv? This way we can still complete the training without the shortcut or pipeline data load.

[amitshelke]

How did you increase font size in formula bar at timestamp of 27:20. Please help me with the shortcut.

[ThinakaraRajuChitra]

Thank you for the lesson. I have an doubt in the line chart, we can arrange the month in order on powerbi desktop .What we have done in powerbi sortby column that i cannot able to perform in fabric. Can you able to teach me to sort out this problem.

[cargouvu]

Is there a way to prevent snakes and mosquitoes? I guess if the water isn't stagnant mosquitoes may not come but snakes can get attracted to water. I wasn't sure if this was accounted for during the construction.

Beautiful home... absolutely phenomenal.

[gauravsukhadia]

During Power query online get data from one drive is it possible to point it to folder so all files inside gets loaded in one shot ?

[tinjxqn]

My company has some data on Azure SQL that refreshes once every 24 hours.
I can write dataflow to bring selected rows into PowerBI.
However I want to create some reusable summary tables for which I think Python would be great.

Is it possible that in Lakehouse,
1- I create Dataflow that brings data from Azure SQL into a table
2 - Create scheduled pipeline that runs every 24 hours and runs the Dataflow that overwrite my table
3 - Use Pyspark or something similar to create the summary table
4 - Write that table to Lakehouse

I am not sure how step 3 and 4 will be automated on schedule? And I am not sure if above is possible at all?

Can you please help?

[spacespectale]

u should provide the data set link that you have used in the project..which will be helpfull for us to practice along with you

[dheerajy]

Hello, @5:05 How to get the WWI_FactOrders table? Please help. Thank you in advance.

[Sozvdn]

@centidabi @nik, Great video on end-to-end fabric. is there way I get the same dataset for trying out.?