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…Oct 4, 2022Oct 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…Mar 4Mar 4
Pooja Chavan#Real World Fake Data: ‘ER Visits’ Dashboard in TableauLoved recreating this popular viz using Marginal Bar Charts.Mar 1Mar 1
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…Feb 2Feb 2
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…Feb 1Feb 1
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…Oct 5, 2022Oct 5, 2022
Pooja ChavanSQL bits & bytes-Best PracticesThese pertain to general SQL programming.Jan 29, 2021Jan 29, 2021