Data Research

Microsoft Power BI has emerged as one of the most powerful tools for business intelligence, offering robust data visualization and analysis capabilities. Whether you are a seasoned data analyst or a business professional with no technical background, at Scalesology we work with Power BI as one of our business intelligence tools to transform raw data into meaningful insights. In this

BUSINESS PROBLEM 
A Dart Sporting company that supports dart leagues was planning for a dart tournament abroad, but they did not have a portal created to sell their tickets. The company wanted a portal that is simple and intuitive for their users, had ticket limits, multi-lingual capabilities, and would only be active for a short amount of time so it

BUSINESS PROBLEM
This 3PL Packing-Distribution Company was reliant on a complicated multi-tabbed spreadsheet for developing estimates.  Due to the proprietary nature of the calculations within the spreadsheet, only a limited number of individuals were able to have access to the spreadsheet causing a bottleneck for getting out estimates to current and potential clients.  In addition, the spreadsheet was freezing due

BUSINESS PROBLEM
This 3PL business needed a way to parse information on a monthly basis from thousands of emails based on keywords defined by the client and header information in order to quickly identify potential partners for the company’s future strategies.

SCALESOLOGY IN ACTION
Scalesology used Python to ingest and parse header, body, and signature information from email messages

BUSINESS PROBLEM
This airline data provider offered the highest quality data to aviation analysts but suffered in delivering a modern-day reporting tool to their clients. Due to the millions of records being processed per request, their web application was slow, costly and antiquated, offering no advanced graphics or enhanced usability features.

SCALESOLOGY IN ACTION
Using a blend of scalable front-end

BUSINESS PROBLEM
A leading bio-tech company sought to establish a robust data mart for their clinical trial data, enabling in-depth analysis. Additionally, they aimed to harness Business Intelligence (BI) tools for enhanced result visualization.

SCALESOLOGY IN ACTION
We integrated clinical trial data from diverse data files into a centralized data mart using a data pipeline built in Microsoft Azure.

BUSINESS PROBLEM
Financial institutions are popular targets for attackers because, as the old saying goes, “That’s where the money is.” This stock brokerage had an internal Security Operations Center (SOC), which used a Security Information Event Management (SIEM) system for the analysts to receive alerts of possible malicious activity and aid in their investigations. SIEM systems can be very expensive,

BUSINESS PROBLEM
This company needed to identify highly probable fraudulent claims in their claims processing system.

SCALESOLOGY IN ACTION
Car insurance claims were analyzed using machine learning algorithms for the following:

  • To predict whether auto parts should be repaired or replaced.
  • To identify links between car parts commonly damaged together and to categorize damages based on vehicle type
  • To