what does the term 'layout' mean when creating a dashboard?
how the audience reads the dashboard is not a trivial consideration. The dashboards' purpose is to help guide the readers eye through multiple views in coordination and tell the story of each insight
How do we use the function of pivot tables in excel?
To display data in a manageable way that allows for easy readability and manipulation.
what do you need to make a JavaScript code successful
it needs JavaScript syntax rules, vocabulary and grammar
list all the data types
short text, number, data/time, AutoNumber, yes/no, and currency
list at least 4 dashboard requirements to make an effective dashboard
Charts/Graphs, Colors, Effective titles and subtitles, Audience interactivity.
how to get the data ready step by step
sorting data, filtering data, cleaning panes, pivot tables, and lastly, conditional formatting
How to perform rolling and heading using Sphero ball (JavaScript)
await roll (heading, speed, duration,)
Identify the purpose/role for queries that are present in databases
Queries ask questions about information stored in the tables.
why is audience interactivity with the dashboard important to achieve an effective dashboard?
By considering the audience and how it will make it easier for the audience interact with data.
identify how to freeze rows in excel give answer step by step.
1. select one cell in the row you wish to freeze
2. Go to the 'view' tab
3. Select the 'Freeze Panes' option
What is JavaScript code format?
asycn function startProgram ( ) { // Write sphero code