Work in progress
Bdigital Solutions:
Consultoria Especializada en BI
Bdigital is collaborating with leaders around the globe to help address some of the most pressing challenges and opportunities in business and society.
¿Quienes somos?
Consultoria especializada en:
-
Data engineering
Business intelligence
Planning & Performance
-
Artificial Intelligence
Web development
Process automation
Casos de exito
Confiaron en nosotros
-
DevOps
Praesent ultrices consequat rutrum. Cras ut arcu lectus. Quisque porttitor purus nunc, vitae lobortis eros placerat sed. Aliquam cursus vestibulum iaculis. Aliquam et pulvinar massa. Curabitur eu convallis velit. -
PharmaUSA
id ante quis accumsan. Nam eget nibh ut odio pretium ultricies ac ac turpis. Praesent justo tortor, sagittis vitae fringilla quis, volutpat non neque. Donec id ligula tellus. Etiam a ex risus. Praesent ut suscipit lacus, suscipit malesuada mi. -
Pharma
Morbi at eleifend quam, eget consectetur arcu. Nulla malesuada diam non leo mollis iaculis.Praesent dictum nisi ex, molestie consectetur erat semper sit amet. Vivamus consequat -
Heavy industry company SAP
Ut tristique quam eget turpis imperdiet luctus. Donec ipsum magna, fermentum in elit vel, varius volutpat sem. Sed volutpat tincidunt quam in pharetra. Vivamus dictum congue gravida. Nulla eleifend lacinia -
Empresa productos belleza
Morbi in neque non nibh ornare gravida sed eu ante. Vestibulum vulputate auctor eros eget pellentesque. Etiam pulvinar scelerisque mauris, eget tempus -
SEC
Pellentesque quis mauris quis massa vulputate vulputate id id nunc. Nam gravida placerat eros, eget posuere arcu auctor id. Suspendisse consectetur, purus vitae porta maximus, justo elit finibus odio, a fermentum enim leo non augue. Maecenas maximus posuere porttitor. In hac habitasse platea dictumst. Morbi -
Essbase
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Duis venenatis ultricies semper. Vivamus id pharetra tellus, ut fringilla massa. In gravida ex vel euismod accumsan. Integer viverra nec lorem eu dictum. Vestibulum lacinia aliquam metus, vitae consequat lacus eleifend id. Curabitur vel feugiat quam, quis euismod nibh.
DevOps
The development backed by Azure DevOps
- Full tracking of the technical project.
- Track work with Kanban boards, backlogs, team dashboards, and custom reporting.
- Deployment and rollback full control.
- Clear policies in the Power BI publish and repository.
- Security and change tracking.
- Constant Documentation.
- Central point of coordination of all the involved people of the project.
Sales team Efficiency USA – Pharma
The solution has the following parts:
Oracle DB:
Data Source.Azure data lake gen2:
Data lakehouse where the data will be stored so that power BI can query it.Power BI:
Reporting tool that will be used to build the reporting deck.
Features:
- Full HCP Geo-localization.
- Sales Team structure.
- SAP product jerarquies.
- Growth-Volumen analysis.
Italian Pharma Company
Project Profile
- Creation and development of a Business Intelligence environment for the sales business unit.
- Deployment of the infrastructure necessary to support a Business Intelligence environment.
- Data extraction and data ordering from an SQL database.
- Creation of an SSAS tabular model for a sales business unit.
- In-depth analysis advanced analysis techniques for collecting business information.
- Easy-to-use report and dashboard design with highly valuable information.
- Row level security (RLS) by group and by user.
- SAGE integration.
Scope
- Sales
- Marketing
- Users: 50
- Reports: > 100
- Number of KPIs: > 50
- Dimensions: 100
- Number of tables: > 50
Heavy Industry Company SAP
Project Profile
- Integration with SAP.
- Development of a complete Budget Business Plan (BBP) system for the entire company with 5 floors.
- Deployment of the infrastructure necessary to develop a BBP system.
- Creation of SQL databases based on local files.
- Development of the end user interface for data entry to the SQL database.
- Creation of the SSAS tabular model for the entire BBP system.
- User-friendly report design for the BBP system.
- Control panel and report design.
Empresa productos belleza
Project Profile
Creación y mantenimiento de todo un entorno de BI:
- Despliegue de la infraestructura necesaria para desarrollar un entorno de Business Intelligence.
- Extracción de datos y ordenación de datos desde múltiples bases de datos SQL.
- Análisis avanzado para recopilar información relevante del negocio.
- Diseño de informes fácil de usar, fácil de interpretar y con información muy valiosa.
- Row-level security (RLS) por grupo y usuario.
- Reunir datos no estructurados de páginas web para obtener información que juega un papel importante para la administración del comercio electrónico.
- Modelo tabular SSASS creado en Dax basado en bases de datos SQL, páginas web y hojas de cálculo de Excel.
- Integración de MS ERP.
Scope
- Ventas
- Marketing
- Producción
- Control and Finance
- Usuarios: 25
- Reports: > 28
- Number of KPIs: > 30
- Dimensions: 30
- Number of tables: > 23
Monthly financial reporting SEC company
The solution has the following parts:
- SAP BW : Data Extraction to HANA Tables.
- SAP HANA: source of the data to be able to make the reporting deck.
- Azure synapse Analytics: Orchestrator of the process of loading the data into Power BI once the data is in the blob storage.
- Azure data lake gen2: Data lakehouse where the data will be stored so that power BI can query it.
- Power BI: Reporting tool that will be used to build the reporting deck.
- Azure function: Used as the back-end for the custom comments visual to read and write comments to the database.
- SQL server: database that will store all comments.
- Power BI Tiles: Tool to extract reports to Power Point.
Essbase – Oracle Multidimensional to Tabular format
The solution has the following parts:
Oracle Essbase:
34 cubes, ragged dimension, numerous.Azure data lake gen2:
Data lakehouse where the data will be stored
so that Power BI can query it.Power BI:
Reporting tool that will be used to build the
reporting deck.
Features:
- On-demand/Scheduled refresh,
- Full financial monthly reporting,
- Complex security.