BI Reporting Development for a Norwegian Media Company

Project Context

I played a key role in a project aimed at enhancing the data analytics capabilities of a media company based in Norway. As a Database Administrator (DBA) and BI Developer, my responsibilities were central to the development and management of Business Intelligence (BI) reports.

Key Responsibilities

Data Collection and Management:

Data Modeling and Customer Segmentation:

Report Development:

Power BI Service Administration:

Tools Used

SSIS (SQL Server Integration Services): Used for efficient data integration and workflow applications.

SQL Server: Served as the backbone for data storage, management, and complex query execution.

Power BI: Key tool for creating interactive and insightful reports.

Power BI Service: Used for hosting, sharing, and managing BI reports in a cloud environment.

Conclusion

This project was instrumental in providing the media company with deep insights into their operations and customer base. Through the effective use of tools like SSIS, SQL Server, Power BI, and Power BI Service, I was able to contribute significantly to the company's understanding of its market position, customer dynamics, and overall business health. The BI reports developed not only informed strategic decisions but also enhanced the company's data-driven approach to business management.