Reporting

These features are currently only available by request. Please reach out to product@addigy.com to request access.

Reports are essential tools for administrators managing fleets of devices. They transform complex data into visual formats, making it easier to identify trends, inefficiencies, and recurring issues. This clarity enables IT teams to proactively address problems, optimize resource allocation, and ensure system reliability. Additionally, reports provide measurable insights into performance metrics like costs, helping stakeholders make data-driven decisions to improve operations and reduce expenses. By presenting actionable insights in an accessible manner, reports demonstrate the value of IT efforts while fostering accountability and informed decision-making.

Addigy is taking a three prong approach to reporting:

1. Exporting data
2. Providing useful prebuilt dashboards
3. Allowing you to create your own dashboards

Exporting Data for tools like PowerBI

We understand that you use many tools in your day to day work and sometimes you need to cross reference data across multiple systems. This is why we are making it easier than ever for you to easily export data from Addigy to be used with the most popular Business Intelligence (BI) tools in the market such as PowerBI.

In order to accomplish this, we have created an integration with Google Cloud’s BigQuery that automatically exports different Addigy datasets into your BigQuery system. BigQuery can then be used as a source for all popular Business Intelligence tools.

Exporting to BigQuery

1. Make sure that your Addigy user role has the permission “Export Report Data”.
2. Navigate to Dashboards > Data Exports
3. Click on “New Export Job”
4. Follow the instructions on the screen to make sure you have a Project ID from Google Cloud Platform and a BigQuery Dataset.
5. Click on “Grant Addigy Access To BigQuery and follow the instructions on screen
6. Enter the Project ID obtained from previous steps
7. Click on “Load Datasets”
8. Select the Dataset from the drop down menu
9. Click “Select All” or just specific datasets you are interested in exporting
10. Make sure you “Enable” the integration on the top right of the prompt
11. Finally, click “Save”

After completing these steps you will be able to see new BigQuery tables built within the Dataset that you selected. The table names will be prefixed with addigy_, for example: addigy_device-audits. Each table will have a column named export_date that indicates the date in which the data was exported from Addigy into BigQuery. Addigy will export data once a day starting from within an hour of the integration being enabled and every consecutive day within one hour of 12AM UTC.

These tables are partitioned on the export_date field, which makes it optimized for querying based on this date in order to make the queries cheaper and faster. Addigy will not remove any data from these tables; it is up to you to make sure that the tables are maintained in accordance with your own data retention policies and requirements.

Accessing Data From PowerBI

1. On PowerBI Desktop, start a new project or open an existing project
2. In the Home navigation bar, click on “Get Data” > “More…”
3. Search for “BigQquery”, select “Google BigQuery”, and click “Connect”
4. Click “Ok” and follow the instructions on the screen to authenticate to your Google Cloud Platform account
5. Click “Connect”
6. Select the Project > Dataset > Tables you wish to use within PowerBI and click “Load”
7. On the “Connection settings” prompt we recommend you toggle the DirectQuery option so that you are always looking at the most recent data and don’t have to worry about refreshing local data.

After these steps you should have the BigQuery tables available in your Data menu to be used in your reports.

Prebuilt Dashboards

This feature requires a user with permission “View Reports”.

As administrators, oftentimes we don’t know what we need. By partnering with many administrators in the industry we are using market insights to provide you with useful dashboards that not only allow you to find and resolve issues in your portfolio but also show value to your stakeholders.

These new dashboards will be created and maintained by Addigy. They will become available under the Dashboards navigation submenu. Within each dashboard you will find useful charts related to the theme of the dashboard. You will be able to see and download the data behind each chart by clicking in the top-right options menu on each chart. 

Custom Dashboards

As helpful as we want our Prebuilt Dashboards to be, we understand that one size does not fit all. This is the reason we are giving you the ability to create your own custom dashboards tailored to your unique reporting needs.

Custom Dashboards are coming soon.