Video Training: Machine Learning and Analytics with R and Power BI

Length: 6 Hours and 33 Minutes

Instructor

Dr. Leila Etaati

Our trainer is the world’s well-known name in the Microsoft Data Science and Power BI fields. Leila Etaati is Microsoft AI, and Data Platform (Most Valuable Professional) focused on AI and BI Microsoft technologies; Microsoft has awarded her MVP because of her dedication and expertise in Microsoft BI technologies from 2016 till now. She is a speaker in the world’s best and biggest Microsoft Data Platform, BI and Power BI, AI conferences such as Microsoft Ignite, Microsoft Business Applications Summit, Microsoft Data Insight Summit, PASS Summits, PASS Rallys, SQLBits, TechEds, and so on. She is the author of some books on this topic, and she has more than 15 years’ experience in Microsoft BI technologies and Data science. Leila is the co-founder of RADACAD and a consultant for more than seven years.

This is a self-speed tutorial for the learning machine learning inside the Power BI using R codes. This course is around eight training hours. We cover most of the possibilities for doing machine learning inside Power BI by writing R codes.  Each module may contain more than one lessons, and each lesson has a video file,  power BI file examples and series of the datasets that are used in the video.

Who should attend this course

•  This course is designed for anyone who is planning to start learning R in practice. and see different possibilities of using R for statistical analysis, visualization and machine learning
•  This course also good for people who want to enhance the Power BI capability by using R codes. They can enhance the visualization possibilities and do machine learning inside Power BI.
• This course is good for Developers because this course has lots of hands-on and demos about how to do things.
• This course is good for Architect to know what are different possibilities.
• This course is good for Consultant, they will learn the main concepts and technologies.

How many Parts (modules) and Lessons are there

There are six different parts ( modules) in this course and the number of lessons in each part varies based on the topics. In below paragraph, you can find the explanation of each part. each lesson has a related video. For some of the lessons some datasets, codes, or Power BI files have been provided. If you could not access them please contact us.

First Part- Introduction to Machine Learning and R

The first part is about the machine learning concepts, what is machine learning, what is R and some basic introduction to the R codes and how to work with R Studio. The audience will be familiar with the basic data structure of R, R environment and how to run R codes inside R Studio. This part has three different lessons.

Second Part- Import Data, Statistical Analysis, and Packages in R

The second part is about how to import data into Rstusio, what is R packages. The audience will be familiar with some of the important packages in R. The last lesson in this part is about how to do some simple statistical analysis with R. This part has three lessons.

Third Part- R Visualization in Power BI

The third part is about how we can create R visual inside Power BI report area using existing R custom visual. This part contains three different lessons. The first lesson just shows how to draw a simple R chart inside Power BI visualization. The second and third lessons show how to draw some more complex chart using ggplot2 package inside Power BI. All related codes, dataset and power BI files have been attached to each lesson. Just you need to change the data source in Power Query to your so you able to see the reports. Moreover, make sure you already install Rstudio and ggplot2 package in it.

Forth Part- Machine Learning in Power BI

The forth Modules is about doing machine learning inside Power Query. This part has six different lessons that each of them focus on specific machine learning algorithms such as KNN, market basket analysis, clustering and so forth. In these lessons how to run R codes inside Power Query has been explained. Again the related codes, dataset, and Power BI files have been attached to each lesson.

Fifth Part- Time Series in Power BI using R

The fifth part focuses on the time series with the aim of forecasting. The two main algorithms for forecasting been “Exponential smoothing” and “ARIMA”  have been explained. The related codes, dataset, and Power BI have been attached.

Sixth Part- Create Custom Visual Using R

The last part mainly focuses on the how to create the custom visual using R codes. Usually to create custom visuals we need to write some java scripts and c# codes. Custom visuals extend the ability to draw the charts inside PowerBI. Creating custom visual with R codes is much easier and users able to create the icon and their name for that.

For each lesson, a brief introduction has been provided plus the required dataset or Power BI files.