2 Code Interpreter + ChatGPT. Как анализировать маркетинговые данные

1.

Code Interpreter/
Advanced Data Analysis
как легко и просто анализировать
данные
АЛЕКСЕЙ ЧЕРНЯК

2.

Доступ к Code Interpreter и 2 кейса
1. Анализ продаж интернет-магазина
1. Анализ стартапов, получивших
инвестиции за неделю (Crunchbase)
https://chat.openai.com/?model=gpt-4-code-interpreter

3.

Кейс 1. Анализ продаж интернет-магазина
These are supermarket sales transactions
I am the manager of this shop. Make me 10 useful
graphs for strategic decision making
Here's a breakdown of the graphs we will create:
Total Sales by Branch: Comparison of total sales across branches.
Sales Trend Over Time: Monthly sales trend to identify seasonal patterns.
Top 5 Product Lines by Sales: Analysis of best-performing product categories.
Payment Method Distribution: Breakdown of payment methods used.
Customer Type Analysis: Sales comparison between Members and Normal customers.
Gender-Based Sales Analysis: Comparison of sales by gender.
Hourly Sales Distribution: Analysis of sales by hour to identify peak times.
Rating Distribution: Understanding customer satisfaction through ratings.
Gross Income by Product Line: Analysis of gross income by product categories.
Quantity Sold by Product Line: Analysis of the quantity of products sold in different
categories.
https://www.kaggle.com/datasets/aungpyaeap/supermarket-sales
https://drive.google.com/drive/folders/1Lzmco08GY-m-q80r0YUd7O68Ije9DBjC?usp=drive_link

4.

Кейс 2. Анализ стартапов, привлекших инвестиции за
эту неделю. Данные из Crunchbase
I'm an entrepreneur. The challenge is to find an idea for the next big
project to launch. Make me 10 useful charts for making strategic
decisions, finding business trends and areas that are growing strongest
Certainly! As an entrepreneur interested in identifying the next big project, it's essential to analyze various
aspects of the market, including industry trends, investment patterns, geographical preferences, and
technological advancements.
Based on the data provided earlier, I'll create the following 10 charts to help you make strategic decisions:
Funding Distribution by Industry: Analyze the top sectors receiving investments.
Funding Types Distribution: Understand the different stages of funding (Seed, Series A, etc.).
Top 10 Locations for AI Startups: Identify regions that are leading in AI innovation.
Funding Trend Over Time: See how investments in AI have changed over time (if time data is available).
Funding Distribution by AI Subdomain: Break down investments into specific AI subdomains (e.g., NLP,
Computer Vision).
Top Investors in AI Startups: Recognize key players investing in AI (if investor data is available).
AI Startup Size Distribution: Analyze the company size in terms of employees or revenue.
Correlation Between Funding and IP (Patents/Trademarks): Understand the relationship between
innovation and funding.
Technology Stack Used in AI Startups: Explore commonly used technologies and platforms.
Market Cap Growth of Top AI Startups: Investigate the growth of top-performing AI companies (if market
cap data is available).
https://drive.google.com/drive/folders/1Lzmco08GY-m-q80r0YUd7O68Ije9DBjC?usp=drive_link

5.

Источники данных россыпью для тренировки
1. Яндекс.Метрика/GA
2. Поиск по Datasets
https://datasetsearch.research.google.com/
3. Данные для соревнований Kaggle
https://www.kaggle.com/datasets
4. Датасеты https://paperswithcode.com/datasets
5. Структура затрат американцев по основным категориям
товаров и услуг за год
https://fred.stlouisfed.org/release/tables?eid=44183&rid=53
6. Структура затарт времени американцев
https://www.bls.gov/news.release/atus.t01.htm
7. Росстат и ЦБ
https://www.cbr.ru/statistics/macro_itm/households/