Mayuri Awati

Mayuri Awati

15 followers

Welcome to my data-diaries world! Join me on a simplified journey through the realm of data analysis, where I unravel complex concepts and transform them into easily digestible insights.

Types of metrics that every analyst should know

Mar 16, 20244 min read

Understanding the metrics used for analyzing businesses is essential for informed decision-making and strategic planning. In the world of data...

Types of metrics that every analyst should know

Choosing the Good Metrics for Your Analysis

Feb 9, 20243 min read

Data analytics is all about tracking the metrics that are critical for a business and business stakeholders. But it's tricky to choose the right kind...

Choosing the Good Metrics for Your Analysis

window ranking functions in SQL

Aug 19, 20237 min read

Ranking functions are one of the most commonly used Window functions in Data analysis these functions provide you with the tools to assign ranks,...

window ranking functions in SQL

Window framing in SQL window function.

Jul 29, 20238 min read

what are window functions in SQL? Window functions, also known as windowing or analytical functions, are a powerful feature in SQL that allows you to...

Window framing in SQL window function.

Story of Granularity in Data Analysis.

Jul 22, 20238 min read

Introduction: In the world of data analytics, one fundamental concept that holds immense importance is granularity. Imagine yourself as a master chef...

Story of Granularity in Data Analysis.

Traps and Tricks: The Art of Filtering Joined Data in SQL

Jul 21, 20235 min read

As an SQL developer, you may be well-versed in the power and versatility of JOINs, essential for combining data from multiple tables. While JOINs are...

Traps and Tricks: The Art of Filtering Joined Data in SQL