About

Headquartered in Texas, the Client is an international company (with about 300 employees) that is an expert in commercial and residential real estate development.

Challenge

Aiming to gain deeper insight into their business, the Client wanted to establish a comprehensive financial reporting. Instead of disparate data unsuitable for data analyzing and for making informed decisions, the Client wanted to receive an efficient reporting tool based on the aggregate data.

Solution

In the course of the project, VolgoTechnologies BI implementation team of a data analyst, a database developer and a senior BI developer delivered the following.

Data warehouse based on Microsoft SQL Server ETL using Python Data integration from about 40 sources Data cleaning and merging Analytical cube development with 15 dimensions and 30 measures Integrated financial and analytical reports and dashboards based on Power BI

The reports show the data of both entire company and the branches. Additionally, any attribute can be chosen to filter the data (including the hierarchy of branches, accounts and dates).

Staging

Data Ware House

Data Ware House

Desktop Application

Results

At the end of the project, 17 reports (with different levels of detail) and 5 dashboards allowed the Client r to look at the aggregate financial data from any perspective and, consequently, better understand their business. Besides, the Client was able to analyze the cash flow, spot the trends, and quickly react to a changing environment.

Technologies and Tools

Microsoft SQL Server (DWH), Python (ETL), Microsoft Power BI (Reporting)