Descriptive analysis

Case


Each company tries to identify peculiar properties of clients behavior, to define patterns, trends. Based on the knowledge the company can draw up key features of a typical client for future marketing campaigns and assess its strengths and weaknesses.
The project goal was to identify a typical client of the company and patterns of client’s behavior.

Solution


Analysis was performed using Python, necessary aggregations of the data was made in Oracle RDBMS. As a result couple of recommendations for the company were represented concerning the future work with clients, necessary database architecture improvement for the analysis in future, recommendations concerning the establishing of steady relationships with clients and drawbacks elimination .

Challenges


Plenty of data from different databases to analyze
Harsh deadline

Project info

Industry
Telecommunication
Case
Identify patterns and trends of clients’ behavior
Technologies
PL/SQL, MySQL, Python
Team
2 DB Developers, 2 Data Analysts
Terms
2 months overall