PROJECTS
PYTHON COURSE PROJECTS (IN PROGRESS)
Skills and techniques used
Beginner python coding – professional python coding
BINANCE TRADING BOT
Skills and techniques used
Python coding, Binance API, trading
BITCOIN HALVING PRICE ANALYSIS
Skills and techniques used
PYTHON – numpy, pandas, matplotlib, seaborn
BITCOIN HALVING PRICE ANALYSIS
Skills and techniques used
Web scraping, excel formating, power query, visualizations, bookmarks, buttons, DAX calculations
EXCEL BUDGET AND EXPENSE PROJECT
Skills and techniques used
DAX functions, VLOOKUP, SUMIFS, DATEDIF, TEXT, EOMONTH, IF, data validation, scroll bars, data visualizations, conditional formating, pivot table, filters and slicers, VBA.
SQL Adventure Works Database
Skills and techniques used
Restoring database, updating database using a script, SELECT, CONCAT, CASE statement, JOINS, WHERE clause, ISNULL, LEFT, ORDER BY.
Power BI Adventure Works Project
Skills and techniques used
Importing data, Excel CONCAT function, power query, data modeling, DAX, dashboard creation, filters and slicers, visualizations (donut chart, column charts, map charts, tree map, bar charts, matrix), drill down
