CUSTOMER
The Customer is a leading market research company.
CHALLENGE
Though having a robust analytical system, the Customer believed that it would not be able to satisfy the company’s future needs. Acknowledging this situation, the Customer was keeping their eyes open for a future-focused innovative solution. A system-to-be was to cope with the continuously growing amount of data, to analyze big data faster and enable comprehensive advertising channel analysis.
After deciding on the system’s-to-be architecture, the Customer was searching for a highly qualified and experienced team to implement the project. Satisfied with a long-lasting cooperation with ScienceSoft, the Customer addressed our consultants to do the entire migration from the old analytical system to a new one.
SOLUTION
During the project, the Customer’s business intelligence architects were cooperating closely with ScienceSoft’s big data team. The former designed an idea, and the latter was responsible for its implementation.
For the new analytical system, the Customer’s architects selected the following frameworks:
Amazon Web Services and Microsoft Azure were selected as cloud computing platforms.
Upon the Customer’s request, during the migration, the old system and the new one were operating in parallel.
Overall, the solution included five main modules:
Data preparation
The system has been supplied with raw data taken from multiple sources, such as TV views, mobile devices browsing history, website visits data and surveys. To enable the system to process more than 1,000 different types of raw data (archives, XLS, TXT, etc.), data preparation included the following stages coded in Python:
Staging
Apache Hive formed the core of that module. At that stage, data structure was similar to raw data structure and had no established connections between respondents from different sources, for example, TV and internet.
Data warehouse 1
Similar to the previous block, that one also based on Apache Hive. There, data mapping took place. For example, the system processed the respondents’ data for radio, TV, internet and newspaper sources and linked users’ ID from different data sources according to the mapping rules. ETL for that block was written in Python.
Data warehouse 2
With Apache Hive and Spark as a core, the block guaranteed data processing on the fly according to the business logic: it calculated sums, averages, probabilities, etc. Spark’s DataFrames were used to process SQL queries from the desktop app. ETL was coded in Scala. Besides, Spark allowed filtering query results according to access rights granted to the system’s users.
Desktop application
The new system enabled a cross analysis of almost 30,000 attributes and built intersection matrices allowing multi-angled data analytics for different markets. In addition to standard reports, such as Reach Pattern, Reach Ranking, Time Spent, Share of Time, etc., the Customer was able to create ad hoc reports. After the Customer selected several parameters of interest (for example, a particular TV channel, group of customers, time of day), the system returned a quick reply in the form of easy-to-understand charts. The Customer could also benefit from forecasting. For example, based on expected reach and planned advertising budget, the system would forecast the revenue.
RESULTS
At the project closing stage, the new system was able to process several queries up to 100 times faster than the outdated solution. With the valuable insights that the analysis of almost 30,000 attributes brought, the Customer was able to carry out comprehensive advertising channel analysis for different markets.
TECHNOLOGIES AND TOOLS
Apache Hadoop, Apache Hive, Apache Spark, Python (ETL), Scala (Spark, ETL), SQL (ETL), Amazon Web Services (Cloud storage), Microsoft Azure (Cloud storage), .NET (desktop application).
muadotho
cesirc@gmail.com
man city purple shirt for cheap cowboys jersey 82 new york yankees fitted hats cheap gasjordan jumpman bucket cap kitrealtree camouflage atlanta braves hat meaninglos angeles dodgers script hat zions ladies air max 97 blacknike flyknit roshe wolf gris sequoiaadidas nmd black gold for cheapadidas nmd black gray for cheap ray ban 2180 polarizedray ban rb2184holbrook prizm polarized lensesray ban aviator silver
muadotho http://www.muadotho.com/
zinitgroup
uaofxdba@gmail.com
nike kd 7 rougenike shox for kids cheapbest asics for supination noirnike lunar tr1 nero verde man utd human race shortslebron association jerseydallas cowboys prochicago bears alternate uniforms pandora circle stud earrings knit newsboy hat pattern baby youtube jordan 12 retro white black taxiadidas gazelle indoor noir and orange3m x nike tn air max plus enigma stonered black and white jordan 1 semi formal teenage girlpink short dressescasual dress attiremetallic silver bridesmaid dresses
zinitgroup http://www.zinitgroup.net/
latzinsurance
vsjdkkwvwgt@gmail.com
adidas campus vegan
latzinsurance http://www.latzinsurance.net/
transorgs
ssvxobbfrhe@gmail.com
white puffer jacket monclermoncler the real realmoncler coatyellow moncler coat cincinnati reds adjustable hat company green black womens asics gel hyper 33 oakley frogskins rossirb4165 justin classicoakley sweep lensesoakley portal x deep water adidas y3 sort and redadidas samba navy bluenike 270 airmizuno wave phantom 2 volleyball air jordan 1 nero toe legit checkshox tl nova 2 sneaker in whiteadidas gazelle chaussures blancstussy nike shox blanc
transorgs http://www.transorgs.com/
tecnomagzne
fvgtctmxjts@gmail.com
liverpool kits every year for cheap new fancy clothes mk signature purse red adidas sst track pants colin kaepernick 49ers jersey patent bred
tecnomagzne http://www.tecnomagzne.com/