PinnedKingsley OkoyeEXTRACT 200 TABLES FROM ANY SQL DATABASE WITH JUST 20 LINES OF CODE.Have you ever been in a situation where you were instructed to explore a database and you started looking forward to it, your fingers…Feb 255Feb 255
PinnedKingsley OkoyeHOW TO AUTOMATE YOUR DASHBOARD REPORT USING PYTHON, SQL AND POWER BI.(DYNAMIC REPORTING EVERY BUSINESS NEEDS)Oct 15, 2023Oct 15, 2023
Kingsley OkoyeBEFORE YOU WRITE YOUR NEXT SQL JOIN STATEMENT, MAKE SURE TO AVOID THIS MISTAKE.The good thing about working with real world data is that you get to learn concepts you would never have learnt working with sample…3d ago3d ago
Kingsley OkoyeHOW TO MANAGE MANY TO MANY RELATIONSHIPS (MUST KNOW DATA MODELLING SKILL).Data modelling is an integral part of the data cleaning/integration process that cannot be overemphasized considering how it can make or…4d ago4d ago
Kingsley OkoyeHOW ANY BUSINESS CAN START KEEPING TRACK OF THEIR BUSINESS PROFITABILITY WITH SQL.I am of the opinion that if some large scale business decided to do an in-depth profit analysis of their business, they would either be:5d ago5d ago
Kingsley OkoyeHOW TO LOAD DATA INTO GOOGLE BIG QUERY USING PYTHON IN 10 MINUTES.We have all seen the ADS on youtube, websites and possibly our Gmail promotion inbox. Google Big query is garnering more and more adoption…5d ago5d ago
Kingsley OkoyeIMPLEMENT INCREMENTAL DATA LOAD ETL WITH SQL (FOR LARGE DATASETS AND REAL WORLD SCENARIOS)May 251May 251
Kingsley OkoyeTHIS SIMPLE SQL FUNCTION WILL OPTIMIZE YOUR ETL PROCESS.One process you will have to go through as a data engineer or analytics engineer even sometimes as a data analyst is integrating new data…May 193May 193
Kingsley OkoyeHow do you solve this problem as a data/business analyst? SQL challenge.When you start you journey as a data analyst or business analyst, you tend to practice with datasets where all data needed to arrive at…Apr 253Apr 253