Wefi

Sisense Logo
Customer Company Size
Large Corporate
Product
  • Sisense
  • Sisense ElastiCube
Tech Stack
  • SQL
  • Sisense ElastiCube
Implementation Scale
  • Enterprise-wide Deployment
Impact Metrics
  • Productivity Improvements
  • Customer Satisfaction
  • Digital Expertise
Technology Category
  • Analytics & Modeling - Big Data Analytics
  • Analytics & Modeling - Predictive Analytics
  • Application Infrastructure & Middleware - Data Visualization
Applicable Industries
  • Telecommunications
  • Software
Applicable Functions
  • Business Operation
  • Quality Assurance
Services
  • System Integration
  • Software Design & Engineering Services
About The Customer
WeFi provides technology for optimizing and managing Wi-Fi networks. For mobile operators, WeFi acts as a data offloading tool in overloaded cellular networks. For end users, WeFi makes it easier for them to find and enjoy optimal wireless connections around the world. WeFi’s tools allow its user community to map the global Wi-Fi network with minimal effort, as over 75,000,000 access points have been identified around the world. Millions of WeFi users are generating seriously big data, and the database team deals with an average table size of more than 5 million rows for behavioral data, and over 500 million rows for activity records of some of the most active clients. Reporting on this activity is essential to helping the company’s management team make decisions.
The Challenge
WeFi’s database team had been manually running SQL queries, but they struggled to generate the reports that gave the management team crucial feedback. WeFi needed to perform advanced analysis on large amounts of data in three categories: the behavior of millions of WeFi users, including retention activity and data acquisition activity; the performance and activity of wireless networks to which its users are connected; and the activity records of active clients. The average table sizes for these categories were more than 5 million rows, 70 million rows, and 500 million rows respectively.
The Solution
WeFi carried out its initial Sisense implementation by loading data as-is into a single Sisense ElastiCube, and additional stores were added to the server later on. A dedicated PC machine serves as the ElastiCube server, and today the WeFi team runs the majority of its business reporting and dashboards on Sisense, using a total of six ElastiCube data stores. Business users today have the autonomy to create custom dashboards and reports, which dramatically reduces the time it takes to get new data insights; lightning-fast query response times mean answers to key strategic questions are available faster. Meanwhile, the database team can focus on crucial tasks without spending hours writing and running SQL queries.
Operational Impact
  • Business users have the autonomy to create custom dashboards and reports.
  • The time to get new data insights has been dramatically reduced.
  • Lightning-fast query response times mean answers to key strategic questions are available faster.
  • The database team can focus on crucial tasks without spending hours writing and running SQL queries.
Quantitative Benefit
  • WeFi’s tools have identified over 75,000,000 access points around the world.
  • The database team deals with an average table size of more than 5 million rows for behavioral data.
  • The database team deals with over 500 million rows for activity records of some of the most active clients.

Case Study missing?

Start adding your own!

Register with your work email and create a new case study profile for your business.

Add New Record

Related Case Studies.

Contact us

Let's talk!
* Required
* Required
* Required
* Invalid email address
By submitting this form, you agree that IoT ONE may contact you with insights and marketing messaging.
No thanks, I don't want to receive any marketing emails from IoT ONE.
Submit

Thank you for your message!
We will contact you soon.