If you are a BI developer, business analyst, data scientist who wants to push Power BI and transform it from being just a BI tool into an advanced data analytics tool, then this is session. R and Python languages are powerful complements to Power BI. They enable advanced data transformation techniques that are difficult to perform in Power BI in its default configuration, but become easier through the application of data wrangling features that languages such as R and Python support. I will cover:
• Create data visualizations through R using the ggplot2 package
• Ingest data using R and Python to overcome the limitations of Power Query
• Use String manipulations not otherwise possible in Power BI using R and Python
• Use SQL 2019 2022 Polybase with Power Bi, R and Python to explore Hadoop, Oracle, MongoDB and SQL server data sets with 1 T-SQL Query to build your organization data lake with min effort and without ETL\ELT in real time .
• If time Permit: Apply pre-trained models in SQL Server Machine Learning Services models
This is a maximum demo session with minimum theory!
https://www.youtube.com/watch?v=BKsngBKCfNA