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 .
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
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.
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?
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...
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.
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 ...
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
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
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.
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.
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?
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.
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...
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 ...
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
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_ 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?
Watched so many RUclips 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!
Hi sir make more videos on how Microsoft Fabric can be used by a Data Analyst, Data Scientist, etc. Thank you for this explanation.
Came accross different vedios but this vedio is simple and effective ❤❤
Glad to hear that
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
This is the most comphensive tutorial on microsoft fabric
Superb explanation 👌
What you're doing is really great. Thanks Chandoo
Thanks for the love and super Mark 😍
Really awesome understandable video❤
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.
I love this guy :) Wonderful explanation
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 ?
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?
So awesome integration of services at one place
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...
Wonderful explanation with use of simple and effective examples 👍
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
Hey man, great stuff thanks for teaching us all. one question, Is MS Fabric generally available or when it can be?
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.
super thanks you are genuis
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 ...
Thank you explained about Fabric can you please make more videos on fabric technology understand...
Thanks for simplified explanation.
Glad it was helpful!
That is one mount of a video man!!!! It is huge and thee BEST!!!!
Very useful to understand this, thanks Chandoo!
Please make more videos for microsoft fabric
I liked this video as soon as I saw LEGO people used to explain the concept
Nice presentation Chandoo🎉
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.
Great explanation. Ty
Hi Chandoo sir, Is there any video regarding ,"Create power bi visuals using Microsoft Fabric" ???
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
top,
Thank You
Video chala baagundhi
Thanks
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....
Thank you sir for sharing it
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
sir please make a videos on different advance power bi projects for resume building
Great explanation 👌
Awesome. Great lego explanation!
do the demo video and how to get started with the Microsoft Fabric
Please upload video on purview
So it's ready for use or still in dev phase?
Fabric is really a piece of cloth😀👍
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.
Thanks SIR C
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
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)
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.
Bhayya super
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...
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
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.