PinnedData 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
‘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 4, 2024Mar 4, 2024
#Real World Fake Data: ‘ER Visits’ Dashboard in TableauLoved recreating this popular viz using Marginal Bar Charts.Mar 1, 2024Mar 1, 2024
Anatomy/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 2, 2024Feb 2, 2024
Statistical 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 1, 2024Feb 1, 2024
Data 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
