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.

logo

¿Quienes somos?

Consultoria especializada en:

  • Data engineering

    • Databricks
    • AzureDataFactory
    • AzureSynapse

    Business intelligence

    • MicrosoftFabric
    • PowerBI
    • SAP

    Planning & Performance

    • Notion
    • Notion
    • Openai

  • Artificial Intelligence

    • Openai
    • AzureMachineLearning
    • AzureCognative

    Web development

    • Nextjs
    • React
    • React

    Process automation

    • Python
    • Bash
    • Powershell

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.
img18 img17

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.
img16
img15

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
img8
img9
img10

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.
img11
img12
img13

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
img4
img3
img2

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.
img7 img6 img5

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.
img14