☰ Menu

 

UPTOWN PROCESS

Agile BI City

The efficiency in process

Have you ever seen a data plant? No? Then it's time to visit one. And as luck would have it, Uptown Process is home to the first such data assembly line.

 

Uptown Process is a place where you can discover lean and efficient process frameworks. Our top choice is PMI Disciplined Agile, offering a goal-centric approach with various delivery lifecycle options. These include iteration-based lifecycles like Scrum and flow-based lifecycles like Kanban. Furthermore, there are two types of development organizations:

  • Generalizing Specialists Organization: In this setup, most tasks for implementing a macro end-to-end increment (from data source to data warehouse and final data product) can be executed by a single, versatile specialist.                             
  • Assembly Line Organization: In this arrangement, work on a macro end-to-end increment is divided into several workstations where specialists handle micro end-to-end increments.

A typical data assembly line in the BI/DWH domain consists of five workstations:

  1. Rapid Prototyping: Create a rapid prototype of the data product and underlying data model, connecting directly to the source system with analysis tools like Power BI.
  2. Data Lake and Persistent Staging Area (PSA): Implement source system connectivity, loading necessary data into the data lake and PSA. Initially, load only a few months ofdata for quick loading and testing. Provide a simple user interface (e.g., an Excel-based report) for product owners or business users to validate the new increment.
  3. Data Warehouse and Data Mart: Load new source data from the PSA into the Data Warehouse and data mart layers, including data harmonization in the Data Warehouse and measure logic implementation in the data mart layer. Report this data in a basic Excel report without complex design.                       
  4. Final Data Product: Create the data product by taking data from the underlying Data Mart, focusing on meaningful visualization and user experience.
  5. Deployment, Integration Testing and Data Volume Extension: Deploy the macro end-to-end incre-ment to a test environ-ment, loading it with the full amount of available source data to add more value compared to increments built with a subset of data.

 

 

Let's continue the tour

Raphael Branger

Raphael Branger

Principal Consultant Data & Analytics / VR / Partner

mehr

Raphael Branger

Raphael Branger

Principal Consultant Data & Analytics / VR / Partner

 

­

You want to know more?

Agile BI City

If you want to learn more about Agile BI City, have a look at the upcoming book “How to succeed with Agile BI”. You can already start reading now by registering as beta reader on the following page.