Table of Contents
| Table of Contents |
|---|
Example PowerBI reports
Power BI
Overview of Power BI
...
Microsoft Power Bi process
| Gliffy | ||||
|---|---|---|---|---|
|
Power Bi Desktop
Use this to:
...
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/
...
In the sample below - 32 = multiple vehicles, 64 = Favourite, 128 = Is bulk order, 16 = POD.
| Note |
|---|
Bitwise operators are converted into readable text when using the vbi_ tables. Only when using raw database tables will you need to convert. |
Review the changes made
Once you have cleansed the data you can review each step applied (it is applied again in order if you refresh the data)
...
| Page Properties | ||
|---|---|---|
| ||
|