Online Book: Analytics with Power BI and R


About the book; Quick Intro from Author

In 2016, after bringing the capability of writing R codes inside Power BI, I’ve been encouraged to publish an online book through a set of blog posts. The main reason to publish this book online, was that there is no integrated and comprehensive book on how to use R inside Power BI. From that time till now, I’ve been writing blog posts (or sections) of this book almost weekly in RADACAD blog. So far, I have more than 20 sections wrote in this book. This book covers most aspects of R inside Power BI; from creating R visual inside Power BI, how to run Machine Learning algorithm and how to create R custom visual. This book explains the main concepts of machine learning, R from novice to professional level. You can start reading this book with no prerequisite. I recommend to follow the book structure rather than read each section by itself. However, there are some sections, you don’t need to follow specific order. After six months of writing online, I decided to release this book as a PDF version as well, for two reasons; First to help community members who are more comfortable with PDF books, or printed version of materials. Second as a giveaway in my Advance Analytics training courses. Feel free to print this book and keep it in your library, and enjoy. This book is FREE! This book will be updated with updated editions (hopefully every month), so you can download the latest version anytime from my blog post here: I will do my best to update any changes in next few editions. Just to keep you informed, the publish date of each section is mentioned at the beginning of each section under the header.

About Author

Dr. Leila Etaati is invited speaker in world’s best and biggest SQL Server and BI conferences such as Microsoft Data Insight Summit, PASS Summits, PASS24H, SQL Nexus, PASS Rallys, SQLBits, TechEds, Ignites, SQL Nexus, SQL Days, SQL Saturdays and so on. She obtained her PhD in Information System from University of Auckland. She has more than 10 years experience in Microsoft technologies. More than 5 years of her experience focused on training and consulting in Machine Learning Concepts and BI Technologies. She is Microsoft Data Platform MVP (Most Valuable Professional) focused on BI and Data Analysis, She has been awarded MVP from Microsoft because of his dedication and expertise in Microsoft BI technologies from 2016 till now. These days Leila runs Advance Analytics training, consulting, and mentoring in many cities and countries around the world (USA, Canada, Europe, Asia, Australia, and New Zealand). She trained more than 100 students in just last few months for Microsoft Advance Analytics training. Leila lives in Auckland, New Zealand, but you will probably see her speaking in conferences, or teaching courses near your city or country from time to time. If you are interested to be in touch with Leila, or learn about her upcoming courses, visit RADACAD events page.

adv analytics 640

Download Free PDF Version

Who Is This Book For?

This book is designed for BI Developers, Consultants, Data scientists who wants to know how to develop machine learning solutions inside Power BI. BI Architects and Decision Makers who wants to make their decision about using or not using R visuals or Machine Learning inside Power BI in their BI applications. Business Analysts who want to get better insight on data and learn tricks of how to apply machine learning on specific data. The book titled “Advance Analytics with Power BI and R”, and that means it will cover wide range of readers. I’ll start by writing 100 level and we will go deep into 400 level at some stage. So, if you don’t know what Power BI is, or If you are familiar with R but want to learn how to use Power BI, this book able to show you the main process.

Table of Contents

  1. R Data Structures for Machine Learning.
  2. Have More Charts by writing R codes inside Power BI: Part 1.
  3. Have More Charts by writing R codes inside Power BI: Part 2.
  4. Have More Charts by writing R codes inside Power BI: Part 3.
  5. Variable Width Column Chart, writing R codes inside Power BI: Part 4.
  6. Visualizing Data Distribution in Power BI – Histogram and Norm Curve -Part 5.
  7. Visualizing Numeric Variables in Power BI – boxplots -Part 6.
  8. Prediction via KNN (K Nearest Neighbours) Concepts: Part 1.
  9. Prediction via KNN (K Nearest Neighbours) R codes: Part 2.
  10. Prediction via KNN (K Nearest Neighbours) KNN Power BI: Part 3.
  11. Make Business Decisions: Market Basket Analysis Part 1.
  12. Make Business Decisions: Market Basket Analysis Part 2.
  13. Over fitting and Under fitting in Machine Learning.
  14. Clustering Concepts , writing R codes inside Power BI: Part 1.
  15. K-mean clustering In R, writing R codes inside Power BI: Part 2.
  16. Identifying Number of Cluster in K-mean Algorithm in Power BI: Part 3.
  17. Neural Network Concepts Part 1.
  18. Neural Network R Codes in Power BI Part 2.
  19. Interactive Charts using R and Power BI: Create Custom Visual Part 1.
  20. Interactive Charts using R and Power BI: Create Custom Visual Part 2.
  21. Interactive Charts using R and Power BI: Create Custom Visual Part 3.

Download Free PDF Version

Leila Etaati on LinkedinLeila Etaati on TwitterLeila Etaati on Youtube
Leila Etaati
Trainer, Consultant, Mentor
Leila is the first Microsoft AI MVP in New Zealand and Australia, She has Ph.D. in Information System from the University Of Auckland. She is the Co-director and data scientist in RADACAD Company with more than 100 clients in around the world. She is the co-organizer of Microsoft Business Intelligence and Power BI Use group (meetup) in Auckland with more than 1200 members, She is the co-organizer of three main conferences in Auckland: SQL Saturday Auckland (2015 till now) with more than 400 registrations, Difinity (2017 till now) with more than 200 registrations and Global AI Bootcamp 2018. She is a Data Scientist, BI Consultant, Trainer, and Speaker. She is a well-known International Speakers to many conferences such as Microsoft ignite, SQL pass, Data Platform Summit, SQL Saturday, Power BI world Tour and so forth in Europe, USA, Asia, Australia, and New Zealand. She has over ten years’ experience working with databases and software systems. She was involved in many large-scale projects for big-sized companies. She also AI and Data Platform Microsoft MVP. Leila is an active Technical Microsoft AI blogger for RADACAD.

8 thoughts on “Online Book: Analytics with Power BI and R

Leave a Reply