Tableau Basic DefinitionsIf you want to jump right in to working with Tableau you may want to skip this post […] March 1, 2023 in Data Visualization tagged Tableau / introduction / Tableau by Mike
Pre-attentive AttributesWhat do we mean by pre-attentive attributes? To define this we’ll go back and first look at a […] February 28, 2023 in Data Visualization tagged design / attributes / user / brain by Mike
Design ThinkingDesign thinking is a process used to solve complex problems in a user-centric way. It uses empathy for […] February 26, 2023 in Data Visualization tagged visualization / chart / thinking / design by Mike
Elements of Art in Data VizBoth data analysts and artists use elements of art in their work. A few of the main elements […] February 26, 2023 in Data Visualization tagged art / data / visualization / artistic by Mike
Tableau PublicTableau Public is a free platform to publicly share and explore data visualizations online. With Tableau Public, all […] February 23, 2023 in Data Visualization tagged viz / Tableau / data / file / free / visualization / saving / save / Tableau by Mike
Principles of Graphic DesignThe principles of graphic design are as follows, according to ChatGPT. While graphic design is a broad concept, […] February 22, 2023 in Data Visualization tagged graphic / principle / nine / 9 / graphics by Mike
SQL SubqueriesSubqueries (also known as inner queries or nested queries) are a tool for performing operations in multiple steps. […] February 16, 2023 in SQL tagged join / subquery / subqueries by Mike
SQL GROUP BY HAVINGSummarizing tables with GROUP BY is very common and a must-have skill for the data analyst. This post […] February 16, 2023 in SQL tagged having / group / by by Mike
SQL Server COUNT DISTINCTYou can count the number of unique values in a column with COUNT DISTINCT. The Microsoft Press book […] February 13, 2023 in SQL Server tagged unique / sql / distinct / count / SQL Count by Mike
Excel FilteringThis post is about filtering in Excel. For information on the FILTER function have a look at our […] February 12, 2023 in Excel tagged location / copy / select / filter / advanced by Mike
Excel Sort FunctionThe new Excel SORT function is one of the new dynamic arrays that are available in Microsoft 365. […] February 12, 2023 in Excel tagged function / dynamic / sort / arrays by Mike
Excel Dynamic ArraysWhat are dynamic arrays in Excel? Dynamic arrays are new to Excel and are available in Microsoft 365 […] February 12, 2023 in Excel tagged array / dynamic / formula / spill by Mike