Data is everywhere
Let's look at what I can do for your company
Analyzing borrowers’ risk of defaulting
#FINANCE #PYTHON #JUPYTER #NLTK #PANDAS #MATPLOTLIB #DATA PREPROCESSING
I'm an analyst tasked with preparing a report for a bank’s loan division. I’ll need to find out if a customer’s marital status and number of children has an impact on whether they will default on a loan. This report will be considered when building a credit scoring of a potential customer.
Research on car sales ads
#MARKETING #PYTHON #JUPYTER #NUMPY #PANDAS #MATPLOTLIB #DATA PREPROCESSING
I'm an analyst at the imaginary company, Crankshaft List. Hundreds of free advertisements for vehicles are published on their site every day. I need to study data collected over the last few years and determine which factors influence the price of a vehicle.
Research on phone plan revenues
#MARKETING #PYTHON #JUPYTER #NUMPY #PANDAS #MATPLOTLIB #SCIPY #DATA PREPROCESSING #VISUALIZATION #HYPOTHESIS TESTING
I work as an analyst for the telecom operator Megaline. The company offers its clients two prepaid plans, Surf and Ultimate. The commercial department wants to know which of the plans brings in more revenue in order to adjust the advertising budget.
Video game market research
#MARKETING #PYTHON #JUPYTER #NUMPY #PANDAS #MATPLOTLIB #SCIPY #DATA PREPROCESSING #VISUALIZATION #HYPOTHESIS TESTING
I work for the online store Ice, which sells video games all over the world. User and expert reviews, genres, platforms (e.g. Xbox or PlayStation), and historical data on game sales are available from open sources. I need to identify patterns that determine whether a game succeeds or not. This will allow us to spot potential big winners and plan advertising campaigns.
Data analysis for a ride-sharing company
#MARKETING #PYTHON #JUPYTER #NUMPY #PANDAS #MATPLOTLIB #SCIPY #DATA PREPROCESSING #VISUALIZATION #HYPOTHESIS TESTING
I'm working as an analyst for Zuber, a new ride-sharing company that's launching in Chicago. My task is to find patterns in the available information. I want to understand passenger preferences and the impact of external factors on rides. I'll study a database, analyze data from competitors, and test a hypothesis about the impact of weather on ride frequency.
Marketing analytics for a large e-commerce shop
#E-COMMERCE #PYTHON #JUPYTER #NUMPY #PANDAS #MATPLOTLIB #SEABORN #VISUALIZATION #COHORT ANALYSIS #LTV #CAC #ROMI
I've been offered an internship in the analytical department of a large e-commerce store. My first task is to help optimize marketing expenses using server logs from June 2017 to May 2018, a dump file with all orders for the time period, and marketing expense statistics.
Making business decisions based on data
#E-COMMERCE #PYTHON #JUPYTER #NUMPY #PANDAS #MATPLOTLIB #SCIPY #VISUALIZATION #A/B TESTING #HYPOTHESIS TESTING
I'm an analyst at a big online store. Together with the marketing department, I've compiled a list of hypotheses that may help boost revenue. I need to prioritize these hypotheses, launch an A/B test, and analyze the results.
How to tell a story using data
#MARKET RESEARCH #PYTHON #JUPYTER #PANDAS #MATPLOTLIB #SEABORN #PLOTLY #REGEX #DATA PREPROCESSING #VISUALIZATION
I’ve decided to open a small robot-run cafe in Los Ageles. The project is promising but expensive, so my partners and I decided to try to attract investors. They’re interested in the current market conditions. My partners have asked me to prepare a market research report.
Event-based analytics
#MARKETING #CRO #PYTHON #JUPYTER #PANDAS #SEABORN #PLOTLY #SCIPY #VISUALIZATION #A/B TESTING #HYPOTHESIS TESTING
I work at a startup that sells food products. I need to investigate user behavior for the company's app. First, I need to study the sales funnel and find out how users reach the purchase stage.
Trending videos over time with Tableau
#BUSINESS INTELLIGENCE #TABLEAU #VISUALIZATION #DASHBOARDS
This Tableau dashboard takes data on trending videos, their categories, countries of origin, and dates and creates useful visualizations such as percentage of trending videos by category, a pie chart of trending videos by region, and a table showing countries and their most popular categories.
Predicting churn for a gym using machine learning
#BUSINESS INTELLIGENCE #MACHINE LEARNING #PYTHON #JUPYTER #PANDAS #SEABORN #PLOTLY #SKLEARN #SCIPY #EDA #VISUALIZATION
The gym chain Model Fitness is developing a customer interaction strategy based on analytical data. One of the most common problems gyms and other services face is customer churn. In order to fight churn, Model Fitness has digitized a number of its customer profiles. My task is to analyze them and come up with a customer retention strategy.
Assessing sales outlets' performance
#MARKETING #PYTHON #JUPYTER #PANDAS #NUMPY #SEABORN #SCIPY #DATA PREPROCESSING #EDA #VISUALIZATION #HYPOTHESIS TESING
Our goal is to identify the high-performing sales outlets through data analysis. We'll identify which stores bring in the most revenue and look at whether or not the customer loyalty program has any correlation with increased sales.
Writing complex SQL queries in Python
#MARKET RESEARCH #PYTHON #SQL #JUPYTER #PANDAS #SQLALCHEMY #DATA RETRIEVAL
I've been given a database of one of the services competing in the book app market. It contains data on books, publishers, authors, and customer ratings and reviews of books. I need to use SQL to grab data from the database and generate a value proposition for a new product.
A/B Testing for an online store
E-COMMERCE #PYTHON #JUPYTER #PANDAS #NUMPY #SEABORN #PLOTLY #SCIPY #EDA #VISUALIZATION #A/B TESTING #HYPOTHESIS TESTING
I've received an analytical task from an international online store. My predecessor failed to complete it - they launched an A/B test and then quit. They left only the technical specifications and the test results. I need to download the test data, see whether it was carried out correctly, and analyze the results.