A regional telecom leader gains real-time insights about the availability of their services and customer sentiments with modern Power BI reports

About the client

The client is a leading telecommunication company that creates custom technology-based network solutions for businesses of all sizes nationwide. They improve human progress through technology by connecting people, data, and applications. 


Client challenges
  • The client used an on-premises system for storing operators, vendors, and customer data, which was expensive and difficult to maintain. 
  • The absence of a platform to monitor and track customer behavior, usage, and sentiments resulted in a lack of visibility, making it difficult to gather valuable insights that could facilitate service improvements.
  • They wanted to upgrade their system and centralize their data management to remain competitive.   
Solution
  • PreludeSys created an Azure Storage account and developed Snowpipes to move data from the Azure Storage account to Snowflake.
  • Performed tokenization, logistic regression, and TF-IDF processes before loading data into Snowflake for further analysis and reporting.   
  • Created APIs to fetch real-time data about their services across various sources and integrated Power BI into Snowflake to access actionable insights and generate real-time reports.
  • Leveraged the Snowflake data and Power BI to provide real-time insights into business performance and future trends.   
Results at a glance
Established affordable and scalable data architecture Data-driven identification of potential service offerings Reduced query execution time and increased efficiency
Benefits
  • The integrated and streamlined data architecture improved data quality, consistency, visibility, and access.
  • Implemented scalable data solutions for storage, processing, and analytics, significantly reducing operational costs. 
  • Real-time insights on customer, vendor, and service levels improved their performance and decision-making.
  • The Power BI reports enable them to identify customer sentiments and launch custom service offerings.
  • The newly implemented Snowflake architecture accelerated query execution, boosting the overall efficiency of their data analysts.    
Technology
  • Snowflake
  • Power BI
  • Microsoft Azure
  • Python