ImportantThis article shows how the connector works with the Data Query 2 API
About Bime Analytics
Founded in 2009, BIME helps businesses answer the questions they have about their customers. As one of the first analytics platforms to serve up a pure SaaS model, BIME enables any marketer, data analyst, product manager, or support manager to access and consume the data they want to work with and learn from. With customers in over 35 countries, BIME is headquartered in Montpellier, France and joined the Zendesk family in October 2015. Learn more at www.bimeanalytics.com.
The main areas in which Bime works (eg : Design Kpi / Reporting / Data sharing)
- Data analysis
- Data visualization
- Data aggregation
- Data mashups
- Data reporting
- Data sharing
What make BIME different is how it’s built from the ground up to make data more accessible and consumable for anyone—for the support ops manager, the online marketer, or the sales manager.
- Access all your data: With 65+ plug-and-play connectors, BIME makes it easy for you to bring together the data sources you care about.
- Customize your analysis: Within BIME, analysts and non-analysts alike can do analysis by creating data joins, reports, and custom metrics—no SQL required.
- Create beautiful visualizations: BIME comes pre-built with 25+ point-and-click visualization types, so you can transform your analysis into impactful charts and dashboards.
- Share your analysis: Easily share or embed interactive dashboards with others in your organization, so everyone draws from the same insights.
Learn more: https://www.bimeanalytics.com/
Import data into Bime
To get started, simply download the BIME application or the online trial version.
Once the application is open, you can begin importing data.
Select a data source
BIME offers numerous possibilities for data connection. You may choose from the available library: flat files, connectors, or SQL databases.
To connect your AT Internet data, choose the REST connector and click ‘Next’.
Create a Rest set up
This important step allows you to establish the setup of your REST connector and to import your AT Internet data into BIME.
The simplest way to do this is by using the REST connection feature available in the above library.
You’ll then be able to load a REST URL (in XML or JSON format) which you can obtain directly in the Data Query application within AT Internet’s Analytics Suite.
Create a Data Query request (or use an existing template)
Build your query in Data Query and select the API REST URL relating to your data set.
To be able to import data into BIME, it is mandatory to have the Data Explorer option activated on your account, which will allow you to access the Data Query application.
Go into Data Query:
Create a template or use an existing template:
Import data from the AT Internet API to Bime
Select the URL created below the dataset in the desired format.
The import will not work with long URL mode. Please remember to select the short URL mode, as shown in the below screenshot.
- Paste this Data Query URL into the BIME interface’s GET/JSON URL section.
- Add the following optional parameter to format data returned in BIME: $.DataFeed.Rows
- During the import, you will be asked to enter your AT Internet account login and password. Select the basic authentication mode, as in the below example.
Now, you must specify the different parameters making up this API URL by clicking on "parameters" next to the "authentication" section.
The URL put forth by the Data Query application offers the following parameters:
Simply place these parameters into the various fields below:
To test and save your data connection, remember to verify that you’re always authenticated at each step, and that your query has a name.
Create your own queries
By default, Bime offers you certain queries, but it's entirely possible to create your own. Bime will sort the fields of your data source into attributes and measures according to the content in each field.
To learn more about Query Builder, please consult the Bime support centre.
Once your data is formatted, Bime will import it and suggest that you access Query Builder. This tool allows you to pair measures or attributes in order to build the visualisation that's most adapted to your needs. Create colour coding, build filters, or customise your query by adding a table or by editing the axes options.
Bime will select the type of visualisation that's most adapted to your query.
Create your dashboard
As with for queries, Bime's intelligence and power lets you access a ready-to-use dashboard incoporating AT Internet data.
In the prior example, we connected data about visits per country during a fixed period. Below are the results :
To get more AT Internet data, you can create an exhaustive template in Data Query, or connect several templates by following the above steps as many times as needed.
Share your dashboard
In each created dashboard, it's possible to use the Export feature which will let you choose different data formats : CSV, image, Excel.
If you wish to share your dashboard internally, use the share feature which lets you create groups of users and select the type of publication (public or private).
Activating this partnership activates the export of AT Internet data into Bime. Only the data necessary for the proper functioning of the bridge are exported.