The Treasurer handed down <a href="https://www.budget.gov.au/">Budget 2018-19 at 7:30pm on Tuesday 8 May 2018</a>. The budget is a complex set of documents and for an ordinary individual understanding or even navigating the document could be quite a daunting task. Interactive visuals have always been a preferred choice for many when it comes to deciphering numbers, particularly multi-dimensional dollar values that run across a number of years.
In this article, we will demonstrate how <a href="/products/kibana">Kibana</a> could be used to visualise a subset of the budget data elegantly than one would normally do using a spreadsheet application.
<h3>The challenge of multi-dimensional data in its raw form</h3>With data (e.g., .csv or .xls) provided in their raw form, one would normally open a spreadsheet application, select the rows and columns in a sheet, and configure some sort of visualisation. The visuals thus created would be static, and one would not be able to select a dimension or dig deeper into that column. Moreover, the process of creating the visual, sharing across an organisation or publicly becomes inefficient and error prone. And by the way, who wants to read a csv or .xls file cell by cell?
We need a simple tool to be able to visualise data and understand its content.
<h3>Visualising Australia 2018 Budget - An example</h3>Budget 2018-19 Tables and Data are publicly available <a href="https://data.gov.au/dataset/863c394c-a26c-4340-896b-a26b18af476d">here</a>.
One of the files “2018-19 Budget Dept Expenses.csv” if opened in a spreadsheet, would look like:
<img src="https://images.contentstack.io/v3/assets/bltefdd0b53724fa2ce/blt1610f65fde9f32c9/5c583e46893c9ee20b66f7ec/spreadsheet-image.jpg" data-sys-asset-uid="blt1610f65fde9f32c9" alt="spreadsheet-image.jpg">
Using Kibana, that data is now presented in an interactive manner as below:
<img src="https://images.contentstack.io/v3/assets/bltefdd0b53724fa2ce/blt6611af0b63b9bd9d/5cc353d9ee4bf29d69c58e13/australia-budget-2.png" data-sys-asset-uid="blt6611af0b63b9bd9d" alt="Australia budget data presented in Kibana" "="">
If you were interested in drilling-down on the “human services” department expenses, then just clicking on that bar would take you to a visualisation like below:
<img src="https://images.contentstack.io/v3/assets/bltefdd0b53724fa2ce/blt070b36ab0640a933/5cc35402ee4bf29d69c58e19/australia-budget-3.png" data-sys-asset-uid="blt070b36ab0640a933" alt="Drilling down into budget data with Kibana" "="">
By the way, have you noticed that these visuals are a part of a webpage and the http link could be shared with anyone you wish?
<img src="https://images.contentstack.io/v3/assets/bltefdd0b53724fa2ce/blt0ba59e988f7aec63/5c6c47ef2b22f9f161d6d356/image1.png" data-sys-asset-uid="blt0ba59e988f7aec63" alt="" "="">
We wanted to see and understand more. So we opened the file “2018-19-pbs-program-expense-line-items.csv”, and the results on piechart showed so much detail.
<img src="https://images.contentstack.io/v3/assets/bltefdd0b53724fa2ce/blt564701f1ea291d17/5cc3543fee4bf29d69c58e1f/australia-budget-5.jpg" data-sys-asset-uid="blt564701f1ea291d17" alt="Detail drilldown via pie chart in Kibana" "="">
Drilling down onto one of the programs, e.g,. Employment Services, we can ascertain how much funds the budget has allocated, as depicted below:
<img src="https://images.contentstack.io/v3/assets/bltefdd0b53724fa2ce/blt0489d0d0f75e26a9/5cc3546f43283e8d640eb9bc/australia-budget-6.jpg" data-sys-asset-uid="blt0489d0d0f75e26a9" alt="Drilling into programs within the pie chart" "="">
Post the technical setup, visualisation creations and final touches, the dashboard is ready to be shared in a multi-tenant way, and it could look as simple as below:
<img src="https://images.contentstack.io/v3/assets/bltefdd0b53724fa2ce/blt024960c2a184a51e/5cc3548f887e04ba6916f953/australia-budget-7.jpg" data-sys-asset-uid="blt024960c2a184a51e" alt="The final budget dashboard in Kibana" "="">
At Elastic, we make things simple!
Now on the technical side of things...
<h3>Importing, Storing, and Visualizing Australia 2018 Budget - An Engineering Approach </h3>Steps to follow to get to the Kibana visuals that could be shared with masses.
<ul>
	<li>Sign up for an <a href="/cloud">Elastic Cloud</a> account.</li>
	<li>Download and install <a href="/downloads/logstash">Logstash</a>.</li>
	<li>Copy-paste the below configuration in your Logstash’s config path.</li>
	<li>Run the Logstash pipeline.</li>
	<li>Start creating visualisations and dashboard in Kibana.</li>
</ul>Below, you will find a Logstash configuration for importing a csv file. You may name this file as “2018-19-pbs-program-expense-line-items.conf”:
<pre class="prettyprint"># This is where your .csv file will be read
input {
 file {
 path =&gt; "/usr/share/logstash/pipeline/aubudget2018/2018-19-pbs-program-expense-line-items.csv"
 start_position =&gt; beginning
 }
}
# This section will allow you to specify the columns, their types, and any additional formatting
filter {
 dissect {
 mapping =&gt; {
 "message" =&gt; "%{Portfolio},%{Department/Agency},%{Outcome},%{Program},%{Expense type},%{Appropriation type},%{Description},%{2017-18},%{2018-19},%{2019-20},%{2020-21},%{2021-22},%{Source document},%{Source table},%{URL}"
 }
 }
 mutate {
 convert =&gt; { "2017-18" =&gt; "float" }
 convert =&gt; { "2018-19" =&gt; "float" }
 convert =&gt; { "2019-20" =&gt; "float" }
 convert =&gt; { "2020-21" =&gt; "float" }
 convert =&gt; { "2021-22" =&gt; "float" }
 }
}
# This section defines the Elasticsearch output configuration
output {
 elasticsearch {
 hosts =&gt; "https://elasticsearch-hostname:9243/"
 ssl =&gt; true
 user =&gt; "elastic"
 password =&gt; "youwishyouknewthisdidn'tyou?"
 index =&gt; "2018-19-pbs-program-expense-line-items"
 }
}
</pre>If you have a docker installed, then you could use the following command to run Logstash pipeline:
<pre class="prettyprint">docker run --rm -it -v `pwd`:/usr/share/logstash/pipeline -e xpack.monitoring.enabled=false -e log.level=debug -e pipeline.workers=4 docker.elastic.co/logstash/logstash:6.2.4
</pre>For more information on the dissect filter being used above, please <a href="/guide/en/logstash/6.2/plugins-filters-dissect.html">visit the documentation</a>.
This is it for now friends.

kibana-visualize-australia-budget-sorted-EmploymentServices-expenses-2018.png

kibana-visualize-australia-budget-sorted-expenses-thumb-2018.png

Using Elastic Stack to Explore Australia 2018 Budget

Start free trial

Blog Footer CTA

Sign up for Elastic Cloud free trial

Dr Suraj Pandey

By submitting you acknowledge that you've read and agree to our <a href="/legal/elastic-cloud-account-terms" target="_self">Terms of Service</a>, and you agree to receive the <a href="/legal/privacy-statement#how-we-use-the-information" target="_self">selected communications</a> at the contact details you provided above. See <a href="/legal/privacy-statement/" target="_self">Elastic’s Privacy Statement</a> for more details or to opt-out at any time.

Communication Preferences - ONLY for /communication-preferences

提交即表示您确认您已阅读并同意我们的<a href="/cn/legal/elastic-cloud-account-terms" target="_self">服务条款</a>，并且您同意通过您提供的上述联系方式接收<a href="/cn/legal/privacy-statement#how-we-use-the-information" target="_self">所选的通信</a>。如需了解更多信息，或想随时取消订阅，请参阅 <a href="/cn/legal/privacy-statement/" target="_self">Elastic 的隐私声明</a>。

By submitting you acknowledge that you've read and agree to our <a href="/legal/serverless-preview-terms" target="_blank">Terms of Service</a>, and that Elastic may <a href="/legal/privacy-statement#how-we-use-the-information" target="_blank">contact you</a> about our related products and services, using the details you provide above. See <a href="/legal/privacy-statement/" target="_blank">Elastic’s Privacy Statement</a> for more details or to opt-out at any time.

Serverless GDPR Text

提交即表示您确认您已阅读并同意我们的<a href="/cn/legal/serverless-preview-terms" target="_self">服务条款</a>，并且 Elastic 可以使用您提供的上述详细信息与您联系，以向您介绍我们相关的<a href="/cn/legal/privacy-statement#how-we-use-the-information" target="_self">产品和服务</a>。如需了解更多信息，或想随时取消订阅，请参阅 <a href="/cn/legal/privacy-statement/" target="_self">Elastic 的隐私声明</a>。

By submitting you agree to <a href="/agreements/global/cloud-services-monthly" rel="nofollow">Elastic Cloud Terms of Service</a>. Your personal data will be processed in accordance with <a href="/legal/privacy-statement">Elastic's Privacy Statement</a>.

Cloud Trial GDPR Text

提交即表示您同意 <a href="/cn/agreements/global/cloud-services-monthly" rel="nofollow">Elastic Cloud 服务条款</a>。我们将会按照 <a href="/cn/legal/privacy-statement">Elastic 的隐私声明</a>处理您的个人数据。

By submitting you acknowledge that you've read and agree to our <a href="/legal/terms-of-use" target="_blank">Terms of Service</a>, and that Elastic may <a href="/legal/privacy-statement#how-we-use-the-information" target="_blank">contact you</a> about our related products and services, using the details you provide above. See <a href="/legal/privacy-statement/" target="_blank">Elastic’s Privacy Statement</a> for more details or to opt-out at any time.

Newsletter GDPR Text

提交即表示您确认您已阅读并同意我们的<a href="/cn/legal/terms-of-use" target="_self">服务条款</a>，并且 Elastic 可以使用您提供的上述详细信息与您联系，以向您介绍我们相关的<a href="/cn/legal/privacy-statement#how-we-use-the-information" target="_self">产品和服务</a>。如需了解更多信息，或想随时取消订阅，请参阅 <a href="/cn/legal/privacy-statement/" target="_self">Elastic 的隐私声明</a>。

Explore similar demos

Overview

Speakers

Close

See more insights

The content on this page is not available in the selected language. As Elastic grows globally, we continue to support content in multiple languages.

The content on this page is not available in the selected language.

本页内容尚不支持所选语言。Elastic 正在不断努力，以实现对多种语言内容的支持。感谢您在此期间给予的耐心与陪伴！

Author

Articles by

Learn more

Watch now (no PT)

Watch now

See all top stories

All (no PT translation)

Contact information

Press Release

Share on Reddit

Share this story

Share by Email

Thank you for your interest!

Contact Info

Follow us on Youtube

Load More

Share on LinkedIn

Follow us on LinkedIn

Search Integrations

All Solutions

Video for

Follow us on Twitter

See when this webinar starts in my time zone

查看本次网络研讨会在我的时区的开始时间

Register to Watch

Register now

See All Posts

Can't make it? Register and we'll send you the recording. You'll also receive an email with related content

无法实时参加？注册后我们会给您发送录像。您还将收到相关内容的电子邮件。

Author

Articles by Suraj Pandey

Using Elastic Stack to Explore Australia 2018 Budget

Sign up for Elastic Cloud free trial