How to create a table with a bar graphs in it? In a Power BI page, add a new “Table” visual: Now drag and drop the fields Date, Subdivision and Business Unit in the Values section of the table: I removed the Quarter, Month and Day from my Date hierarchy (in the values section […]
Continue reading
Do you know how to create a map chart in Power BI? In a Power BI page, insert a Filled map visual: In your recently created visual, drag and drop the fields Country, State and City to the Location section: Now we have to add some numbers and change the colours. Drag and drop the […]
Continue reading
How to create a chart with stacked bars and a line over a period of time? In a Power BI page, follow the instructions: In the Visualizations menu, choose “Line and stacked column chart”. Now drag the Date field to the Shared axis and the Revenue to the Column values: Now drag the Subdivision to […]
Continue reading
How to create a table with a bar chart in Tableau First, Open tableau and connect to your data. Then you’ll start by building the table. Drag and drop into the Rows shelf the date, subdivision, business unit and revenue pills. This will be the result: Rick click on the green (continuous) SUM(Revenue) pill […]
Continue reading
In this quick tutorial, I’ll show you how to create a shaded map in Tableau. Tableau automatically recognizes the Country, State and City as a hierarchy and their geographical roles which makes creating a map quite easy. Also, Tableau generates the Latitude and Longitude for us, according to those geographical roles, saving us a lot […]
Continue reading
Ever wondered how to show a graph in a tooltip with Tableau? In this example, I’ll show a very simple and quick example of how you embed a graph in another graph’s tooltip. Suppose you have a graph that shows the revenue and the forecasted revenue over time but I want to show more detail […]
Continue reading
Have you ever struggled to create a Tableau chart with stacked bars and a line over a period of time? Open Tableau and follow these instructions: 1. Drag and drop your date pill on your Columns shelf, right click on it and select “Exact Date”. 2. Tableau will transform it in Continuous, […]
Continue reading
There’s an awful lot of talk around interactive dashboards lately. Most of it is about how they can instantaneously show you valuable information about a business and all via self-service analytics. It seems everyone has built a dashboard and consider themselves either dashboard rookie or dashboard craftsman. A dummy’s guide to … There are plenty […]
Continue reading
A craftsman is defined as a worker skilled in a particular craft. As a true craftsman in data analytics, you are someone who can create an interactive dashboard in any technology and achieve the same outcome. An outstanding interactive dashboard that not only engages the audience but delivers valuable insights. Choose your weapon You are an […]
Continue reading
You have been using dashboarding tools like Power BI and Tableau for a couple of years and some would consider you a dashboard expert. You are no rookie You are very familiar with the way data works and are possibly an accomplished data engineer. You would be comfortable with data in all shapes and flavours […]
Continue reading