Home

Hi Hello, Welcome. Just starting out the blog. It's mostly going to be about ...

BLOG

Alex holds a BS in IT & Mgmt and is currently pursuing his master's degree in Data Analytics & Mgmt at Illinois Tech. He has a keen interest in utilizing technology to create visually appealing content, and he enjoys eating spicy food and spotting cool neon arts.

Keep on going and the chances are you will stumble on something, perhaps when you are least expecting it. I have never heard of anyone stumbling on something sitting down.

— Charles F. Kettering

2020

Gotcha Moments of the Day

I guess I’m pretty late to the game - So I stumped upon DataGrip by JetBrain while I was reasearching for Database version control tools online. Loved it’s ability to show table diagrams and the neat color themes. MYSQLWorkbench crashes when searching string within the whole database. All the features were amazing, but one thing has been bother...

Csoncatenating row values by groups

TASK USECASES: Empty values created due to large chunk of description Grouping multiple intersts Query User Intersts SELECT u.user_email AS 'Email', u.display_name, SUBSTRING_INDEX(u.display_name, ' ', 1) AS 'First', SUBSTRING_INDEX(u.display_name, ' ', -1) AS 'Last', wp.post_title AS 'Company', mp.meta_value AS '...

SQL window function / running total

This is a inner join. We will need to add two conditions. one to get each day record and all next days records.

Basic BeatifulSoup Crawler

The media of this site were moved to the Amazon S3 bucket. Forestry implemented Amazon S3, but it doesn’t allow migration at this point.

How to setup Pentaho on MacOS Catalina

I’ve struggled several hours trying to figure out how to get the pentaho data integration app running on my macOS Catalina 10.15.2.