Power BI Business Intelligence Consulting

Business Unit Demand Analysis

Analysis Step 1

Even if the preliminary analysis documents for the business intelligence project you want to have done are not available or you do not have an analysis department or personnel on your staff, we will create a preliminary analysis of your request by organizing meetings with your business units, so that we can shape your preliminary analysis document together....

Analysis Documentation

Analysis Step 2

After the preliminary analysis, we create your Analysis document together by detailing the request and clarifying the outputs such as calculation, grouping, filtering, design, etc.

Preliminary Analysis Consensus

Analysis Step 3

Agreeing on the requirements is achieved with the help of a preliminary analysis or detailed analysis document.

Project Solution Analysis

Analysis Step 3

Based on the agreed-upon analyses, details are clarified for a specific architectural fit, if any, regarding how the project will be solved. Otherwise, the most cost-effective and most appropriate alternatives for the needs are presented among the architectural solution alternatives.

Determining Scope and Excluded Items

Project Management Step 1

Project scope and non-scope items are clarified based on the agreed analysis document.

Creating a Project Solution Document

Project Management Step 1

The solution architecture decided upon based on the alternative solutions presented is documented....

Scheduling the Project

Project Management Step 3

Documented technical solution architecture process steps such as data warehouse, relational in-memory OLAP model and visualization interface are explained.

Periodically monitoring the project with the Agile Method

Project Management Step 4

The project is periodically reviewed every weekday by the development unit to determine whether the project adheres to the schedule and resolves any gaps or bottlenecks. A weekly meeting is held with the requesting business unit and the client project manager to inform them about schedule compliance.

Infrastructure development such as DWH etc.

Development Step 1

Stagnation and DWH environments are created in a relational cloud or in-house RDBMS system using a model consistent with the project solution document. Incremental, bulk, and periodic transfer frequencies are determined to best suit the needs of detail and summary, in line with fact and dimension table relationships. The SP, Azure Datafactory, and SSIS ETL operations are developed according to the budget.

Creating a Data Model

Development Step 2

According to the need, a data model is created using in-memory relational fact and dimension tables, and the desired KPIs suitable for the model are coded.

Interface design development

The KPIs fed from the data model are applied to the company's generic colors and the presentation layer is created to display the data in the most meaningful visual objects...

Automate

Development Step 4

A schedule is created for the data model data refresh frequency...

Backup

Go Live Step 1

Backups of Dev, Test and Prod environments are taken and reporting environments are published sequentially.

Post-Go-Live Data Flow Test

Go Live Step 2

Data records of revenues taken live are checked....

Post-Go-Live User Access Controls

Go Live Step 3

User-based access controls are performed....

Periodic monitoring of flow, backup, etc.

Go Live Step 4

Creating notification emails for periodic backups, periodic data replications and similar operations...

Creation of Development Documents

Project Delivery Training Step 1

Creation of DWH, Olap, Data Model technical documentation...

Providing Development Transfer Training

Project Delivery Training Step 2

Providing training on advanced DWH, Olap, Data Model, etc. that can be continued after the transfer...

User Interface Usage Training

Project Delivery Training Step 3

It includes user training on using the Hub, such as filters, page transitions, etc.

Periodic Maintenance Training

Project Delivery Training Step 4

It includes training on operations such as data repetition frequency monitoring, etc.

Monitoring server load

Maintenance Step 1

Periodic monitoring of server RAM, processor, disk occupancy and workload on Power BI Test and Live machines...

Cocacola

Apache Airflow-Data Quality Project

It is a Python project to develop a product by automating the control of all transferred tables and including controls such as before and after ETL transfers between Teradata (Staining) and Google Big Query (DWH) layers, data singularity, data flow completion date control, row, amount and quantity basis, percentage and quantity growth rates, null control, etc. The schedule success and stuck status of both SAP DS and Google Composer DAG packages are visualized with the Power BI report.