https://store-images.s-microsoft.com/image/apps.58401.5a642089-48ec-454b-96c4-bf879eacace4.e1424d05-7a08-466a-a347-acba69a22260.95a55585-2eb1-4e5c-8a89-6f7bbc8a136f

PowerBI & QuickBooks Desktop: 2-wk Implementation

GadellNet Consulting Services LLC

Rapid deployment of a Power BI solution for QuickBooks Desktop. This includes the data model, visualization and Excel connectivity.

This solution provides an out-of-the-box data warehouse and Power BI reports including Profit and Loss, Balance Sheet, Statement of Cash Flows, Trial Balance, General Ledger, Job analytics and more. Requires 3rd party license. Please inquire with GadellNet for more information.

AGENDA

Planning (Week 1)

  • Discovery of Accounting practices
  • QuickBooks environment review
  • Requirements documentation
  • Configure QuickBooks access
  • Install Data Gateway
  • Acquire assets for report development

Implementation (Week 2)

  • Produce .pbix files
  • Publish to Power BI service
  • Configure scheduled data refresh
  • Configure Excel connection
  • 2-hour structured training
  • Documentation

DELIVERABLES

  • Standard Profit and Loss, as well as Budget vs Actual by category for current, YTD and YOY comparisons.
  • Standard Balance Sheet with additional metrics including Working Capital, Current Ratio and more.
  • Trial Balance report including current vs last period trends, as well as a detail level tabular visual containing Beginning and Ending Balance.
  • Accounts Receivable by Customer and Job, category and standard aging buckets (Current, 30, 60, 90).
  • Data warehouse provides raw detail for custom analytics based on customer requirements.
  • Most statements can be produced by Class.
Hiter pregled
https://store-images.s-microsoft.com/image/apps.9748.5a642089-48ec-454b-96c4-bf879eacace4.e1424d05-7a08-466a-a347-acba69a22260.74f4bfd0-9065-4326-84ea-71ffbfe1ac90
https://store-images.s-microsoft.com/image/apps.5671.5a642089-48ec-454b-96c4-bf879eacace4.e1424d05-7a08-466a-a347-acba69a22260.671b4d19-0d2b-4b8e-b716-dd7814c42a64
https://store-images.s-microsoft.com/image/apps.15337.5a642089-48ec-454b-96c4-bf879eacace4.e1424d05-7a08-466a-a347-acba69a22260.ef1b74be-6a01-49d4-8521-80fda47bc0b4
https://store-images.s-microsoft.com/image/apps.47552.5a642089-48ec-454b-96c4-bf879eacace4.e1424d05-7a08-466a-a347-acba69a22260.c509df94-d2a7-49ad-bda2-0d8f14ee9f41
https://store-images.s-microsoft.com/image/apps.4209.5a642089-48ec-454b-96c4-bf879eacace4.e1424d05-7a08-466a-a347-acba69a22260.a5877fe6-f748-4068-8eb7-02dcc84808df

Druge storitve za svetovanje ponudnika GadellNet Consulting Services LLC