Intermediate

Integrating Akkio with Screenly

Tutorial

Integrating Akkio with Screenly
An example Airtable view

What is Akkio?

Using Akkio, users can upload their own data sets and then use a drag-and-drop interface to build machine learning models that can predict outcomes or classify data. The software uses automated machine learning algorithms to suggest the best models for the user’s data, and also allows for customization of the models to fit specific needs.

Akkio is designed to be user-friendly and accessible, so that individuals and organizations of all sizes can leverage the power of machine learning in their work without needing a team of data scientists or programmers.

The data is not top-of-mind if employees do not view this data regularly and cannot use the data to make informed decisions. Screenly allows users to display data from Akkio on a TV or monitor. By displaying these data on an office TV, businesses can make sure the relevant parties are up-to-date with relevant information.

The best way to go about this is by adding data from Akkio to a dashboard/visualization software such as Google Looker Studio or Zoho Analytics. With Google Looker Studio or Zoho Analytics, data from Akkio can be used to create analytics dashboards that can be integrated smoothly with Screenly.

Creating dashboards with Akkio data in Google Looker Studio

The first step is to log in to your Akkio account. After logging in to your Akkio account, open the flow dataset you would like to display on the digital sign. At the top-right corner, click on the “Download” button, to download the csv file for the flow dataset.

An image showing akkio flow dataset with download button at the top-right

This csv file can be added as a data source in Google Looker Studio. With Google Looker Studio, you can make interactive dashboards with the csv file for your Akkio workflow. This dashboard can then be added as content to your Screenly account and displayed on your TV or monitor with a digital signage player.

To add your csv file to Looker, first you have to sign up for or log in to Google Looker Studio. After logging in, click on “Create” from the side-menu, then click on “Report” from the sub-menu.

An image showing looker page with left-side menu and button to create report

In the new page, from the “Add data to report” popup modal, scroll down to find the “File Upload” option and click on it.

An image showing looker page with data sources for creating reports including the File Upload option

In the pop-up modal, click on the “Click to Upload Files” button, add your csv file from your storage and click the “Add” button at the bottom right.

An image showing a pop-up modal in looker to upload files for report creating

You have now successfully uploaded your Akkio data to Google Looker Studio as a data source. Follow the on-screen instructions to create an interactive dashboard with your data. To learn more about how to integrate your analytics dashboard with Screenly, read our detailed tutorial article on Google Looker Studio.

Creating dashboards with Akkio data in Zoho Analytics

The first step is to log in to your Akkio account. After logging in to your Akkio account, open the flow dataset you would like to display on the digital sign. At the top-right corner, click on the “Download” button, to download the csv file for the flow dataset.

An image showing akkio flow dataset with download button at the top-right

This csv file can be added as a data source to a data visualization software such as Zoho analytics. With Zoho analytics, you can make custom analytics dashboards with the csv file for your Akkio workflow. This dashboard can then be added as content to your Screenly account and displayed on your TV or monitor with a digital signage player.

To add your csv file to Zoho analytics, first you have to sign up for or log in to Zoho analytics. After logging in, click on “Create” from the side-menu, then click on “New Table/Import Data” from the sub-menu.

An image showing a Zoho analytics page with left-side menu open and create button

In the “Import Your Data” page, click on the Excel icon with “Files” written underneath.

An image showing a Zoho analytics page with data sources for creating dashboards including the Files Upload option

In the new page, enter a name for your new table that is about to be created. Under File Type, select “CSV, TSV & Other Text Format”. Select “Pasted Data” as the data location. Open the csv file in any text editor, copy it and paste it into the textbox provided, then click the “Next” button.

An image showing a Zoho analytics page with form for csv file upload options

In the final “Import” page, adjust the table settings as you like, then click on the “Create” button at the bottom of the page. This will create a table in your Zoho analytics account using the data from the csv file.

An image showing a Zoho analytics page with form for csv file upload options and create button at the bottom

To create an analytics dashboard from the table in Zoho analytics, click on “Create” from the side-menu, then click on “Chart View” from the sub-menu. Follow the on-screen prompts to create a dashboard. This dashboard can then be integrated with your Screenly account.

An image showing a Zoho analytics page with left-side menu open and create new dashboard submenu

To learn more about how to integrate your analytics dashboard with Screenly, read our tutorial article on Zoho analytics.

We are here to help

If you have any trouble integrating Akkio with Screenly, let us know at Screenly Support. We are here to help!

Recent Tutorials

Display your best content with Screenly digital signs.

Screenly is loaded with features to make digital signage management easy.

footer screen image
manage cookies