Posts by Ryan Janzen
Power BI: Beyond the Dashboard
In recent years, Power BI has come to be known as a very powerful tool for easily and efficiently creating dashboards to summarize data. But can Power BI be more than a data visualization tool? Can it also be a data analysis tool? This session will explore functions, techniques, and methods that can help make…
Read MoreFinal Value Reconciliation
This material covers the reconciliation process an appraiser goes through. Arriving at the best indication of market value while considering all approaches to value requires weighing the pros and cons of each approach, the available data, and the resources used to establish each approach.
Read MoreMarket Modeling – 2024 KCAA
Presented at the 2024 KCAA Conference, this presentation addresses many of the items related to the market modeling steps one could consider when developing a mass appraisal model. Items discussed include market condition adjustment calculations and applications, model variable considerations, multiple regression analysis measures of fit, calibration, and testing.
Read MoreYou’re Never Too Small – The Income Approach in Small Jurisdictions
Description In small jurisdictions the Income Approach to value can be difficult to implement. Income and expense information can be hard to obtain, cap rates are often difficult to determine, making model building and calibration a real challenge. So much so, small jurisdictions often write off the approach all together due to lack of information. …
Read MoreEconomic Life: Why We Need to Stop Ignoring Economic Life as Part of the Depreciation Equation
The buildings in Kansas are getting older. This is by no means a ground-breaking revelation. But what are we doing to account for these aging buildings? Most jurisdictions rely on the Cost Approach for a large majority of their commercial properties. The cost of the improvements is comprised of two components: the replacement cost new…
Read More