Teams Collaboration

Business Intelligence (BI) tools and their use with Microsoft Dynamics GP

For my final post in this series, I’m going to look at one of my favorite Dynamics GP Business Intelligence and financial reporting tools. Solver’s BI360 software is an Excel and Web-based Business Intelligence Suite. BI360 integrates with many major ERPs right out of the box via a real-time connection. These include the following:

  • Microsoft Dynamics AX, GP, NAV, SL, C5 and MS CRM
  • Sage MAS 500, Sage X3
  • Prophet 21
  • SAP Business One
  • Acumatica
  • Intacct
  • NetSuite
  • Salesforce

BI360 Data Warehouse software has pre-built modules (fact tables) for general ledger, payables, accounts receivable, revenue, fixed assets, projects and human resources. Plus they have five custom modules that can be configured by business users. Loading of the data warehouse can be handled by SQL Scripts or SSIS package files and can be managed by Solver, a knowledgeable VAR or your IT staff.

Implementing BI360 One Stop Reporting and Data Warehouse provides the follows benefits:

  • One Stop Reporting
  • Drag and drop report design
  • Excel based reporting with complete excel formula and formatting functionality
  • Live operational connection reporting to all ledgers and sub-ledgers
  • Benchmark, KPI and graphical reporting
  • Drill to general ledger detail and drill across to sub-ledgers
  • Data Warehouse

Drag and drop report design

  • Excel based reporting with complete excel formula and formatting functionality
  • Benchmark, KPI and graphical reporting
  • Consolidation reporting
  • Excel based budgeting and forecasting
  • Modeling and what-if analysis

I know what you’re thinking – “get on with it already and show me what I can do with the product.” Building a report would be a lot for one blog, so I’m just going to provide a screen shot of the income statement that I created with the One Stop Reporting add-on for Excel.

The first image shows what the designer view looks like in One Stop Reporting. The blue arrow on the left is pointing to the report designer area where you would find the fields you will drag to your report. The black arrow points to where you drop our fields in the spreadsheet. In this case, you would drop accounts from the chart of account on the rows, their description and the mount value for that account. You would then drag the period function above the values in columns D and E, so when you run the report, you can do it for a user definable time frame. Then add Excel formulas for the variances and conditional formatting to column F. Excel charts where the adding for the major Income Statement categories.

The results look like this:

I’ve had fun with this BI blog series and I hope you did too. If you would like help with implementing Solver’s BI360 or just want to see a demo, please contact sales@ktlsolutions.com

Share this post

Related Posts

KTL Solutions Makes Inc. 5000 List for 2022

Each year, Inc. Magazine comes out with its list of the fastest-growing private companies in the nation. The 2022 list includes 131 Maryland businesses, with 11 of them making the prestigious Top 500. Those 131 MD-based businesses represent $2.7 billion in total revenue and more than 10,500 jobs added.

Read More »