Portfolio

Hi, I'm Kasia

Explore my skills and experience in data analysis

I have years of experience working in international corporations, where I was responsible for creating interactive reports, tabular cubes, and implementing automation to streamline and optimize processes. I collaborated with multiple teams, delivering solutions that supported business objectives. Thanks to my experience working with stakeholders, I always tailor my projects to meet business requirements.

Technical Skills

Tools and languages I use daily

Power BI and Data Modeling

I specialize in advanced data modeling and visualization using Power BI. I work with DAX, SSAS, and Power Query, allowing me to create interactive reports and OLAP cubes. With tools like Tabular Editor and DAX Studio, I build optimized analytical models.

SQL and Relational Databases

I have extensive experience in advanced SQL, utilizing functions such as CTEs, window functions, and advanced aggregation operations like ROLLUP, CUBE, and GROUPING SETS. I have worked with various databases, including Oracle and SQL Server.

Python and Machine Learning

I use Python for data analysis and process automation, leveraging libraries such as Pandas, Tkinter, SQLAlchemy, oracledb, scikit-learn, and matplotlib. I support my analyses with predictive models and data visualizations.

Projects

Selected projects I have worked on

Experience in Reporting: Sales and Marketing | Carbon Footprint | Customer Satisfaction

Sales and Marketing Reports:
I developed comprehensive reports and data models, as well as OLAP cubes, analyzing large datasets to support the sales and marketing teams' activities.
Carbon Footprint Analysis:
I conducted detailed analyses of carbon footprint metrics, providing valuable insights on environmental impact.
Customer Satisfaction Improvement: I used machine learning to analyze customer feedback and build predictive models that supported enhancements in customer satisfaction.

Application Development for Analysts

Process Automation Tools:
I developed tools using Python and VBA that automated processes and streamlined the analytical team's work.
Data Processing Automations:
My tools retrieved data from various sources, modeled and cleaned the data, then generated results with automated email notifications, speeding up the information flow.

Personal Projects:
Excel Add-In / Ninja Data

Excel Add-In: I created an Excel plugin that simplifies data analysis, enabling users to quickly and effectively utilize data processing functions.
Ninja Data Educational Profile on Instagram, YouTube, and LinkedIn (@ninja_data): I share knowledge on social media related to Power BI, Python, SQL, and DAX. I regularly publish tutorials, tips, and best practices, engaging the community and supporting others in developing their analytical skills.