Тёмный

New Artificial Intelligence capabilities in Power BI Desktop 

Guy in a Cube
Подписаться 437 тыс.
Просмотров 74 тыс.
50% 1

Power BI Desktop has new Artificial Intelligence (AI) capabilities in the November 2019 release. Sarina Stevens shows us what it is all about!
Documentation: docs.microsoft.com/power-bi/d...
Connect with Sarina Stevens: / stevenssarina
Guy in a Cube courses: guyinacu.be/courses
********
LET'S CONNECT!
********
-- / guyinacube
-- / awsaxton
-- / patrickdba
-- / guyinacube
-- / guyinacube
-- guyinacube.com
**Gear**
Check out my Tools page - guyinacube.com/tools/

Наука

Опубликовано:

 

13 ноя 2019

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 92   
@pabeader1941
@pabeader1941 4 года назад
Please add "Premium Only" to the title of the video. That way we can make a informed decision about viewing without getting excited for no reason.
@brianmenard7565
@brianmenard7565 4 года назад
The vision and text analysis is premium only. The Azure ML part will work with a pro license. Nothing wrong with MicroSoft trying to sell their new features.
@pabeader1941
@pabeader1941 4 года назад
@@brianmenard7565 Of course not. Just want a bit of warning before the let down, that's all.
@raymonds5709
@raymonds5709 4 года назад
@@pabeader1941 I think nothig wrong to watch the video and getting insight, atleast we know what is there and someone working for organisation can give an advice.
@tommyjamison2k6
@tommyjamison2k6 3 года назад
Stop being cheap and get a pro license 😆
@pabeader1941
@pabeader1941 3 года назад
@@tommyjamison2k6 I have one. That's not the issue. Pro doesn't give you Premium stuff.
@iamdhruvinshah
@iamdhruvinshah 4 года назад
This is superb... Microsoft should provide the free capacity license preview for the developer to explore these new features for their learning purpose.
@georgeeivaz362
@georgeeivaz362 4 года назад
This is great but I find it crazy that one has to spend ridiculous amounts of money for premium. We are an insurance agency with about 30 pro licenses and love power bi. But have noticed that most of the cool "new features" are being tilted to premium which can cost as much as 5000/month. This cost is not feasible for the average small to medium business such as ours. It would also help quite a bit to tell us that this is a premium license in the title so that we don't watch a whole video with the tease and our time is not wasted.
@AlainPilon
@AlainPilon 4 года назад
You can turn on/off the premium instance whenever you need them. It takes about 1-2 minutes to power on.
@phvaguiar
@phvaguiar 4 года назад
That's awesome. I'll try that.
@abhishekstatus_7
@abhishekstatus_7 4 года назад
This is really great capability of Power BI. Huge thanks to the entire team bringing lot of AI capabilities into Power BI. 🥂🥂🥂🥂🥂🥂🥂🥂🥂🥂🥂🥂🥂🥂🥂🥂🎂🎂🎂🎂🎂🎂🙏🙏🙏🙏🙏
@Ferruccio_Guicciardi
@Ferruccio_Guicciardi 4 года назад
What ? ! ... point-and-click AI in Power BI - no coding! - no code AI and ML - no Python, no R - applies to Power Query for Power BI Desktop data sets as well as for on-line dataflows ... ! Awesome !
@DIGITAL_COOKING
@DIGITAL_COOKING 4 года назад
This absolutely very awesome!!!
@opentube5962
@opentube5962 4 года назад
Awesome!
@totvabe1
@totvabe1 4 года назад
Wow! Amazing!
@CharudattaAmbekar
@CharudattaAmbekar 4 года назад
Hi, This is superb! Is the AI in Dataflows too premium only?
@nickdoy5785
@nickdoy5785 4 года назад
Great addition but it's a shame it is premium only as smaller business would benefit from this immensely. I'm not sure whether it is practicable but is there no way to leverage local hardware to run the ML models rather than using the cloud.
@AndrewClark83
@AndrewClark83 4 года назад
You can do the text component manually within Power BI really easily, the image side of things i have not looked at previously.
@themosh54
@themosh54 4 года назад
I completely agree with OP. I don't see why it would require the cloud, it's perfectly possible to run R and Python ML models on local hardware. But, smaller businesses may not have people with that skillset so like OP said, they would lose out on those benefits.
@learnspreadsheets
@learnspreadsheets 4 года назад
Andrew Clark how can you do it manually? Sentiment analysis and key phrase extraction
@patolobos8266
@patolobos8266 4 года назад
@@learnspreadsheets Using R or Python, either calling those as a R or Python Script in Power Query or creating a R o Python visual in your report (Visual have a limit of 150.000 rows, but is enough for most cases). If you massive amount of data or you are not familiar with ML, then spin an Azure ML resource in your Azure Portal, then use AutoML (assuming you understand the basics of ML) and you can easily call your models in Power BI. All of this is quite old in fact and well documented in public domain.
@AlainPilon
@AlainPilon 4 года назад
you can provision a A4 instance and use it to analyse your model then shut it down, total cost: less than 1$. You dont have to keep the premium instance running 24/7.
@Evan-mh7it
@Evan-mh7it 3 года назад
Will it detect multiple languages in the same column and adjust the analysis accordingly? Because that would be really something.
@SiyaMedia
@SiyaMedia 4 года назад
Multiple regression and principal component analysis thank you
@SriKrishna94
@SriKrishna94 4 года назад
Where are these algos are in BI.
@classicappetite
@classicappetite 4 года назад
What's the visual she used to show the hotel pics and comments?
@databases2288
@databases2288 3 года назад
Thank you for great videos! Just a quick question from "2021 future": is "Power BI Premium Per User" enough to do Auto ML? Or some additional Azure or other subscription is needed?
@peterpan3900
@peterpan3900 3 года назад
Where do i can get the Tshirt " I love Data"? :D
@patweinmayr295
@patweinmayr295 4 года назад
Text analytics would be great for embedded users.
@kentlaw8582
@kentlaw8582 4 года назад
Did she CTRL + click plant and garden @ 7:42 or just clicked on the 2nd bar alone which by default selected the first one too?
@chilliyou
@chilliyou 4 года назад
Power BI is growing big. Happy to see AI features getting simpler and efficient.
@alvarotorres2095
@alvarotorres2095 4 года назад
Hey there, pretty cool interview, could you create an example of Text Analytics and Vision? To understand how does it work? It is really, fantasict!
@SriKrishna94
@SriKrishna94 4 года назад
What are the ML models they are using? It is better to give an option to select different models!
@vaishnaviv3049
@vaishnaviv3049 4 года назад
Text Analytics is great! It would be awesome if we had Predictive Analytics.
@marionoriega6341
@marionoriega6341 4 года назад
if we want to dig deeper into ML, text analytics, vision... what would be a good source, what is the process you go through to gather rich data.. real estate data more specifically
@vikrambagewadi1355
@vikrambagewadi1355 2 года назад
Though it’s a premium version! But thanks for sharing this insightful information within a short period of time! Good job!
@Ashley-vb5vk
@Ashley-vb5vk 3 года назад
Would you class this as Natural Language Processing?
@ketansolanki22
@ketansolanki22 4 года назад
Great to see PowerBI growing big on ML and AI. I am a power user on Azure ML and happy to see it on PowerBI. Is Microsoft releasing an integration with Alexa or Google Assistant to make better use of QnA ?
@emanueleorecchio5160
@emanueleorecchio5160 3 года назад
does anyone know how create the pannels with image in 7:15?
@SriKrishna94
@SriKrishna94 4 года назад
Can we use it in power app’s!
@SolutionsAbroad
@SolutionsAbroad 3 года назад
Great addition, the text analytics is so PERFECT for sentiment analysis in house, shame it's just for Premium users.
@ncbshiva
@ncbshiva 4 года назад
Super
@simhadri-2024
@simhadri-2024 4 года назад
Premium only--- for limited users and customers. It would be good to have this with the pro license.
@vog5197
@vog5197 4 года назад
I'd like to see more things like fuzzy merge with AI, to avoid manually mapping all kinds of things, more dataprep related. It would also be nice if AI could optimize our Power Query steps to find the optimal steps from source to final step, similar in how it optimized between models.
@nickdoy5785
@nickdoy5785 4 года назад
A power query optimiser would be good. There are subtle nuances in the interactions that mean the optimal order might not be the norm.
@1yyymmmddd
@1yyymmmddd 4 года назад
It is very unfair to say that these capabilities are available in Power BI Desktop. They are available in a different product called Power BI Premium.
@andyforeman6183
@andyforeman6183 2 года назад
it's Power BI Desktop but you have to have the Premium capacity/ PPU
@1yyymmmddd
@1yyymmmddd 2 года назад
@@andyforeman6183 No, it's not a capacity issue. Premium is a different product, with many more additional capabilities, not only capacity.
@cedricgacond1990
@cedricgacond1990 4 года назад
Sentiment analysis can be done aside with natural language kit ( that are free ) and then pull them in powerbi. No need to pay 5000 USD / month , hope that they will use their tool to see what is the sentiment on their expensive release based on our comments
@ianfahlman-morgan2081
@ianfahlman-morgan2081 4 года назад
Is there any "how to" Documentation anywhere? Very keen to try this within my organisation!
@GuyInACube
@GuyInACube 4 года назад
I put a link to the documentation in the description.
@ianfahlman-morgan2081
@ianfahlman-morgan2081 4 года назад
@@GuyInACube perfect! I know what I'm doing tomorrow morning 👍👍👍
@davidcopeland1886
@davidcopeland1886 4 года назад
I was also wondering how the image board was created so it changes with other visuals?
@driouchemountasir7894
@driouchemountasir7894 4 года назад
Awesome capability ! No more need for python scripts (for basic stuff). Unfortunately it only works with premium capacity even if it doesn't need resources from the cloud but why not ! Even Microsoft has to make it's money ^^ However some points to test : - Efficiency with large data sets (in terms of execution time) - How does it reacts to irony Thank you for this video Adam and Guy in a Cube team, as usual you're awesome !
@x9rtu3os1t8
@x9rtu3os1t8 4 года назад
Omg i love it
@elaborconseil1133
@elaborconseil1133 4 года назад
Great , is text analysis working on foreign language such as French ?
@johnfromireland7551
@johnfromireland7551 3 года назад
By now, probably. More languages are being added as we speak.
@chrisweis
@chrisweis 4 года назад
Idea: Would be cool to be able to paste in an Azure key to Desktop and have it run off Azure Cognitive Services directly too (without needing Premium) 😊
@takuram4616
@takuram4616 4 года назад
Some things should be premium to profitable this is justified I think. Sentiment analysis on scale for large organizations, great !!!
@yanamadalaharishkumar5041
@yanamadalaharishkumar5041 4 года назад
Tableau vs Power Bi better one ?
@kittenme8845
@kittenme8845 4 года назад
Is there anybody I can connect to in Singapore on Power BI Licensing options? So far no response from sales associates in SG
@johnfromireland7551
@johnfromireland7551 3 года назад
Contact Microsoft Support from the Admin Centre of your tenant (log in). It will be routed to Singapore or whomsoever is responsible for Power NI Licensing in your Region.
@solarpunk_
@solarpunk_ 4 года назад
Guys, I love your stuff, but it’s heartbreaking to get halfway through a video to find a feature is out of reach for most users. Please let us know in the intro or title if it’s a premium only feature.
@adityakalra7383
@adityakalra7383 4 года назад
Hi! Is it possible to Sentiment analysis of CryptoCurrency on Twitter Data
@ajinnadh7519
@ajinnadh7519 4 года назад
Coool
@vivekvenugopal7519
@vivekvenugopal7519 4 года назад
We need a write back functionality in power BI... When will it get added?
@GuyInACube
@GuyInACube 4 года назад
You can embed a Power App to get write back. Also, the PowerOn custom visuals provide that type of feedback.
@vivekvenugopal7519
@vivekvenugopal7519 4 года назад
@@GuyInACubeGreat, thanks for immediate response... Would you please share any video related to your statement
@kavi626
@kavi626 4 года назад
I dont see this on preview feature. What's the name of this feature?
@allthingspowerbiwithadebol3576
@allthingspowerbiwithadebol3576 4 года назад
This is probably late response... but just in case, it is AI Insights Function Browser
@kavi626
@kavi626 4 года назад
@@allthingspowerbiwithadebol3576 I got this worked out.. Thanks for responding though....
@juanpablorvvv
@juanpablorvvv 4 года назад
Power BI Premium is simply so unreachable. Microsoft should re-evaluate his business model with Power BI given the tendency of open source. Companies that can pay Premium, for sure are not learning from Guy In a Cube. Sometimes I get confused of who is the audience of PBI Premium.
@spilledgraphics
@spilledgraphics 4 года назад
Power BI is kick *ss :P
@juanes1235
@juanes1235 3 года назад
Sarina... 🥰😍 ah! The new Ai is cool too
@paulnandes2841
@paulnandes2841 4 года назад
I wish power bi had python or r instead of m and dax. we would learn only one language instead of two and that language would be useful outside power Bi as well, to complete the data project with a portal or web service, etc.
@paulnandes2841
@paulnandes2841 4 года назад
@@JoaoCarlos-qg5cn can I replace m and dax, writing python within the advanced editor or creating measures?
@paulnandes2841
@paulnandes2841 4 года назад
@@JoaoCarlos-qg5cn and publish to power Bi service?
@danielszabo2928
@danielszabo2928 4 года назад
Paul Nandes hi Paul, yes, you can but there are limitations for the packages you can use. Also, you can’t create measures as far as I know. Check out this article for more info: powerbi.microsoft.com/en-us/blog/python-visualizations-in-power-bi-service/ Ps.: you can use R as well.
@pabeader1941
@pabeader1941 4 года назад
Doesn't it? I see both icons in the visuals lists...
@themosh54
@themosh54 4 года назад
It also has R support. However, like the other commenter said, you have to write measures in DAX. Power BI at it's heart is essentially SSAS in Tabular mode which requires DAX for calculations. Honestly, if you know how to write CALCULATE statements you can do about 75% of the calculations you'll need in most business scenarios. And 90% of the stuff you'll need to do in M is GUI driven so in my opinion the bar isn't very high on that either.
@souviksaha6026
@souviksaha6026 4 года назад
Dear Sir, I want you to make a video on:- Like I have two slicers and one dynamic x-axis chart. In one of the slicers I have top n (5,10,15,20) and on the other slicer, I have customer and product. I have a dynamic x-axis chart showing sales by customers or product. So, when I select the customer and top 5 it will show in the dynamic chart or when I select top 20 and then select products it will show top 20 products by sales in the same dynamic x-axis chart. Please, sir, do a video on this.
@themosh54
@themosh54 4 года назад
They have a video on this. Search their channel or scroll down the list of videos and you'll find it. It basically involves using bookmarks.
@hrishihatolkar1944
@hrishihatolkar1944 4 года назад
Sarina n PBI 💓
@mshparber
@mshparber 4 года назад
Premium...? So I just keep using KNIME open source...
@seriouscoder1727
@seriouscoder1727 3 года назад
She is so lovly &cutte
@zzzzzzzzzzzzzzzz9
@zzzzzzzzzzzzzzzz9 3 года назад
She is pretty 🥰
@mathew9665
@mathew9665 4 года назад
Another Premium only feature, it's a pitty
@mixedsalad4773
@mixedsalad4773 4 года назад
I not sure, that would work logically. This supposed to be built on machine learning 'supervised'. A key word like 'good' might be there as good or not good within the text block. Still don't buy it.
@themosh54
@themosh54 4 года назад
The text sentiment model is pretty well trained straight off the shelf. It doesn't use one word to score a whole text block, it looks at the context formed by all the words, the order they're in, etc.
@successfullife7689
@successfullife7689 4 года назад
Very naive, this is not a high level stuff ! In python you can do a LOT LOT MORE very easily and freely and integrate that into Power BI or any other Visualization tool like tableau or Qlik !
@user-zr4kx5ow9v
@user-zr4kx5ow9v 3 года назад
such beautiful girl
Далее
Master Power BI with AI | @PavanLalwani
12:33
Просмотров 62 тыс.
The Current State of AI and the Future of Developers
11:33
🎙ПЕСНИ ВЖИВУЮ от КВАШЕНОЙ🌹
3:09:38
How smart is the SMART NARRATIVE visual in Power BI?
12:11
Так ли Хорош Founders Edition RTX 4080 ?
13:00