Advanced Analytics with Power BI and R

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.

1 - R Data Structures for Machine Learning

• Vector – C()
• Factor – Factor()
• Lists - list()
• Data frames -  data.frame()

2 - Have More Charts by writing R codes inside Power BI

3 - Variable Width Column Chart, writing R codes inside Power BI

4 - Visualizing Data Distribution in Power BI – Histogram and Norm Curve

5 - Visualizing Numeric Variables in Power BI – boxplots

What is median!
First Quarter and Third Quarter

6 - Prediction via KNN (K Nearest Neighbours) Concepts

7 - Prediction via KNN (K Nearest Neighbours) R codes

8 - Prediction via KNN (K Nearest Neighbours) KNN Power BI

9 - Make Business Decisions: Market Basket Analysis

• What is Market Basket Analysis (Concepts)?
• Measuring rule interest – support and confidence
• Market Basket Analysis in R
  • Step 1 -  Get Data, Clean Data and Explore Data
  • Step 2 -  Create Market Basket Analysis Model

10 - Make Business Decisions: Market Basket Analysis

11 - Over fitting and Under fitting in Machine Learning

12 - Clustering Concepts, writing R codes inside Power BI

• Advance Analytics with Power BI and R

13 - K - mean clustering in R, writing R codes inside Power BI

14 - Identifying Number of Cluster in K - mean Algorithm in Power BI

15 - Neural Network Concepts

16 - Neural Network R Codes in Power BI

• Scenario:

17 - Interactive Charts using R and Power BI: Create Custom Visual Part 1

• First Step
• Second Step
• Third Step

18 - Interactive Charts using R and Power BI: Create Custom Visual Part 2

• Have more custom visuals
• Jitter Chart

19 - Interactive Charts using R and Power BI: Create Custom Visual Part 3

• Jitter Chart
• Pie Chart
• Polar Scatter Chart
• Box Plot
• Column Width Chart