Tableau’s Custom Table CalculationLet’s use the Superstore dataset from Tableau to create an example of a custom table calculation. We’ll look […] July 10, 2024 in Data Visualization tagged zn / delta / triangle / custom / table / zero / calculation / number / lookup by Mike
Excel’s VLOOKUP FunctionUse VLOOKUP when you need to find things in a table or a range by row. For example, […] February 4, 2023 in Excel tagged lookup / up / look / VLOOKUP by Mike
Microsoft’s FoodMart DatabaseIt’s always very helpful to have a database to work with when you are learning software such as […] November 28, 2022 in Database tagged test / sales / sample / set / lookup / fact / food / mart / datasets / data by Mike
Excel Index and MatchExcel’s Index and match functions used together can solve complex lookup problems. Let’s jump right into an example […] October 15, 2022 in Excel tagged index / lookup / match by Mike
Power BI OrientationLet’s look at the video at Udemy.com called Power BI – The Ultimate Orientation by Paula Guilfoyle. The […] August 13, 2022 in Data Visualization tagged lookup / dimension / fact / Power BI by Mike