The tool set selection is an easy one. I need to use Microsoft technology for the presentation so immediately I am looking at the following technologies:
- SQL Server 2012 ( what I have available to me)
I have downloaded the Power BI Desktop Application from https://powerbi.microsoft.com/en-us/downloads/ and signed up for a free account using my own domain name. Note that personal e-mail addresses don’t work with the sign up page, so I was unable to use my usual Microsoft account.
The power BI account is essential as with the desktop application you are limited in what can be shared and presented. Power BI online allows the creation of “dashboards” that select use components of reports that can be created using the desktop application. It is from here that you can share the information and publish it to the WWW.
There are a number of other downloads:
- Microsoft on-premises data gateway that allows you to refresh your data by connecting to your on-premises data sources without the need to move the data.
- Microsoft Power BI Mobile for iOS, android and Windows
- Microsoft Power BI publisher for Excel that allows snapshots of PivotTables, Charts, cell ranges, from Excel spreadsheets to be saved a Power BI web dashboard.
So after configuring the developer edition of SQL Server and my Power BI downloads I am ready to go.