128K views · 1.1K reactions | Similar to using DISTINCT COUNT in SQL, did you know that you can use DISTINCT COUNT in your pivot tables as well to count the number of unique values? This is a lesser-known feature of Excel that is really helpful in analyzing unique values in your pivot table without needing to create separate tables! #Excel #Data #datascience #analyst #corporatelife  | Excelwithkyle23 | Facebook

SQL IF Statement for Conditional Logic

SQL IF Statement introduction and overview

IF-THEN logic in SELECT and WHERE with CASE expressions in Oracle SQL

SQL PIVOT and SQL UNPIVOT Examples to Transform Data