Databases & SQL
70-
875 USD Setting up Looker Studio and Porter
Databases & SQLList of tasks:
— Creating a Porter account;
— Filtering created metrics to display necessary information;
… — Integrating Looker Studio and Porter;
— Combining filtered metrics to calculate conversion rates for corresponding data sources;
— Searching for a report template for the client's needs;
— Importing the report template from Porter to Looker Studio;
— Integrating Facebook and Instagram accounts;
— Integrating with Google Spreadsheets;
— Setting up the imported template with connected data sources.
-
Krud Restaurant
Databases & SQLCRUD Functionality: Ability to add, view, update, and delete product information.
Adaptation: Full adaptation of the website from 1920px to 360px for optimal display on mobile devices.
Delivery and Menu Page: Display of product selection from the database, showcasing all products and categories.
Shopping Cart: Functions to add, view, update, and delete products from the cart.
… Checkout: Form for checkout that adds order information to the database.
API: Integration of an API to display the restaurant's location using data from OpenStreetMap.
-
23 USD Revenue Metrics
Databases & SQLThis project involves the creation of an informational dashboard for tracking and analyzing key revenue indicators. The dashboard contains five charts highlighting new paying users, revenue (MRR), the number of users who have unsubscribed (Churned Users), and indicators of revenue expansion and contraction. Interactive filters for user language and age allow for a more detailed analysis of revenue dynamics over different periods.
The analysis included studying the number of new paying users, the level of monthly recurring revenue (MRR), user churn dynamics (Churned Users), and the impact of expansions and contractions on revenue. Key findings showed an increase in new paying users in the middle of the year, which positively affected MRR. However, at the end of the year, there was an increase in user churn, which reduced overall revenue. A significant impact of revenue expansions in certain months was also found, which compensated for losses from contractions. This information will help product managers make strategic decisions regarding user retention and revenue growth.
-
Contact Center as a Business Solution
Databases & SQL#HTMl #adaptive #cross-browser #javascript #CSS #cms_opencart #Photoshop #figma #Illustrator #PHP #react.js #node.js #next.js #ReactNative #typescipt #docker #MaterialUI #Web-designe #web design #UI design #web development #web site
The basic structure was created using top-class technologies and tools, including Typescript, PostgreSQL, React.js, Asterisk, WebRTC, Material-ui, Docker.
The system can be bound by a material design interface, video twins platforms similar to Google Meet, and complex work with different databases, among other features.
-
Sales details by customer
Databases & SQLDetails by Customer
-
Sales details for retail company
Databases & SQLSales details
-
The SQL Task
Databases & SQLRequest and Functions in T-SQL Language
-
Computer Shop
Databases & SQLThe program is written on order in the Delphi environment for coursework. Details on GitHub.
-
API GA4 - Google Bigquery - Data Studio
Databases & SQLScreenshot to download data from Google Analytics 4 (API, not direct download) , export to Google Bigquery, visualization to Google Data Studio (screen illustrative)
-
11 USD Certification for medical facilities in Ukraine
Databases & SQLCalculation of tariffs for medical facilities. Written on Lazarus/FreePascal, BD SQLite3, cross-platform (Windows/Linux). Detailed information on the site by link.
If necessary, I provide a demo version that has restrictions on the printing of documents (in the full version the restriction is not available).