What is Microsoft Fabric & what can we DO with it?
Vložit
- čas přidán 13. 07. 2024
- Microsoft recently announced Fabric, a unified data platform. In this video let me jargon bust and explain what it is all about.
In this video:
==========
◉ What is Microsoft Fabric?
◉ How Fabric is related to Power BI?
◉ What can we do with Fabric?
◉ A real-world example of Fabric
◉ Various Fabric components - Data Factory, One Lake, Purview, Real-time Analytics
⏱ Timestamps:
=============
0:00 - What is Microsoft Fabric
2:05 - Fabric is not "completely" new
2:44 - As a data person, what does Fabric mean to you?
3:48 - A real-world example of Microsoft Fabric
😎 Watch next
=============
Database vs. Data Warehouse vs. Data Lake - • KNOW the difference be...
Top 20 BI & Data Analytics terms explained easily - • Top 20 Data & BI terms...
What is ETL? • What is ETL with a cle...
What is SQL? • SQL Basics for people ...
~
Why is the data analyst ashamed...?
He was caught without a fabric on him 🤣 - Věda a technologie
Watched so many CZcams clips on MS fabric, but your description of it is by far the best, nice one! keep it up Chandoo, you have an amazing gift.
Wow, thank you!
plz continue with this series... on a seperate playlist
Thanks Chandon for the update . You are awesome. Your explanation strategy and style is just superb . Keep going . This old man is ready to learn more . Keep it up .
These type of presentations are damn good!
Very useful to understand this, thanks Chandoo!
Hey Thank Chandoo. Like every time this time also you bring complex topic in simple format. Easy to Understand. Want more video on every aspect of Fabric.
Wonderful explanation with use of simple and effective examples 👍
Hi sir make more videos on how Microsoft Fabric can be used by a Data Analyst, Data Scientist, etc. Thank you for this explanation.
Really awesome understandable video❤
I love this guy :) Wonderful explanation
That is one mount of a video man!!!! It is huge and thee BEST!!!!
So awesome integration of services at one place
Awesome. Great lego explanation!
This is the most comphensive tutorial on microsoft fabric
Thank you sir for sharing it
Great explanation 👌
super thanks you are genuis
Video chala baagundhi
Great explanation. Ty
Came accross different vedios but this vedio is simple and effective ❤❤
Glad to hear that
top,
Thank You
What you're doing is really great. Thanks Chandoo
Thanks for the love and super Mark 😍
Thanks for simplified explanation.
Glad it was helpful!
Nice presentation Chandoo🎉
chandoo.. Anna garu.. meru super..., Anna garu telugu lo full end to end data analytics video cheyandi pls anna. iam learned lot from Ur channel, PBI ,EXCEL. need more videos on 1)data factory 2)power query 3)MS Fabric
Woww you just made the understanding of this new ms capability extremely clear to me... if microsoft succeeds in fully pulling this off it will disrupt the expensive enterprise performance management (epm) solutions market... this solves the exact problem the organization i work for.... am going to focus and hone my microsoft excel skills...
Thanks
Thanks SIR C
You just made Microsoft Fabric make sense to me.
I've been having a hard time understanding what it's all about, much less explain it to my team
Hi chandoo thanks for your wonderful videos and pls provide us more videos on ms fabric and how we can use it for data analysis....
great and very funny explanations, thank you so much. Now, I understood the concets behind ms fabric 🙂 In my eyes ms reduced a little bit the chaos in its messy ecosystem ;-) It seems a good approach to query all the data from one place, but on the other side you have to implement a strict data governace and a robust metadata management, isn't it?
Thank you explained about Fabric can you please make more videos on fabric technology understand...
Hey man, great stuff thanks for teaching us all. one question, Is MS Fabric generally available or when it can be?
Its a request, it would be a blessing to have a Microsoft Fabric Course or playlist curated by you. Can we expect one coming in the near future ?
I liked this video as soon as I saw LEGO people used to explain the concept
Please make more videos for microsoft fabric
I've written about your website during my career. It's wonderful to connect with you through your YT channel now.
I wanted to ask if Fabric requires all 3 sections to be on Microsoft platforms or can it be a heterogeneous setup.
While I can see that the OneLake will provide an end-to-end view of the data pipeline, shouldn't there be a data dedup process going on before you get to work on the Analytics side of things?
Or is this something that is overlooked by companies?
Thanks for all your hard work and making things simpler for us. 👍🏽🙏🏽
Thanks for the love 😍
You can use "shortcuts" in Onelake to connect to data outside (for ex. S3 buckets) But tbh, I find it costlier as you would pay for both platforms. I agree that companies may want dedup in the pipeline, and you can achieve by just creating an intermediate storage destination in your pipeline.
If you want to use other platforms to do parts of the process, it might be a lot cheaper to just not use fabric as the cost savings only come thru when everything is in one place.
Hi Chandoo,
I have some complex "Scalar user defined functions" defined in MYSQL and I have to migrate them to fabric, but as of now fabric doesn't support creation of "Scalar user defined functions" in warehouse. In this scenario please let me know alternative options I can use.
Thanks
Learning Excel, or Power BI, PQ, DAX can all be done by one person on a PC. This stuff is different, larger scale, many people involved, different hardware. I know Excel and Power BI desktop quite well, but this "lake" environment seems to be another world. Maybe there will be a smaller version where you can practice all this on your own?
You can sign up for a free trial and give it a go. But as I mentioned in another comment, Fabric is a platform with the core ingredients like Power BI, coding, SQL & Power Query based flows. As long as you know those, you can use Fabric quite well.
It also depend of you goals and usage, if you are a powerbi user that do not use data Science and machine learning, there is not such a large incentive to use fabric. You can use powerbi premium and you will have dataflows (power query online,) a good online data storage and very simplified and automated data Science access for $20 a month...
But if you want to explore the data Science space, or your company work with very large data and you need a data warehouse, then fabric becomes more appealing...
If you dare to start exploring data science and coding, the spark notebooks with one lake behind is a very attractive way to start learning...
So first explore you data needs and explore fabric if there is a good match between your needs (and future professional goals) and this new framework...
Great Presentation. But I am still not clear why we need it ?
For example, if I want to analyse data stored in Microsoft SQL server DB into power BI. I can GET DATA from the database using the connector and credentials and then transform to analyse it.
How does fabric help here ? Thanks
Fabric is a competitor for Snowflake, which is a Cloud DWH stores not only structured data but also your un-structured data and files etc in a single place.
So Fabric is similar to Snowflake ...
Bhayya super
sir please make a videos on different advance power bi projects for resume building
Hi Chandoo. A quick question. In Microsoft Fabric, can we create a one-time measures so I can use it in Excel, PBI, etc instead of creating separately in different platforms? Do you have any idea on that?
Yes we can.
We can also create them without Fabric (using Power BI datasets and then Analyze in Excel)
Fabric is really a piece of cloth😀👍
Hi Chandoo sir, Is there any video regarding ,"Create power bi visuals using Microsoft Fabric" ???
And so I hope Chandoo, Microsoft will offer pricing competitive advantage in terms of its subscription fees, etc. Some of the Data Hub and Cloud Computing Tools are costly.
Unlike Power BI's per user pricing, Fabric has compute & storage pricing. Fabric pricing seems to be competitive, but the costs can go up quickly if you do a lot of compute or storage.
So learning Microsoft fabric will definitely add a feather to one's cap? And land up in getting a good salary job.. Please tell what is the scope of thia
Please upload video on purview
Hey Chandoo.
I think the reality is this:
Major (Fortune 500 companies) are so cheap that they try to do everything with Excel, and PowerBI.
Nevermind Data engineers, Data Warehouses and Analytics teams.
Most of the time some IT guy, or a good administrator will have to jump through flaming hoops to try to extract, clean, organize and display data from multiple systems.
Like SAP, Proficy, GRP and all sort of systems you can name under the sky.
I see that this is a good startup! But honestly? I am not convinced that this will work in real life. If it will it will take another 10 years to grow into.
Love your content! Keep up the good work and grow back the hair! We need the old Chandoo back from the profile picture!
Greetings from Hungary.
do the demo video and how to get started with the Microsoft Fabric
So it's ready for use or still in dev phase?
Its great but still I dont understand use case as a power BI user. Eg, in power BI we can connect to any data set or data base without copying also. Can you please explains how fabric helps here?
From my understanding: currently Power BI, when using import method, stores a new copy of the data as Power BI datasets. In Fabric, the Power BI Dataset is replaced with a Semantic model, which is nothing but a meta layer pointing to the data that already exists in the Fabric OneLake, thereby not having to create a new copy of the data.
Hi.
I got lost when you said that in the past you were not able to get what DE do and now they can put in in One Lake..
Are you talking about a cenario when the Data Analyst didn't have access to SQL ?
Otherwise I didn't understand the concept because I could reach out to my DE team to request a new logic in a table and then I could connect to the table using SQL ''as our shared place'' and everything was fine.
I don't know If I missed something and I couldn't see the benefit yet ..
I was talking about a situation without onelake. If there is no centralized repository, the DE team may not want to build tables for one off requests. But with a central storage like onelake anything they do ends up in the OL and I can see and use it. Doesn't happen everytime, but I see that happen previously.
On a more generic note, if you already have a functional DE teams, central storage and tight integration to Data Analytics + Science tools you probably don't get much out of Fabric.
Fabric is a competitor for Snowflake, which is a Cloud DWH stores not only structured data but also your un-structured data and files etc in a single place.
So Fabric is similar to Snowflake ...
so this is great for facilitating work across large teams. but if I'm a one-man band I can probably keep using OneDrive and SharePoint yeah?
Yes. In its current form it is a very expensive and over engineered solution for small teams.
Chandoo, your videos are fantastic but I am still at the very basic level but, learning. I am struggling with excel 2010 & 2016 versions with counting the coloured cells with numbers in them. If we had 20 cells with blue, red and yellow cells, how can I show the quantity of the colours as a result in another cell, i.e, 5 yellow, 10 red and 5 blue cells? Thank you
So sir should we learn this insted of powerbi.
Fabric is not an actual tech. It is a platform. The ingredients are still Power BI, Data Science, SQL and Data concepts. So focus on learning those, but also try to understand how they apply on Fabric platform.
@@chandoo_ Thanks sir.
Fabric is similar to Snowflake ...it can store your data str and unstr data etc in the cloud platform...u must use power bi to create your reports
How to integrate created visual in Data science into Power BI Report
I have created a new visual for forecasting any value in Microsoft Fabric Data science environment with help of writing python code in notebook where I have used the same Lakehouse which I used when I created an Power BI report. No I want to connect that Visual into my report then how is it possibile to do so?
Not able to get any clear information
You can use the Python Visual option in Power BI and embed your code to make the visual.
@@chandoo_ Thank you sir for the help but May I confirm as we have got the Power BI desktop datasource connection with Lakehouse so isn't there any interlink of this created visual in notebook (Data science) could directly fetch into our power BI report?
I have not tried that option, but there might be some way to bring a notebook.
@@chandoo_ Thank you sir. Can you please make some insightful video on this as not able to get any clear picture on this, it would be really helpful.