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.
TRADITIONAL APPROACH:
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).
TABLEAU APPROACH
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.
17 Jun 2019
鏈接
關於我們
企業培訓
招募Xccelerate頂級人才
活動
網誌
所有課程
加入我們
Teach With Us
常見問題
未來企業家 X
校園大使計劃
未來教育基金
COVID-19 經濟復甦教育基金
Women in Tech Scholarship
一對一職業諮詢
地址
天后威非路道18號萬國寶通中心3樓 炮台山地鐵站: A出口步行5分鐘天后地鐵站: A2出口步行5分鐘