Upload CV Submit Vacancy

Optimizing Business Intelligence: A leading global manufacturing company’s BI Reporting Project Case Study

12 February 2024


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.


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.

For large-scale digital transformation consulting and projects, connect with Ignite today.

For more information

Follow us on