Data Analytics Flashcards
7 cards from real CTE practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.
Read the first 7 Data Analytics flashcards as text
A telecom operator notices its average revenue per user (ARPU) is declining. Which analytics approach best identifies the root cause?
Answer: Segment-level cohort analysis comparing spend patterns over time
Cohort analysis isolates trends within customer segments, revealing whether ARPU decline stems from churn, plan downgrades, or mix shifts.
In telecom network analytics, what does a high packet loss ratio combined with low latency most likely indicate?
Answer: Congestion at a specific node causing drops before queuing pressure builds
Packet loss with low latency often signals a node-level issue (e.g., hardware fault or misconfigured QoS) rather than broad network saturation.
Which statistical technique is most appropriate for forecasting telecom subscriber growth when seasonality is present?
Answer: ARIMA with seasonal components (SARIMA)
SARIMA explicitly models both trend and seasonal patterns, making it well-suited for subscriber forecasting with cyclical demand.
A CTE candidate reviews a dashboard showing NPS scores segmented by geographic region. What additional dimension would most improve actionability?
Answer: Customer service interaction history and resolution rates by region
Linking NPS to service interaction data reveals whether detractors are driven by specific touchpoint failures that can be operationally addressed.
What is 'data normalization' in the context of preparing telecom usage datasets for machine learning?
Answer: Scaling numeric features to a common range so no single feature dominates model training
Normalization rescales features (e.g., call minutes and data usage in different units) so algorithms treat them with equal weight.
A carrier's fraud detection system generates many false positives. Which metric should be prioritized to reduce customer impact while maintaining fraud catch rates?
Answer: Precision
Precision measures the share of flagged cases that are truly fraudulent; improving it directly reduces false positives that harm legitimate customers.
In telecom capacity planning analytics, what is 'Busy Hour Traffic' (BHT)?
Answer: The peak one-hour period of network load used to size infrastructure capacity
BHT represents the single busiest hour of traffic and is the standard dimensioning reference to ensure the network handles peak demand.