Analytics in Power BI with R and Python with SQL Server 2019 ML Service & Polybase - Itshak David

preview_player
Показать описание
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.
• Create data visualizations through R using the ggplot2 package
• Ingest data using R and Python to overcome the limitations of Power Query
• Apply pre-trained models in SQL Server Machine Learning Services models
• Use String manipulations not otherwise possible in Power BI using R and Python
• Use SQL 2019 Polybase with Power Bi , R and Python to explore Hadoop , Oracle , MongoDB and SQL server data sets with 1 T-SQL Query .

My previous lectures : Practical SQL 2014 Data Mining and introduction to R ,Practical data science and Performance patterns for a DBA with SQL Server 2017.
Рекомендации по теме
visit shbcf.ru