Can anyone point me to a good resource for learning how to do some basic analytics in Excel? What I'm trying to learn how to do is look at all the operating and maintenance costs of hundreds of facilities and determine which ones cost the least/most overall. Also to look for cases where a property manager might be under-performing, overspending, incorrectly coding transactions, or downright stealing from the company.
I'm trying to look at everything at an individual facility/property level. I have the following criteria that could factor into the costs to operate the facility:
Criteria 1-2 allow me to compare apples to apples since heating costs in Canada will be significantly higher than in Mexico.
With criteria 3-5, I would expect a direct correlation: more people, bigger building, older facility = higher operating costs
The problem is that I just don't know how to effectively analyze all these criteria together. Any ideas where I could start learning how to address this? Thanks!
I'm trying to look at everything at an individual facility/property level. I have the following criteria that could factor into the costs to operate the facility:
- Geographic location (by state)
- Type of building (Floor Plan A vs Floor Plan B.... vs. Floor Plan X)
- Avg number of customers using the building per week
- Size of building in square feet
- The year the facility was built
Criteria 1-2 allow me to compare apples to apples since heating costs in Canada will be significantly higher than in Mexico.
With criteria 3-5, I would expect a direct correlation: more people, bigger building, older facility = higher operating costs
The problem is that I just don't know how to effectively analyze all these criteria together. Any ideas where I could start learning how to address this? Thanks!
