E-mail: tombachdev@gmail.com
About me
Tomasz Bachmura
Currently I work as an IT teacher in a primary school. I'm also a programming and engineering trainer for children and teenagers. My goal is to work and constantly develop in Data Science and Analytics field. I obtained my master's degree in Mechatronics at Warsaw University of Technology.
My skills
SQL
Basic SQL querying and programming concepts.
• JOINs
• variables, WHILE, IF, CASE
• subqueries, derived tables, CTEs
• Stored Procedures and Functions with parameters
• Transactions and Error handling
MS Excel and Power tools
• Pivot Table reports
• Data visualization: charts and conditional formatting
• Conditional and Dynamic Array functions
• Power Query - importing, cleaning and transforming data
• Power Pivot - data modelling, relations between tables, DAX Measures
Power BI
• Various data visualizations
• Power Query - importing, cleaning and transforming data
• Data modelling
• Measures
Python
Basic programming skills for data analysis purposes.
Using tools like Pandas, Numpy, Pyplot, Plotly and Jupyter Notebook.
My recent projects
Projects presenting my skills in practice.[ENG] "Moving Average Trading System" - Python
Trading system project done using historical market data that contains:
• API connection to import data - yfinance API
• Trading indicators formulas made with Numpy and Pandas Data Frame tools
• Pyplot tool - data visualization
• Jupyter Notebook
[ENG] "Crypto Market Exploratory Data Analysis" - Python
Project showing basic EDA results and Python programming skills like:
• API connection to extract data - Binance Exchange API
• Pandas data analysis tool - cleaning, transforming and visualizng data
• Plotly tool - data visualization
• Jupyter Notebook
[ENG] "Wide World Importers earnings overview" - SQL & Power BI
Project is an analysis of data extracted from Microsoft Sample WWI databases.
• T-SQL queries (GITHUB)
• Power Query data modelling
• Power BI data visualization and analysis
[PL] "Placówki oświatowe w Polsce" - MS Excel
Raport podsumowujący dane pozyskane z oficjalnej bazy Rejestru Szkół i Placówek Oświatowych.
• Power Query data import and cleaning
• MS Excel Pivot tables and conditional formatting
• dynamic tables and formulas with Slicer selection
[ENG/PL] Basic T-SQL practice queries
Exercises done during my T-SQL learning journey.
Includes basic SQL querying and programming concepts.
• JOINs
• variables, WHILE, IF, CASE
• subqueries, derived tables, CTEs
• Stored Procedures and Functions with parameters
• Transactions and Error handling
