Ivan Koliadko
Offer Ivan work on your next project.
Private message
Offer work
Rovno,
Ukraine
6 hours 38 minutes back
available for hire
on the service 2 days 6 hours
Rating
Successful projects
Average rating
Language proficiency level
Українська: fluent
English: elementary
Skills and abilities
Programming
Services
Promotion
Portfolio
-
Sales and Revenue Dashboard in Looker Studio
Data Processing
Educational analytical project created within the Data Analytics course.
Task: prepare an interactive dashboard for sales and revenue analysis.
… What has been done:
• connected data from PostgreSQL;
• created key indicators: total revenue, number of orders, unique customers, products, and sales cities;
• added filters by date, sales channel, payment method and status, and customer status;
• built a revenue dynamics chart;
• created a sales map, product table, and customer segments chart.
Tools: Looker Studio, PostgreSQL, SQL.
Result: one interactive report for a quick overview of key sales indicators.
#LookerStudio #DataAnalytics #Dashboard #PostgreSQL #SQL