Table of Contents

...

1. General Information and standard reports - Use our internal PowerBi Reports (coming soon)
2. Detailed Analysis with Lots of Data - Setup your own SQL Azure and PowerBi environmentsenvironments (you need a Microsoft Azure license and PowerBI online licenses)
   1. We will create a SQL database with a number of linked tables in AzureAzure 
   2. We will publish data to those tables regularly
   3. Connect PowerBI to this table set - then publish to PowerBi online
   4. Edit and adjust your reports in PowerBi online
   5. Note PowerBi can also connect to other data sources like excel online or websites to enrich the data
3. Export from lists in the system regularly
   1. Either / or
      1. import these to power bi desktop then publish the results
      2. Load these upto excel online that Power Bi is connected to

Microsoft Power Bi

...

The ideal place for this database is in SQL Azure - it is cheap and in the same place as Power Bi Online so data does not travel across your network for designing and refreshing the report data.

• For those that like excel it can also connect to Azure... https://blogs.technet.microsoft.com/office_online_support_blog/2015/10/29/excel-online-refreshing-data-to-a-sql-azure-database/   and https://powerbi.microsoft.com/en-us/documentation/powerbi-azure-sql-database-with-direct-connect/

...