Text Analytics, Vision analytics and Machine learning in Power Query - Power BI update November 2019

Подписаться 135 тыс.

Просмотров 10 тыс.

50% 1

In today's video I will review the new AI functions in Power Query which are: Text, vision analytics and Machine learning.
Use cognitive services API instead: • Sentiment Analysis usi...
Link to documentation: docs.microsoft.com/en-us/powe...
Here you can download all the pbix files: curbal.com/donwload-center
SUBSCRIBE to learn more about Power and Excel BI!
/ @curbalen
Our PLAYLISTS:
- Join our DAX Fridays! Series: goo.gl/FtUWUX
- Power BI dashboards for beginners: goo.gl/9YzyDP
- Power BI Tips & Tricks: goo.gl/H6kUbP
- Power Bi and Google Analytics: goo.gl/ZNsY8l
☼☼☼☼☼☼☼☼☼☼
POWER BI COURSES:
Want to learn Power BI? How about you take one of our courses? Here you can find the available courses:
curbal.com/courses-overview
☼☼☼☼☼☼☼☼☼☼
ABOUT CURBAL:
Website: www.curbal.com
Contact us: www.curbal.com/contact
▼▼▼▼▼▼▼▼▼▼
If you feel that any of the videos, downloads, blog posts that I have created have been useful to you and you want to help me keep on going, here you can do a small donation to support my work and keep the channel running:
curbal.com/product/sponsor-me
Many thanks in advance!
▲▲▲▲▲▲▲▲▲▲
************
************
QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
Linkedin ► goo.gl/3VW6Ky
Twitter ► @curbalen, @ruthpozuelo
Facebook ► goo.gl/bME2sB
#CURBAL #SUBSCRIBE

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

8 дек 2019

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 24

@meiss76 Год назад

Thank you for the video! In second example Detect language you used video_id column, that's why polish appeared)))

@Amr-Ibrahim-AI 4 года назад

Thanks Ruth for the useful video. Regarding the example you mentioned about your customer for matching TripAdvisor ratings and sentiment analysis scores, I believe we are not comparing apples to apples here. Sentiment analysis shows the sentiment of the text while TripAdvisor rating shows how others evaluate this opinion. So, if this review was for a horrible place, sentiment analysis would normally be very negative. However, if the place is really horrible, others would give that review five or four stars because they agree with the negative opinion on that specific horrible place. No match is expected here

@CurbalEN 4 года назад

When you do a review on TripAdvisor you can give stars or give stars and a text review. Those two should match. So if you give one star, the text review should say it was a bad experience and the sentiment score should be low, and we didn’t find that on our test. /Ruth

@op-training Год назад

Hi Ruth. I have just discovered your channel! Really interesting content and I love your honesty and lack of hype about the features you are talking about. I have one small request: could you please use a higher resolution for your video because it is a bit blurry and I am finding it hard to read the text.

@CurbalEN Год назад

Hi Gideon! Welcome to the channel :) All my videos are shoot in HD, i believe google is reducing the resolution maybe due to internet speed connections. You can overide that: support.google.com/youtube/answer/91449?hl=en

@manuelbanza114 4 года назад

Hi Ruth. Thanks for the tutorial. Any tips on how we can extract in power query just the emojis of a text column in to a new one? Also the same for hashtags. Thanks!

@ayobamiologun9184 4 года назад

Thanks for sharing this, Ruth...

@CurbalEN 4 года назад

My pleasure Ayobami! /Ruth

@utpalkant5934 4 года назад

Hey it was great video , but I have premium capacity EM1 but in my workload there no option. Called Ai preview ?

@vilenmoodley1390 4 года назад

Hi thank you for the video. Apply query changes is taking forever. Table only has 50k records. In power query it ran quick

@learnspreadsheets 4 года назад

Totally agree! I want to pay based on usage

@CurbalEN 4 года назад

Hopefully soon.. /Ruth

@GHRichardson 4 года назад

Thanks as always, Ruth. Love your honesty about Premium features. Let's hope that MSFT are watching :-) I think that you were running the Language Detection test on your videoId field values. Maybe that's why you saw Polish in the language output...! Something else about the ISO language: you don't need to supply it as a parameter. If it's left blank, then the framework will automatically detect the language of the text being passed. So there can't be many use cases when you want to _force_ the language?

@CurbalEN 4 года назад

Maybe when there are nuances in the languages like Spanish (SPAIN) and Spanish (Mexico)? I don’t know how good the detector is. Thanks for sharing the feedback! Was that you on discord a while ago? /Ruth

@GHRichardson 4 года назад

@@CurbalEN Good point about the subtlety in the language options, but IIRC only a handful of the ISO languages are supported on the parameter field. Yes, I just joined you on Discord :-)

@CurbalEN 4 года назад

👏👏 welcome :) /Ruth