Power BI integration for social services in Päijät-Häme County
Laakso, Carolina (2025)
Julkaisun pysyvä osoite on
https://urn.fi/URN:NBN:fi:amk-2025060319814
https://urn.fi/URN:NBN:fi:amk-2025060319814
Tiivistelmä
The main objective of this thesis was to create an interactive Power BI dashboard that would help with the analysis of survey data on wellbeing and inclusion allowing the users to see survey data in real time and filter it. The study aimed to convert static datasets into a reporting tool that would be dynamic and easy to use, for the detection of patterns and insights across different groups of respondents. The dashboard was meant to make it easier for professionals in municipal wellbeing services and associations to access and use survey results.
The study used a design-oriented, practice-based method. Power Query was used to preprocess data, DAX was used to calculate logic, and Power BI was used to implement the visual design. Particilar focus was placed on features such as data cleaning, user navigation, and data segmentation.
The dashboard that was the outcome of this study allows users to review at inclusion scores, wellbeing indicators, and subgroup characteristics. Data is filtered by demographic factors such as age, gender, and job status, and different types of charts can be used to compare data. The study shows how business intelligence tools can be made easier for people who are not particularly tech-savvy and how the model could be used in other parts of Finland and by other operators. In the future, automation, SQL-based scalability, and geographic visualization could be added to this tool.
Keywords: power bi, wellbeing, data visualization, wellbeing services county
The study used a design-oriented, practice-based method. Power Query was used to preprocess data, DAX was used to calculate logic, and Power BI was used to implement the visual design. Particilar focus was placed on features such as data cleaning, user navigation, and data segmentation.
The dashboard that was the outcome of this study allows users to review at inclusion scores, wellbeing indicators, and subgroup characteristics. Data is filtered by demographic factors such as age, gender, and job status, and different types of charts can be used to compare data. The study shows how business intelligence tools can be made easier for people who are not particularly tech-savvy and how the model could be used in other parts of Finland and by other operators. In the future, automation, SQL-based scalability, and geographic visualization could be added to this tool.
Keywords: power bi, wellbeing, data visualization, wellbeing services county