We've got 2x projects:
-- Project 1 --
We've built two business reports:
1) Total Sales Report (with an excel data model) x 2 (monthly version and weekly)
2) Sales Report (with an excel data model)
Both of these reports pull database data from CSV that is downloaded out of our POS system.
1) Move these management reports into PowerBI (including data models)
2) Database data from CSV remains, but loaded into Access. Want to keep history of this data in one place, and PowerBI to link and can be run for any period.
1) Style Sheet template attached loads into an Access Database
1) Additional fields to be added to the Style Sheet (see tab 2) to accommodate for ecomm fields
2) These fields are loaded into the Access Database
3) Access Database requires updates to accommodate and cleaner coding, including automatic structure testing/repairs
4) Database exports files (CSV, XLSX), also requiring to be updated
To win the projects:
1) Lowest bid
2) Move these models into PowerBI and show me useful info
3) Payment upon completion
4) ONGOING work may come out of it if you impress us
15 pekerja bebas membida secara purata $508 untuk pekerjaan ini
i have good experience in building dynamic access projects, where end user can easily minimal effort to get the output. expert in access VBA + power bi reporting tool.