akenza.io
WebsiteAPI DocumentationWhat's newLogin
  • Overview
  • Getting Started
    • Connect a Device
  • Changelog
  • General
    • Applications
    • Organization context
    • Workspace Context
    • Users
      • User Roles
  • Device Management
    • Managing an organization
      • API keys
      • Users (Organization)
        • Add & removing users from your organization
    • Managing a workspace
      • General Settings
        • Device Lifecycle Reports
        • Workspace properties
        • Occupancy settings
        • Device Setup Assistant
      • Custom fields
      • Tags
      • Users (Workspace)
    • Devices
      • Device
      • Device Simulator
      • Bulk actions
      • Bulk import CSV templates
    • Rules
      • Input
      • Logic blocks
        • Comparison
        • Custom Logic
          • Logic Block Scripting
      • Timed Rules
      • Rule Actions
        • Downlink
    • Data Flows
      • Device Connectors
        • Device Security
          • Using Device Credentials
            • Creating Public/Private Key Pairs
            • Using JSON Web Tokens (JWTs)
              • Python
              • Java
        • HTTP
        • MQTT
        • CoAP
        • LoRaWAN
          • Connectivity Management
          • Swisscom LoRaWAN
          • The Things Network
          • Loriot
          • Actility’s ThingPark Wireless
          • EWZ
          • Cibicom
          • Helium
          • ChirpStack
        • NB-IoT
        • mioty
        • Disruptive Technologies
        • VergeSense
        • Spaceti
        • Haltian
      • Device Types
        • Custom Device Types
          • Uplink
          • Downlink
          • Scripting
        • Library
      • Output Connectors
        • Databases
          • akenza DB
          • InfluxDB
          • SQL Databases
        • Streaming
          • Webhook
          • Azure IoT Hub
          • AWS Kinesis
          • Google Cloud Pub/Sub
          • Apache Kafka
        • Notifications
          • E-Mail
          • SMS
          • Microsoft Teams
          • Slack
    • Custom Components
    • Integrations
    • Reference
      • REST API
        • Filtering
        • Querying Device Data
      • WebSocket API
      • Scripting
        • Stateful Operations
        • Utility Functions
      • Payload Templating
  • Reference
  • Dashboard Builder
    • Managing Dashboards
      • Embedding dashboards
    • Components
      • Map
      • Floorplan
  • Device Setup Assistant
    • Device Setup Assistant - Overview
  • Tutorials
    • BI Tools
      • Grafana Data Source Plugin
      • How to build a dashboard with Retool
      • How to analyze data with AWS QuickSight
    • Devices
      • How to integrate the XDK device from Legic via MQTT on akenza
      • How to connect the Disruptive Technologies-cloud on akenza
      • How to send Downlinks to the Kuando Busylight device
      • How to integrate an Arduino device via MQTT on akenza
      • Integrate a MClimate Vicki LoRaWAN Radiator Thermostat on akenza
      • How to integrate an ERS Elsys device with Loriot on akenza
      • How to integrate the IAM Decentlab device with TTN on akenza
      • How to integrate the Seeed SenseCAP T1000 tracker on akenza
      • How to integrate a Swisscom Multisense device on akenza
    • Notifications
      • How to send SMS notifications
      • How to send notifications to Slack
      • How to send notifications to Microsoft Teams
    • Enterprise solutions
      • How to send data to Azure IoT Hub
      • How to send data to the Google Cloud Pub/Sub
      • How to send data to InfluxDB
      • How to send data to AWS Kinesis
      • How to send data to Azure Event Hubs with Apache Kafka
    • IoT Starter Kits
      • How to integrate the IAQ Kit with Actility on akenza
      • How to integrate the CoWork Kit with Actility on akenza
      • How to integrate the Smart Building Kit with Actility on akenza
      • How to integrate the Pepperl+Fuchs Kit with Actility on akenza
  • Support Center
    • FAQ
    • Status Page
    • Service Desk
    • Request a feature
  • Deprecated
    • SIM-Cards
    • Everynet
    • Sigfox
    • How to connect the Yanzi Lifecycle cloud on akenza
Powered by GitBook
On this page
  • Data Flow Architecture
  • Akenza Output connector
  • AWS Kinesis Data Stream
  • AWS Data Firehose
  • Amazon S3
  • AWS QuickSight

Was this helpful?

  1. Tutorials
  2. BI Tools

How to analyze data with AWS QuickSight

This page describes the architecture needed to stream data from akenza to AWS QuickSight and how to set up a simple dashboard

PreviousHow to build a dashboard with RetoolNextDevices

Last updated 4 months ago

Was this helpful?

Data Flow Architecture

In this tutorial we'll guide you through the process to set up the architecture below. In order to store data from akenza in an Amazon S3 bucket and use QuickSight for data analysis and report generation.

Akenza Output connector

Set up a AWS Kinesis output connector as described here: How to send data to AWS Kinesis

AWS Kinesis Data Stream

Use the Data Stream created in the above mentioned tutorial.

AWS Data Firehose

Prerequisites

If you haven't already created an Amazon S3 data base with a bucket dedicated for this data flow, create one now. Following this chapter: #general-purpose-bucket

Creating a Firehose Stream

Create a new firehose stream. When prompted, select Amazon Kinesis Data stream as Source and Amazon S3 as Destination. Continue to add a name for your stream.

As a next step browse for the previously created Kinesis data stream in Source settings. As well as the prepared S3 bucket in the Destination settings. You may also enable the New line delimiter option.

Now continue to create firehose stream.

Amazon S3

Create General purpose bucket

In your amazon S3 account create a new General purpose bucket. Add a name for your bucket. And consider to enable ACLs to later grant access rights for your QuickSight user to access data in this bucket.

AWS QuickSight

Start by creating an AWS QuickSight account. Ensure to deselect any optional subscription checkboxes. Grant access for QuickSight to the following services:

  • IAM

  • Amazon S3

    • select the relevant bucket

You may need to add additional permission policies to your aws-quicksight-service-role user to allow access to the S3 bucker. Ensure the following policies have been assigned in IAM:

Create Datasets

In Datasets create a New Dataset. Select S3 as data source and give it a name. Continue to upload a manifest file. You may use our sample file. Make sure to update the URIprefixes to match the files in your S3 bucket.

// Sample manifest file

{
    "fileLocations": [
        {
            "URIPrefixes": [
                "s3://akenza-quicksight-testing/2025/"
            ]
        }w
    ],
    "globalUploadSettings": {
        "format": "JSON"
    }
}

Create Analysis

In Analyses create a New Analysis selecting the dataset you just created. Continue with use in analysis and create a new sheet. You may then continue to create your analysis and publish the dashboard when completed.

AWSQuickSightIAMPolicy
AWSQuickSightS3Policy
Target Architecture
Creating a firehose stream
Create QuickSight data source
Basic line chart