PinnedKingsley Okoye·Apr 25, 2024How 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…A response icon3A response icon3
PinnedKingsley Okoye·Aug 25, 2024HOW 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…
Kingsley Okoye·Jun 8How to use AI to optimize your marketing agency’s performance using data. (Simple one time set up)These are the kind of beneficial business insights I get for my clients when I set up AI to investigate and provide recommendations.
Kingsley Okoye·Mar 19How I discovered over $15,000 waste in google ad spend for huge e commerce business.How I discovered over $10,000 in ad spend waste
Kingsley Okoye·Mar 15Set up shopify data collection and analysis automatically using windsor.ai — Part 2.I recently wrote an article about how you can set up automated collection and analysis of your shopify data, in that article I outlined the…
Kingsley Okoye·Mar 10How to set up collection and analysis of your shopify data automatically using windsor.ai.You’ve started selling on shopify or you have a client selling on shopify, recently they/you decided to start tracking and analyzing…A response icon1A response icon1
Kingsley Okoye·Jul 23, 20257 looker studio challenges you will face and how you can handle them.Looker Studio (formerly Google Data Studio) has become a go-to tool for building dashboards and visualizing data especially for marketers…A response icon1A response icon1
Kingsley Okoye·Nov 5, 2024GET A CLEAR UNDERSTANDING OF ANY WEBSITE’S GA4 METRICS USING BIG QUERY AND LOOKER STUDIO.With GA4, Google empowers you with the ability to track nearly every aspect of activity on your website using the extensive data it…A response icon1A response icon1
Kingsley Okoye·Sep 21, 2024HOW TO GENERATE FAKE DATA FOR YOUR NEXT DATA PROJECT.Projects are extremely important when trying to showcase your skills to potential recruiters and employers as a data professional, while…
Kingsley Okoye·Aug 27, 2024BEFORE 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…A response icon4A response icon4