Census Analyzer Hints At Future
Written by Kay Ewbank   
Tuesday, 16 February 2016

A web app for data visualization and analysis has been released in proof-of-concept stage by JetBrains.

 

Census Analyzer 1.0 is, as the name suggests, currently available for analyzing US Census Bureau data, but this version is being described as a proof-of-concept tool meant as a preview for a more large-scale data analysis product that is still in the works. The current version can be used in the cloud to work with graphs and pivot charts, generate graphical reports, publish them and share them online.

casq 

The app is fully web based, with no local client needed to run the analysis. It lets you analyze and visualize the data using the same app. The tool has three main components, starting with a file system in the cloud that's hosted by JetBrains but managed by the user. There's a simple code editor that lets you create queries, build pivot tables, and draw charts and maps. The final element is a drag-and-drop report builder for creating and publishing your reports as interactive dashboards that can be shared.The app can be used collaboratively, so you can share workbooks with colleagues who can edit it simultaneously.

 

Census Analyzer from Sasha Malahov on Vimeo.

 

As shown in the video, the code editor has ease-of-use features such as smart autocompletion and action suggestions. The developers say queries are written in "an understandable language" and created automatically; all you need to do is choose the right types and dimensions of plots.

The code in the samples on the app has a reasonably understandable syntax; the following gets some data and creates a pie chart, for example:

retrieve data data source:
  census
    columns: Age.By 5 Years
    row: Race
    where: Year.2010
    measure: <default>
pie chart RaceDist
  category: Race
  value: _0_4
  presentation
     chart height: 400 px
     chart width: 400 px

The charting options in this initial version include basic plots such as scatter plots, bar/line/area charts, population pyramids, and two types of maps. There's also a drag-and-drop report builder onto which you can drag your queries, charts and maps to create reports.

The app can be tried out for free with a Google account.

 

casq

More Information

JetBrains Blog

Census Analyzer App

Related Articles

0xdeb Becomes Datagrip

JetBrains Previews IDE For SQL

JetBrains Toolbox - An Unwelcome Change

JetBrains Responds To Backlash

To be informed about new articles on I Programmer, sign up for our weekly newsletter,subscribe to the RSS feed and follow us on, Twitter, FacebookGoogle+ or Linkedin

Banner


Advent Of Code 2024 Now Underway
01/12/2024

December 1st is much anticipated among those who like programming puzzles. It is time to start solving small but tricky puzzles on the Advent of Code website with the goal of amassing 50 stars by Chri [ ... ]



.NET 9 Released
18/11/2024

.NET 9 has been released with a number of performance improvements and new features designed to help developers use AI.


More News

espbook

 

Comments




or email your comment to: comments@i-programmer.info

Last Updated ( Tuesday, 16 February 2016 )