KPI Dashboard
20 USDСоздание таблицы KPI из Excel
| KPI | Explaination |
| Available Capacity per Employee per Month | A diagram showing the available capacity of each employee for every month of 2024. Additionally be able to see the available capacity by filtering by the Priority (see the availability if we only filter by Prio 1, Prio 1+2, Prio 1,2+3, etc.) |
| Planned effort per cost type | A diagram showing the effort in man-days for each cost type with a montly and yearly view for each employee and for the whole team consolidated. |
| Allocated costs per cost type | A diagram showing the monthly and yearly costs per cost type based on the salaries Tab |
| Allocated costs per cost type for each entity | A diagramm showing the montly and yearly costs per cost type for each entity based on the ILV percentage in tab salaries |
| Allocated costs per project | A diagramm showing the allocated costs per project based on the Salaries of the involved employees |
| Allocated costs per project for each entity | A diagramm showing the allocated costs per project assigned to a specific business unit |
Applications 1
Current freelance projects in the category Databases & SQL
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 ∙ 3 days 9 hours 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 ∙ 3 days 12 hours back ∙ 19 proposals |
1C data integration
Organize quality preparation and data transfer from 1C to BigQuery for further use in Looker:Organize the data according to the required fields.Prepare a clear structure of tables and intermediate datasets on which dashboards will be built.Set up data loading, gather key… Databases & SQL, Data Processing ∙ 5 days 3 hours back ∙ 9 proposals |
Development of a simple controlling and management record system in Google Sheets "turnkey"
Task name: Development of a simple controlling and management record system in Google Sheets "turnkey" for a construction company in Poland (+ online training and implementation assistance) About the company, context, and my main problem Hello, I am looking for an experienced… Databases & SQL, Accounting Services ∙ 6 days 8 hours back ∙ 36 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 ∙ 6 days 12 hours back ∙ 13 proposals |
Switzerland