BIOS. Power BI development Reviews & Company Profile

Power BI developer (BI, ETL, DWH, SSAS, SSRS, SSIS)

Our specialization: make design and arhitecture of DWH, create tables, views, stored procedures, triggers, indexes t-sql code; developing integration package in SSIS; create tabullar model in SSAS and create formulas in DAX; I have expirience in REST API integration with marketing system, weather forecast, trello service, tmetric service. We have expirience in Manufacturing, Retail, Transportation & Logistics, Agriculture, Business Services, Information Technology.

Locations

Ukraine

Zdolbunivska, Kyiv, kyiv 02081

+380673323032

Focus Areas

Service Focus

Big Data & BI

Client Focus

Large Business
Medium Business
Small Business

Industry Focus

Manufacturing
Retail
Other

BIOS. Power BI development Clients & Portfolios

Key Clients

Global Spirits
Bayadera
Goodwine
Rost
Nielsen
Eldorado
Little House
Translogistic
Gulliver
Nemiroff
Winemart

View Portfolio

MS Power BI dashboards for HRD

About client
Kernel Trade is the largest agricultural company in Ukraine, whose products are exported almost all over the world: cereals, various food oils

Project description
MS Power BI dashboards for HRD, it for HR department employees to measure KPI recruitment and staff outflow. Data from several sources was collected and a Power BI dashboard was developed

Data Analytics Skills

Business Intelligence
Data Visualization Tools

Microsoft Power BI
Programming Languages

SQL, DAX

Web App

View Portfolio

MS Power BI dasboards for e-commerce

About client
TSUM Shopping Center is the largest center of fashion boutiques, located on the main street of Kyiv, attracts attention with a strict design outwards and modern style inside, where recognized world brands are represented on the 7 floors. Thanks to the shop-in-shop concept, the buyer has the opportunity to visit TSUM both offline and online. Ecommerce Sanahunt project provides buyer experience at the highest level

Project description
MS Power BI dashboards with General KPI for e-commerce on self-create visual components. The task was to develop individual components for the report, because the standard did not solve the problem of presentation presentation of information. The designer developed the design of the report, how it was supposed to look and we developed components that looked exactly like in design.

Data Analytics Skills
Business Intelligence

Data Visualization Tools
Microsoft Power BI

Programming Languages
SQL, DAX, Java

Web App

View Portfolio

MS Power BI dashboard "Traffic and turnover" for shopping mall

About client

Gulliver multi-functional complex is a shopping and entertainment center, decoration of the center of Kiev, and a business center of class A+. It has the title of the highest shopping center in Europe with a height of 161 meters. Interactive advertising screen is the largest in Europe with the ability to make media broadcasts of video with a resolution of 8K, even in 3D. Daily receives up to 50 thousand visitors and is a tourist vision of Kyiv.

Project description

We developed MS Power BI dashboard Traffic and turnover for shopping mall, created central database, where it had collected the most requested data, developed exchanges and reports, including for mobile smartphones. We created a repository of business intelligence reports on MS SQL, developed the collection and consolidation on MS SSIS data and several MS Power BI dashboards for investors and TOP managers of the company. On first stage we designed dashboard prototypes. At this stage, formulas for calculating indicators and design were agreed. In total a few Dashboards includs all information for commercial team: traffic by floor, turnover by lot and m2, debt, plan-fact analysis and more. Commercial team separate tenants by category and analysys result one tenants and all tenants in it category

Data Analytics Skills

Business Intelligence

Data Visualization Deliverables

Dashboard

Data Visualization Tools

Microsoft Power BI

Database Administration Skills

SQL Server Integration ServicesSQL Server Reporting Services

Databases

Microsoft SQL Server

Programming Languages

SQL, DAX

Web App

BIOS. Power BI development Reviews

Tamara Kogler, CMO at OnHires

Posted on Aug 16, 2022

DWH design and architecture. BIOS create the convenient reports for our team

Rating Breakdown

Quality
Schedule & Timing
Communication
Overall Rating

Project Detail

Review Summary

Our financial reports needed additional analytics - projects, articles, marketing's sources and so on. For this it was necessary to finalize the data warehouse and develop reports with additional analytics. BIOS identified 1 developer who conducted a business analysis of our requirements, made changes to our storage and developed reports, trained employees. They upgraded analytical financial statements of the existing system - P&L, Cashflow.

What was the project name that you have worked with BIOS. Power BI development?

OnHires’ financial reports from BIOS

What service was provided as part of the project?

Big Data & BI

Describe your project in brief

What is it about the company that you appreciate the most?

The quality of the agency's work. All the additional KPI in our financial reports we needed BIOS developed on time.

We communicate almost every day on Microsoft Teams, and every week by email for reports.

What was it about the company that you didn't like which they should do better?

I am satisfied with their work. It was really good cooperation.