Sobre este projeto
it-programming / data-science-1
Aberto
We are seeking an experienced Power BI developer to finalize a critical report for a medical supplies distributor. The foundational data model and Power Query scripts are already in place, providing a solid base for the remaining development.
The primary responsibilities for this project include:
* Developing DAX calculated columns and approximately 35 complex measures.
* Designing the report layout and ensuring all labels are in Spanish.
* Implementing calculations for stock levels, expiry dates, risk assessment, product valuation, returns, and material status.
* Integrating a 'what-if' parameter to analyze different expiry windows.
* Applying a custom JSON theme for consistent branding and aesthetics.
* Creating 6 comprehensive report pages featuring key performance indicators (KPIs), various charts, detailed tables, heatmaps, and interactive slicers.
* Configuring slicers to synchronize across all report pages for a cohesive user experience.
* Performing thorough validation of all report totals against provided Excel pivot tables to ensure data accuracy.
* Producing concise documentation for each developed DAX measure, explaining its logic and purpose.
The report will utilize existing SAP Excel data, encompassing information from 4 hospitals, approximately 50 distinct products, and multiple production lots per product. We will provide the current PBIX file, M code, draft DAX logic, and expected validation values to facilitate a smooth handover.
Required Skills:
* Strong proficiency with Power BI Desktop.
* Exceptional DAX formula writing and optimization skills.
* Proven experience in data modeling and effective report design.
* Ability to communicate clearly in English.
* Mandatory requirement for Spanish report labels.
Categoria TI e Programação
Subcategoria Data Science
Tamanho do projeto Grande
Prazo de Entrega: Não estabelecido
Habilidades necessárias