BO1 AG – Data Modeling / Data Engineering.

About this project

BO1 AG developed the Paydentity app and payments, credit and identity check at the Point of Sale. With this in mind, management required a KPI framework to enable monitoring operations, performance of the business in the form of Power BI dashboards and reports.

Within this project, I gathered the requirements, defined and designed a North Star Framework for the business, collected the data points and fields that were required to compile the metrics, modeled the data in Power Query and created management reports and dashboards in Power BI.

Categories: Data Engineering, Data Modeling

Project Highlights

  • Data Lake – defining the Data Lake structure, file-type, data governance policy and data ingestion schedule

  • Star Schema – modeling data within Power BI with Power Query, DAX

  • Design and creation of Power BI dashboards

  • Defining and creating a North Star Framework to facilitate performance monitoring of the business goals and focus on growth

  • Design and implement an interim data solution for the Paydentity Pilot launch via modeling of data in Power Query