Aim

To integrate R with Power BI, use R for statistical analysis, advanced visualization and timeseries forecasting, and combine the results with Power BI KPI cards, slicers, filters and drilldown in one professional, interactive dashboard.

Objectives

Set up R with Power BI and enable R script visuals.

Import and clean the Adventure Works data and calculate summary statistics.

Create at least four R visuals, five KPI cards and four native Power BI visuals.

Run an advanced analysis (a time-series forecast) with an R package.

Add slicers, filters and a drill-down, then write the business insights.

Tools : Power BI Desktop, R (with RStudio for testing), packages ggplot2 , forecast and scales.

Dataset : Adventure Works sales, product, territory and customer files.

The short version

Power BI is excellent at totals and slicers but cannot draw a box plot or fit a forecasting model on its own. R can.…