2b:null 2c:["$","title",null,{"children":"cxapp Assessment - Utilization Percentage | Akhila Sulgante | Observable"}] 31:T6f9,utilpercent = html`

`32:T787,time = html`

`33:[{"id":"905f7433f5a70a754d1e1ffe4997f9faa0fad5bfca2dd7b8d4cbb8e56e24eed039b141775aa8e4b91d1c192ae09a99dccf409fa8297583bc8e80cc23ad5e2004","href":"https://static.observableusercontent.com/files/905f7433f5a70a754d1e1ffe4997f9faa0fad5bfca2dd7b8d4cbb8e56e24eed039b141775aa8e4b91d1c192ae09a99dccf409fa8297583bc8e80cc23ad5e2004","name":"Screenshot 2024-01-26 at 16.53.21.png","type":"image/png","lastModified":1706316861864.811,"size":41263},{"id":"0900af175f5cea98abf330e6531d673816762ab315178479b96677ce048c754469ca71909df7052e92e727d88fc1d6728e0bd74ed195f0ae52c200eef1818c04","href":"https://static.observableusercontent.com/files/0900af175f5cea98abf330e6531d673816762ab315178479b96677ce048c754469ca71909df7052e92e727d88fc1d6728e0bd74ed195f0ae52c200eef1818c04","name":"CXAppPreprocessing.ipynb","type":"application/octet-stream","lastModified":1706317464635.862,"size":36751}] 2f:{"id":"5009b4a397face47","slug":null,"title":"cxapp Assessment - Utilization Percentage","thumbnail":"0a9d9cee5a479647a2ba0ee71d671b809626c540835b644d36055c4139acb909","access_level":"public","create_time":"$D2024-01-26T18:44:53.138Z","update_time":"$D2024-02-19T02:59:06.084Z","view_time":null,"first_public_time":"$D2024-01-26T18:44:53.138Z","has_unpublished_edits":null,"fork":false,"stars":0,"starred":false,"owner":{"type":"team","id":"e76678b312b62ab3","login":"akhila","name":"Akhila Sulgante","avatar_url":"https://avatars-next.observableusercontent.com/2e264e285632a44937edf6eb6b531fffbd152d07233e70f4c70c2cd9a5cd9e09","tier":"starter_2024"},"version":121,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"667daa7e86be0e8e","login":"akhila","name":"Akhila Sulgante","avatar_url":"https://avatars-next.observableusercontent.com/2e264e285632a44937edf6eb6b531fffbd152d07233e70f4c70c2cd9a5cd9e09","tier":null}],"members":[{"type":"individual","id":"667daa7e86be0e8e","login":"akhila","name":"Akhila Sulgante","avatar_url":"https://avatars-next.observableusercontent.com/2e264e285632a44937edf6eb6b531fffbd152d07233e70f4c70c2cd9a5cd9e09","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"title":"cxapp Assessment - Utilization Percentage","cells":[{"id":0,"value":"# cxapp Assessment - Utilization Percentage\n_Knowing Utilization Percentage by Buildings and Floor_\n\nThis Visualization is created by Akhila Sulgante as a part of a hiring assessment by [cxapp](https://cxapp.com/). This is not for reproducing purposes.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":79,"value":"## Summarizing Utilization Percentage by Buildings and by Floors in each buildings","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":83,"value":"*** Note: Hover over the blocks to see the exact Utilization Percentage and Country","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":13,"value":"UtilPer = html`

${utilpercent}

`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":85,"value":"Utilization Percentage for the given data is calculated as total unique spaces booked / total bookable available spaces.\n","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":94,"value":"Insight: Building10 in Turkey has the highest(100%) utilization factor, followed by a building71 in United States\n\nFollowing inquiry arising from the visualization:\n1. Analyze the location of the buildings with high utilization factors to decide if the location is feasible for future investments\n2. Analyze the cost spent and cost gained from the buildings to understand if the building is profitable\n3. Analyze the amenities provided in the buildings with higher utilization factors to understand customer needs\n ","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":48,"value":"## Analyzing Utilization Factor over time","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":99,"value":"In the below interactive dashboard, you can see the utilization factor in steps of Monthly, Weekly, and Daily","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":101,"value":"**** Use the slider to select Start and end time to select period and select value from Temporal Analysis to select duration steps","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":56,"value":"TimeAnalysis = html`

${time}

`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":109,"value":"Insight: Utilization factor fell drastically from \"05/01/2021\" to \"06/01/2021\" and there is a steady growth since.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":90,"value":"#### Data Cleaning Process and Assumptions\n1. As floor data had different naming conventions for different building, I mapped the floors to a common name retaining the floor numbers and parking information as is","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":114,"value":"#### Data Relation","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":111,"value":"screenshot20240126At165321 = FileAttachment(\"Screenshot 2024-01-26 at 16.53.21.png\").image()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":118,"value":"**Data Preprocessing file in the attachment for reference**","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":54,"value":"divElementTime = {\n return TimeAnalysis.querySelector(\"#viz1706311944527\");\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":59,"value":"{\n let vizElement = divElementTime?.getElementsByTagName(\"object\")[0];\n vizElement.style.width = \"1000px\";\n vizElement.style.height = \"1000px\";\n let scriptElement = document.createElement(\"script\");\n scriptElement.src = \"https://public.tableau.com/javascripts/api/viz_v1.js\";\n vizElement.parentNode.insertBefore(scriptElement, vizElement);\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":5,"value":"$31","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":10,"value":"divElementutil = {\n return UtilPer.querySelector(\"#viz1706310882360\");\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":25,"value":"{\n let vizElement = divElementutil?.getElementsByTagName(\"object\")[0];\n vizElement.style.width = \"1200px\";\n vizElement.style.height = \"800px\";\n let scriptElement = document.createElement(\"script\");\n scriptElement.src = \"https://public.tableau.com/javascripts/api/viz_v1.js\";\n vizElement.parentNode.insertBefore(scriptElement, vizElement);\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":52,"value":"$32","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":120,"value":"","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"}],"files":"$W33","stdlib":"1","titling":"auto"}} 30:"$2f:body"