Databases & SQL
70-
113 USD Sales Analysis with Excel
Databases & SQLTo see what and how you are selling will help with the MS Excel database management system.
Send your files and I will do what you will be used to, comfortable and pleasant to work!
#Electronic
Business analyticsExcel
… Enterpriseresourseplanning
-
226 USD Local construction-montage work
Databases & SQLBusiness analytics of the enterprise. Cheap ERP in usual MS Excel format.
the composition of the object;
The network schedule;
- schedule of use of machines and equipment;
… Graphics of employment resources.
It is adapted on the basis of the existing base of the enterprise.
-
Export of Ukr
Databases & SQLC++ Builder, #Firebird, #xml, #ftp
The program forms a xml file with information about the residues of goods in the specified groups and loads it to ftp.
-
GreenLancer Helper
Databases & SQLC++ Builder, MySQL and Parsing
The program allowed to keep the key points of the project in the base by producing a parsing web page, which accelerated the verification of the project performed. It describes the projects that were in operation and the rest of the time spent on them.
-
Mercedes-Benz Vehicles, Techniques and Parts MySQL Database
Databases & SQLA database of cars, techniques and original Mercedes-Benz spare parts in MySQL.
It contains brands: Mercedes-Benz, MAYBACH, Smart, Unimog.
The following types of vehicles are presented: Car, Van, Truck, Bus, MB Trac, Powersystems.
The product contains: BD, drawings, BD scheme, web interface with sql requests, search for VIN (DataCard)
-
Development of an Excel file for inventory accounting
Databases & SQLProject Meta
It is necessary to develop a user-friendly Excel file for managing the inventory of solar equipment.
Currently, one manager will be working with the file, entering purchases, reservations, and sales of goods.
The file should automatically calculate the remaining stock of goods, their cost price, the value of inventory, and the profit from sales.
-
Transfer of the website to WordPress CMS
Databases & SQLLanding page layout according to the design using HTML, CSS, JavaScript, transferring the site to the WordPress CMS, connecting the database management system.
-
Keno game
Databases & SQLThe Keno game I am currently maintaining is, as everyone knows, a game where you bet on how many of the 20 numbers randomly selected out of 80 are correct.
-
E-Mail Campaign Performance Analysis
Databases & SQLAnalyzed engagement metrics (open/click rates, unsubscribe rates, audience analyses), provided actionable recommendations to monetize the campaigns in the future.
#Excel
#analysis
-
Analysis of gaming metrics in Google Sheets
Databases & SQLCalculated key metrics for games: Total Revenue, Paid Users Count, CR to Paid, ARPPU, average/median/minimum/maximum age of paying users.
Built a summary row with Total metrics.
Written analytical conclusions and hypotheses regarding the reasons for differences in user behavior.
Identified possible reasons for low conversion to payers and differences in ARPPU between games.
… Formulated recommendations for improving game monetization.
Tools and approaches: #GoogleSheets, formulas SUMIF, COUNTIF, AVERAGEIF, logical functions, table formatting.
-
124 USD Accounting program for a private logistics company
Databases & SQLPrivate logistics company accounting program
Execution environment C# + SQL Server + Integration with MS Office
-
45 USD ETL pipeline
Databases & SQLMy task was to create an ETL process that loads data from a .CSV file, transforms and cleans it, loads it into a PostgreSQL database, and several SQL queries for analysis. Also, for convenience, the cleaned data is stored in a .CSV.