...

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 environments
   1. We will create a SQL database with a number of linked tables in Azure
   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

Consists of a number of parts

...

Power Bi Desktop

Use this to:

1. Define the data sources and add new data sources
2. Define the data conversion steps (from raw data to ready to analyse data)
3. Create reports / dashboards
4. This environment can do everything except allow others to view the results.  To do this you must publish your report to the online environment

Power Bi Online

1. An online report editor An online publishing areato create reports / dashboards
   
   1. Note: Can load up single tables and create reports - but not link tables together nor do data cleansing
2. Online Consumption of reports
   1. Reports once published are accessable by users

Where to get data

Power Bi can accept data from many sources as you can see here...

1. all into a single data set
2. Manage multiple data sets

Image AddedImage AddedImage AddedImage Added

Exporting from Lists in the system (CSV files)

Extracts from any list in the system - choose a date range etc if required

BI Extracts (CSV Files)

If your system has a BI Download configured - these files save as CSV with the "|" character as the delimiter

...