Project Overview
Business Partner: ITW (IT Division)
Project Focus: BI Reporting Project
Goal: Enable strategic decision-making through improved BI reporting
Scope of Work
On-Demand was commissioned by the global manufacturing company’s IT division to enhance its business reporting capabilities. The project involved the provision of a BI Lead Developer and a BI Analyst, focusing on developing, testing, and maintaining the manufacturing company’s data warehouse environment.
Roles and Responsibilities
BI Lead Developer:
- Engagement:
- Collaborated with the Reporting and BI Analyst, reporting to the IT & Digital Manager.
- Key Tasks:
- Developed and tested the SSAS tabular model in an Azure-based warehouse.
- Created and tested Power BI visualizations and reports.
- Investigated and resolved data issues in report calculations and warehouse data.
- Expertise Demonstrated:
- Proficient in Power BI, SQL Server, SQL Server Analysis Services (Tabular/Multidimensional), and Data Analysis Expressions (DAX).
- Developed and maintained SSIS packages for ETL operations.
- Supported and developed the Enterprise Data Warehouse.
- Knowledgeable in various systems including Microsoft BI Stack, Cognos, and Pronto Xi ERP.
BI Analyst:
- Role:
- Data expert skilled in databases, data warehouse management, and report development.
- Responsibilities:
- Assessed user needs to provide support, training, and proactive services.
- Addressed reporting opportunities using relevant tools.
- Provided second and third-level helpdesk support for reporting/BI and data warehouse issues.
- Engaged in the development and testing of reporting and BI requirements.
- Maintained strong application knowledge to achieve business objectives.
- Troubleshoot data issues in report calculations or warehouse data.
- Facilitated cross-functional meetings to discuss reporting needs and improvements.
- Guiding Principles:
- Utilized our clients’ guiding principles and toolbox for operational improvements.
Impact
The BI Lead Developer and Analyst played crucial roles in enhancing our client’s BI reporting capabilities. Their expertise in data analysis, visualization, and warehouse management significantly contributed to the company’s ability to make informed, strategic decisions. The project underscored the importance of sophisticated BI tools and skilled professionals in transforming data into actionable business insights.