The Analyst Geek

"Data in Focus, Insights Unveiled"

5 Followers

Pune, Maharashtra

Member Since Nov, 2022

Writes at

The Analyst Geek

theanalystgeek.hashnode.dev

Read the blog

About Me

I am a data enthusiast who finds joy in working with data, utilizing my skills to extract meaningful and valuable insights from it.

My Tech Stack

SQL PostgreSQL Python 3 Databases data analyst pandas

I am available for

Assistance | Teaching | Working | Playing Cricket & Call of Duty

Badges

Word Warrior

Earned on Jul 23, 2023

Self Starter

Earned on Mar 18, 2023

Recent Activity

Aug 18

Wrote an article

Different database design approaches Star schema and Relational schema.

Aug 17

Wrote an article

Just Steps to Append and Merge data using Power Query in Power BI

Aug 14

Wrote an article

Difference between Fact and Dimension tables in SQL/Power BI with example.

Aug 12

Wrote an article

Exploring the WITHIN GROUP Clause in PostgreSQL

Aug 3

Wrote an article

How to Handle Null Values in SQL

Aug 1

Wrote an article

Using SQL with Python & R for Data Analysis

Jul 30

Wrote an article

Optimized SQL Queries for Daily Use !

Jul 29

Wrote an article

Performing Change Data Capture (CDC) without Timestamp Columns using SQL

Jul 27

Wrote an article

Create Library DB from scratch go through these queries & appear for interview !

Jul 26

Wrote an article

Understand over() clause in comparison with group by and equivalent code [using inner join and subquery].