HUB
Demo
kdb Insights Enterprise is a cloud-native, real-time solution for continuous actionable intelligence. Over the coming pages you will work through a scenario, ingesting, transforming, and visualising a public dataset. Click Next to begin.
Next
HUB
Demo
SCENARIO
The NYC Dept of Transportation has provided you with an historical dataset of taxi information and asked you to provide insight into traffic density across the state. Using kdb Insights Enterprise you will ingest, query, and then visualize a solution to present back to the team. Click Next to Begin.
The public records used in the following KX Insights Platform Walkthrough are generated from the trip record submissions made by yellow taxi Technology Service Providers (TSPs). Each row represents a single trip in a yellow taxi in 2021. The trip records include fields capturing pick-up and drop-off dates/times, pick-up and drop-off locations, trip distances, itemized fares, rate types, payment types, and driver-reported passenger counts.
View the Dataset
Back
Next
HUB
Demo
kdb Insights Enterprise offers a clean, simple workspace with intuitive workflows.
From the overview pane users can see existing reports and data pipelines, or discover new insights by importing, transforming, exploring, and reporting.
In this example, we are ingesting data from a new data source, so we will select import to continue.
Back
Next
HUB
Demo
The Import landing page offers extensible connectivity to industry standard tooling and highlights several readers for connectivity to sources such as Cloud, Kafka, PostgreSQL, and SQL. Click Google Cloud Storage to begin the Import.
Back
Next
HUB
Demo
To configure the cloud reader, enter the parameters of the Google Cloud Storage Bucket. This will then allow ingestion of the NYC taxi dataset. Click Next to continue.
Back
Next
HUB
Demo
The provided data will be ingested as a static comma-separated value (CSV) file and converted into a kdb+ format, KX’s proprietary in memory, column-store database.
Select CSV to continue.
Back
Next
HUB
Demo
Let's write the data into a new table called Taxi. This empowers analysts to easily query and visualize via kdb Insights Enterprise's reporting feature.
Select Open Pipeline to continue.
Back
Next
HUB
Demo
The NYC Taxi dataset requires nothing more than a simple ingestion process, however, kdb Insights Enterprise is capable of simultaneously ingesting from multiple feeds, merging data into a single function that is compatible with industry standard tooling such as SQL and Python. Click to expand.
Select Deploy to continue.
Back
Next
HUB
Demo
Let's look at how kdb Insights Enterprise simplifies analysis through KX’s proprietary language q, or industry standards such as SQL. Click Explore to continue.
Back
Next
HUB
Demo
With a simple freeform SQL query, we can extract the first 10 records from the NYC Taxi dataset and display the results either visually or in table form:
SELECT * FROM taxi LIMIT 10
Click Overview to continue.
Back
Next
HUB
Demo
Reports offer an interactive data visualization experience that enables non-technical and power users to query, transform, share and present data insights. Select Report to continue.
Back
Next
HUB
Demo
The report designer provides an intuitive layout familiar to any user of office software. Components can be dragged from a palette on the left, arranged on a central canvas, and modified via a property inspector on the right. Click the chart icon to continue.
Back
Next
HUB
Demo
kdb Insights Enterprise provides complete extensibility through hundreds of custom connectors and additionally comes preinstalled with 35 charting components to provide out-of-the-box functionality. Explore the dashboard to learn the insights gained from our ingested NYC Taxi dataset. You have now completed this walkthrough.
2021
2022
2022
2021
Ready to build your own? Access our Guided Walkthrough
Back
KX Insights Click Through
dbaker
Created on September 26, 2022
Start designing with a free template
Discover more than 1500 professional designs like these:
View
Interactive Hangman
View
Secret Code
View
Branching Scenario: Academic Ethics and AI Use
View
The Fortune Ball
View
Repeat the Sequence Game
View
Pixel Challenge
View
Word Search: Corporate Culture
Explore all templates
Transcript
HUB
Demo
kdb Insights Enterprise is a cloud-native, real-time solution for continuous actionable intelligence. Over the coming pages you will work through a scenario, ingesting, transforming, and visualising a public dataset. Click Next to begin.
Next
HUB
Demo
SCENARIO
The NYC Dept of Transportation has provided you with an historical dataset of taxi information and asked you to provide insight into traffic density across the state. Using kdb Insights Enterprise you will ingest, query, and then visualize a solution to present back to the team. Click Next to Begin.
The public records used in the following KX Insights Platform Walkthrough are generated from the trip record submissions made by yellow taxi Technology Service Providers (TSPs). Each row represents a single trip in a yellow taxi in 2021. The trip records include fields capturing pick-up and drop-off dates/times, pick-up and drop-off locations, trip distances, itemized fares, rate types, payment types, and driver-reported passenger counts.
View the Dataset
Back
Next
HUB
Demo
kdb Insights Enterprise offers a clean, simple workspace with intuitive workflows. From the overview pane users can see existing reports and data pipelines, or discover new insights by importing, transforming, exploring, and reporting. In this example, we are ingesting data from a new data source, so we will select import to continue.
Back
Next
HUB
Demo
The Import landing page offers extensible connectivity to industry standard tooling and highlights several readers for connectivity to sources such as Cloud, Kafka, PostgreSQL, and SQL. Click Google Cloud Storage to begin the Import.
Back
Next
HUB
Demo
To configure the cloud reader, enter the parameters of the Google Cloud Storage Bucket. This will then allow ingestion of the NYC taxi dataset. Click Next to continue.
Back
Next
HUB
Demo
The provided data will be ingested as a static comma-separated value (CSV) file and converted into a kdb+ format, KX’s proprietary in memory, column-store database. Select CSV to continue.
Back
Next
HUB
Demo
Let's write the data into a new table called Taxi. This empowers analysts to easily query and visualize via kdb Insights Enterprise's reporting feature. Select Open Pipeline to continue.
Back
Next
HUB
Demo
The NYC Taxi dataset requires nothing more than a simple ingestion process, however, kdb Insights Enterprise is capable of simultaneously ingesting from multiple feeds, merging data into a single function that is compatible with industry standard tooling such as SQL and Python. Click to expand.
Select Deploy to continue.
Back
Next
HUB
Demo
Let's look at how kdb Insights Enterprise simplifies analysis through KX’s proprietary language q, or industry standards such as SQL. Click Explore to continue.
Back
Next
HUB
Demo
With a simple freeform SQL query, we can extract the first 10 records from the NYC Taxi dataset and display the results either visually or in table form: SELECT * FROM taxi LIMIT 10 Click Overview to continue.
Back
Next
HUB
Demo
Reports offer an interactive data visualization experience that enables non-technical and power users to query, transform, share and present data insights. Select Report to continue.
Back
Next
HUB
Demo
The report designer provides an intuitive layout familiar to any user of office software. Components can be dragged from a palette on the left, arranged on a central canvas, and modified via a property inspector on the right. Click the chart icon to continue.
Back
Next
HUB
Demo
kdb Insights Enterprise provides complete extensibility through hundreds of custom connectors and additionally comes preinstalled with 35 charting components to provide out-of-the-box functionality. Explore the dashboard to learn the insights gained from our ingested NYC Taxi dataset. You have now completed this walkthrough.
2021
2022
2022
2021
Ready to build your own? Access our Guided Walkthrough
Back