Join our 5-Day Coding Challenge and Build Your First Ecommerce Website! Learn More Here.
17 Jun 2019
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.
If you are at a choice point in your career and need someone to help you navigate professional challenges. You can make an appointment to our complimentary 1-on-1 Career Consultation and receive personalised career advice.
Full-Stack Web Development Immersive
Immersive Data Science & Machine Learning
Full-Stack UX Design Immersive
Web Development for Absolute Beginners
Data Science & Machine Learning
Digital Marketing & Growth Hacking
Introduction to FinTech
Introduction to Python
User Experience Design (Fundamentals)
User Interface Design
Introduction to Product Management
Hire Xccelerate Top Talent
Teach With Us
School Ambassador Program
Future Education Foundation
COVID-19 Economic Recovery Education Fund
Women in Tech Scholarship
1-on-1 Career Consultation
Hong Kong's Largest Career Switch Series 2022
3/F, Citicorp Centre, 18 Whitfield Rd, Tin Hau, Fortress Hill
10 Ubi Crescent, #05-42 Ubi Techpark, Singapore 408564