Great video, thank you. Here's a publish to web link for a demo I've used to illustrate the value of visualization: app.powerbi.com/view?r=eyJrIjoiNzI4NTU4MTUtNTlkNi00OGQwLTljZmYtNGY1NjFkNmEyMTMzIiwidCI6IjdkM2I0MjQ0LTY3YTQtNGU2YS1hN2U2LWU5NjRjZTk0OTQ3YiIsImMiOjZ9
I've used R transformations with PowerBi for a couple of things; the integration is great. The one issue is that the area to paste the R code is small. I read about using R instructions like 'source' (so you write the whole script using R/R studio and then just write one line in PowerBI Desktop to call the script). I haven't found a good link to understand how to get it to work. Would you have any suggestions for how to do this? Thanks
Been thinking about this border between data sci and power bi for quite some time now. Still haven’t found the sweet spot. But we do use it for visualising model predictions and model monitoring. The hard part is shifting completely into modelling in pbi. If I cant switch entirely it becomes a bump in the workflow when having to move data back and forth and having to make different transformation steps in different languages. Then I end up not using it at all.. What’s your take on this Adam?
Great feedback! I agree with your outlook. When doing the demo in the video, I still needed to pull data into the data model within Power BI. That is probably not something a data scientist is familiar with and becomes a potential barrier. I don't know that I have a good answer. With any technology, there will be a learning curve. Hopefully, the data scientist can partner up with someone in the business to bridge the gap. Kind of how Buck and I teamed up for this video. Assuming there is someone available.
This got me thinking on a related matter. Do you have any insights into what is going to happen with Azure ML Workbench? Got confirmed from Microsoft that it's being terminated but I have no information on what's happening next. That software was very similar to PowerBI in regards to the data prep features. It felt like some of the code had been reused so to speak :). But it was made for the data scientist/engineer and had a lot of neat features that competitors have completely overlooked in the data science area. Some features even deserve to be in PowerBI as well! But now its being phased out and I would at one hand like to know if there is a replacement coming up that matches its strength or if there is a plan to integrate similar functionality in current products (PowerBI perhaps?).
You brought me back to my post graduate days, I studied a lot of stochastic control methodologies, there are a lot of Math there! I may handle some data stream for a control loop using Power BI and R.
Hi Adam , I have a different question not related to this video which was asked by my friend. Is it possible to build a report that shows new additions / modifications to the dataset between the current refresh date and the previous refresh date. Is there a way I can extract this information as a count of lines in the table and highlight those new and modified entries to the reader.
Not by default in the model. You could potentially have a field that tracks it in your data source. but you would have to have some process that does it. Some sort of change data capture scenario.
Great! thank you for sharing. your videos are always awesome sir. :) yeah.. I am also using Power Bi R visualisation and R transformation in edit queries. its awesome.
haha no worries. That is a Buck-ism. He said "maybe a picture is worth a thousand stats". Which is a play on words of "A picture is worth a thousand words." en.wikipedia.org/wiki/A_picture_is_worth_a_thousand_words
@@GuyInACube oh OK. Still don't get the idea. Why are results so much different from R to PowerBI? I'm new in PowerBI and I love your videos mister! Helping me through my Dynamics Job. Cheers! Hope you answer. Greetings from Argentina
Great video, thank you. Here's a publish to web link for a demo I've used to illustrate the value of visualization: app.powerbi.com/view?r=eyJrIjoiNzI4NTU4MTUtNTlkNi00OGQwLTljZmYtNGY1NjFkNmEyMTMzIiwidCI6IjdkM2I0MjQ0LTY3YTQtNGU2YS1hN2U2LWU5NjRjZTk0OTQ3YiIsImMiOjZ9
wow! that is a really great way of showing it. Thank you so much for that!
This is Great!! What a way to showcase the importance of Visualization! Great usher to the world of Data Science and Power Bi!! Thanks a lot!
It's a truly relevant illustration Richard, thank you!
Hey Richard, that was awesome. I need something similar, please do reply...need your help :)
This is what we call - "Fun n Learn"... Great way to show importance of Power BI wrt R
Thanks, Ashok! Appreciate it!
I've used R transformations with PowerBi for a couple of things; the integration is great. The one issue is that the area to paste the R code is small. I read about using R instructions like 'source' (so you write the whole script using R/R studio and then just write one line in PowerBI Desktop to call the script). I haven't found a good link to understand how to get it to work. Would you have any suggestions for how to do this? Thanks
Been thinking about this border between data sci and power bi for quite some time now. Still haven’t found the sweet spot. But we do use it for visualising model predictions and model monitoring. The hard part is shifting completely into modelling in pbi. If I cant switch entirely it becomes a bump in the workflow when having to move data back and forth and having to make different transformation steps in different languages. Then I end up not using it at all.. What’s your take on this Adam?
Great feedback! I agree with your outlook. When doing the demo in the video, I still needed to pull data into the data model within Power BI. That is probably not something a data scientist is familiar with and becomes a potential barrier. I don't know that I have a good answer. With any technology, there will be a learning curve.
Hopefully, the data scientist can partner up with someone in the business to bridge the gap. Kind of how Buck and I teamed up for this video. Assuming there is someone available.
This got me thinking on a related matter. Do you have any insights into what is going to happen with Azure ML Workbench? Got confirmed from Microsoft that it's being terminated but I have no information on what's happening next. That software was very similar to PowerBI in regards to the data prep features. It felt like some of the code had been reused so to speak :). But it was made for the data scientist/engineer and had a lot of neat features that competitors have completely overlooked in the data science area. Some features even deserve to be in PowerBI as well! But now its being phased out and I would at one hand like to know if there is a replacement coming up that matches its strength or if there is a plan to integrate similar functionality in current products (PowerBI perhaps?).
Focus is going to PBI it seems to me
Yay for Buck and Adam together!
It was a happy day!
You brought me back to my post graduate days, I studied a lot of stochastic control methodologies, there are a lot of Math there! I may handle some data stream for a control loop using Power BI and R.
Hopefully, those are good memories :) Glad this opened up some possibilities for you. Thanks for watching!
Can anyone explain to me tho why did the data changed that much? Why didn’t R show it like that?
statistics and data cleansing is a must-know! :)
YES! 👊
Thanks Adam and Buck for this video. Amazing! Looking forward for more on power BI + Data Science!!
Hi Adam ,
I have a different question not related to this video which was asked by my friend.
Is it possible to build a report that shows new additions / modifications to the dataset between the current refresh date and the previous refresh date. Is there a way I can extract this information as a count of lines in the table and highlight those new and modified entries to the reader.
Not by default in the model. You could potentially have a field that tracks it in your data source. but you would have to have some process that does it. Some sort of change data capture scenario.
Try creating a calculated table in Power Bi Model with delta records based on refresh date and throw a visual.
is it possible to one chart(line chart) through drill down we get another chart( bar chart)
Pirate trying to find hidden treasure inside of PowerBi, says 'RRRR'
Rrr
I used R in PBI to show 2 scales on the same chart... both od you are grate😂
Awesome! Love it! Thanks for watching.
Great! thank you for sharing. your videos are always awesome sir. :) yeah.. I am also using Power Bi R visualisation and R transformation in edit queries. its awesome.
Awesome! Glad to hear that.
You made me laugh Adam...awesome video
haha awesome! We try to entertain and teach at the same time. That's the goal at least. Thanks for watching!
nice video
Thanks for watching! 👊
Nice video
love it,
I love this video!
We love you! Thanks for watching!
Sorry, my english is a little hard . What does Buck say at 8:02? "Maybe a picture is ksldjfklsad a thousand safsad" I don't get that hahahaha
haha no worries. That is a Buck-ism. He said "maybe a picture is worth a thousand stats". Which is a play on words of "A picture is worth a thousand words." en.wikipedia.org/wiki/A_picture_is_worth_a_thousand_words
@@GuyInACube oh OK. Still don't get the idea. Why are results so much different from R to PowerBI? I'm new in PowerBI and I love your videos mister! Helping me through my Dynamics Job. Cheers! Hope you answer. Greetings from Argentina
@@agustinmoragues191 lo que quiso decir es "sera que una imagen vale mas que mil estadistas"? Juego de palabras haha, saludos de Panama.
Stupid question why is x4=10 when it shows 8
Pity dax doesn't have a native slope command