Michał Bzunek, PhD
Business Intelligence Expert at Smarketer GmbH- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
-
angielski Full professional proficiency
-
polski Native or bilingual proficiency
-
niemiecki Elementary proficiency
Topline Score
Bio
Credentials
-
Go Beyond the Numbers: Translate Data into Insights
CourseraJul, 2023- Nov, 2024 -
Google Advanced Data Analytics Capstone
CourseraJul, 2023- Nov, 2024 -
Google Advanced Data Analytics Specialization
CourseraJul, 2023- Nov, 2024 -
Regression Analysis: Simplify Complex Data Relationships
CourseraJul, 2023- Nov, 2024 -
The Nuts and Bolts of Machine Learning
CourseraJul, 2023- Nov, 2024 -
The Power of Statistics
CourseraJul, 2023- Nov, 2024 -
Foundations of Data Science
CourseraJun, 2023- Nov, 2024 -
Get Started with Python
CourseraJun, 2023- Nov, 2024 -
Survival Analysis in Python
DataCampMay, 2023- Nov, 2024 -
Marketing Analytics: Predicting Customer Churn in Python
DataCampApr, 2023- Nov, 2024 -
Statistical Techniques in Tableau
DataCampApr, 2023- Nov, 2024 -
Data Processing in Shell
DataCampMar, 2023- Nov, 2024 -
Data Storytelling Concepts
DataCampMar, 2023- Nov, 2024 -
GitHub Concepts
DataCampMar, 2023- Nov, 2024 -
Introduction to Shell
DataCampMar, 2023- Nov, 2024 -
Understanding Data Engineering
DataCampMar, 2023- Nov, 2024 -
Introduction to Git
DataCampFeb, 2023- Nov, 2024 -
Introduction to Version Control with Git
DataCampFeb, 2023- Nov, 2024 -
Google Ads Search Certification
GoogleJan, 2023- Nov, 2024 -
Analyzing Data in Tableau
DataCampDec, 2022- Nov, 2024 -
Case Study: Analyzing Customer Churn in Tableau
DataCampDec, 2022- Nov, 2024 -
Connecting Data in Tableau
DataCampDec, 2022- Nov, 2024 -
Creating Dashboards in Tableau
DataCampDec, 2022- Nov, 2024 -
Exploratory Data Analysis in SQL
DataCampOct, 2022- Nov, 2024 -
Intermediate SQL Server
DataCampOct, 2022- Nov, 2024 -
Introduction to SQL Server
DataCampOct, 2022- Nov, 2024 -
Introduction to Tableau
DataCampOct, 2022- Nov, 2024 -
Time Series Analysis in SQL Server
DataCampOct, 2022- Nov, 2024 -
Intermediate SQL
DataCampSep, 2022- Nov, 2024 -
Joining Data in SQL
DataCampSep, 2022- Nov, 2024 -
Introduction to SQL
DataCampAug, 2022- Nov, 2024 -
Object-Oriented Programming in Python
DataCampAug, 2022- Nov, 2024 -
Introduction to Regression with statsmodels in Python
DataCampJul, 2022- Nov, 2024 -
Cluster Analysis in Python
DataCampJun, 2022- Nov, 2024 -
Data Scientist with Python Track
DataCampJun, 2022- Nov, 2024 -
Introduction to NumPy
DataCampJun, 2022- Nov, 2024 -
Introduction to Statistics in Python
DataCampJun, 2022- Nov, 2024 -
Case Study: School Budgeting with Machine Learning in Python
DataCampMay, 2022- Nov, 2024 -
Machine Learning with Tree-Based Models in Python
DataCampMay, 2022- Nov, 2024 -
Machine Learning with scikit-learn
DataCampMay, 2022- Nov, 2024 -
Unsupervised Learning in Python
DataCampMay, 2022- Nov, 2024 -
Data Analyst with Python Track
DataCampApr, 2022- Nov, 2024 -
Intermediate Data Visualization with Seaborn
DataCampApr, 2022- Nov, 2024 -
Statistical Thinking in Python (Part 1)
DataCampApr, 2022- Nov, 2024 -
Statistical Thinking in Python (Part 2)
DataCampApr, 2022- Nov, 2024 -
Streamlined Data Ingestion with pandas
DataCampApr, 2022- Nov, 2024 -
Working with Categorical Data in Python
DataCampApr, 2022- Nov, 2024 -
Working with Dates and Times in Python
DataCampApr, 2022- Nov, 2024 -
Writing Functions in Python
DataCampApr, 2022- Nov, 2024 -
Analyzing Police Activity with pandas
DataCampMar, 2022- Nov, 2024 -
Cleaning Data in Python
DataCampMar, 2022- Nov, 2024 -
Data Manipulation with Python
DataCampMar, 2022- Nov, 2024 -
Exploratory Data Analysis in Python
DataCampMar, 2022- Nov, 2024 -
Introduction to Data Visualization with Matplotlib
DataCampMar, 2022- Nov, 2024 -
Introduction to Data Visualization with Seaborn
DataCampMar, 2022- Nov, 2024 -
ETL in Python
DataCampFeb, 2022- Nov, 2024 -
Finance Fundamentals in Python Track
DataCampFeb, 2022- Nov, 2024 -
Introduction to Portfolio Analysis in Python
DataCampFeb, 2022- Nov, 2024 -
Joining Data with pandas
DataCampFeb, 2022- Nov, 2024 -
Importing and Managing Financial Data in Python
DataCampJan, 2022- Nov, 2024 -
Data Analysis in Excel
DataCampDec, 2021- Nov, 2024 -
Finance Fundamentals in Spreadsheets Track
DataCampDec, 2021- Nov, 2024 -
Loan Amortization in Spreadsheets
DataCampDec, 2021- Nov, 2024 -
Manipulating Time Series Data in Python
DataCampDec, 2021- Nov, 2024 -
Intermediate Python for Finance
DataCampSep, 2020- Nov, 2024 -
Introduction to Financial Concepts in Python
DataCampSep, 2020- Nov, 2024 -
Data Manipulation with pandas
DataCampAug, 2020- Nov, 2024 -
Data Science for Everyone
DataCampAug, 2020- Nov, 2024 -
Merging DataFrames with pandas
DataCampAug, 2020- Nov, 2024 -
Financial Forecasting in Python
DataCampFeb, 2020- Nov, 2024 -
AI Fundamentals
DataCampJan, 2020- Nov, 2024 -
Data Science for Business
DataCampJan, 2020- Nov, 2024 -
Data Skills for Business Track
DataCampJan, 2020- Nov, 2024 -
Data Visualization in Spreadsheets
DataCampJan, 2020- Nov, 2024 -
Financial Analytics in Spreadsheets
DataCampJan, 2020- Nov, 2024 -
Financial Modeling in Spreadsheets
DataCampJan, 2020- Nov, 2024 -
Importing & Cleaning Data with Python Track
DataCampJan, 2020- Nov, 2024 -
Introduction to Databases in Python
DataCampJan, 2020- Nov, 2024 -
Introduction to Relational Databases in SQL
DataCampJan, 2020- Nov, 2024 -
Manipulating DataFrames with pandas
DataCampJan, 2020- Nov, 2024 -
Marketing Analytics in Spreadsheets
DataCampJan, 2020- Nov, 2024 -
Pivot Tables in Spreadsheets
DataCampJan, 2020- Nov, 2024 -
Python Programmer Track
DataCampJan, 2020- Nov, 2024 -
Spreadsheet Fundamentals Track
DataCampJan, 2020- Nov, 2024 -
Python for Spreadsheet Users
DataCampJun, 2019- Nov, 2024 -
Joining Data in SQL
DataCampMar, 2019- Nov, 2024 -
Introduction to Data Science in Python
DataCampFeb, 2019- Nov, 2024 -
pandas Foundations
DataCampFeb, 2019- Nov, 2024 -
Intermediate Spreadsheets for Data Science
DataCampNov, 2018- Nov, 2024 -
Intro to Python for Finance Course
DataCampNov, 2018- Nov, 2024 -
Excel Statistics Essential Training: 1
LinkedInAug, 2018- Nov, 2024 -
Learning Excel Cluster Analysis
LinkedInAug, 2018- Nov, 2024 -
Cleaning Data in Python Course
DataCampJul, 2018- Nov, 2024 -
Data Analysis with Spreadsheets Course
DataCampJul, 2018- Nov, 2024 -
Intermediate Importing Data in Python
DataCampJul, 2018- Nov, 2024 -
Intermediate Python
DataCampJul, 2018- Nov, 2024 -
Introduction to Importing Data in Python
DataCampJul, 2018- Nov, 2024 -
Python Data Science Toolbox (Part 1) Course
DataCampJul, 2018- Nov, 2024 -
Python Data Science Toolbox (Part 2) Course
DataCampJul, 2018- Nov, 2024 -
Python Fundamentals
DataCampJul, 2018- Nov, 2024
Experience
-
Smarketer GmbH
-
Germany
-
Advertising Services
-
100 - 200 Employee
-
Business Intelligence Expert
-
Jan 2023 - Present
• Utilized dbt (Data Build Tool) to design and implement SQL and Python (Jinja) models, optimizing data workflows for enhanced analytics. • Automated procedures with Python and used essential libraries like pandas, NumPy, SciPy, Math, and scikit-learn in order to boost operational efficiency and data-driven insights. • Applied data engineering skills in Python to optimize connectors for accurate data retrieval, while enhancing error handling procedures crucial for various business operations. • Led data science initiatives, where I developed and deployed Python-based AI models that played a pivotal role in enabling data-informed decision-making processes, contributing significantly to project success and outcomes. • Proficiently used Tableau for creating insightful data visualizations and prepared data sources, including BigQuery and other platforms. • Collaborated effectively with stakeholders across all organizational levels to drive project completion, leveraging strong interpersonal skills to align business objectives and deliver results. • Successfully collaborated with external agencies/vendors to accomplish diverse projects and managed the data warehouse, showcasing effective partnership skills essential for project success and data infrastructure management Show less
-
-
-
Zachodniopomorska Szkoła Biznesu - Akademia Nauk Stosowanych
-
Poland
-
Higher Education
-
1 - 100 Employee
-
Assistant Professor
-
Mar 2016 - Present
• Delivering lectures, seminars and tutorials for both Polish and international students (also on weekends)• Designing, preparing and developing teaching materials.• Assessing students’ work, advising students, setting and marking examinations.• Undertaking personal research projects and actively contributing to the institution's research profile.• Participating in research projects and research teams.• Writing up research and preparing it for publication.• Providing a personal commitment to, and achievement in a particular scholarly area, participating in research projects and research teams, developing a record of publication.• Conducting blind reviews for ZPSB’s journal (“Firma i Rynek”), and recommending the manuscripts to be accepted with no revisions, accepted with revisions (minor or major), or rejected. Show less
-
-
Teaching and Research Assistant
-
Nov 2011 - Feb 2016
• Preparing and delivering lectures for various college courses – related to the field of corporate finance.• Preparing course material for the students • Evaluating and grading examinations, assignments, or papers and record grades • Scheduling and maintaining regular office hours to meet with students.• Assisting with academic research.• Gathering and analyzing data.• Publishing scholastic papers.• Carrying out discussions and academic talks.• Assistsing in administrative duties. Show less
-
-
International Business Studies Manager
-
Nov 2011 - Feb 2016
• Maintaining, managing, and building relationship with the ZPSB representatives and partners.• Administer contracts and agreements with partners.• Liaise regularly with partners to ensure contract requirements are being fulfilled and standards met.• Undertaking desk research of potential partners.• Managing and creating the International Business Studies website’s content.• Supporting creation of promotional materials.• Providing support for candidates in admission process, accommodation and visa procedures. • Carrying out administrative tasks related to the department, such as student admissions, induction programmes and involvement in committees and boards.• Attending the relevant educational expos. Show less
-
-
Adjunct Instructor
-
Oct 2008 - Nov 2011
• Developed and delivered engaging lectures to graduate and undergraduate students on corporate finance topics.• Conducted in-depth research and published scholarly papers on finance-related subjects.• Maintained accurate records of student attendance, grades, and progress.• Designed and graded assignments that challenged students to apply critical thinking and problem-solving skills.• Developed and updated course materials to ensure relevance and quality of content.
-
-
-
GEWI Sp. z o.o.
-
Utilities
-
1 - 100 Employee
-
Energy Data Scientist
-
Jul 2021 - Jan 2023
• Developing and testing RES electricity production forecasting algorithms in python using datasets such as load, weather, historical, etc. • Using requests, BeautifulSoup and other Python libraries to extract desired data from various URLs in an automated way. • Conducting analyses, modeling and optimization procedures related to energy markets, using multiple analytical methods and energy domain expertise. • Reviewing data for accuracy, anomalies, unexpected patterns and completeness, consistency, and integrity using Pandas, Numpy and other Python libraries. • Generation of various reports and data visualization using Python packages like matplotlib and Seaborn. • Developing and testing electricity price forecasting algorithms, and arbitrage strategies using large datasets related to energy markets such as grid, load, weather, historical, forward markets etc. Show less
-
-
-
Columbus Energy S.A.
-
Poland
-
Renewables & Environment
-
300 - 400 Employee
-
Data Analyst (Electricity Market Analyst / Wholesale Electricity Trading Specialist)
-
Jun 2020 - Jul 2021
Employer - Columbus Obrót Sp. z o.o. (subsidiary company of Columbus Energy S.A., former Vortex Energy - Obrót Sp. z o.o.) • Developed and improved day-ahead and intraday production output forecasting models of renewable power generation (for both photovoltaic and wind farms) in python (using ML and ANN algorithms). • Created forecasting models and automated data reporting procedures which are required by Transmission System Operator and Distribution System Operators (DSOs) according to System Operation Guidelines (SOGL). • Automated processes and developed various economic plans, and models in order to support business operations, e.g. hourly price forward curve model. • Built models and analyzed data to discover trends and patterns using Python and R. • Prepared dashboards and stories for reporting. • Cooperated with business partners, DSOs and TSO. • Actively traded on the wholesale electricity market (DAM, XBID). Show less
-
-
-
CRB Sp. z o.o.
-
Szczecin, West Pomeranian District, Poland
-
Data Analyst
-
Mar 2016 - Jun 2020
• Collaborated with clients to conduct initial assessments of complex situations and evaluate their financial positions. • Utilized Python, leveraging libraries such as NumPy, pandas, and Matplotlib, for data analysis to provide on-demand insights, enabling informed decision-making. • Developed metrics and interactive dashboards to distill raw data into actionable insights, particularly in the realm of corporate finance. This encompassed tasks such as business valuations, investment assessments, financial statement analyses, and financial projections. • Demonstrated critical thinking, problem-solving prowess, and a keen aptitude for data analysis e.g. using Python to extract meaningful information from datasets. • Produced comprehensive reports on data findings that influenced business performance and strategic direction. • Delivered tailored solutions and recommendations that precisely addressed clients' needs, contributing to their success. • Kept up-to-date with industry trends and developments by closely monitoring financial markets, assessing general economic conditions, and staying informed about emerging financial products. Show less
-
-
-
Tampere University of Applied Sciences
-
Finland
-
Higher Education
-
500 - 600 Employee
-
Academic Exchange
-
Sep 2015 - Sep 2015
In September 2015 I delivered lectures for following modules: • Financial Planning and Control • Management Accounting • Corporate Finance In September 2015 I delivered lectures for following modules: • Financial Planning and Control • Management Accounting • Corporate Finance
-
-
-
Self Employed
-
United States
-
700 & Above Employee
-
Self Employed
-
Jul 2011 - Jan 2015
• Offered a diverse range of tailored business consulting services, including but not limited to valuations, investment assessments, in-depth financial statement analyses, and precise financial projections. • Played a pivotal role in the formulation of comprehensive business plans and the development of strategic operational strategies. This encompassed conducting thorough market analyses and actively participating in fundraising efforts to secure vital resources. • Conducted extensive research and gathered critical information to inform strategic decision-making processes, ensuring that clients had access to the most up-to-date and relevant data. • Conducted rigorous financial analyses, utilizing advanced tools and techniques, to generate insightful reports that guided clients in their pursuit of financial growth and stability. Show less
-
-
-
Uniwersytet Szczeciński
-
Poland
-
Higher Education
-
100 - 200 Employee
-
Teaching and Research Assistant
-
Nov 2010 - Sep 2011
• Designed and delivered engaging lectures across a spectrum of college courses, ensuring effective knowledge dissemination to students. • Developed comprehensive course materials that enriched the learning experience and supported students' academic growth. • Conducted thorough evaluations of examinations, assignments, and papers, meticulously recording grades to provide constructive feedback to students. • Maintained a consistent schedule of office hours, creating an accessible environment for students to seek guidance, discuss coursework, and receive academic support. • Actively contributed to academic research initiatives, participating in data collection, analysis, and scholarly endeavors. • Authored and published scholarly papers that contributed to the academic discourse, disseminating valuable knowledge within the field. Show less
-
-
Education
-
Uniwersytet Szczeciński
Doctor of Philosophy - PhD, Finance (Finanse) -
Zachodniopomorska Szkoła Biznesu w Szczecinie
M.A. (Magister - Mgr), Economics (Ekonomia) -
Wyższa Szkoła Bankowa we Wrocławiu
M.A. (Magister -Mgr), Finance and Accounting (Finanse i Rachunkowość) -
Wyższa Szkoła Bankowa we Wrocławiu
Postgraduate Studies (Studia podyplomowe), Banking (Bankowość) -
Wyższa Szkoła Integracji Europejskiej
B.A. (Licencjat - Lic.), Management and Marketing (Zarządzanie i marketing)