What is Microsoft Fabric? | New Data Analytics Platform!

Microsoft just announce Microsoft Fabric which is meant to be a unified data analytics platform.
In this video we will dive into some of the new features that will come with Microsoft Fabric.
There is a lot of tools and services that will be packaged in this platform so I won't dive into things like Azure Data Factory, Warehousing, and other already existing products. I will be focusing mostly on the new features that will come with Fabric.
Resources to Learn More:
1. techcrunch.com/2023/05/23/mic...
2. fabric.microsoft.com/groups/m...
3. www.microsoft.com/en-us/micro...
____________________________________________
SUBSCRIBE!
Do you want to become a Data Analyst? That's what this channel is all about! My goal is to help you learn everything you need in order to start your career or even switch your career into Data Analytics. Be sure to subscribe to not miss out on any content!
____________________________________________
RESOURCES:
Coursera Courses:
📖Google Data Analyst Certification: coursera.pxf.io/5bBd62
📖Data Analysis with Python - coursera.pxf.io/BXY3Wy
📖IBM Data Analysis Specialization - coursera.pxf.io/AoYOdR
📖Tableau Data Visualization - coursera.pxf.io/MXYqaN
Udemy Courses:
📖Python for Data Science - bit.ly/3Z4A5K6
📖Statistics for Data Science - bit.ly/37jqDbq
📖SQL for Data Analysts (SSMS) - bit.ly/3fkqEij
📖Tableau A-Z - bit.ly/385lYvN
Please note I may earn a small commission for any purchase through these links - Thanks for supporting the channel!
____________________________________________
BECOME A MEMBER -
Want to support the channel? Consider becoming a member! I do Monthly Livestreams and you get some awesome Emoji's to use in chat and comments!
/ @alextheanalyst
____________________________________________
Websites:
💻Website: AlexTheAnalyst.com
💾GitHub: github.com/AlexTheAnalyst
📱Instagram: @Alex_The_Analyst
____________________________________________
All opinions or statements in this video are my own and do not reflect the opinion of the company I work for or have ever worked for

[@mubastudio2322]

The more you go into Data Analysis/Science the more it gets more interesting 🙂 I'm really enjoying this 😻❤️

[@frederickzoreta6617]

Great explanation Alex! I’m really excited to see some courses in Fabric.

[@akin-ojoayotomide8909]

Looks like a really huge deal! Thanks for sharing Alex!

[@mdjavedfurquan4585]

Thanks Alex, very useful and informative video, waiting for next video and use this public microsoft fabric. 💙

[@AwanievaStudios]

I have been waiting for your video on Microsoft Fabric 👏👏

[@anshultiwari1303]

Thanks for the update Alex. It's was really knowledgeable and exiting information.

[@shujashakir9952]

You are right, Alex, in saying this is going to be mind-blowing. Any data analyst knows that the biggest headache is having to access your data scattered across different cloud platforms. If Microsoft succeeds in living up to its claims of providing integrated services through Fabric, it is nothing less than revolutionary. I am expecting a video on this channel on how to use Fabric when it is launched. There is no better person than Alex when it comes to understanding data!

[@AlexTheAnalyst]

I plan on it - looks super cool!

[@Analytics_Insider]

Kevin Chant made a great blog post on how to create a free Fabric workspace for developers (without any costs). You can find the guide here, if you are interested: kzbin.info/www/bejne/Y3eycp6Bpt6hpdU 🙃

[@user-lk8bx6kn6p]

Thanks for sharing your great insight! Alex.

[@anthonyarthurmensah5240]

Thanks so much, though I'm a data science newbie but your video is so good and this is the first time I'm watching you do a video. I will be following you from now and hoping i get better learning about data science. Thanks 🙏

[@EdsonNascimentoEN]

Hey Alex thanks for the great tutorial. Short simple and straight to the point.

[@LearnMicrosoftFabric]

Fabric offers a huge box of opportunities, it's amazing how much you crammed into this 7 minute video Alex - great work 💪

[@gdeekshithreddy]

Thanks for sharing Very informative 😊

[@renziereyes4830]

Thanks Alex! 😊

[@Anonymous03Jan]

Great explanation Alex Indeed this is going to ease a lot of tasks

[@ian9557]

Well, first time seeing your channel @Alex, but I just simply subscribed! !

[@thuyvandertd]

Curious to explore ⚡

[@alekseifilanovskii718]

Thanks for the video, it's nice and clear introduction. The only point I didn't get is how to centrally manage metadata. Is there any central catalog? Or Fabric relies on Table format of Delta Lake? If so, is there a way to get list of all tables?

[@KittyOzzyZiggy3895]

I actually downloaded this to start practicing on my Data Analytics

[@dinamuhamad1028]

I love your smile; it is contagious.

[@wilsonman8661]

Thanks for the video Alex. When they said think of OneLake as OneDrive but for your data, I didn't realize they meant you'd be able to literally drag and drop data into a folder lmao I am most intrigued by OneLake and seeing how it works in practice. As a BI developer, DirectLake also caught my eye, although from what I've read from their own documentation so far (subject to flaws in interpretation by a dummy like me), you can only create a dataset using DirectLake through the web portal at this point in time. Granted, it's still in public preview so that may change. However, not being able to build out the dataset in Power BI Desktop, and by extension with all the third party tools currently available, is unfortunate.

[@AlexTheAnalyst]

Yeah it looks pretty awesome! Definitely something I would have loved to have when I was using Azure a ton

[@dashnaso]

You are the only one who has not been paid to advertise to the wrong crowd.

[@10.03MB]

Thanks for sharing…❤❤

[@analyticswithadam]

Microsoft are bringing their end user data tools to a whole new level. If the execution matches the demos it will be game changing, really interested in the security and privacy segmentation.

[@umardurrani6605]

Hi Alex, i hope you can clarify - if we can drop files into one lake, do we need ADF

[@row4509]

Hello Alex! Can I use a visualization tool to create charts and analysis, or do I have to stick with what comes out of the box in Microsoft Fabric?

[@elfinzilla]

Hello Alex, I am watching your channel!

[@joelluis4938]

Hi! I'm not sure if I've understood the concept of ''Shortcuts'' .. How are we supposed to get the data from SQL ? We uses to do it with Import Mode and it usually takes time when we are bringing historical data.. Does this change with Fabric ? I won't need to use import mode or something like that to save time? For example I work for a company which has the Database in RDS and I'm not sure if this could help us or not as this is new and I'm exploring what I can do...

[@user-br8ez4fg6g]

This is a really useful tool that improves the efficiency of data analytics

[@th3graduate292]

Thanks Alex.

[@bulletkip]

more fabric videos please. include use of notebooks

[@farooqverse]

So THEY will keep building AI models and platforms and in reaity teams for different departments and companies will be cut short and there will be need of a few people may be 1 or 2 person and most work is already being automated, I want to stay optimistic but reality is changing at a higher pace... GOD BLESS PEOPLE!!

[@myabowen9696]

Can data be pulled from the Jenzabar platform also?

[@temitopeakintunde4823]

Thank you

[@nahimrimon]

Yeah, Fabric is cool. Hey Alex, would you be planning to make Apache Spark, DeltaLake or DataBricks videos in the future. Because that would be great for some of us. Also, some cloud videos that as you say Azure like the potential of these services on Data Science. ❤ Thanks in Advance.

[@AlexTheAnalyst]

I think I will :)

[@marib9907]

@@AlexTheAnalyst Please do! :)

[@oscarzapatajr2]

It would be really great if you made a video comparing fabric features vs databrick... They seems to do many of the same things, and it would be great comparing them...

[@manhaabdellah3474]

Excellent

[@usmanmb1]

One more question alex, should we attempt the pl300 exam for data analyst, or is it irrelevant now?

[@aben6717]

Wow.. Awesome is this MS Fabric

[@dexterrity]

oh cool, this reminds me of the Databricks approach

[@87ricr]

The biggest concept aside from accessing data anywhere , its just the use of AI to basically do everything you need , Copilots will help users do everything. Is like having a "jarvis" guiding you through any concept as related to data ....end to end .... the era of AI is just amazing

[@srikark3532]

Super!

[@spamspamspamspam3459]

Would you make some videos on Azure?

[@joaquinmartino5111]

Alex! Is there another form of payment in Cousera apart from a Credit card??? I mean, the platform says that it also allows Paypal payments (for the courses or annual subscripton), but when I want to pay with Paypal it also ends me asking for a Credit card Does the possibilty of paying only with my Paypal account exist ????? (I mean, the platform substracting the payments from my Paypal balance) Thank you!!!!!

[@AbrarMuhtasim]

Hi Alex, I would like to ask for suggestions on how to secure data analyst interviews specifically for individuals with expertise in SQL, Power BI, and Tableau. Is it possible to land an interview if I only have knowledge of SQL?

[@homaiphuonganh131]

Love your videos Alex! so informative as always. Though I have to say for this one that the constant visual effect of the slide/ changing between the screen and your lovely face, with the 'vfump' sound effect across the video is so distracting for me xD

[@chidubemngini203]

Hi Alex, are we going to be getting a tutorial soon?

[@a3teni3alatawahini]

so we don't need to migrate data to Onelake but we need to have a copy in onelake. if we try to access the data from a PC on premise, will MS charge for egress traffic?

[@AnkitShah55]

Wow, this is game changer.

[@mohammedasif845]

Hello Sir, what's your opinion on International Institute of Business Analysis and it's certifications.

[@AbrarMuhtasim]

Hi Alex, I'm seeking some suggestions. I tend to get demotivated whenever I struggle to comprehend certain concepts or fail to solve tasks while taking a course. Could you please provide me with some tips on how to stay committed to a course and see it through to the end?

[@brucesmith3740]

Can I disengage Fabric while testing my app? Waiting for Node link to appear when executing Core C# is slowing me down?

[@KevinWard-ku1jz]

As an aspiring Data Analyst, should I still learn how to use Azure or should I focus on Fabric?

[@messey12]

*buckles in for what's ahead*

[@tTiger-kz3ly]

Sorry for the off-topic question, is it possible to work freelancer as data engineer?

[@jayhawkmba]

Marketing. Just like Synapse, most things are concepts or years out before its available. Let it snow ❄️

[@oluwabeejhay]

U re d best Alex

[@ShivamGupta_15]

Hi Alex, how will Microsoft Fabric be different from Azure Synapse Analytics which also integrates various tools at one place?

[@dagg497]

Fabric is overhyped imo. To me it's another licence packaging. Data Factory existed 3years ago, Synapse 2years ago. And Delta Lake is honestly annoying to work with when it comes to changing and incrementally updating parquet files compared to sql. They basically removed table storage like in SQL server, slowly changing dimensions and switched the storage blob/table storage into a unified storage format called parquet.. The only thing that likes parquet is Apache Spark/Databricks, which I also hate working with.. We had it so good with On-prem SQL Server and SSIS 😮

[@bandaralqahtani4356]

Thanks

[@edwinotieno9189]

What of the recent Tableau updates

[@dashnaso]

Why do people not mention the limitations for individual user of ower BI premium per user

[@limjuroy7078]

Hmm, Microsoft One Lake looks like Databricks Lakehouse. Does anyone have the same thought as me?

[@d1a9m9i1lare]

Hi Alex, I am curious to know your thoughts on what tools Fabric will be replacing. My first guess is Tableau

[@hi55us2]

Apples and Oranges with Tableau if you ask me.

[@user-yv5zk7vk8r]

Hi Alex, just a quick question. I am using Azure Virtual Machine and Azure SQL DB for hosting my website and mobile application. Is Microsoft fabric also providing hosting service?

[@AlexTheAnalyst]

I'm not sure - we will have to see in the future if they do or not

[@jaggyjut]

interested to know difference between snowflake vs fabric

[@mohammadfaisal9937]

Can you please make a detailed video on different data analytics environments such Azure, AWS, IBM, Google and more. Also how the data world works and the opportunities lies within

[@aimenyaugba6892]

Wow

[@amndev94]

As someone who was learning tableau and was preparing for getting transitioned to analytics from 4-5 months, microsoft has kind of stopped that completely. While doing job search, i can see now that power bi is superior and tableau gonna go down (very down). Shouldve listened to my friend who told me to learn powerbi instead 😅

[@depelterturbo]

What's better software development or analytics

[@amndev94]

@@depelterturbo anything with AI incorporated is better. or if you are into something that is without AI like creating databases, pipelines etc those are good for 2 years max. you know these software app development from scratch MIGHT BE replaced with low code or no code platforms in future. Try researching mendix, appian, outsystems, flutter, zoho. Theres a personal project created by some guy which is equal to Jarvis (without the overwheing 3D UI you can see floating). It can create landing page (for now) based on text

[@jraz6102]

@@amndev94 To be fair to Tableau - if it's paired with Salesforce Data Cloud, it will do the same thing as its a comparable product (Data Lakehouse, Einstein AI etc)

[@spoonikle]

I need it.

[@johno1104]

Wow, can we get D365 off the dataverse and onto this and be able to write SQL queries?

[@rajdeepghosh5556]

How is it different from synapse analytics? Is not it kind a same?

[@Calxx]

Can you tell us something about the pricing? or any indication how much all of this will cost per month?

[@AlexTheAnalyst]

No idea what the pricing it yet

[@History_Mystery_Crime]

I think over time small to mid size companies can manage their data analysis themselves with very less workforce and not outsourcing to tech companies….and only very large organisations may rely on huge data analysis teams……can’t say this will increase or decrease work force…only time will tell 🙃

[@aimamalik5126]

That gives me job anxiety

[@bogoodski]

I'm a big fan of Palantir Foundry at work. Fabric seems to capture many of its best features. Though, idk if Fabric has a comparable MLOPs capability.

[@ebenbrittz535]

My question is, will this be inuded in Microsoft E5?

[@d1a9m9i1lare]

Hi Alex, With Fabric, do you think transitioning from a data analyst to a data engineer becomes easier?

[@AlexTheAnalyst]

It's hard to say - I think there may be more overlap in this type of scenario depending on how you use it

[@coolspyzz]

Thoughts on the new programming language Mojo?

[@danielgagnon8201]

So we can only use Fabric if the data is being stored in a cloud database?

[@AlexTheAnalyst]

That's a good question - I do think that is the case.

[@jacobbobo4670]

I'm assuming I got this because I watched a tutorial on Power BI lol this is beyond my skill but seems pretty cool

[@LOFI_WORLD_SONG]

Hey Alex Please let me know, ETL dev Vs BI dev Vs Data analyst which will having great opportunity when it comes to hikes, demand, onsite opportunity

[@brandonperks5877]

What is the difference between Azure Synapse and Azure Fabric?

[@yashgawand17]

Now it's time to make a tutorial!!!!! Let's grow

[@mledwaba7]

How is it different from Microsoft graph?

[@Mohamed-Hassanin]

Are Microsoft Fabric will be a game changer in the next years and it's time to switch over to a windows or I'm okay with my suite. I'm currently an Apple fanboy using Macbook Pro and my analysis suite is (Python, Tableau, PostgreSQL, Google Analytics, BigQuery) is that suite okay.

[@YngolSonofYsgramor]

😮

[@dagg497]

Never got the big deal with Fabric besides it being a new licence model. Synapse and Data Factory existed before.. Basically the news is parquet format and data lake made to work with Apache Spark, i mean Databricks 😅

[@vaishnavibhavsar2232]

Future market research may see a downturn. Do those who are knowledgeable about market research have alternative employment options?

[@LOFI_WORLD_SONG]

Can you tell in details please, it can make someones future safe

[@sathyamanikanta2784]

Could you please make video or tutorial about getting started with MICROSOFT FABRIC 😊

[@AlexTheAnalyst]

When I can I will!

[@sathyamanikanta2784]

@@AlexTheAnalyst waiting Alex 😊

[@MA-md5yy]

What impact will this have for Data Analysis role ?

[@EuanM20X]

well depends on the company, but most likely wont be seen in most until 3-5 years

[@ShehrozeBahadar]

Also, make a video on how to install Microsoft Fabric

[@funk44]

It's all good and well to say you can grab your data from anywhere but often the biggest headache is with connectivity with external platforms/systems on the infra side with firewalls, whitelisting, vnets blah blah blah. Concept is good but I'm far from sold

[@mmmmmmmmmm710]

Alex the Analyst, will this new Ai tech replace data analysts in the future?

[@AlexTheAnalyst]

No

[@PavanBalshetwar]

@@AlexTheAnalyst It will reduce chances to get a job in data analytics

[@SudoDama]

Trying to compete with palantir foundry.

[@usmanmb1]

will this make the Data analyst role redundant ?

[@AlexTheAnalyst]

No

[@cindystokes8347]

Funny. Your audience I think is mostly people getting started right? I for one probably don’t even properly appreciate how cool this is the same way my kids don’t appreciate that phones don’t have cords now. 😊

[@AlexTheAnalyst]

Haha I know for a fact I wouldn't have understood this at all when I first started out. Now I geek out on this stuff :D

[@BobWilliamson-to3xp]

In a week there will be another bunch of names

[@Kamalfayadh]

How to be eligible for free Microsoft Fabric?

[@ayaansk99]

This will replace Data jobs 😶

[@beda9beda]

Databricks provides the same kinda functionality

[@oscarzapatajr2]

Could you elaborate on that I don't know the databrick framework, and sound interesting...

[@NeverForget1776]

"Because it's all standardized in Delta Kale" How is this revolutionary or this news worthy when this is just the creation of singular standardized format that can then be used by other systems/platforms using Microsoft Tools. How would this be different from any other competitor coming up with a format that all your users agree to work with? How is is different from any other data conversion tool/application/system?

[@mrmrjims3865]

Seems a lot like SnowFlake and Databricks, is this Microsoft's attempt to compete gainst Snowflake?

[@BobWilliamson-to3xp]

Why dont they just call it Microsoft Porridge. Just another bunch of disconnected Microsoft names from the the Msoft name factory.

[@mrblawblawblaw2335]

How many of you all fear about ai in replace of data analyst?

[@s7s7s7s7s7]

🤡no one

[@mrblawblawblaw2335]

@@s7s7s7s7s7 by how

[@josephdaquila2479]

I feel like data analyst is more human of a role than a data scientist for example. Because of the heavier emphasis on communication.

[@mrblawblawblaw2335]

@@josephdaquila2479 though anything we can feed what we want as our requirement

[@History_Mystery_Crime]

The number of people to do analysis will decrease in time….companies can have just 2-3 data analysts and AI powered tools to do their entire data analysis ….only time will tell😢