Excel — Automating Trend CommentingIn the recent years, I came upon the existence of dedicated report analyst roles that perform monthly up-down commenting of numbers…Sep 12, 2024Sep 12, 2024
Data: Impact Analysis | 5 Ws and 1HMost company i work with comes with a different set of pre-change request impact analysis guidelines and templates, from official ones to…Feb 29, 2024Feb 29, 2024
Python — AWS Boto3 in automating s3 data uploadsBoto3 is an AWS SDK for Python (Boto3) to create, configure, and manage AWS services.Jan 17, 2024Jan 17, 2024
SQL — Customer Movement AnalysisCustomer movement analysis, across different platforms within two time period is the focus of today’s post. The original use case when I…Jan 16, 2024Jan 16, 2024
Python — Competitor Exclusivity AnalysisA continuation from the Competitor Exclusivity Analysis, SQL version here … This is a transpilation of the SQL version to python, given…Jan 8, 2024Jan 8, 2024
SQL — Competitor Exclusivity AnalysisMany moons ago, in my youth, like many others, i drank. I visited outlets where legal age requirements are imposed. It’s easy to enter an…Jan 5, 2024Jan 5, 2024
SQL — Running Dates in SQLHave not been active on medium. The last two years of my life have been spent on work, and more work.Jan 3, 2024Jan 3, 2024