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…3 min read·Aug 9, 2023--1--1
Olamidequzeem91Transforming Axis in Data AnalyticsAxis transformation is a fundamental technique used in data analysis and visualization to enhance the interpretation and insights derived…3 min read·Jul 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…2 min read·Jul 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?1 min read·Jul 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…2 min read·May 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…2 min read·May 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…2 min read·May 26, 2023----
Olamidequzeem91𝐂𝐚𝐬𝐞 𝐒𝐭𝐚𝐭𝐞𝐦𝐞𝐧𝐭: 𝐓𝐡𝐞 𝐈𝐅-𝐄𝐋𝐒𝐄 𝐨𝐟 𝐒𝐐𝐋The SQL Case statement allows for conditional logic in a SQL query, similar to how 𝐈𝐅-𝐄𝐋𝐒𝐄 statements work in other programming…2 min read·May 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…2 min read·May 18, 2023----