BI Reporting Development for a Norwegian Media Company
Alexander Nordvall
Data Visualizer
Business Analyst
Data Analyst
Microsoft SQL Server
Power BI
SQL
Viasat
Viaplay Group
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.
