{"id":966,"date":"2021-03-22T20:50:48","date_gmt":"2021-03-22T09:50:48","guid":{"rendered":"https:\/\/www.xempla.io\/?p=966"},"modified":"2023-03-25T00:50:24","modified_gmt":"2023-03-24T13:50:24","slug":"excel-for-cre-data-analysis-to-be-or-not-to-be-might-not-be-the-right-question","status":"publish","type":"post","link":"https:\/\/stagexemplawppanel.xempla.io\/wppanel\/facilty-management-times\/excel-for-cre-data-analysis-to-be-or-not-to-be-might-not-be-the-right-question\/","title":{"rendered":"Excel for commercial building data analysis: To be or not to be, might not be the right question"},"content":{"rendered":"\n

Do you know that marketers love \u2018Cognitive biases\u2019? Every human being is emotionally, psychologically, or habitually attached to certain belief systems, thought processes. Marketers use that connection to influence or augment consumer\u2019s choices in a particular direction.<\/p>\n\n\n\n

\u201cWe are consumers. We’re the by-products of a lifestyle obsession\u201d<\/p>\n\n\n\n

Remember this iconic statement by Tyler from the movie Fight Club? Well, I wouldn\u2019t go that far to establish my point. But we must have experienced getting manipulated by the brands for their profits both in personal and professional life.<\/p>\n\n\n\n

Want an example? an age-old argument between using Excel for commercial use and Analytics tools. There are dozens of articles you would find which support the ideology that presumes Excel is an outdated application for analytics and you should move to specific tools or platform for automation, AI and all the futuristic use cases. <\/p>\n\n\n\n

They make you feel guilty & cheap for optimizing Excel to solve your business needs (reporting, forecasting & formula based calculations)     <\/p>\n\n\n\n

While I agree that automated business intelligence tools can do a lot more than what Excel does, but that doesn\u2019t mean everyone should go for them. Understanding your business need, available resources, and future roadmap of tech integrations is important before you make that switch. <\/p>\n\n\n\n

In this article, we will discuss those business or technical objectives which you should consider while making that decision. <\/p>\n\n\n\n

Time to process data:<\/h4>\n\n\n\n

How much time does it take for your O&M team to collect the data from different sources (BMS, EMS, CAFM) and analyze it on excel? Does the process is cumbersome and takes more than expected work hours? How frequently does it take place or how much of a repetitive component in it? Answers to these questions can help you quantify the value of your O&M team\u2019s time.<\/p>\n\n\n\n

There are multiple readymade templates available to manage, visualize and process real estate data from Cashflow analysis<\/a>, Rental management<\/a> to asset maintenance<\/a>. If these templates are solving your pain points without taking too much of your team\u2019s time then it\u2019s completely justified not to automate things.       <\/p>\n\n\n\n

Data Complexity:<\/h4>\n\n\n\n

There are 10+ parameters Air handling unit (AHU) generates on a continuous basis. A typical size commercial building consists of 35 – 45+ AHUs which produce hundreds of data points. Not to forget there are other critical assets and building systems that collect, store and visualize a huge quality of data points.  <\/p>\n\n\n\n

When it comes to processing those huge files, most of the computers with standard configuration would struggle to open up a 100 MB .csv file, making it challenging to analyze and report such datasheets. Adding several smaller .csv files to data, like sales data for neighboring regions, will be immensely difficult to combine with your previous dataset and analysis.<\/p>\n\n\n\n

Now, do you find any difficulties processing your asset data? Do you think it will increase with the addition of building data (CAFM, Weather data) in the future? What is a bigger challenge? Is it a volume, logic (Formulation), or processing capabilities of the system? It\u2019s important to understand how your O&M team wants to use your building data before choosing the right application for the same.     <\/p>\n\n\n\n

Integration capabilities:<\/h4>\n\n\n\n

Now whether it is a simple help desk management or maintenance scheduling task, there are multiple individual standalone applications that communicate data to maximize the valuable insights. We are living in a multifamily tech architecture age where the \u2018ecosystem approach\u2019 of technology adoption is mostly followed. <\/p>\n\n\n\n

For example, you might want to process asset data over edge computing or fog layer offered by different applications and deliver alerts and notifications to your workplace communication channels such as Slack or Microsoft teams. A journey of data into insights can touch upon multiple applications via open integration protocols making a real-time response to such requests a necessity. <\/p>\n\n\n\n

Unfortunately, Excel or Google spreadsheets are not equipped to handle real-time data changes. Limiting them for manual data entry tasks and prone to human errors.<\/p>\n\n\n\n

But, If there is no requirement for data integration or automation at your facility for now and in near future, your on-site FM team is comfortable drawing insights with an existing set of applications then you don\u2019t need to dump excel for any other application. <\/p>\n\n\n\n

To sum up, check your business needs, future tech integration, and most importantly how you want to use your data before changing the boats.\u00a0If your facility requires a more advance application then you can look for a building analytics software<\/a>. If you can’t decide what is best for your facility so reach out to us.<\/p>\n","protected":false},"excerpt":{"rendered":"

Do you know that marketers love \u2018Cognitive biases\u2019? Every human being is emotionally, psychologically, or habitually attached to certain belief systems, thought processes. Marketers use that connection to influence or augment consumer\u2019s choices in a particular direction. \u201cWe are consumers. We’re the by-products of a lifestyle obsession\u201d Remember this iconic statement by Tyler from the […]<\/p>\n","protected":false},"author":1,"featured_media":1038,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[5],"tags":[],"class_list":["post-966","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-operations-and-maintenance"],"acf":[],"yoast_head":"\nExcel for building data analysis: To be or not to be, not be the right question<\/title>\n<meta name=\"description\" content=\"When is the right time for facility management teams to switch from Excel to analytics tools for building data analysis\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/stagexemplawppanel.xempla.io\/wppanel\/facilty-management-times\/excel-for-cre-data-analysis-to-be-or-not-to-be-might-not-be-the-right-question\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel for building data analysis: To be or not to be, not be the right question\" \/>\n<meta property=\"og:description\" content=\"When is the right time for facility management teams to switch from Excel to analytics tools for building data analysis\" \/>\n<meta property=\"og:url\" content=\"https:\/\/stagexemplawppanel.xempla.io\/wppanel\/facilty-management-times\/excel-for-cre-data-analysis-to-be-or-not-to-be-might-not-be-the-right-question\/\" \/>\n<meta property=\"og:site_name\" content=\"Xempla\" \/>\n<meta property=\"article:published_time\" content=\"2021-03-22T09:50:48+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-03-24T13:50:24+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/stagexemplawppanel.xempla.io\/wppanel\/wp-content\/uploads\/2021\/03\/Excel-for-building-data-analysis-To-be-or-not-to-be-not-be-the-right-question..png\" \/>\n\t<meta property=\"og:image:width\" content=\"1100\" \/>\n\t<meta property=\"og:image:height\" content=\"550\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/stagexemplawppanel.xempla.io\/wppanel\/facilty-management-times\/excel-for-cre-data-analysis-to-be-or-not-to-be-might-not-be-the-right-question\/\",\"url\":\"https:\/\/stagexemplawppanel.xempla.io\/wppanel\/facilty-management-times\/excel-for-cre-data-analysis-to-be-or-not-to-be-might-not-be-the-right-question\/\",\"name\":\"Excel for building data analysis: To be or not to be, not be the right question\",\"isPartOf\":{\"@id\":\"\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/stagexemplawppanel.xempla.io\/wppanel\/facilty-management-times\/excel-for-cre-data-analysis-to-be-or-not-to-be-might-not-be-the-right-question\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/stagexemplawppanel.xempla.io\/wppanel\/facilty-management-times\/excel-for-cre-data-analysis-to-be-or-not-to-be-might-not-be-the-right-question\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/stagexemplawppanel.xempla.io\/wppanel\/wp-content\/uploads\/2021\/03\/Excel-for-building-data-analysis-To-be-or-not-to-be-not-be-the-right-question..png\",\"datePublished\":\"2021-03-22T09:50:48+00:00\",\"dateModified\":\"2023-03-24T13:50:24+00:00\",\"author\":{\"@id\":\"\/#\/schema\/person\/46bd8eb99363e9f76bbf1e34002ba67e\"},\"description\":\"When is the right time for facility management teams to switch from Excel to analytics tools for building data analysis\",\"breadcrumb\":{\"@id\":\"https:\/\/stagexemplawppanel.xempla.io\/wppanel\/facilty-management-times\/excel-for-cre-data-analysis-to-be-or-not-to-be-might-not-be-the-right-question\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/stagexemplawppanel.xempla.io\/wppanel\/facilty-management-times\/excel-for-cre-data-analysis-to-be-or-not-to-be-might-not-be-the-right-question\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/stagexemplawppanel.xempla.io\/wppanel\/facilty-management-times\/excel-for-cre-data-analysis-to-be-or-not-to-be-might-not-be-the-right-question\/#primaryimage\",\"url\":\"https:\/\/stagexemplawppanel.xempla.io\/wppanel\/wp-content\/uploads\/2021\/03\/Excel-for-building-data-analysis-To-be-or-not-to-be-not-be-the-right-question..png\",\"contentUrl\":\"https:\/\/stagexemplawppanel.xempla.io\/wppanel\/wp-content\/uploads\/2021\/03\/Excel-for-building-data-analysis-To-be-or-not-to-be-not-be-the-right-question..png\",\"width\":1100,\"height\":550,\"caption\":\"Excel for building data analysis To be or not to be, not be the right question\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/stagexemplawppanel.xempla.io\/wppanel\/facilty-management-times\/excel-for-cre-data-analysis-to-be-or-not-to-be-might-not-be-the-right-question\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/stagexemplawppanel.xempla.io\/wppanel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel for commercial building data analysis: To be or not to be, might not be the right question\"}]},{\"@type\":\"WebSite\",\"@id\":\"\/#website\",\"url\":\"\/\",\"name\":\"Xempla\",\"description\":\"Asset Performance Analytics for Facility Management Teams\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"\/#\/schema\/person\/46bd8eb99363e9f76bbf1e34002ba67e\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/dfe9d99ee52e924470fe866949e99899?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/dfe9d99ee52e924470fe866949e99899?s=96&d=mm&r=g\",\"caption\":\"admin\"},\"sameAs\":[\"https:\/\/www.xempla.io\/wppanel\"],\"url\":\"https:\/\/stagexemplawppanel.xempla.io\/wppanel\/author\/admin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel for building data analysis: To be or not to be, not be the right question","description":"When is the right time for facility management teams to switch from Excel to analytics tools for building data analysis","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/stagexemplawppanel.xempla.io\/wppanel\/facilty-management-times\/excel-for-cre-data-analysis-to-be-or-not-to-be-might-not-be-the-right-question\/","og_locale":"en_US","og_type":"article","og_title":"Excel for building data analysis: To be or not to be, not be the right question","og_description":"When is the right time for facility management teams to switch from Excel to analytics tools for building data analysis","og_url":"https:\/\/stagexemplawppanel.xempla.io\/wppanel\/facilty-management-times\/excel-for-cre-data-analysis-to-be-or-not-to-be-might-not-be-the-right-question\/","og_site_name":"Xempla","article_published_time":"2021-03-22T09:50:48+00:00","article_modified_time":"2023-03-24T13:50:24+00:00","og_image":[{"width":1100,"height":550,"url":"https:\/\/stagexemplawppanel.xempla.io\/wppanel\/wp-content\/uploads\/2021\/03\/Excel-for-building-data-analysis-To-be-or-not-to-be-not-be-the-right-question..png","type":"image\/png"}],"author":"admin","twitter_card":"summary_large_image","twitter_misc":{"Written by":"admin","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/stagexemplawppanel.xempla.io\/wppanel\/facilty-management-times\/excel-for-cre-data-analysis-to-be-or-not-to-be-might-not-be-the-right-question\/","url":"https:\/\/stagexemplawppanel.xempla.io\/wppanel\/facilty-management-times\/excel-for-cre-data-analysis-to-be-or-not-to-be-might-not-be-the-right-question\/","name":"Excel for building data analysis: To be or not to be, not be the right question","isPartOf":{"@id":"\/#website"},"primaryImageOfPage":{"@id":"https:\/\/stagexemplawppanel.xempla.io\/wppanel\/facilty-management-times\/excel-for-cre-data-analysis-to-be-or-not-to-be-might-not-be-the-right-question\/#primaryimage"},"image":{"@id":"https:\/\/stagexemplawppanel.xempla.io\/wppanel\/facilty-management-times\/excel-for-cre-data-analysis-to-be-or-not-to-be-might-not-be-the-right-question\/#primaryimage"},"thumbnailUrl":"https:\/\/stagexemplawppanel.xempla.io\/wppanel\/wp-content\/uploads\/2021\/03\/Excel-for-building-data-analysis-To-be-or-not-to-be-not-be-the-right-question..png","datePublished":"2021-03-22T09:50:48+00:00","dateModified":"2023-03-24T13:50:24+00:00","author":{"@id":"\/#\/schema\/person\/46bd8eb99363e9f76bbf1e34002ba67e"},"description":"When is the right time for facility management teams to switch from Excel to analytics tools for building data analysis","breadcrumb":{"@id":"https:\/\/stagexemplawppanel.xempla.io\/wppanel\/facilty-management-times\/excel-for-cre-data-analysis-to-be-or-not-to-be-might-not-be-the-right-question\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/stagexemplawppanel.xempla.io\/wppanel\/facilty-management-times\/excel-for-cre-data-analysis-to-be-or-not-to-be-might-not-be-the-right-question\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/stagexemplawppanel.xempla.io\/wppanel\/facilty-management-times\/excel-for-cre-data-analysis-to-be-or-not-to-be-might-not-be-the-right-question\/#primaryimage","url":"https:\/\/stagexemplawppanel.xempla.io\/wppanel\/wp-content\/uploads\/2021\/03\/Excel-for-building-data-analysis-To-be-or-not-to-be-not-be-the-right-question..png","contentUrl":"https:\/\/stagexemplawppanel.xempla.io\/wppanel\/wp-content\/uploads\/2021\/03\/Excel-for-building-data-analysis-To-be-or-not-to-be-not-be-the-right-question..png","width":1100,"height":550,"caption":"Excel for building data analysis To be or not to be, not be the right question"},{"@type":"BreadcrumbList","@id":"https:\/\/stagexemplawppanel.xempla.io\/wppanel\/facilty-management-times\/excel-for-cre-data-analysis-to-be-or-not-to-be-might-not-be-the-right-question\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/stagexemplawppanel.xempla.io\/wppanel\/"},{"@type":"ListItem","position":2,"name":"Excel for commercial building data analysis: To be or not to be, might not be the right question"}]},{"@type":"WebSite","@id":"\/#website","url":"\/","name":"Xempla","description":"Asset Performance Analytics for Facility Management Teams","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"\/#\/schema\/person\/46bd8eb99363e9f76bbf1e34002ba67e","name":"admin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/dfe9d99ee52e924470fe866949e99899?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/dfe9d99ee52e924470fe866949e99899?s=96&d=mm&r=g","caption":"admin"},"sameAs":["https:\/\/www.xempla.io\/wppanel"],"url":"https:\/\/stagexemplawppanel.xempla.io\/wppanel\/author\/admin\/"}]}},"_links":{"self":[{"href":"https:\/\/stagexemplawppanel.xempla.io\/wppanel\/wp-json\/wp\/v2\/posts\/966","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/stagexemplawppanel.xempla.io\/wppanel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/stagexemplawppanel.xempla.io\/wppanel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/stagexemplawppanel.xempla.io\/wppanel\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/stagexemplawppanel.xempla.io\/wppanel\/wp-json\/wp\/v2\/comments?post=966"}],"version-history":[{"count":9,"href":"https:\/\/stagexemplawppanel.xempla.io\/wppanel\/wp-json\/wp\/v2\/posts\/966\/revisions"}],"predecessor-version":[{"id":2544,"href":"https:\/\/stagexemplawppanel.xempla.io\/wppanel\/wp-json\/wp\/v2\/posts\/966\/revisions\/2544"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/stagexemplawppanel.xempla.io\/wppanel\/wp-json\/wp\/v2\/media\/1038"}],"wp:attachment":[{"href":"https:\/\/stagexemplawppanel.xempla.io\/wppanel\/wp-json\/wp\/v2\/media?parent=966"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/stagexemplawppanel.xempla.io\/wppanel\/wp-json\/wp\/v2\/categories?post=966"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/stagexemplawppanel.xempla.io\/wppanel\/wp-json\/wp\/v2\/tags?post=966"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}