Part 3: This is the third in a multi-part series on incrementally building a dashboard using Plotly Dash. We add selection items to a dropdown filter that will filter the Folium maps in the dashboard we set up (we dynamically create the maps here).

Himalayan blue poppy

The data from Inside AirBnB provides publicly available data for AirBnB listings in Seattle, USA. We will use the dashboard framework we created in the first part of this series and include spatial data to explore the locations of the listings.


Bind a legend to a multiline display of stock close price. Add a tooltip line and text for the selected stock.

I recently watched a very neat trick BI elite’s Parker Stevens employed to create a ticker chart in Power BI. You can watch it here. What I find quite interesting is that, whether in Power Query or Power View quite a few of the concepts used in Python libraries to clean and visualize data can be transferred over to Power BI and vice versa.

Take the above chart created in Altair (Python library for visualization for instance. In Altair, you can break down various elements of the chart, build them based on the underlying data in standalone units and then…


As per Wikipedia, A Pareto chart is a type of chart that contains both bars and a line graph, where individual values are represented in descending by bars, and the cumulative total is represented by the line. The chart is named for the Pareto principle, which, in turn, derives its name from Vilfredo Pareto, a noted Italian economist.

The purpose of the Pareto chart is to highlight the most important among a (typically large) set of factors. …


Visualization with a dash of DAX and peppered with Python Altair

Creating a scatter plot of percentage usage of emojis harvested from viewer tweets during a televised event. The dataset consists of emojis (decimal representation) along with the percentage usage of the top ten emojis in the tweets collected. Most of the emojis have a single Unicode and decimal representation, whereas there is one which is the flag of Ireland emoji that is the concatenation of two Unicode characters.

Why did I not use the standard or custom scatter plots in Power BI? I searched high and low for a scatter plot in Power BI that would display the value (as…


There have been several instances when columns values have to be aggregated in a list of comma separated values. Contrast this to the requirement in this article where we needed to split up a comma separated list in a column into multiple rows.

This kind of aggregation requirement arises when columns are grouped by and the aggregation function, is applied on a column that is text. You can count the number of values in this column being aggregated or you can collect its values in a list. Unlike numeric data, this column cannot be acted upon by an aggregation function…


When you are accumulating wealth, you will run into the task of aggregating and analyzing the totals, either per period or over an entire span of time.

General Ledger Account Scenario

In the case temporary accounts such as expenses, which is a temporary general ledger account, an accounting firm will look to re-calculating the expenses every year, since its account balance is removed by transferring the amount to another account. The value resets with the start of the next fiscal year and accumulates once again until the end of that fiscal year.

Retail Sales Amount scenario

Then there are scenarios…


Part 4: This is the fourth installment of a multi-part series on incrementally building a dashboard using Plotly Dash. We discuss data cleaning, data type recognition, formatting and preparation especially with regard to creating a Sankey and Bar chart. The Sankey diagram will show the number and types of properties in a neighborhood

Himalayan blue poppy

The data from Inside AirBnB provides publicly available data for AirBnB listings in Seattle, USA. We will use the dashboard framework we created in the first part of this series and include spatial data to explore the locations of the listings

Goal

We will be creating a Sankey…


Part 2: This is the second installment of a multi-part series on incrementally building a dashboard using Plotly Dash. We create a spatial data scatter plot using Folium.

Himalayan blue poppy

The data from Inside AirBnB provides publicly available data for AirBnB listings in Seattle, USA. We will use the dashboard framework we created in the first part of this series and include spatial data to explore the locations of the listings

We are aiming for a dashboard layout as seen below. We will add iFrames to our layout to display Folium maps. These maps are interactive, with hover tooltips that provide more…


Part 1 : This is the first of a multi-part series on incrementally building a dashboard using Plotly Dash. We begin with the scaffolding — the HTML structure for the pages.

Himalayan blue poppy

Note : Much is owed to Gabriele Albini whose project on building a professional dashboard structure helped me get started with my own journey with Plotly Dash dashboards. I have used elements of the HTML building structure that he has shared, notably the reusable HTML element creating functions such as get_header and get_navbar.

A dataset is rendered far more meaningful when translated into images from which you can reap…


In a company that handles leases, one of the rates that accounting applies to generate journal entries is depreciation rate. The accounting team has been tasked with updating the depreciation rate for assets for various countries beginning January 01, 2020. While they can insert the new rates and set their effective date from January 01, 2020, the team also has to cap the previous rates denoting that the historic rates stored are effective only until midnight of December 31, 2020.

This is where the analytic LEAD function in SQL steps in. It can be used to look into the rows…

Simi Talkar

Certified Data Analyst (DA-100 Power BI), pursuing Masters in University Of Michigan’s Applied Data Science Program https://www.linkedin.com/in/simi-talkar/

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store