Kenn Francisco

Huge recognition!

"𝘋𝘦𝘢𝘳 𝘒𝘦𝘯𝘯, 𝘵𝘩𝘢𝘯𝘬 𝘺𝘰𝘶 𝘴𝘰 𝘮𝘶𝘤𝘩 𝘧𝘰𝘳 𝘺𝘰𝘶𝘳 𝘢𝘸𝘦𝘴𝘰𝘮𝘦 𝘴𝘶𝘱𝘱𝘰𝘳𝘵 𝘢𝘵 𝘰𝘶𝘳 𝘱𝘳𝘰𝘫𝘦𝘤𝘵 𝘚𝘮𝘢𝘳𝘵 𝘏𝘙. 𝘠𝘰𝘶 𝘢𝘳𝘦 𝘨𝘰𝘪𝘯𝘨 𝘢𝘣𝘰𝘷𝘦 & 𝘣𝘦𝘺𝘰𝘯𝘥 𝘵𝘰 𝘮𝘢𝘬𝘦 𝘰𝘶𝘳
𝘋𝘦𝘷4 𝘵𝘳𝘢𝘪𝘯𝘪𝘯𝘨 𝘦𝘯𝘷𝘪𝘳𝘰𝘯𝘮𝘦𝘯𝘵 𝘵𝘩𝘦 𝘣𝘦𝘴𝘵 𝘵𝘳𝘢𝘪𝘯𝘪𝘯𝘨 𝘦𝘯𝘷𝘪𝘳𝘰𝘯𝘮𝘦𝘯𝘵 𝘵𝘩𝘦𝘳𝘦 𝘪𝘴 𝘰𝘯 𝘵𝘩𝘦 𝘸𝘩𝘰𝘭𝘦 𝘏𝘊𝘔-𝘮𝘢𝘳𝘬𝘦𝘵. 𝘠𝘰𝘶 𝘢𝘳𝘦 𝘷𝘦𝘳𝘺 𝘰𝘱𝘦𝘯 𝘵𝘰 𝘤𝘭𝘪𝘦𝘯𝘵
𝘧𝘦𝘦𝘥𝘣𝘢𝘤𝘬 𝘢𝘯𝘥 𝘢𝘭𝘸𝘢𝘺𝘴 𝘵𝘳𝘺 𝘵𝘰 𝘪𝘯𝘤𝘰𝘳𝘱𝘰𝘳𝘢𝘵𝘦 𝘧𝘦𝘦𝘥𝘣𝘢𝘤𝘬 & 𝘯𝘦𝘸 𝘪𝘯𝘱𝘶𝘵. 𝘉𝘦𝘴𝘪𝘥𝘦𝘴, 𝘺𝘰𝘶 𝘢𝘳𝘦 𝘢𝘭𝘸𝘢𝘺𝘴 𝘢𝘷𝘢𝘪𝘭𝘢𝘣𝘭𝘦 𝘸𝘩𝘪𝘤𝘩 𝘐 𝘢𝘭𝘴𝘰 𝘵𝘳𝘶𝘭𝘺 𝘢𝘱𝘱𝘳𝘦𝘤𝘪𝘢𝘵𝘦.
𝘛𝘩𝘢𝘯𝘬𝘴 𝘧𝘰𝘳 𝘣𝘦𝘪𝘯𝘨 𝘢𝘸𝘦𝘴𝘰𝘮𝘦! 𝘓𝘦𝘵𝘴 𝘤𝘰𝘯𝘵𝘪𝘯𝘶𝘦 𝘵𝘰 𝘨𝘰 𝘵𝘩𝘦 𝘦𝘹𝘵𝘳𝘢 𝘮𝘪𝘭𝘦 𝘧𝘰𝘳 𝘵𝘩𝘦 𝘯𝘦𝘹𝘵 𝘤𝘰𝘶𝘱𝘭𝘦 𝘰𝘧 𝘮𝘰𝘯𝘵𝘩𝘴 - 𝘰𝘶𝘳 𝘵𝘳𝘢𝘪𝘯𝘪𝘯𝘨𝘴 𝘴𝘵𝘢𝘳𝘵𝘦𝘥 𝘭𝘢𝘴𝘵 𝘸𝘦𝘦𝘬
𝘢𝘯𝘥 𝘵𝘩𝘦𝘳𝘦 𝘢𝘳𝘦 𝘴𝘵𝘪𝘭𝘭 𝘴𝘰𝘮𝘦 𝘵𝘩𝘪𝘯𝘨𝘴 𝘵𝘰 𝘥𝘰. 𝘛𝘩𝘢𝘯𝘬 𝘺𝘰𝘶 𝘴𝘰 𝘮𝘶𝘤𝘩! 𝘋𝘦𝘮𝘪𝘢𝘯"

Team

So happy being valued! Will be more proactive :)

10 𝐁𝐞𝐬𝐭 𝐏𝐫𝐨𝐝𝐮𝐜𝐭𝐢𝐯𝐢𝐭𝐲 𝐀𝐩𝐩𝐬 & 𝐏𝐫𝐨𝐝𝐮𝐜𝐭𝐢𝐯𝐢𝐭𝐲 𝐒𝐨𝐟𝐭𝐰𝐚𝐫𝐞 𝐅𝐨𝐫 2024
by The Digital Project Manager | Ben Aston

1. 𝘮𝘰𝘯𝘥𝘢𝘺.𝘤𝘰𝘮
2. 𝘚𝘭𝘢𝘤𝘬
3. 𝘊𝘭𝘪𝘤𝘬𝘜𝘱
4. Guru
5. Zoho Projects
6. SaneBox
7. MeisterTask
8. Kintone
9. Trello
10. Todoist

𝘎𝘳𝘦𝘢𝘵 𝘵𝘰 𝘴𝘦𝘦 𝘛𝘳𝘦𝘭𝘭𝘰 𝘢𝘯𝘥 𝘛𝘰𝘥𝘰𝘪𝘴𝘵 𝘩𝘦𝘳𝘦 𝘴𝘪𝘯𝘤𝘦 𝘐 𝘩𝘢𝘥 𝘦𝘹𝘱𝘦𝘳𝘪𝘦𝘯𝘤𝘦𝘴 𝘶𝘴𝘪𝘯𝘨 𝘵𝘩𝘦𝘮. 𝘍𝘰𝘳 𝘵𝘩𝘦 𝘵𝘰𝘱 3, 𝘐 𝘩𝘪𝘨𝘩𝘭𝘺 𝘳𝘦𝘤𝘰𝘮𝘮𝘦𝘯𝘥 𝘊𝘭𝘪𝘤𝘬𝘜𝘱 𝘧𝘰𝘳 𝘪𝘵𝘴 𝘧𝘳𝘦𝘦 𝘢𝘥𝘷𝘢𝘯𝘤𝘦𝘥 𝘧𝘶𝘯𝘤𝘵𝘪𝘰𝘯𝘢𝘭𝘪𝘵𝘪𝘦𝘴; 𝘨𝘳𝘦𝘢𝘵 𝘧𝘰𝘳 𝘱𝘳𝘢𝘤𝘵𝘪𝘤𝘪𝘯𝘨 𝘢𝘯𝘥 𝘨𝘦𝘵𝘵𝘪𝘯𝘨 𝘶𝘴𝘦𝘥 𝘵𝘰 𝘵𝘩𝘦𝘴𝘦 𝘢𝘥𝘷𝘢𝘯𝘤𝘦𝘥 𝘵𝘰𝘰𝘭𝘴 𝘧𝘰𝘳 𝘱𝘳𝘰𝘫𝘦𝘤𝘵 𝘮𝘢𝘯𝘢𝘨𝘦𝘮𝘦𝘯𝘵 😎

Article link: https://thedigitalprojectmanager.com/tools/best-productivity-apps-tools/

Client

Feedback from Teammate!

Feedback from Teammate

Awesome feedback from client 😎 Very, very motivating.

Quick Queries!

𝘕𝘦𝘦𝘥 𝘢 𝘧𝘪𝘭𝘵𝘦𝘳 𝘱𝘢𝘳𝘢𝘮𝘦𝘵𝘦𝘳 𝘸𝘩𝘪𝘤𝘩 𝘸𝘰𝘶𝘭𝘥 𝘣𝘦 𝘷𝘦𝘳𝘺 𝘩𝘦𝘭𝘱𝘧𝘶𝘭 𝘧𝘰𝘳 𝘮𝘰𝘳𝘦 𝘵𝘩𝘢𝘯 200 𝘳𝘦𝘤𝘰𝘳𝘥𝘴? 𝘊𝘩𝘦𝘤𝘬 𝘵𝘩𝘪𝘴 𝘲𝘶𝘦𝘳𝘺 𝘰𝘶𝘵. 𝘠𝘰𝘶 𝘤𝘢𝘯 𝘢𝘭𝘴𝘰 𝘶𝘴𝘦 𝘓𝘐𝘒𝘌 𝘪𝘯𝘴𝘵𝘦𝘢𝘥 𝘰𝘧 = 𝘧𝘰𝘳 % 𝘸𝘪𝘭𝘥𝘤𝘢𝘳𝘥.

𝐒𝐢𝐦𝐩𝐥𝐞 𝐒𝐐𝐋𝐬!

𝘞𝘢𝘯𝘵 𝘵𝘰 𝘤𝘰𝘶𝘯𝘵 𝘥𝘪𝘴𝘵𝘪𝘯𝘤𝘵 𝘤𝘰𝘥𝘦𝘴 𝘱𝘦𝘳 𝘵𝘺𝘱𝘦 𝘧𝘰𝘳 𝘤𝘰𝘮𝘮𝘰𝘯 𝘭𝘰𝘰𝘬𝘶𝘱𝘴 𝘪𝘯 𝘖𝘳𝘢𝘤𝘭𝘦 𝘏𝘊𝘔 𝘊𝘭𝘰𝘶𝘥? 🤔 𝘏𝘦𝘳𝘦'𝘴 𝘢 𝘴𝘪𝘮𝘱𝘭𝘦 𝘚𝘘𝘓 𝘲𝘶𝘦𝘳𝘺 𝘵𝘩𝘢𝘵 𝘸𝘪𝘭𝘭 𝘩𝘦𝘭𝘱 𝘺𝘰𝘶 𝘨𝘦𝘵 𝘵𝘩𝘰𝘴𝘦 𝘪𝘯𝘴𝘪𝘨𝘩𝘵𝘴 𝘲𝘶𝘪𝘤𝘬𝘭𝘺 𝘢𝘯𝘥 𝘦𝘢𝘴𝘪𝘭𝘺! 🚀

🔍 What it does:
This query counts the distinct number of lookup codes for each type, helping you understand the distribution of lookups in your Oracle HCM Cloud instance.

🔗 Check out my GitHub for more Simple SQLs and detailed guides! https://github.com/kenfranciscoadamson/Oracle-HCM-Cloud-Data-Reports-using-BIP/blob/main/LookupCode%20Counter%20per%20LookupType.sql



💼 P.S. Visit my Notion Portfolio for more insights and content! 🌟
https://www.notion.so/kennfrancisco/myPortfolio-94effad017e34cc4be7944e494adc387?pm=c

𝐏𝐚𝐫𝐭𝐢𝐚𝐥 𝐏𝐲𝐭𝐡𝐨𝐧
📄 𝘴𝘤𝘳𝘪𝘱𝘵 𝘵𝘰 𝘴𝘯𝘪𝘱𝘱𝘦𝘵 📌

Evaluating multiple models using Mean Absolute Error (MAE) in Python!

𝘧𝘳𝘰𝘮 𝘴𝘬𝘭𝘦𝘢𝘳𝘯.𝘮𝘦𝘵𝘳𝘪𝘤𝘴 𝘪𝘮𝘱𝘰𝘳𝘵 𝘮𝘦𝘢𝘯_𝘢𝘣𝘴𝘰𝘭𝘶𝘵𝘦_𝘦𝘳𝘳𝘰𝘳
# 𝘍𝘶𝘯𝘤𝘵𝘪𝘰𝘯 𝘧𝘰𝘳 𝘤𝘰𝘮𝘱𝘢𝘳𝘪𝘯𝘨 𝘥𝘪𝘧𝘧𝘦𝘳𝘦𝘯𝘵 𝘮𝘰𝘥𝘦𝘭𝘴
𝘥𝘦𝘧 𝘴𝘤𝘰𝘳𝘦_𝘮𝘰𝘥𝘦𝘭(𝘮𝘰𝘥𝘦𝘭, 𝘟_𝘵=𝘟_𝘵𝘳𝘢𝘪𝘯, 𝘟_𝘷=𝘟_𝘷𝘢𝘭𝘪𝘥, 𝘺_𝘵=𝘺_𝘵𝘳𝘢𝘪𝘯, 𝘺_𝘷=𝘺_𝘷𝘢𝘭𝘪𝘥):
𝘮𝘰𝘥𝘦𝘭.𝘧𝘪𝘵(𝘟_𝘵, 𝘺_𝘵)
𝘱𝘳𝘦𝘥𝘴 = 𝘮𝘰𝘥𝘦𝘭.𝘱𝘳𝘦𝘥𝘪𝘤𝘵(𝘟_𝘷)
𝘳𝘦𝘵𝘶𝘳𝘯 𝘮𝘦𝘢𝘯_𝘢𝘣𝘴𝘰𝘭𝘶𝘵𝘦_𝘦𝘳𝘳𝘰𝘳(𝘺_𝘷, 𝘱𝘳𝘦𝘥𝘴)
𝘧𝘰𝘳 𝘪 𝘪𝘯 𝘳𝘢𝘯𝘨𝘦(0, 𝘭𝘦𝘯(𝘮𝘰𝘥𝘦𝘭𝘴)):
𝘮𝘢𝘦 = 𝘴𝘤𝘰𝘳𝘦_𝘮𝘰𝘥𝘦𝘭(𝘮𝘰𝘥𝘦𝘭𝘴[𝘪])
𝘱𝘳𝘪𝘯𝘵("𝘔𝘰𝘥𝘦𝘭 %𝘥 𝘔𝘈𝘌: %𝘥" % (𝘪+1, 𝘮𝘢𝘦))

Discover how I leverage MAE to assess model accuracy. Dive deeper into my projects on Notion!
https://www.notion.so/kennfrancisco/myPortfolio-94effad017e34cc4be7944e494adc387?p=c72d6709e0ab41a584b83070ce4376e0&pm=c

for Data

𝐀𝐧𝐚𝐥𝐲𝐳𝐞 𝐘𝐨𝐮𝐫 𝐃𝐚𝐭𝐚 𝐄𝐚𝐬𝐢𝐥𝐲!

📌 Load and preprocess datasets with Pandas.
📌 Visualize data distributions using Matplotlib histograms.
📌 Create scatter plots to identify relationships.
📌 Calculate and display correlation matrices for insights.

𝘗𝘦𝘳𝘧𝘦𝘤𝘵 𝘧𝘰𝘳 𝘥𝘢𝘵𝘢 𝘴𝘤𝘪𝘦𝘯𝘤𝘦 𝘣𝘦𝘨𝘪𝘯𝘯𝘦𝘳𝘴 𝘢𝘯𝘥 𝘦𝘯𝘵𝘩𝘶𝘴𝘪𝘢𝘴𝘵𝘴!

GitHub link: https://github.com/kenfranciscoadamson/PythonData/blob/main/Analyze.py

Notion portfolio link:
https://www.notion.so/kennfrancisco/myPortfolio-94effad017e34cc4be7944e494adc387

Done with 𝐏𝐚𝐧𝐝𝐚𝐬!

Thanks to Kaggle, Alexis Cook, and Aleksey Bilogur!

What's next? Data Cleaning or Geospatial Analysis 😚

Quick overview on the microcourse:

𝐏𝐚𝐧𝐝𝐚𝐬
𝘚𝘰𝘭𝘷𝘦 𝘴𝘩𝘰𝘳𝘵 𝘩𝘢𝘯𝘥𝘴-𝘰𝘯 𝘤𝘩𝘢𝘭𝘭𝘦𝘯𝘨𝘦𝘴 𝘵𝘰 𝘱𝘦𝘳𝘧𝘦𝘤𝘵 𝘺𝘰𝘶𝘳 𝘥𝘢𝘵𝘢 𝘮𝘢𝘯𝘪𝘱𝘶𝘭𝘢𝘵𝘪𝘰𝘯 𝘴𝘬𝘪𝘭𝘭𝘴.

Lessons
1 𝐂𝐫𝐞𝐚𝐭𝐢𝐧𝐠, 𝐑𝐞𝐚𝐝𝐢𝐧𝐠 𝐚𝐧𝐝 𝐖𝐫𝐢𝐭𝐢𝐧𝐠
𝘠𝘰𝘶 𝘤𝘢𝘯'𝘵 𝘸𝘰𝘳𝘬 𝘸𝘪𝘵𝘩 𝘥𝘢𝘵𝘢 𝘪𝘧 𝘺𝘰𝘶 𝘤𝘢𝘯'𝘵 𝘳𝘦𝘢𝘥 𝘪𝘵. 𝘎𝘦𝘵 𝘴𝘵𝘢𝘳𝘵𝘦𝘥 𝘩𝘦𝘳𝘦.
2 𝐈𝐧𝐝𝐞𝐱𝐢𝐧𝐠, 𝐒𝐞𝐥𝐞𝐜𝐭𝐢𝐧𝐠 & 𝐀𝐬𝐬𝐢𝐠𝐧𝐢𝐧𝐠
𝘗𝘳𝘰 𝘥𝘢𝘵𝘢 𝘴𝘤𝘪𝘦𝘯𝘵𝘪𝘴𝘵𝘴 𝘥𝘰 𝘵𝘩𝘪𝘴 𝘥𝘰𝘻𝘦𝘯𝘴 𝘰𝘧 𝘵𝘪𝘮𝘦𝘴 𝘢 𝘥𝘢𝘺. 𝘠𝘰𝘶 𝘤𝘢𝘯, 𝘵𝘰𝘰!
3 𝐒𝐮𝐦𝐦𝐚𝐫𝐲 𝐅𝐮𝐧𝐜𝐭𝐢𝐨𝐧𝐬 𝐚𝐧𝐝 𝐌𝐚𝐩𝐬
𝘌𝘹𝘵𝘳𝘢𝘤𝘵 𝘪𝘯𝘴𝘪𝘨𝘩𝘵𝘴 𝘧𝘳𝘰𝘮 𝘺𝘰𝘶𝘳 𝘥𝘢𝘵𝘢.
4 𝐆𝐫𝐨𝐮𝐩𝐢𝐧𝐠 𝐚𝐧𝐝 𝐒𝐨𝐫𝐭𝐢𝐧𝐠
𝘚𝘤𝘢𝘭𝘦 𝘶𝘱 𝘺𝘰𝘶𝘳 𝘭𝘦𝘷𝘦𝘭 𝘰𝘧 𝘪𝘯𝘴𝘪𝘨𝘩𝘵. 𝘛𝘩𝘦 𝘮𝘰𝘳𝘦 𝘤𝘰𝘮𝘱𝘭𝘦𝘹 𝘵𝘩𝘦 𝘥𝘢𝘵𝘢𝘴𝘦𝘵, 𝘵𝘩𝘦 𝘮𝘰𝘳𝘦 𝘵𝘩𝘪𝘴 𝘮𝘢𝘵𝘵𝘦𝘳𝘴
5 𝐃𝐚𝐭𝐚 𝐓𝐲𝐩𝐞𝐬 𝐚𝐧𝐝 𝐌𝐢𝐬𝐬𝐢𝐧𝐠 𝐕𝐚𝐥𝐮𝐞𝐬
𝘋𝘦𝘢𝘭 𝘸𝘪𝘵𝘩 𝘵𝘩𝘦 𝘮𝘰𝘴𝘵 𝘤𝘰𝘮𝘮𝘰𝘯 𝘱𝘳𝘰𝘨𝘳𝘦𝘴𝘴-𝘣𝘭𝘰𝘤𝘬𝘪𝘯𝘨 𝘱𝘳𝘰𝘣𝘭𝘦𝘮𝘴
6 𝐑𝐞𝐧𝐚𝐦𝐢𝐧𝐠 𝐚𝐧𝐝 𝐂𝐨𝐦𝐛𝐢𝐧𝐢𝐧𝐠
𝘋𝘢𝘵𝘢 𝘤𝘰𝘮𝘦𝘴 𝘪𝘯 𝘧𝘳𝘰𝘮 𝘮𝘢𝘯𝘺 𝘴𝘰𝘶𝘳𝘤𝘦𝘴. 𝘏𝘦𝘭𝘱 𝘪𝘵 𝘢𝘭𝘭 𝘮𝘢𝘬𝘦 𝘴𝘦𝘯𝘴𝘦 𝘵𝘰𝘨𝘦𝘵𝘩𝘦𝘳

𝐓𝐨𝐩 𝐓𝐚𝐬𝐤 𝐌𝐚𝐧𝐚𝐠𝐞𝐦𝐞𝐧𝐭 𝐒𝐨𝐟𝐭𝐰𝐚𝐫𝐞

by Digital Project Manager | Ben Aston

1. monday.com
2. Wrike
3. ClickUp

𝘍𝘰𝘳 𝘣𝘦𝘨𝘪𝘯𝘯𝘦𝘳𝘴, 𝘐 𝘩𝘪𝘨𝘩𝘭𝘺 𝘳𝘦𝘤𝘰𝘮𝘮𝘦𝘯𝘥 𝘊𝘭𝘪𝘤𝘬𝘜𝘱 𝘴𝘪𝘯𝘤𝘦 𝘪𝘵'𝘴 𝘧𝘳𝘦𝘦 𝘢𝘯𝘥 𝘵𝘩𝘦 𝘢𝘮𝘰𝘶𝘯𝘵 𝘰𝘧 𝘤𝘰𝘮𝘱𝘭𝘦𝘹 𝘧𝘶𝘯𝘤𝘵𝘪𝘰𝘯𝘢𝘭𝘪𝘵𝘪𝘦𝘴 𝘤𝘢𝘯 𝘨𝘪𝘷𝘦 𝘺𝘰𝘶 𝘢𝘯 𝘦𝘥𝘨𝘦 𝘰𝘷𝘦𝘳 𝘱𝘳𝘦𝘮𝘪𝘶𝘮 𝘵𝘰𝘰𝘭𝘴.

article link: https://thedigitalprojectmanager.com/tools/best-task-management-software/

Quick Queries!

𝘕𝘦𝘦𝘥 𝘢 𝘲𝘶𝘪𝘤𝘬 𝘸𝘢𝘺 𝘵𝘰 𝘤𝘰𝘶𝘯𝘵 𝘥𝘪𝘴𝘵𝘪𝘯𝘤𝘵 𝘷𝘢𝘭𝘶𝘦𝘴 𝘧𝘰𝘳 𝘢 𝘤𝘰𝘭𝘶𝘮𝘯 𝘪𝘯 𝘺𝘰𝘶𝘳 𝘖𝘳𝘢𝘤𝘭𝘦 𝘏𝘊𝘔 𝘊𝘭𝘰𝘶𝘥 𝘥𝘢𝘵𝘢? 𝘓𝘦𝘷𝘦𝘳𝘢𝘨𝘦 𝘵𝘩𝘦𝘴𝘦 𝘩𝘢𝘯𝘥𝘺 𝘚𝘘𝘓 𝘲𝘶𝘦𝘳𝘪𝘦𝘴 𝘸𝘪𝘵𝘩𝘪𝘯 𝘺𝘰𝘶𝘳 𝘏𝘙 𝘴𝘺𝘴𝘵𝘦𝘮!

Dive deeper & explore more on my Notion portfolio!
https://www.notion.so/kennfrancisco/myPortfolio-94effad017e34cc4be7944e494adc387?p=cf07f71be9a64ff5bc6ee785189313ce&pm=c

𝘔𝘢𝘬𝘦 𝘴𝘶𝘳𝘦 𝘵𝘰 𝘪𝘯𝘤𝘭𝘶𝘥𝘦 𝘋𝘐𝘚𝘛𝘐𝘕𝘊𝘛 𝘧𝘰𝘳 𝘶𝘯𝘪𝘲𝘶𝘦 𝘥𝘢𝘵𝘢.

𝐒𝐢𝐦𝐩𝐥𝐞 𝐒𝐐𝐋𝐬!

𝘕𝘦𝘦𝘥 𝘵𝘰 𝘤𝘰𝘶𝘯𝘵 𝘵𝘩𝘦 𝘯𝘶𝘮𝘣𝘦𝘳 𝘰𝘧 𝘦𝘮𝘱𝘭𝘰𝘺𝘦𝘦𝘴 𝘸𝘪𝘵𝘩 𝘪𝘯𝘷𝘢𝘭𝘪𝘥 𝘰𝘳 𝘯𝘶𝘭𝘭 𝘉𝘢𝘳𝘨𝘢𝘪𝘯𝘪𝘯𝘨 𝘜𝘯𝘪𝘵 𝘥𝘢𝘵𝘢 𝘪𝘯 𝘖𝘳𝘢𝘤𝘭𝘦 𝘏𝘊𝘔 𝘊𝘭𝘰𝘶𝘥? 𝘛𝘩𝘪𝘴 𝘲𝘶𝘪𝘤𝘬 𝘚𝘘𝘓 𝘲𝘶𝘦𝘳𝘺 𝘤𝘢𝘯 𝘩𝘦𝘭𝘱 𝘺𝘰𝘶 𝘨𝘳𝘢𝘣 𝘵𝘩𝘢𝘵 𝘪𝘯𝘧𝘰 𝘪𝘯 𝘢 𝘧𝘭𝘢𝘴𝘩! ✨

Here's the code: https://github.com/kenfranciscoadamson/Oracle-HCM-Cloud-Data-Reports-using-BIP/blob/main/Counter%20for%20BargainingUnit(null%20and%20invalid).sql

What it does:
Counts the distinct number of PERSON_NUMBERs with either 'INVALID' or 'NULL' Bargaining Unit data.



P.S. Check out my portfolio at Notion for more Simple SQLs and other content! (https://www.notion.so/kennfrancisco/myPortfolio-94effad017e34cc4be7944e494adc387)

𝐅𝐢𝐯𝐞 𝐒𝐭𝐞𝐩𝐬 𝐭𝐨 𝐚 𝐅𝐚𝐬𝐭𝐞𝐫 𝐌𝐞𝐭𝐚𝐛𝐨𝐥𝐢𝐬𝐦

#1 - Strength train.
#2 - Eat more protein and food.
#3 - Get good sleep.
#4 - Balance hormones.
#5 - Walk after meals.

Strength train doesn't mean HIIT or crossfit ;) A good number for daily protein intake is n grams = target bodyweight in pounds (145 lbs = 145 grams of protein)

MindPump episode: https://mindpumppodcast.com/2372-five-steps-to-a-faster-metabolism/

𝐏𝐚𝐫𝐭𝐢𝐚𝐥 𝐏𝐲𝐭𝐡𝐨𝐧
📄 𝘴𝘤𝘳𝘪𝘱𝘵 𝘵𝘰 𝘴𝘯𝘪𝘱𝘱𝘦𝘵 📌

💡 Aggregating Results

"𝘈𝘨𝘨𝘳𝘦𝘨𝘢𝘵𝘪𝘯𝘨 𝘢𝘯𝘥 𝘱𝘪𝘷𝘰𝘵𝘪𝘯𝘨 𝘳𝘢𝘤𝘦 𝘳𝘦𝘴𝘶𝘭𝘵𝘴 𝘵𝘰 𝘴𝘶𝘮𝘮𝘢𝘳𝘪𝘻𝘦 𝘥𝘳𝘪𝘷𝘦𝘳 𝘱𝘦𝘳𝘧𝘰𝘳𝘮𝘢𝘯𝘤𝘦. 𝘛𝘩𝘪𝘴 𝘴𝘯𝘪𝘱𝘱𝘦𝘵 𝘪𝘴 𝘬𝘦𝘺 𝘵𝘰 𝘵𝘳𝘢𝘯𝘴𝘧𝘰𝘳𝘮𝘪𝘯𝘨 𝘳𝘢𝘸 𝘥𝘢𝘵𝘢 𝘪𝘯𝘵𝘰 𝘪𝘯𝘴𝘪𝘨𝘩𝘵𝘧𝘶𝘭 𝘴𝘶𝘮𝘮𝘢𝘳𝘪𝘦𝘴."

Check out the full script here: https://github.com/kenfranciscoadamson/PythonData/blob/main/F1_DashBoard.py

Check out my portfolio: https://www.notion.so/kennfrancisco/myPortfolio-94effad017e34cc4be7944e494adc387

𝐏𝐚𝐫𝐭𝐢𝐚𝐥 𝐏𝐲𝐭𝐡𝐨𝐧
📄 𝘴𝘤𝘳𝘪𝘱𝘵 𝘵𝘰 𝘴𝘯𝘪𝘱𝘱𝘦𝘵 📌

📊 Visualizing Race Data
"𝘊𝘳𝘦𝘢𝘵𝘪𝘯𝘨 𝘢 𝘩𝘦𝘢𝘵𝘮𝘢𝘱 𝘵𝘰 𝘷𝘪𝘴𝘶𝘢𝘭𝘪𝘻𝘦 𝘵𝘩𝘦 𝘱𝘰𝘪𝘯𝘵𝘴 𝘴𝘤𝘰𝘳𝘦𝘥 𝘣𝘺 𝘥𝘳𝘪𝘷𝘦𝘳𝘴 𝘢𝘤𝘳𝘰𝘴𝘴 𝘢𝘭𝘭 𝘳𝘢𝘤𝘦𝘴. 𝘛𝘩𝘪𝘴 𝘴𝘯𝘪𝘱𝘱𝘦𝘵 𝘣𝘦𝘢𝘶𝘵𝘪𝘧𝘶𝘭𝘭𝘺 𝘱𝘳𝘦𝘴𝘦𝘯𝘵𝘴 𝘵𝘩𝘦 𝘥𝘢𝘵𝘢!"

Check out the full script here: https://github.com/kenfranciscoadamson/PythonData/blob/main/F1_DashBoard.py

Check out my portfolio: https://www.notion.so/kennfrancisco/myPortfolio-94effad017e34cc4be7944e494adc387

𝐏𝐚𝐫𝐭𝐢𝐚𝐥 𝐏𝐲𝐭𝐡𝐨𝐧
📄 𝘴𝘤𝘳𝘪𝘱𝘵 𝘵𝘰 𝘴𝘯𝘪𝘱𝘱𝘦𝘵 📌

🔍 Fetching Race Data
"𝘋𝘦𝘧𝘪𝘯𝘪𝘯𝘨 𝘧𝘶𝘯𝘤𝘵𝘪𝘰𝘯𝘴 𝘵𝘰 𝘧𝘦𝘵𝘤𝘩 𝘵𝘩𝘦 𝘳𝘢𝘤𝘦 𝘴𝘤𝘩𝘦𝘥𝘶𝘭𝘦 𝘢𝘯𝘥 𝘳𝘦𝘴𝘶𝘭𝘵𝘴 𝘧𝘰𝘳 𝘦𝘢𝘤𝘩 𝘳𝘰𝘶𝘯𝘥 𝘰𝘧 𝘵𝘩𝘦 𝘴𝘦𝘢𝘴𝘰𝘯. 𝘛𝘩𝘪𝘴 𝘴𝘯𝘪𝘱𝘱𝘦𝘵 𝘴𝘦𝘵𝘴 𝘵𝘩𝘦 𝘧𝘰𝘶𝘯𝘥𝘢𝘵𝘪𝘰𝘯 𝘧𝘰𝘳 𝘦𝘹𝘵𝘳𝘢𝘤𝘵𝘪𝘯𝘨 𝘥𝘢𝘵𝘢 𝘧𝘳𝘰𝘮 𝘵𝘩𝘦 𝘌𝘳𝘨𝘢𝘴𝘵 𝘈𝘗𝘐."

Check out the full script here: https://github.com/kenfranciscoadamson/PythonData/blob/main/F1_DashBoard.py

for Data!

𝐕𝐢𝐬𝐮𝐚𝐥𝐢𝐳𝐞 𝐂𝐮𝐫𝐫𝐞𝐧𝐭 𝐅1 𝐃𝐫𝐢𝐯𝐞𝐫 𝐒𝐭𝐚𝐧𝐝𝐢𝐧𝐠𝐬
📌 Fetches F1 data from Ergast in real-time.
📌 Uses visualizations in the form of interactive heatmaps via Plotly.
📌 Includes an informative log at console to confirm whether race data is available or not.

𝘎𝘳𝘦𝘢𝘵 𝘧𝘰𝘳 𝘍1 𝘦𝘯𝘵𝘩𝘶𝘴𝘪𝘢𝘴𝘵𝘴 𝘢𝘯𝘥 𝘥𝘢𝘵𝘢 𝘷𝘪𝘴𝘶𝘢𝘭𝘪𝘻𝘢𝘵𝘪𝘰𝘯 𝘣𝘦𝘨𝘪𝘯𝘯𝘦𝘳𝘴!

GitHub link: https://github.com/kenfranciscoadamson/PythonData/blob/main/F1_DashBoard.py

Hello friends!

Just updated my F1 Dashboard at myPorfolio in Notion (https://www.notion.so/kennfrancisco/myPortfolio-94effad017e34cc4be7944e494adc387?p=60dabce36e9d4ec09855c6c544cd0f15&pm=c)

Please check it out! Here's the github repo with the Python codes: https://github.com/kenfranciscoadamson/PythonData

AustrianGP was one hell of a ride (people are still pointing fingers at this moment) 😅 Looking forward to finish our triple header with the BritishGP

27 𝐁𝐞𝐬𝐭 𝐖𝐨𝐫𝐤𝐟𝐥𝐨𝐰 𝐌𝐚𝐧𝐚𝐠𝐞𝐦𝐞𝐧𝐭 𝐒𝐨𝐟𝐭𝐰𝐚𝐫𝐞 𝐅𝐨𝐫 𝐄𝐟𝐟𝐢𝐜𝐢𝐞𝐧𝐭 𝐃𝐞𝐥𝐢𝐯𝐞𝐫𝐲 𝐈𝐧 2024 🎆

By Digital Project Manager | Ben Aston

1. monday.com — Best for automating manual processes
2. Wrike — Best for reconnecting siloed teams
3. Jira — Best for agile project tracking
4. Celoxis — Best for being a robust, enterprise-grade workflow system
5. Process Street — Best for process documentation
6. ClickUp — 100 free uses of basic workflow tools + charts
7. Kissflow Workflow — Best for workflow templates
8. Qntrl — Best for workflow orchestration
9. Jotform — Best for B2B-oriented enterprises
10. Miro — Best for workflow flowcharts & mind maps
11. Quickbase
12. Kissflow
13. Quixy
14. Nifty
15. Pipefy
16. Forecast
17. Cflow
18. Kintone
19. DocuWare
20. Avaza
21. Asana
22. Camunda Platform
23. Planview Clarizen
24. ProcessMaker
25. ProWorkflow
26. Next Matter
27. beSlick

𝘗𝘦𝘳𝘴𝘰𝘯𝘢𝘭𝘭𝘺 𝘸𝘪𝘭𝘭 𝘢𝘵𝘵𝘦𝘴𝘵 𝘵𝘰 𝘮𝘰𝘯𝘥𝘢𝘺.𝘤𝘰𝘮, 𝘊𝘭𝘪𝘤𝘬𝘜𝘱, 𝘑𝘪𝘳𝘢, 𝘔𝘪𝘳𝘰 𝘢𝘯𝘥 𝘈𝘴𝘢𝘯𝘢! (𝘕𝘰 𝘭𝘰𝘷𝘦 𝘧𝘰𝘳 𝘛𝘳𝘦𝘭𝘭𝘰?)

27 𝐁𝐞𝐬𝐭 𝐖𝐨𝐫𝐤𝐟𝐥𝐨𝐰 𝐌𝐚𝐧𝐚𝐠𝐞𝐦𝐞𝐧𝐭 𝐒𝐨𝐟𝐭𝐰𝐚𝐫𝐞 𝐅𝐨𝐫 𝐄𝐟𝐟𝐢𝐜𝐢𝐞𝐧𝐭 𝐃𝐞𝐥𝐢𝐯𝐞𝐫𝐲 𝐈𝐧 2024 🎆

By Digital Project Manager | Ben Aston

1. monday.com — Best for automating manual processes
2. Wrike — Best for reconnecting siloed teams
3. Jira — Best for agile project tracking
4. Celoxis — Best for being a robust, enterprise-grade workflow system
5. Process Street — Best for process documentation
6. ClickUp — 100 free uses of basic workflow tools + charts
7. Kissflow Workflow — Best for workflow templates
8. Qntrl — Best for workflow orchestration
9. Jotform — Best for B2B-oriented enterprises
10. Miro — Best for workflow flowcharts & mind maps
11. Quickbase
12. Kissflow
13. Quixy
14. Nifty
15. Pipefy
16. Forecast
17. Cflow
18. Kintone
19. DocuWare
20. Avaza
21. Asana
22. Camunda Platform
23. Planview Clarizen
24. ProcessMaker
25. ProWorkflow
26. Next Matter
27. beSlick

Article link: https://thedigitalprojectmanager.com/tools/workflow-management-software/ -reviews

𝘗𝘦𝘳𝘴𝘰𝘯𝘢𝘭𝘭𝘺 𝘸𝘪𝘭𝘭 𝘢𝘵𝘵𝘦𝘴𝘵 𝘵𝘰 𝘮𝘰𝘯𝘥𝘢𝘺.𝘤𝘰𝘮, 𝘊𝘭𝘪𝘤𝘬𝘜𝘱, 𝘑𝘪𝘳𝘢, 𝘔𝘪𝘳𝘰 𝘢𝘯𝘥 𝘈𝘴𝘢𝘯𝘢! (𝘕𝘰 𝘭𝘰𝘷𝘦 𝘧𝘰𝘳 𝘛𝘳𝘦𝘭𝘭𝘰?)

Quick Queries!

Level up your HR analytics in Oracle HCM Cloud with these handy SQL queries! 𝘚𝘶𝘤𝘤𝘦𝘴𝘴𝘧𝘶𝘭𝘭𝘺 𝘧𝘦𝘵𝘤𝘩 𝘥𝘢𝘵𝘢 𝘧𝘳𝘰𝘮 𝘦𝘪𝘵𝘩𝘦𝘳 𝘤𝘰𝘭𝘶𝘮𝘯𝘴 𝘪𝘯 𝘢 𝘵𝘢𝘣𝘭𝘦.
📌 If either columns has a data while the other is null, it'll show the row.
📌 If neither columns has data, it will not show the row.
📌 Of course, if there's data at both columns, the row will show also.
📌 This will avoid duplicated rows.

Get the full toolkit on my GitHub & learn how to write your own queries! https://github.com/kenfranciscoadamson/Oracle-HCM-Cloud-Data-Reports-using-BIP

These are also available at my portfolio: https://kennfrancisco.notion.site/myPortfolio-94effad017e34cc4be7944e494adc387?pvs=4

𝐒𝐢𝐦𝐩𝐥𝐞 𝐒𝐐𝐋𝐬!

𝘕𝘦𝘦𝘥 𝘵𝘰 𝘴𝘦𝘦 𝘸𝘩𝘪𝘤𝘩 𝘈𝘤𝘵𝘪𝘰𝘯𝘴 𝘩𝘢𝘷𝘦 either 𝘙𝘰𝘭𝘦𝘴 𝘰𝘳 𝘈𝘴𝘴𝘪𝘨𝘯𝘮𝘦𝘯𝘵 𝘚𝘵𝘢𝘵𝘶𝘴 𝘥𝘢𝘵𝘢 𝘪𝘯 𝘖𝘳𝘢𝘤𝘭𝘦 𝘏𝘊𝘔 𝘊𝘭𝘰𝘶𝘥? 𝘛𝘩𝘦𝘴𝘦 𝘲𝘶𝘪𝘤𝘬 𝘚𝘘𝘓 𝘲𝘶𝘦𝘳𝘪𝘦𝘴 𝘤𝘢𝘯 𝘩𝘦𝘭𝘱 𝘺𝘰𝘶 𝘨𝘳𝘢𝘣 𝘵𝘩𝘢𝘵 𝘪𝘯𝘧𝘰 𝘪𝘯 𝘢 𝘧𝘭𝘢𝘴𝘩! ✨

Check out the code on GitHub: https://github.com/.../Actions%20with%20Roles%20or...

Please check out my portfolio at Notion, also (link: https://kennfrancisco.notion.site/myPortfolio...) where I compile these Simple SQLs of mine, as well as other stuff that I discussed.