PinnedPooja ChavanData Exploration with SQL — Building a Pareto Table⭐What is it: The Pareto chart analysis is a statistical graphical technique used to map and rank business process problems starting from…2 min read·Oct 4, 2022----
Pooja Chavan‘Car Purchases’ Dashboard in TableauWith over 11000 records, the simple dashboard explores and decodes the buying patterns from a fictitious car retailer in each month of year…1 min read·Mar 4, 2024----
Pooja Chavan#Real World Fake Data: ‘ER Visits’ Dashboard in TableauLoved recreating this popular viz using Marginal Bar Charts.1 min read·Mar 1, 2024----
Pooja ChavanAnatomy/Parts of a SQL StatementSQL is the standard language for talking with RDBMS. Extensively used in all data-related roles and with English-like syntax, beginner SQL…1 min read·Feb 2, 2024----
Pooja ChavanStatistical Analysis using SQL.The mighty SELECT statement is quite versatile. In addition to cleaning/wrangling data, below are some of the ways it helps in initial…1 min read·Feb 1, 2024----
Pooja ChavanData Cleaning with SQL- Identifying Duplicate RowsGenerally speaking, a table should have unique constraints to prevent duplication of values into specific column/s. However, you may find…1 min read·Oct 5, 2022----
Pooja ChavanSQL bits & bytes-Best PracticesThese pertain to general SQL programming.3 min read·Jan 29, 2021----