Data-Driven Dashboard Technology 2024.pdf

Data Driven Dashboard Digital Technologies Getting Started First open a new Google Sheets file in the folder that you have shared with me. Name the file ‘Production and Design Folio’. Your spreadsheet should look similar to this picture. Make sure you know how to navigate your spreadsheet. FORMULA...

Data Driven Dashboard Digital Technologies Getting Started First open a new Google Sheets file in the folder that you have shared with me. Name the file ‘Production and Design Folio’. Your spreadsheet should look similar to this picture. Make sure you know how to navigate your spreadsheet. FORMULAS AND FUNCTIONS Add Median Subtract If Multiply Ifs Divide Iferror Min Countif Max Sumif Count Vlookup Counta Current Date/Time Average Filter CREATING AN INTERACTIVE CHART You will need to add a new sheet on your spreadsheet and rename label with ‘Creating an Interactive Chart’. In this exercise you will learn how to create an infographic to visually represent data. The Enhanced Media Metrics Australia report found young Australians were the most likely to eat out and eat fast food, with 60 per cent of those aged 14-29 eating fast food at least once a month compared with the national average of 45 per cent. https://www.goodfood.com.au/eat-out/news/average-australian-eats-fast-food-nearly -every-week-20140311-34k15