on June 17, 2019
If you want to read the Chinese version, please click here
One day your boss asks the team something like:
“Team, how much of our sales comes from new customers?”
Suppose you are able to access the sales order files (both the sales header file and the sales detail file). Both of the files are in typical sales table schema. As usual, it would rack the brains of the team members, with many of them dodging away from giving response.
Although it is still possible to work it out in Excel/SQL Server, it is not easy at all. The traditional working steps would be something like:
The steps are quite tedious and error prone. Even if you can do it in SQL Server by writing the SQL statements, you need to export the result set to Excel for making the chart for a better presentation.
On the contrary, it can be done in just 1 minute (in an ingenious way).
You can be proactive and take the bull by the horns. You then open up your notebook computer and Tableau with confidence.
Step 1: Import and Join the two tables
Step 2: Define a Calculated Field called Customer First Order Year as follows
Step 3: Convert the new Measure to Dimension
Step 4: Make the bar chart by dragging the dimensions and measures as follows:
Order Date -> Columns Sales -> Rows Customer First Order Year -> Color Sales -> Label
Optionally, give the chart a descriptive title as shown.
Incredible! All of this is done in just ONE minute. Your boss would certainly be impressed by your efficiency as you have enabled him to visualize a business problem at a glance.
He could easily spot out that less than 2% of the sales in 2018 were obtained from new customers (represented by the light blue horizontal bar in 2018. Virtually there was no new blood!
Having given a useful chart with daunting efficiency, you have shown high productivity and are well deserved to receive your boss’s praise “Well done!” with a big thumb. That would differentiate you from your peers. Tableau made you a difference. Promotion? Maybe…
TABLEAU – A MARKET LEADER IN DATA VISUALIZATION
Different levels of executives would prefer to view the information in different manners. A CEO, for example, likes charts that possess the following features:
As a middle-level manager, they would like outputs in the form of charts and tabular reports exportable to Excel, easily shareable with team members to follow up issues.
As a supervisor, they like to get charts or reports with exception highlights, identifying outliers, and easily get down to the customer or transactional levels.
All of the above functions are natively offered by Tableau, one of the market leaders in Business Intelligence software.
This is only one example that shows some power of Tableau. The next Tableau amazing example will further impress you more. Watch out for my next blog.
W.C. Chan will be holding the upcoming course, Data Visualisation for Business with Tableau. To learn tricks like this and many more, check out the course page and talk to our admissions consultant for more information.