#58 PowerBI Dashboard for Messi´s worldrecord of 91 goals in one year
- This post is not about an Excel I made (but about a Microsoft Power BI dashboard I made, which is (almost) a copy of an Excel workbook I blogged about earlier), so I tagged it with the 'More' category.
Once I made an Excel with a PowerView dashboard for Messi's worldrecord of #goals in one year (91), see:
In this post, I made a new version of this dashboard, but now in Microsoft PowerBI, and also with some improvements, e.g. the treemap-view for all matches in which Messi scored, aggregated by the team and competition where he made his goals. NB: For more info about the Treemap-chart, see my previous post:
See fig.1 for the end-result, in PowerBI Desktop.
Fig.1 Messi-Dashboard in PowerBI Desktop
The nice thing of PowerBI-dashboards is that they are suited for any device, so apart from PC also smartphone or tablet, see fig.2, in PowerBI-online (cloud-service), so this is a site for sharing your dashboards, for mine, see:
This URL Power BI gave me after choosing menu-option: "File > Publish to web", which should make the dashboard 'public', see:
Or you can use this URL: https://app.powerbi.com/groups/me/dashboards/729276ac-365c-4473-9d42-1969ddd16dac
There is also a Power BI Community page which has a 'Data Stories Gallery', and I posted my 'Messi-dashboard' here:
And here I found another nice Messi-dashboard:
So this is similar to this page of the Tableau-community:
Fig.2: Messi-Dashboard in PowerBI (online) on PC and smartphone
2 Nice build-in features of Power BI are:
- Quick Insight in the dataset (source of dashboard), which generates several 'data-profile' charts, see fig.2b
- Natural language Q&A, user types his question (in English), using some 'keywords' like 'by' to specify the 'slice-and-dice' dimensions, and Power BI answers (with charts) , see fig.2c.
For more details about these features (and Power BI in general), see:
Fig.2b: Quick Insight
Fig.2c: Natural language Q&A
As said in my previous blog-post, my Messi-dashboard was inspired by one made with BI/Dashboard-tool Tableau (for which PowerBI was Microsofts answer/alternative), see fig.3 for the this version.
Fig.3: original Messi-dashboard in (free trial version of ) Tableau
To see another really nice example of a PowerBI-report with the results of the Spanish soccer League made by a friend, see fig.4 and his site: http://Ligasantanderbi.azurewebsites.net
Fig.4: PowerBI (with Azure) example with results Spanish soccer League
So with Power BI you can make really nice dashboards, and with the frequent updates/releases of Power BI, much more frequent than that of MS Office (Excel), one could wonder if for 'self-service BI' Power BI is the way to go (and not Excel with its 'Power-plugins' like Power View, Power Map etc.) Some say it is, see e.g.:
while others say you can/should use the 'pack' 'Power BI + Exel', see:
And what do you think? Comments are welcome (but please not anonymously, because I get a lot of 'fake' comments (publicity) from anonymous users, so I don't read anonymous comments.
Although I haven't got any comments on this post (yet), apparently the 'editor' of The #PowerBI Daily (on www.paper.li), liked this post, because he published it here today, see fig.5.
NB: Paper.li is a site to create your own (virtual) newspaper of tweets of persons you follow, for more info, see:
Fig.5: Blog-post referenced on The #PowerBI Daily (on www.paper.li)
-1: Good explanation of what is "Business Intelligence (BI): Multidimensional Analysis"
-2: A 'BI-solution' actually consists of 2 components: a Data Warehouse (DW), the (invisible) back-room ('the database') and BI, the (visual) front-room (the dashboard), where DW is normally about 80% of the solution, and BI 20 %, so it is the top of the ice-berg, as described here:
Pbix-file, so PowerBI-report: