Category: powerbi

Just for my memory, this is how I started learning PowerBI:

 
1. Download PowerBI Desktop https://powerbi.microsoft.com/en-us/desktop/

2.    Make sure you have the QuickStart https://docs.microsoft.com/en-us/power-bi/desktop-quickstart-connect-to-data

3.    Read the tutorials /samples from https://docs.microsoft.com/en-us/power-bi/desktop-what-is-desktop

4.    Goto https://appsource.microsoft.com/en-us/marketplace/apps?page=1&src=office&product=power-bi-visuals  and be sure that you see RUN in PowerBI Desktop all visuals created by Microsoft ( each visual has a downloadable DEMO file that can be opened in PBI Desktop)

5.    Goto https://appsource.microsoft.com/en-us/marketplace/apps?page=1&src=office&product=power-bi-visuals and  find some visuals that seems nice ( https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104381112?src=office )

That will be all  – and that means at least 1 week of hard working….

Series:

http://msprogrammer.serviciipeweb.ro/2017/06/12/powerbi-visualizations-the-default-ones/

http://msprogrammer.serviciipeweb.ro/2017/06/19/powerbi-custom-visualizations-part-1/

http://msprogrammer.serviciipeweb.ro/2017/06/26/powerbi-custom-visualizationpart-2/

http://msprogrammer.serviciipeweb.ro/2017/07/03/powerbi-custom-visualizationwith-r-part-3/

This is the latest Custom visualization from the series

Here the visuals are made with R – so the user must have R if they want to modify / view in PowerBI desktop ( on web they can see it plain and simple)

Spline : https://store.office.com/powerbiaddininstallpage.aspx?rs=en-US&assetid=WA104380860 

AssociationRules: https://store.office.com/powerbiaddininstallpage.aspx?rs=en-US&assetid=WA104380815

Correlation: https://store.office.com/powerbiaddininstallpage.aspx?rs=en-US&assetid=WA104380814

TimeSeries ForeCasting: https://store.office.com/powerbiaddininstallpage.aspx?rs=en-US&assetid=WA104380816

However, those insist on downloading some packages … so the ugly head of dll hell is raising again.

Series:

http://msprogrammer.serviciipeweb.ro/2017/06/12/powerbi-visualizations-the-default-ones/

http://msprogrammer.serviciipeweb.ro/2017/06/19/powerbi-custom-visualizations-part-1/

http://msprogrammer.serviciipeweb.ro/2017/06/26/powerbi-custom-visualizationpart-2/

http://msprogrammer.serviciipeweb.ro/2017/07/03/powerbi-custom-visualizationwith-r-part-3/

Now I wanted to give a try of each new visualization.  There are 89 visualization on https://store.office.com/search.aspx?productgroup=powerBI .

I have played with last of them – without R integrations – 24 – and the .pbix file can be downloaded from https://1drv.ms/f/s!Aordxu1LWKDZgopsf3vS3IZx2UHOgQ  – you need just PowerBI Desktop.

The visualizations are

TornadoChart

BrickChart

CalendarVIsual

EnlightenDataStory

TableSorter

TimeLIneSlicer

TableHeatmap

AttributeSlicer

Sunburst

HierarchySlicer

WordCloud

ChicletSLicer

BubbleStack

AsterPlot

You can see here:

Series:

http://msprogrammer.serviciipeweb.ro/2017/06/12/powerbi-visualizations-the-default-ones/

http://msprogrammer.serviciipeweb.ro/2017/06/19/powerbi-custom-visualizations-part-1/

http://msprogrammer.serviciipeweb.ro/2017/06/26/powerbi-custom-visualizationpart-2/

http://msprogrammer.serviciipeweb.ro/2017/07/03/powerbi-custom-visualizationwith-r-part-3/

Now I wanted to give a try of each new visualization.  There are 89 visualization on https://store.office.com/search.aspx?productgroup=powerBI .

I have played with some of the first 24 – and the .pbix file can be downloaded from https://1drv.ms/f/s!Aordxu1LWKDZgopsf3vS3IZx2UHOgQ  – you need just PowerBI Desktop.

The visualizations are

HistogramChart

TimeBrushSlicer

DualKPI

CountDown_Narrative_Scroller_Tile

JourneyGraph

RotatingChart

DrillDownDonut

Quadrant

ZoomCharts

PlayAxis

DrillDownChart

You can see the result here

Series:

http://msprogrammer.serviciipeweb.ro/2017/06/12/powerbi-visualizations-the-default-ones/

http://msprogrammer.serviciipeweb.ro/2017/06/19/powerbi-custom-visualizations-part-1/

http://msprogrammer.serviciipeweb.ro/2017/06/26/powerbi-custom-visualizationpart-2/

http://msprogrammer.serviciipeweb.ro/2017/07/03/powerbi-custom-visualizationwith-r-part-3/

Because any program need visual representations, I decided to play a bit with PowerBI Desktop. I need some sample dataset to represent . There are thousands on the internet – I decided to go with Sales Transactions from here .

What I wanted to do is make one report for each visualization . The result can be found at https://1drv.ms/f/s!Aordxu1LWKDZgopsf3vS3IZx2UHOgQ  – you need just PowerBI Desktop.

The default visualizations that I made are :

100%StackedBarChart
Bubbles
Cards
Clustered bar chart
FilledMap
Funnel
GeoMap
LineClustered
LineStacked
PieDonut
Stacked Bar Chart
TableMatrix
TreeMap
Waterfall

If you do not have PowerBI , you can see images at
https://1drv.ms/f/s!Aordxu1LWKDZgopufBHcfMrTzJ_nQw

Again, you can download the file from https://1drv.ms/f/s!Aordxu1LWKDZgopsf3vS3IZx2UHOgQ – you need just PowerBI Desktop.

Next time I will do some custom visualizations from https://store.office.com/search.aspx?productgroup=PowerBI&qu=