What is Microsoft Fabric & what can we DO with it?

Рет қаралды 56,106

Күн бұрын

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 🤣

Пікірлер: 77

@peterdallyn6440 Жыл бұрын

Watched so many KZfaq 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.

@chandoo_ Жыл бұрын

Wow, thank you!

@jeekakrishna Жыл бұрын

plz continue with this series... on a seperate playlist

@ravim49 Жыл бұрын

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 .

@samose100 Жыл бұрын

These type of presentations are damn good!

@stellyozoms6203 8 ай бұрын

This is the most comphensive tutorial on microsoft fabric

@BI_Monkey 10 ай бұрын

Wonderful explanation with use of simple and effective examples 👍

@chrism9037 Жыл бұрын

Very useful to understand this, thanks Chandoo!

@views-re2om 7 ай бұрын

I love this guy :) Wonderful explanation

@narayanjena4259 Жыл бұрын

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.

@sapnanayak1453 Жыл бұрын

Hi sir make more videos on how Microsoft Fabric can be used by a Data Analyst, Data Scientist, etc. Thank you for this explanation.

@anilv3165 Жыл бұрын

So awesome integration of services at one place

@asureshkumarin Жыл бұрын

Thanks for simplified explanation.

@chandoo_ Жыл бұрын

Glad it was helpful!

@aiasaiascon3894 Жыл бұрын

That is one mount of a video man!!!! It is huge and thee BEST!!!!

@durgad4763 Ай бұрын

Came accross different vedios but this vedio is simple and effective ❤❤

@chandoo_ Ай бұрын

Glad to hear that

@markward251 Жыл бұрын

What you're doing is really great. Thanks Chandoo

@chandoo_ Жыл бұрын

Thanks for the love and super Mark 😍

@varun1023 29 күн бұрын

Really awesome understandable video❤

@taizoondean689 Жыл бұрын

Thank you sir for sharing it

@Metzanine Жыл бұрын

Awesome. Great lego explanation!

@falzar101 7 ай бұрын

Great explanation. Ty

@vamsi8708 5 ай бұрын

Video chala baagundhi

@duurduranto Жыл бұрын

Great explanation 👌

@chandrakantha648 4 ай бұрын

Nice presentation Chandoo🎉

@srinathp4486 11 ай бұрын

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

@williamhowe2705 6 ай бұрын

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...

@user-bz9kw6xp1i 5 ай бұрын

top, Thank You

@emmanuelapalowo5744 10 ай бұрын

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

@user-yl1fo5wy6q 11 ай бұрын

Thanks

@mamalik1088 Жыл бұрын

Thanks SIR C

@robertbutscher6824 10 ай бұрын

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?

@piyushnautiyal6271 Жыл бұрын

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....

@digamberdeshmukh974 Жыл бұрын

Thank you explained about Fabric can you please make more videos on fabric technology understand...

@cinemax4D 3 ай бұрын

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 ?

@angmathew4377 8 ай бұрын

Hey man, great stuff thanks for teaching us all. one question, Is MS Fabric generally available or when it can be?

@Aristarkhos31 Жыл бұрын

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. 👍🏽🙏🏽

@chandoo_ Жыл бұрын

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.

@rob_kujawa Жыл бұрын

I liked this video as soon as I saw LEGO people used to explain the concept

@suprajapatil 4 ай бұрын

Please make more videos for microsoft fabric

@barttitulaerexcelbart9400 Жыл бұрын

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?

@chandoo_ Жыл бұрын

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.

@oscarzapatajr2 Жыл бұрын

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...

@kebincui Жыл бұрын

Fabric is really a piece of cloth😀👍

@krahul456 Жыл бұрын

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

@BhaskarJogiSQLandBI 5 ай бұрын

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 ...

@paulabhilash5852 Жыл бұрын

sir please make a videos on different advance power bi projects for resume building

@mdazim08 Жыл бұрын

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?

@chandoo_ Жыл бұрын

Yes we can. We can also create them without Fabric (using Power BI datasets and then Analyze in Excel)

@sathyamanikantabk4483 Жыл бұрын

do the demo video and how to get started with the Microsoft Fabric

@arunkumarr6059 Ай бұрын

Please upload video on purview

@abhayrajsinghbisht9999 7 ай бұрын

Hi Chandoo sir, Is there any video regarding ,"Create power bi visuals using Microsoft Fabric" ???

@user-dy8xu7uj8k 24 күн бұрын

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

@megabuilds3007 Жыл бұрын

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?

@johnedward4171 4 ай бұрын

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.

@JoshAutomates Жыл бұрын

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.

@chandoo_ Жыл бұрын

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.

@asmitjais3776 11 ай бұрын

So it's ready for use or still in dev phase?

@ritudahiya6223 9 ай бұрын

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

@jaggumuggu 4 ай бұрын

Bhayya super

@JK-yd9jy Жыл бұрын

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?

@chandoo_ Жыл бұрын

Yes. In its current form it is a very expensive and over engineered solution for small teams.

@joelluis4938 Жыл бұрын

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 ..

@chandoo_ Жыл бұрын

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.

@BhaskarJogiSQLandBI 5 ай бұрын

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 ...

@thegoldenagelegendz4425 Жыл бұрын

So sir should we learn this insted of powerbi.

@chandoo_ Жыл бұрын

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.

@thegoldenagelegendz4425 Жыл бұрын

@@chandoo_ Thanks sir.

@BhaskarJogiSQLandBI 5 ай бұрын

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

@vishaljuneja000 Жыл бұрын

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

@chandoo_ Жыл бұрын

You can use the Python Visual option in Power BI and embed your code to make the visual.

@vishaljuneja000 Жыл бұрын

@@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?

@chandoo_ Жыл бұрын

I have not tried that option, but there might be some way to bring a notebook.

@vishaljuneja000 Жыл бұрын

@@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.

@donnybigboy Жыл бұрын

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

@szita2000 Жыл бұрын

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.