- Call Date Time
- Call Direction
- Phone Type
- Last Cell Tower
- Dropped Reason
- Dropped Call
- Conversation Time (min)
- Setup Time (s)
- ...add your own attributes!
To get your Telco dashboard, you need to provide a Tableau workbook file with (at least) the following 5 attributes (the name of your attributes can differ):
- Call Date Time Date-Time of the call (Date used for time-series analysis)
- Call Direction Call Direction: "InBound", "Outbound"
- Phone Type Phone model, Phone type, Phone Manufacturer...
- Network Network: "3G", "4G"...
- Last Cell Tower Last Cell Tower
- Dropped Reason Call Drop Reason
- Handovers Number of handovers during the call
- Dropped Call 1 if the call dropped, else 0
- Conversation Time (min) Duration of the conversation (in minutes)
- Setup Time (s) Duration of the setup (in seconds)
Your Telco dashboard will contain 10 KPIs
- Total CallsTotal number of calls
- Dropped CallsTotal number of dropped calls
- Dropped Calls %Share of dropped calls
- Avg Setup TimeAverage call setup time (in seconds)
- Avg Conversation TimeAverage call conversation time (in minutes)
- Total HandoversTotal number of call handovers
- Avg HandoversAverage number of handovers per call
- Drop Calls: Avg Conversation TimeAverage dropped call conversation time (in minutes)
- Nb of Cell TowersTotal number of cell towers
- Calls per Cell TowerAverage number of calls per cell tower
Dashboard Pages & Data Visualizations
Your Telco dashboard will contain 7 pages
Telco Top Performers
Telco Adhoc Analysis
Creating your TELCO dashboard Step-by-Step
You want to get a clear understanding on your Telco results? You want to build a Tableau dashboard to better understand your Telco data?
Using LinPack-for-Tableau.com, you can generate an eye-catching, fit-for-purpose Tableau Dashboard on your Telco data in less than 5 minutes!
1st STEP: Create the initial Tableau workbook file
Create a Tableau workbook in which you map your Telco data (whether it comes from: ERP, database, Excel, CSV file...)
You must retrieve at least the following attributes (it is ok if the names don't match, and it is better to add additional attributes to analyze):
2nd STEP: Upload your Tableau workbook file
On LinPack-for-Tableau.com, select 'create dashboard from template: Telco' and upload your Tableau workbook (note: your data is NOT uploaded).
3rd STEP: Map your attributes
Map the attributes of your workbook on the attributes of the template.
Finally, click 'Confirm & Download'... and your Telco dashboard is already downloading :-)
Open the Tableau workbook file you received, it will automatically reconnect to your data sources.
Your Telco dashboard is now ready to be used or customized!