Business Intelligence

Businesses capture a tremendous amount of data through daily activity. This data, which reflects such things as the organisation's sales figures, purchases, operational expenses, employee salaries, and budgets, can become valuable information, or business intelligence, for decision makers. Financials contains a number of features that help you gather, analyze, and share your company data.

The Dimensions functionality plays an important role in business intelligence. A dimension is data that you can add to an entry as a kind of marker. This data is used to group entries with similar characteristics, such as customers, regions, products, and salesperson, and easily retrieve these groups for analysis. Among other uses, you use dimensions when defining analysis views and when creating account schedules for reporting. For more information, see Working with Dimensions.

Tip

As a quick way to analyse transactional data by dimensions, you can filter totals in the chart of accounts and entries in all Entries windows by dimensions. Look for the Set Dimension Filter action.

The following table describes a sequence of tasks, with links to the topics that describe them.

To See
View actual amounts compared to budgeted amounts for all accounts and for several periods. How to: Analyze Actual Amounts Versus Budgeted Amounts
Create new account schedules to define financial statements for reporting or for display as charts. How to: Work with Account Schedules
Analyse your financial performance by setting up KPIs based on account schedules, which you then publish as web services. The published account-schedule KPIs can be viewed on a web site or imported to Microsoft Excel using OData web services. How to: Set Up and Publish KPI Web Services Based on Account Schedules
Set up analysis views to analyse data using dimensions. How to: Analyze Data by Dimensions
Create new analysis reports for sales, purchases, and inventory, and set up analysis templates. How to: Create Analysis Reports
Enable global financial reporting by to international accounting organisations with the eXtensible Business Reporting Language standard. How to: Create Reports with XBRL

See Also

Finance
Using Financials as a Power BI Data Source
Closing Fiscal Periods
Importing from Other Finance Systems
Working with Financials