I’m Piia, and I work at Pinja as a Business Intelligence and Data Warehouse Specialist. In my work, I have, among other things, redesigned a client’s financial reporting to make it easy to drill down. Data transfer was done from the source systems using SSIS packages to a Microsoft SQL Server database.
The transferred data was compiled into a tabular cube, and published to SQL Server’s Analysis service. The data was put into a cube format that can be viewed in Excel and Power BI reports, making it easy to find incorrect entries, for example. Initially it was done at the company level, but now it has been refined down to the level of the work management.
I like the fact that I can prepare the whole reporting pipeline from where the data is, all the way to the report. It’s nice to see the end result. For a long time, I wasn’t involved in Power BI, which made it difficult to get started: I didn’t know how the end result would be used, and what it should be like. In my own work, I pride myself on the fact that I create a properly finished product once, which I rarely have to go back and improve.
Pinja’s working culture is open towards the client. We are serious about helping our clients, and our solutions are tailored to their needs, so that the collaboration continues beyond the first project. We have a strong sense of working together – solutions are thought through together.
At the beginning of the year, we participated in the SQL Bits event in Wales remotely. Every office had the lines open, and I was in the Kuopio office during those two days. We had pre-selected the program, and the topics of the first day were Azure and Data Factory, and the second day was Machine Learning. For me, an important thing was getting to spend time with the team, talking and bonding.
The best thing about my workplace is: My colleagues! It’s important to feel comfortable at work. The colleagues are the support and security in your everyday life. People are the ones that make Pinja.