Power BI QuickBooks Data Integration & Data Model Help

Job ID: 39656335

Budget: $8 – $15 USD

I am seeking an experienced professional to assist me in connecting QuickBooks data to Power BI using either CData Software or a Custom API. Although I have managed to connect using the CData Software Connector, I am struggling with understanding the table relationships, identifying relevant tables, and writing queries necessary to extract key performance indicators (KPIs) such as Top Customers, Revenue, Balance Sheet, and Profit & Loss.

Key Requirements:
- Expertise in QuickBooks data extraction using CData Software or Custom API
- Ability to create a proper connection and set up a data model in Power BI
- Experience in identifying and understanding table relationships and relevant tables
- Proficiency in writing queries to extract necessary KPIs

Ideal Skills and Experience:
- Proven track record of working with QuickBooks data integration in Power BI
- Strong understanding of data modeling and KPI extraction
- Experience with CData Software Connector and/or Custom API Access
- Ability to provide guidance and support in setting up a robust data model

I do not require complete dashboard development, only assistance in creating the proper connection and setting up the data model to obtain the required KPIs. Your expertise in this area will be invaluable in helping me achieve my goals.