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