If you are a BI developer, business analyst, or 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:
• Executing R and Python Visualizations
• Getting Power BI Ready for R & Python: Install R & Python, Load the required packages, one editor to use them all: R Studio
• Creating R Custom Visuals in Power BI Using ggplot2
• Load &Transforming Data into the Power BI Data Model Using R and Python
• Reading SQL Server Data using R & Python
• ChatGPT chatbot technology with Power BI Desktop integration allows users to interact with data and reports through NLP queries. A step-by-step guidance on setting up the integration and use of ChatGPT to enhance functionality.
This is a demo session only with minimum theory!
If time Permit 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 .
This is a maximum demo session with minimum theory!