---
title: "The Analyst Geek (@theanalystgeek) | Hashnode"
description: "\"Data in Focus, Insights Unveiled\". Read the latest articles by The Analyst Geek on Hashnode."
url: "https://hashnode.com/@theanalystgeek"
---

@theanalystgeek

# The Analyst Geek

@theanalystgeek · Pune, Maharashtra · Joined November 2022

"Data in Focus, Insights Unveiled"

### [Different database design approaches Star schema and Relational schema.](https://theanalystgeek.hashnode.dev/different-database-design-approaches-star-schema-and-relational-schema?utm_source=hashnode&utm_medium=feed)

Star Schema and Relational Schema are both database design approaches used to structure data for efficient storage and querying, but they have different focuses and characteristics. Let's explore the differences between them: Data Modeling Approach:...

2 min read · [theanalystgeek.hashnode.dev](https://theanalystgeek.hashnode.dev/different-database-design-approaches-star-schema-and-relational-schema?utm_source=hashnode&utm_medium=feed)

[Aug 18, 2023](https://hashnode.com/posts/different-database-design-approaches-star-schema-and-relational-schema/64dfcc267fd7eaefad73f59b)

### [Just Steps to Append and Merge data using Power Query in Power BI](https://theanalystgeek.hashnode.dev/just-steps-to-append-and-merge-data-using-power-query-in-power-bi?utm_source=hashnode&utm_medium=feed)

Difference between Append and Merge Merge queries can combine tables with different numbers of columns(it is simply a), while append queries require tables to have the same number of columns. Appending Files and tables in Power BI (Power Query) Appe...

2 min read · [theanalystgeek.hashnode.dev](https://theanalystgeek.hashnode.dev/just-steps-to-append-and-merge-data-using-power-query-in-power-bi?utm_source=hashnode&utm_medium=feed)

[Aug 17, 2023](https://hashnode.com/posts/just-steps-to-append-and-merge-data-using-power-query-in-power-bi/64de072acf083d013516dfd0)

### [Difference between Fact and Dimension tables in SQL/Power BI with example.](https://theanalystgeek.hashnode.dev/difference-between-fact-and-dimension-tables-in-sqlpower-bi-with-example?utm_source=hashnode&utm_medium=feed)

Quick Introduction Fact and dimension tables are two fundamental concepts in data warehousing and database design. They serve different roles in organizing and storing data for efficient analysis. Here's the difference between them: Key Differences b...

6 min read · [theanalystgeek.hashnode.dev](https://theanalystgeek.hashnode.dev/difference-between-fact-and-dimension-tables-in-sqlpower-bi-with-example?utm_source=hashnode&utm_medium=feed)

[Aug 14, 2023](https://hashnode.com/posts/difference-between-fact-and-dimension-tables-in-sqlpower-bi-with-example/64da87d7311640e9f8188645)

### [Exploring the WITHIN GROUP Clause in PostgreSQL](https://theanalystgeek.hashnode.dev/exploring-the-within-group-clause-in-postgresql?utm_source=hashnode&utm_medium=feed)

What is WITHIN GROUP CLAUSE in PostgreSQL? The WITHIN GROUP clause is a special part of SQL that helps you control how data is grouped and processed when you're using ordered-set aggregate functions. The WITHIN GROUP clause is particularly useful whe...

5 min read · [theanalystgeek.hashnode.dev](https://theanalystgeek.hashnode.dev/exploring-the-within-group-clause-in-postgresql?utm_source=hashnode&utm_medium=feed)

[Aug 12, 2023](https://hashnode.com/posts/exploring-the-within-group-clause-in-postgresql/64d80b944cdaba4b71516729)

### [How to Handle Null Values in SQL](https://theanalystgeek.hashnode.dev/how-to-handle-null-values-in-sql?utm_source=hashnode&utm_medium=feed)

Understanding Null Values in SQL In SQL, a null value represents the absence of a value for a specific data field. It is not the same as zero or an empty string; rather, it signifies that the data is unknown or not applicable. It's important to recog...

2 min read · [theanalystgeek.hashnode.dev](https://theanalystgeek.hashnode.dev/how-to-handle-null-values-in-sql?utm_source=hashnode&utm_medium=feed)

[Aug 3, 2023](https://hashnode.com/posts/how-to-handle-null-values-in-sql/64cbc82d6e24d7b2787dbe00)
