Sisense Case Studies Wefi

Edit This Case Study Record

	Wefi Sisense

Wefi

Sisense

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
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. Read More
About 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. Read More
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. Read More Log in to view content
Contents

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

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.

About 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.

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.

Impact #1	Business users have the autonomy to create custom dashboards and reports.
Impact #2	The time to get new data insights has been dramatically reduced.
Impact #3	Lightning-fast query response times mean answers to key strategic questions are available faster.

Impact #1

Business users have the autonomy to create custom dashboards and reports.

Impact #2

The time to get new data insights has been dramatically reduced.

Impact #3

Lightning-fast query response times mean answers to key strategic questions are available faster.

Benefit #1	WeFi’s tools have identified over 75,000,000 access points around the world.
Benefit #2	The database team deals with an average table size of more than 5 million rows for behavioral data.
Benefit #3	The database team deals with over 500 million rows for activity records of some of the most active clients.

Benefit #1

WeFi’s tools have identified over 75,000,000 access points around the world.

Benefit #2

The database team deals with an average table size of more than 5 million rows for behavioral data.

Benefit #3

The database team deals with over 500 million rows for activity records of some of the most active clients.

Download PDF Version

Overview

Wefi

Operational Impact

Quantitative Benefit