Data Processing
55-
100 USD Automation of seller reports from Amazon Seller Central
Data ProcessingAutomation of any reports that are on https://sellercentral.amazon.com/ or that are provided by the API.
-
400 USD Dashboard
Data Processing#DashBoards #UIUXdesign #websites #analytics
-
Google spreadsheet with analysis of weather temperature indicators
Data ProcessingTemperature map for the convenience of analyzing weather indicators by days and hours.
-
Web analytics
Data ProcessingIn-depth competitor analysis: I research traffic, acquisition sources, user behavior, and key performance indicators. I identify strengths and weaknesses so you can make informed strategic decisions.
-
Competitor analysis and web analytics
Data ProcessingI conduct a comprehensive analysis: overall market overview, search traffic, SEO metrics, and social media activity. I identify the strengths and weaknesses of competitors, helping to find opportunities for growth and improving the efficiency of your business.
-
Competitor analysis and web analytics
Data ProcessingComprehensive research of the market, competitors, and user behavior. I identify growth points, optimize strategy, and help businesses make data-driven decisions.
-
Business plan: "Production".
Data ProcessingBusiness plan: "Production". Fragment of the financial model.
-
45 USD Python Script Working with Google Sheets (Data Processing)
Data ProcessingA "Python-Script" was set up that connected to a Google spreadsheet using Google Console. In the Google Spreadsheet, there are two sheets: No. 1 with the processing results, No. 2 with processing settings:
In the second sheet, column A - Variations of product colors, the priority color is the first in the list, the list is built from 1 to n.
In the second sheet, column B - Variations of product Brands.
In the second sheet, column C - The products themselves that need to be split. The subsequent columns in the second sheet are responsible for - Availability / Price / Warranty / Model / Category.
-
Analysis of SaaS company revenue
Data Processing#analysis #product #analytics #visualization #data #Tableau
Full project description: https://github.com/valenthr/SaaS_revenue_analysis
Tools and skills: Tableau and product analytics.
Essence: analysis of product revenue by date and location.
… Brief job description:
1. Analyzed data on the revenue of the SaaS company for the year.
2. Customer behavior patterns were identified using cohort analysis.
3. Problem areas in the customer journey were identified that significantly reduced customer retention.
-
Data Entry/Typing Job
Data ProcessingOne of my skills is Data Entry. Process of manually inputting information into a computer system. (Excel, Spreadsheet, Converting files, Organizing files)
-
11 USD Excel Create a pivot table
Data Processing1. Create a pivot table on a separate sheet. Display data (average price and total quantity) by city-category-product, add the remaining fields to the filter.
2. Combine the categories butter and oil into one category "Fats", hide the field "Sweets".
3. Create a calculated field "Total Sales" = price * quantity.
4. Add a field with the standard deviation of price.
… 5. Create a separate pivot table by region with the total sales indicator.
6. Pull the total sales for the corresponding region from the pivot table to the data table (column I) using a formula.
-
Template for the order cost calculator table and their accounting
Data ProcessingConsists of two sheets:
1. Sheet "Guides"
In this sheet, variables that affect the cost of the order (for example, printing on t-shirts) will be entered.
Also, data about your customers should be entered here.
…
2. Sheet "Orders"
To calculate the cost of orders, you need to select the required values in the corresponding cells (only the green-colored columns should be filled in, the others will be filled in automatically).
Filters for displaying summary data by any criteria have already been added in the first row.
Video instruction with step-by-step slides - at the link