Importing and structure data, further organising the data with advanced functions
Visualising insights from the datasets and reflected on outputs
Implemented VBA coding into my workflow for swifter and efficient results
Currently undertaking Microsoft Certification Excel training to bolster my already strong Spreadsheet skills and reviewing other spreadsheet solutions including Google Sheets.
Explored the Tableau and Power BI platforms and their features
Used both platforms to transformed data, generate reports and create dashboards
Going through Microsoft Power BI and Tableau training, respectively
Creating dashboards for financial market participants that shows the market moving information at a glance without the noise
Core database concepts
SQL best practices
Undertaking further SQL training
Using SQL to store large datasets alongside Python to call them to test financial economic models and backtest trading and investing strategies
Exploring the Microsoft Azure Suite of product offerings including Cosmos and Fabric
Cloud fundamentals and cloud offering comparisons
Doing further training on Azure, GSuite, and AWS
Explored other integrations and how they can further value eg the dataverse, Power Suite
Python fundamentals
Computing and visualising data using libraries such as Pandas, and Nympy
Doing further Python training, and actively using Python for financial market analysis
Exploring Python with ML for financial markets
High Frequency Trading Strategy
Market Forecast; Sentiment Analysis
Economic, Business, and Commerce Drill Up/Down Analysis Tool
Portfolio Performance Analysis
Sentiment Analysis
Trend Finder; Identify Where Trends Start & The Key Details Everyone Misses