Olamidequzeem91Outliers: What are they, and how to spot and treat them?As data professionals, it’s quite imperative for us to spot and mitigate outliers during our analysis, as they are always ever-present in…Aug 9, 20231Aug 9, 20231
Olamidequzeem91Transforming Axis in Data AnalyticsAxis transformation is a fundamental technique used in data analysis and visualization to enhance the interpretation and insights derived…Jul 25, 2023Jul 25, 2023
Olamidequzeem91𝐃𝐚𝐭𝐚 𝐂𝐥𝐞𝐚𝐧𝐢𝐧𝐠 𝐯𝐬. 𝐃𝐚𝐭𝐚 𝐓𝐫𝐚𝐧𝐬𝐟𝐨𝐫𝐦𝐚𝐭𝐢𝐨𝐧Data cleaning and data transformation are two important steps in the data preparation process to ensure that data is suitable for analysis…Jul 20, 2023Jul 20, 2023
Olamidequzeem91SQL: Making Unrelated Columns appear side-by-sideHave you ever wanted to make columns from unrelated tables appear side by side in your query results?Jul 14, 2023Jul 14, 2023
Olamidequzeem91GCGO: Empowerment of WomenFor my GCGO, I decided to play a part in addressing “Empowerment of Women” and as part of Milestone 3, I am required to formulate a problem…May 30, 2023May 30, 2023
Olamidequzeem91SQL: RANK Vs. DENSE_RANKIn this post, I will be discussing the major difference between RANK and DENSE_RANK, two important SQL window functions commonly used in…May 27, 2023May 27, 2023
Olamidequzeem91SQL: Why Append Query Result???As a Data Analyst, appending query results might be the key to conducting a thorough and effective data analysis. Data Analysts end up…May 26, 2023May 26, 2023
Olamidequzeem91𝐂𝐚𝐬𝐞 𝐒𝐭𝐚𝐭𝐞𝐦𝐞𝐧𝐭: 𝐓𝐡𝐞 𝐈𝐅-𝐄𝐋𝐒𝐄 𝐨𝐟 𝐒𝐐𝐋The SQL Case statement allows for conditional logic in a SQL query, similar to how 𝐈𝐅-𝐄𝐋𝐒𝐄 statements work in other programming…May 19, 2023May 19, 2023
Olamidequzeem91SQL: Why Common Table Expressions(CTEs)???As a Data Analyst, the need to make one SQL query clear and readable can’t be overstated enough, as they help team members understand the…May 18, 2023May 18, 2023