Solutions · Business Software

Power BI

Power BI is Microsoft’s tool for data analysis and reporting. It reads data from the ERP, the CRM, databases and Excel files, prepares it and presents it in interactive reports and dashboards that can be viewed in a browser or on a smartphone. Aesir builds the data model around the questions management actually asks and keeps it current over time.

How it works

Power BI at a glance

Interactive reports and dashboards

Data becomes charts, tables and indicators you can filter, drill into and compare across periods. A well-built dashboard answers in seconds questions that used to require an export and half a day’s work in Excel.

Data preparation

With Power Query data is extracted, cleaned and transformed before analysis: duplicates removed, formats standardised, codes mapped to the same master data. The rules are written once and applied at every refresh.

Connection to ERP systems

Power BI reads data from many ERP systems, including SAP, Oracle, Microsoft Dynamics 365, TeamSystem, NTS Informatica’s Business Experience and Fluentis. Sales, purchasing, stock, production and accounting are analysed from source data.

Many sources together

Beyond ERP systems, the platform connects to SQL databases, cloud services, Excel files and web services. Data living in different systems ends up in the same model, and automatic refresh keeps it aligned.

Controlled sharing

Reports are published to the Power BI service and shared with colleagues and partners with defined permissions. Everyone sees the data relevant to them: a sales rep their own area, management the overall picture.

Apps and alerts

The iOS and Android apps bring reports and dashboards to the smartphone. Alerts can be set to trigger when an indicator crosses a threshold, so a variance is noticed without opening the report every day.

In detail

Power BI features

The value of Power BI depends less on the charts than on the data model behind them. Before designing a dashboard you need to decide which measures matter, which system each figure comes from and how customers, items, jobs and periods relate. A well-built model can also answer new questions without starting over.

Power BI Desktop is the tool for building models and reports, with languages such as DAX for calculations and M for data transformation. The online service distributes reports and handles scheduled refreshes and permissions. The mobile apps complete the picture for people who need the figures away from the office.

  • Interactive reports and dashboards with filters, drill-down and period comparison.
  • Power Query to extract, clean and transform data before analysis.
  • Connection to ERP systems such as SAP, Oracle, Microsoft Dynamics 365, TeamSystem, NTS Business Experience and Fluentis.
  • Integration with SQL databases, cloud services, Excel files and web services.
  • Data models with DAX calculations and M transformations in Power BI Desktop.
  • Scheduled data refresh on the Power BI service.
  • Report sharing with user permissions and data access levels.
  • iOS and Android apps to view reports on the move.
  • Automatic alerts when indicators cross thresholds.
With Aesir

How we bring it into the company

We start from the questions. With management and department heads we collect the decisions currently made without reliable figures, or with figures that arrive late, and derive the indicators to measure. Then we check where the data lives, how clean it is and what is needed to connect it.

We build the data model, the first reports and their distribution, review them with the people who will use them and refine them until the figures match those of the finance team. After go-live we remain the point of contact for support, new reports and adapting the model when processes or source systems change.

Power BI is part of Business software. See also the Aesir method, the case studies and how our support works.

Want to know whether Power BI makes sense for your company?

We start from the process, not the product. A first meeting with no commitment.

Request a call