Data analytics

Data analytics with Power BI

Sample 1 of analytics

Details:

1. Dimensions

   1. X-axis: Total sales

   2. Y axis: Sales quantity

   3. Play-axis: Month

   4. Legend (comparison): Seller

2. Analytics (magnifying glass). This adds the quadrant

   1. Average line 1: Sales amount

   2. Average line 2: Total sales

With the play button (lower-left corner), reproduce the evolution of each month of the selected year

Ejemplo 2 de analítica de datos

Chart 1 details

1. Dimensions

2. Axis: Month and year

3. Values: Total sales

Chart 2 details

1. Dimensions

2. Axis: Month and year

3. Values: Total sales

4. Forecast

   1. Duration of the forecast: 12 points

   2. Ignore the last one: 7 points

   3. Confidence interval: 95%

   4. Confidence band style: Fill

   5. Transparency: 80%

Data analytics with Python/R

Power BI offers the possibility of integrating BI tools, with languages such as Python or R To make an example script in R, download and install R and R Studio

The URLs are available in the Recommended reading or tools section

We get the data of the example from a CSV file

We load the desired file

We're going to specify data and create a table (warehouse) of measures

Measurement table

We create a measure

To check the measurement, we create a table and see that it works OK

To check the measurement we create a table and see that it works OK

Do not summarize, to see age details

The age in detail with the calculated measurement

Now we will take these two variables to a graph made with R

We copy the R script that we've in a TXT

We enable the script that we are going to create

Now we take the variables age and sum of lines (not summarized)

We paste script and press play (upper right corner)