Page 50 - PinnacleCustomerMagazineWinter2017

Better analysis and

greater insight with

Pinnacle Data Analytics

With this in mind, we developed Pinnacle Data Analytics, which powered by Microsoft SQL
and utilising Excel macros and pivot table technology such as slicers and timelines, looks
directly at your Sage data to answer questions in real time.

All data fields within Sage 200 are available, working across multiple companies providing
consolidation functionality, Pinnacle Data Analytics provides powerful drill down analysis to
the underlying data. We’ve developed two packs of predefined standard reports, but there
is also the ability to add your own customised reports. The standard reports include:

Pinnacle Data Analytics Financials Pinnacle Data Analytics Commercials

• Profit and Loss reporting • Sales Order Profitability Report
• Balance Sheet reporting • Sales Order Per Period
• Trial Balance reporting • Frequently Sold
• MTD Balances
• Nominal Account Listings • Sales Monthly Analysis Figures
• This Years Journals • Slow Moving Stock Report / Stock
• Sales Turnover • Predictions
• Outstanding Debt • Fast Moving Stock Items
• Average Days To Pay • Transaction History
• SL Contacts • Stock Item Balances
• Purchase Turnover • Return Rate
• Outstanding Debt • Purchase Order History
• PL Contacts • Purchase Monthly Analysis Figures
• Cash Book Statement History • POP Accruals
• Roles and Features
• Feature Access Log

Pinnacle News & Views 50