Tableau Public
Tableau Public is a free platform to publicly share and explore data visualizations online. With Tableau Public, all […]
Blog
Principles of Graphic Design
The principles of graphic design are as follows, according to ChatGPT. While graphic design is a broad concept, […]
SQL Subqueries
Subqueries (also known as inner queries or nested queries) are a tool for performing operations in multiple steps. […]
SQL GROUP BY HAVING
Summarizing tables with GROUP BY is very common and a must-have skill for the data analyst. This post […]
SQL Server COUNT DISTINCT
You can count the number of unique values in a column with COUNT DISTINCT. The Microsoft Press book […]
Excel Filtering
This post is about filtering in Excel. For information on the FILTER function have a look at our […]
Excel Sort Function
The new Excel SORT function is one of the new dynamic arrays that are available in Microsoft 365. […]
Excel Dynamic Arrays
What are dynamic arrays in Excel? Dynamic arrays are new to Excel and are available in Microsoft 365 […]
Excel’s Hash Reference
What is the hash symbol that you see in some formulas? What does it do? If you have […]
Sorted Data Validation List
In Excel, in Microsoft 365, how do you sort your dropdown data validation list? You have a cell […]
SQL Temp Tables
Let’s discuss temporary tables in Microsoft’s T-SQL. Temporary tables have a hash (#) at the start of their […]
Cleaning Data with Alex
This post is based on a video on YouTube by Alex the Analyst. Thanks Alex. Learn with YouTube […]