Table of Contents

COSMO Analytics

COSMO Analytics is a comprehensive yet light-weight standard reporting solution for Microsoft Dynamics 365 Business Central. It is built in a modular way, closely aligned with the most important ERP business processes.

Why COSMO Analytics

  • Out-of-the-box KPIs and reports — start analyzing your Business Central data on day one, no report building required.
  • One consistent data model — a single source of truth replaces scattered Excel files and data silos.
  • Self-service and ad-hoc analysis — explore your data in Power BI and build on top of the semantic models.
  • Multi-company ready — consolidate and compare across companies and clients.
  • Open Microsoft Fabric architecture — extend and adapt the platform to your individual needs.

Modules

COSMO Analytics covers the following process areas, grouped by domain:

Financials

  • Finance — financial statements, GL analytics, and controlling.
  • Cash — liquidity, receivables, and payables analytics.

Sales & Customer

  • Sales — revenue, margins, customer and item performance.
  • Know Your Customer — customer analytics and loyalty.

Supply Chain & Operations

Common functionality

COSMO Analytics ships a set of base functionality that applies to all modules and reports.

Easy-to-understand "Star schema"

COSMO Analytics follows Power BI best practices for data modeling: every module uses the Star schema (Kimball) approach, so the semantic models are optimized for both performance and usability. Analysts can easily find and understand the dimensions (master data and their attributes) as well as the facts (transactions) and the derived measures in the model.

Time Intelligence

COSMO Analytics provides Time Intelligence calculations for all included measures, so you can automatically compute historical values and period comparisons. The following time intelligence calculations are included:

Abbreviation Description
Current Current Value (Value of the selected Time Period)
PY Previous Year
PM Previous Month
ATD ALL To Date (cumulative value since the very beginning)
YTD Year To Date
PY YTD Previous Year To Date
QTD Quarter To Date
MTD Month To Date
YoY Year over Year comparison (abs.)
YoY % Year over Year comparison (rel.)
R12 Rolling 12 Months

Getting started

New to COSMO Analytics? See Getting Started for installation, licensing, and how to connect your Business Central data.


Note

Naming: COSMO Analytics is the product; a concrete offering adds its platform variant (e.g. COSMO Analytics for BC on Fabric). Each area above is a module (e.g. Sales, Finance, Cash).