TZ
The task 1.Set a sales forecast for the entire period.Set a trend line and take into account seasonal fluctuations.The task 2.Graphically display data on the volume of sales of the state section on the map.Distinguish the color.Add 2 additional layers to the existing map.(Visualization on layers is arbitrary)
The task 4.Take the initials of the name of a separate field.Select the 2m field first the name, then the first letter of the name.Set the sales amount for each customer.Calculate the number of customers with the name that starts with 'Y' and the total sales amount on them.The task 5.Create a waterfall chart on sales that will display the value of profit.Positive profit to show the shells up, (blue color to show the diagram, green shell), Negative profit to red with the shell down (red diagram, red shell).The task 6.Create a visualization on which you can view variably categories, cities, segments, depending on profits, sales and quantities in the sum, average, minimum and maximum value.All the visualization with calculations must be displayed exclusively on 1 calculation list.The task 7.Make all the first customer orders within a month.Calculate the number of all the first orders in the month, display the data for all 4 years.Give a comment on what this visualization shows.The task 8.Build the dashboard 1. in a single color solution, on which the visualization 6 and 1 will work by switching the parameter.Visualizations should be a filter for other visualizations.It is necessary to add a filter by date with the option of choosing the viewing period.Build Dashboard 2 with a map.Make a clickable transition between two dashboards.
Applications 1
Current freelance projects in the category Databases & SQL
A developer is required for parsing the catalog and automating data import.Detailed technical specifications in the attached document Please indicate the estimated cost and timeline in your response Do you have experience working with parsing large catalogs What possible difficulties or limitations do you see in this task Databases & SQL, Data Parsing ∙ 14 minutes back ∙ 11 proposals |
Need a Power BI specialist to build management reporting based on BAS Accounting CORP
About the CompanyWe are a distributor of international sports brands in Ukraine. Accounting is maintained in BAS Accounting CORP.We are looking for a specialist who can help build a management reporting system for the company's management based on Power BI.Important: we are… Databases & SQL, Accounting Services ∙ 4 days back ∙ 6 proposals |
Technical task: Integration of Telegram chatbot with BAS1. General Description It is necessary to implement the integration of the chatbot with the BAS system for the transfer and recording of data about products (orders). 2. Input Data (sent by the chatbot): Group ID Product name (with product code) Product price 3. Logic of… Enterprise Resource Planning (ERP), Databases & SQL ∙ 4 days 3 hours back ∙ 19 proposals |
Development of an analytical Power BI dashboard
45 USD
This is our request, we need a person who understands Power BI: Screen 1: Strategic Cockpit (Financial Health of the Plant) Goal: To understand in 5 seconds, "where are we losing money and how much?". KPI Tiles (Top Bar): Overall margin (Actual vs Plan) in %. Amount of "lost… Databases & SQL ∙ 7 days 3 hours back ∙ 13 proposals |
Project: Basic Setup of End-to-End Analytics (Analytics Engineer / Data Analyst)
203 USD
About us and current stack: We are a B2C web product. Currently, we have disparate data that needs to be consolidated into a single system for marketing decision-making. Database: PostgreSQL (user data). Payments: Stripe. Web analytics: Google Analytics 4. Traffic sources:… Databases & SQL ∙ 8 days 22 hours back ∙ 10 proposals |
Ukraine