Analyze and monitor your SALES, PURCHASES, GENERAL LEDGER, INVENTORY data collected with Microsoft Dynamics NAV or AX

Columbus LT Built-In Power BI Reports helps to analyze and monitor data collected with Microsoft Dynamics NAV or AX. Designed to be easy to use and manage, they are built on Microsoft SQL Server, to provide you with the necessary analytical, data mining, and reporting capabilities. With 19 ready to use reports we offer our best-practice to help you explore data in main business areas: sales, purchases, general ledger and inventory.

Sales: sales reports help to track sales, compare it with last year situation, analyze sales persons results or monitor unpaid customers amounts. For your business insights we offer these reports: Sales analysis, Comparative sales analysis, Customer/Sales Person/Product statics, Sales returns, Customer debts (current and to date).

Purchases: purchases reports help to take decisions related to long-term relationship with vendors and helps to increase negotiation power. For your business insights we offer these reports: Purchase analysis, Comparative purchase analysis, Vendor/Product statics, Purchase returns, Debts to vendors (current and to date).

General Ledger: financial reports help to follow balance between income and expenses, compare financial results quarterly or track budget fulfillment. For your business insights we offer these reports: General ledger analysis, GL comparing to last year, Budget vs. Fact.

Inventory: inventory reports help to keep optimal stock level and inventory turns. For your business insights we offer these reports: Product expiration, Inventory in stock, Inventory aging, Inventory turnover.

 

 

Accessing Columbus LT Power BI solution through Power BI

Follow these easy steps to add the Columbus LT Power BI solution app to your Power BI account:

  1. Log in to Power BI at https://app.powerbi.com/groups/me/apps
  2. Click the “Apps” tab on the left, and click the yellow “Get Apps” button

  3. Search for “Columbus”, and select the “Apps” results tab.  When you see the Columbus LT Power BI solution listing, click the “Get It Now” button
  4. You’ll then see a popup to enter login information:

    Data scource link: http://powerbiapp.columbus.lt:8008/odata/v0.1
    User: Columbus
    Password: Demo


Columbus LT Power BI solution Content Pack uses demo data. If you are interested to integrate our solution with your company data collected with Microsoft Dynamics NAV or AX, please contact Edgaras Bencevičius mob.: +370 610 25 924, e-mail: edgaras.bencevicius@columbusglobal.com