Date: 8 April 2021
Time: 18:00 UTC
Topic: R and Python Integration in Power BI
Register here: bit.ly/AVG20210408
Both, R and Python, are very popular languages among data scientists. And both are integrated into Power BI: As source and transformation in Power Query and as standard visual in Power BI.
If Power BI’s standard or custom visuals cannot satisfy your need to present the data in a certain way, or if you already have a data visualization script written in either R or Python at hand, then the R visualization and Python visualization are your friends.
The same applies to Power Query: Power BI, R, and Python have in common that they are heavily used to ingest, transform, and prepare data. All three come with very helpful ways of achieving such tasks. You can use Power BI’s core functionalities to transform data either via the graphical interface or by writing M code. If you hit the limitations of Power Query, you can use a transformation written in R or Python, or even reuse one you already have, inside Power Query.
Markus Ehrenmüller-Jensen is the founder and business intelligence architect of Savory Data. He works as a project leader, trainer & consultant for data engineering, data science and data visualization since 1994. He is an educated software-engineer, graduated business educator and professor for databases and project engineering at HTL Leonding (technical college) and certified as MCSE Data Platform, MCSE Business Intelligence, and MCT. Markus speaks regularly on international conferences (eg. PASS Summit, Power Platform World Tour, Intelligent Cloud Conference, SQL Saturdays, SQL Days, SQL PASS Austria, …) and writes articles for well-known journals. In 2013 he co-founded SQL PASS Austria, in 2015 Power Platform Usergroup Austria and he organizes SQL Saturdays in Austria since 2014.