Age Pyramid Prediction In Poland

Age Pyramid Prediction In Poland

What our community will look like in next 30-40 years? Who will be working for our retirement? What is the future of Polish society? Let’s try to answer those questions with some data analysis using age pyramid visualization. What official statistics say and what does it mean? Polish government has a great data regarding historical and current community statistics. A lot of them are available on stat.gov.pl and my analysis

Read More

Modern Dashboard

Modern Dashboard

This time I’d like to share something new. Dashboard with dark background and rectangle sections for specific groups of measures. I called that “modern dashboard” because of its unusual design and colors, but in general it’s still a standard overview dashboard covering Sales metrics and some business questions can be answered.  Running Sum of Sales and Running Average of Sum of Sales.  As you know – Running Sum or Running

Read More

KPIs Review Dashboard

KPIs Review Dashboard

Whenever it’s possible I prefer creating one-dashboard-only Business Intelligence applications. But how can I fit all visualizations for so many KPIs on one screen? Here is the solution. Dynamic version of KPI dashboard in Tableau Gallery is here. One general dashboard with dynamic measures and dimensions. Most of business KPIs are analysed on trend chart and this one comes as main viz on the dashboard. Usually it takes a lot

Read More

Sales By Customers Dashboard

Sales By Customers Dashboard

Data visualization is all about answering questions. Business grows and you already know how your sales by products go. Better understanding of who and how actually buys your products can help with creating customer profile, recognizing customer’s needs and with preparing marketing operations. What the average order of our customer looks like? According to data from last few years, our average customer makes orders 3-4 times a year, everytime ordering

Read More

Sales By Products Dashboard

Sales By Products Dashboard

Data visualization is all about answering questions. Starting from basics, let us analyse sales by products dashboard. Sales departments usually want to know what, when and how many iteams were sold, so let’s try to answer these most frequently asked questions to better understand business we run. What is my income? The first metric shows total income as sales amount. This one is set to calculate the entire loaded orders

Read More