Dan English's BI Blog

Welcome to my random thoughts in regards to Business Intelligence, databases, and other technologies

Posts Tagged ‘RStats’

PASS Business Analytics Virtual Group October 19 “R visual in Power BI: with pbiviz and ggplot2”

Posted by denglishbi on October 18, 2017

The next PASS Business Analytics Virtual Group meeting will be this week on Thursday, October 19.  We welcome back Leila Etaati who will be showing us how to use R to visualize data in Power BI.PASSBA_Logo

–> REGISTER NOW <– (Login with PASS account first to register for webinar)

October 19 – R visual in Power BI: with pbiviz and ggplot2

Session Abstract

The integration of R inside Power BI provides lots of possibilities for doing machine learning and providing more data visualization options. In this session, I will first show how to write R code inside the R visualization area. Then, how to create some visuals that we do not have currently in Power BI visualizations like Slope chart, Facet chart and Column width chart with the help of ggplot2 package. Moreover, there is a possibility to create your own custom visual as pbiviz file by writing R codes and importing it into your Power BI report. I will go through the process of creating a pbiviz file.

Speaker Bio –

Leila is a Microsoft Data Platform MVP, PhD, mentor, speaker, trainer, and consultant. She spoke in some important SQL server conference such as Data insight Summit, SQLNexus, SQL Rally and Microsoft ignite New Zealand, PASS BA, PASS 24 H, and so on. She has over 10 years’ experience working with SQL server. She was involved in many large-scale projects for big sized companies as SQL server and BI consultant. She worked in Industries including banking financial, power and utility, manufacturing .Leila is PhD of Information System department, University of Auckland, New Zealand. She is a lecturer of BI and Machine Learning courses.

–> REGISTER NOW <– (Login with PASS account first to register for webinar)

Also, we will be doing a random drawing after the webinar and giving away eight $50 Amazon gift cards to anyone that attends and fills out the survey!

Posted in Training | Tagged: , , , , | Leave a Comment »

PASS Business Analytics VC April Meeting – Using R Machine Learning Script as a Power BI Desktop Data Source

Posted by denglishbi on April 1, 2016

The next PASS Business Analytics Virtual Chapter meeting is coming up next week on Thursday, April 7.  This month we welcome data scientist Sergei Dumnov who will show us how we can use an R script in Power BI.

–> REGISTER NOW <–PASS_BAVC_Logo_New_201502

April 7 – Using R Machine Learning Script as a Power BI Desktop Data Source


You can develop a Power BI Dashboard that uses an R machine learning script as its data source and custom visuals. In this webinar, you will learn how to connect to data sources over the Internet, cleanse, transform and enrich the data through the use analytical datasets returned by the R script, design the dashboard and finally share it.

Bio –Sergei Dumnov

Sergei is a data scientist at Qrious, an Auckland (NZ) based big data analytics company, where he responsible for data wrangling, analysing it and building analytical applications using variety of tools (Greenplum DB, R, PostGIS, QGIS and Tableau). He received his PhD from the Institute of Hydrodymics (Russian Academy of Sciences) developing mathematical models of water flow and transport phenomena in water bodies.


If you are planning on attending the PASS Business Analytics Conference use the following discount code and save $100

Save $100 right now using discount code BAVCBA

If you are interested in speaking at an upcoming PASS BA Virtual Chapter meeting we are always looking for speakers, please leave a comment or send us an email at PASSBAVC@SQLPASS.ORG

Posted in Training | Tagged: , , , , | Leave a Comment »