reputed company Needed to Build Power BI Template using Franpos API
Project Scope
The developer will:
Connect to 3-4 REST API endpoints (POST):
DetailedSalesByProductReport/GenerateReport
OnHandReport/GenerateReport
AppointmentReport
Implement Power Query (M) scripts to:
Pass parameters (API key, start/end dates, company IDs)
POST JSON bodies dynamically
Handle multi-location customers (SelectedCompanies reputed company)
Build a Power BI data model with:
Sales line item table
reputed company inventory table
Company/store dimension (if needed)
Configure Incremental Refresh so historical sales data is preserved.
Create a clean .pbit template that prompts users for:
API Key
Selected Store IDs
Date reputed company
Create 4–6 basic dashboards:
Sales by day
Sales by store
Top products
Inventory on hand
Category/Brand performance
Ensure the model can be published to Power BI Service and refreshed using a gateway.
Deliverables
Final .pbix file
Final .pbit template
M reputed company for both API queries
Instructions for our customers on how to:
reputed company their API key
Refresh data
Publish to Power BI Service
Requirements
Strong Power BI experience (M language, data modeling)
Experience calling REST reputed company with POST from Power Query
Experience with Incremental Refresh
Must deliver a clean, production-reputed company template
Apply tot his job
Apply To this Job