• Home
  • Diver BI Group
    • Diver | BI
    • Customer Commendations
    • Videos
    • Case Studies
    • Documents and Brochures
    • Diver BI Group Privacy Policy
  • Articles
    • News
    • Accolades
    • Blog
    • Ask Anthony
      • Common ODBC Errors
  • The Team
    • Key Experts
    • Members
      • Dynamic Business Informatics
      • Envisage
      • Chartwell IT
      • Cloud-Works Solutions Ltd
      • Data Management Business Insight
      • Manitex
      • Equiniti ICS
      • Pharma IT
      • Pinnula
      • Formell
      • IBI
    • Partners
      • Dimensional Insight US
      • Dimensional Insight EU
      • Dimensional Insight Asia
      • DI Panama
      • ID Technology (Brazil)
      • Infotool (Nordic Countries)
      • iXias Software – DI France
      • Vision IT
      • KDE Group (Israel)
      • Zight -Partner for Transport
      • 24/7 Uptime
  • Applications
    • Property
      • Property Prices Portal
    • Supply Chain
      • Retail
      • Distributor
      • Wholesale
      • Manufacturing
      • Produce
      • Beverage Alcohol Suppliers
      • Beverage Alcohol Distributors
      • Autoparts
      • Transport
      • Public Transport
      • DI Program Advisor
    • Healthcare
      • Healthcare
      • DI Surgery Advisor
      • DI Physician Performance Advisor
      • Pharma BI Applications of Diver
    • Finance
      • Finance
      • DI GL Advisor
    • Mobile & SaaS
      • Diver BI SaaS
      • SaaS for Sales Gap Analysis
      • BI designed for Tablet
      • DiveTab – Mobile BI
    • Diversity
      • Travel & Tourism
      • Colleges & Universities
      • Waste Management
      • Parking
      • Telecom Brokerage
      • Economic Trends
      • Maps
      • Smart Meters
      • Carbon Emissions Management
  • Workbench
  • Contact
    • Free Consultation with One of Our Experts
    • Add a New Revenue Stream as a Partner

DiverBIGroup

Business Intelligence Experts

Diver BI Group Blog New Charts in Property Prices Portal

New Charts in Property Prices Portal

27th January 2022

By Debbie Lonsdale

I’ve just added a couple of new charts into the Property Prices Portal that I think will help you to make sense of what’s happening in the Irish Property Market. They are on the “Scatter and Heat Charts” page on the menu shown below.

They both work using the filters at the top of the page which allow you to go back in time and compare a whole YTD v the previous YTD. In this case, because we don’t have much data yet for January 2022, I’ve chosen to compare the full year of 2021 from 1st January up to the last sale date of 29th December, with the exact same period in 2020.

As the year progresses you can see how we’re doing year-to-date 2022 with the same period 2021 by changing the Current Date to cover the period you want to compare.

Scatter Plot

In the scatter plot below we can get an immediate feel for 3 key measures about how property prices were doing in 2021 v 2020.

Each county is represented by a circle on the chart. It’s position and size are determined by the 3 measures.

  • The x-axis shows us the % change 2021 v 2020 in the average price by county
  • The y-axis shows us the % change 2021 v 202 in the number sold by county
  • The size of the circle increases the higher the average price.

When you hover over a circle as below a tool tip details the 3 measures for the county – in this case Tipperary.

Can you guess which county the big circle bottom left represents?  To see if you’re correct go to the portal and hover over the circle. 

The small circle top right represents Longford which has had a great year in terms of increased number of properties sold (42.53% up) and also in terms of average price change (21.86% up) – but still only has a fairly low average price in 2021 of €162,851, hence the small circle size.

Next let’s look at the heat chart further down and see the breakdown per county of VAT Excl. average sales prices (new properties are entered into the portal at VAT Excl price) and the VAT Incl. average sales prices (second hand properties are entered into the portal at VAT Incl. price).

Heat Chart

For the same year-to-date period selected , in this case the full year for 2021 sales, we can see at a glance the breakdown of average sales price by county and by VAT status. We can see by the gradient of colour, the lowest averages (lighter blue) and the highest averages (darker blue).

Dublin looks as you would expect, the darkest (highest), in both VAT Excl. and VAT Incl. sales.

Look at Longford – we already know from above that the overall Average Price for 2021 was €162,851. But what happens when we break down by New v Second Hand?

Longford has an unexpectedly high Vat Excl. Average Price for 2021 – €693,109 and a very low Vat Incl. Average Price of €145,338.

This could be for several reasons. Because we are working on a mean average we know from the overall average of €162,851 that there can’t be that many new houses otherwise this would be much higher.

It seems likely that there might be a small number of very expensive new houses sold in 2021.

Let’s look at the Search Addresses page to see more detail about what’s going on.

Search Addresses

When we filter down to Longford and VAT Excl. Sales for 2021, we can see clearly why the average price is so high for VAT Excl. sales in Longford.

There are only 18 VAT Excl. Sales out of 563 total sales.

There are several sales of single expensive properties, but there are also some sales of whole or partial housing estates which instead of being classified in the data as separate properties, have been sold as one property.

These could be brand new estates, or newly completed ghost estates left over from the property crash in 2008, and now sold on as one lot.

There is a genuine double-property sale on Campbell’s Drive which has been entered as such in the data, so the  mean average is not affected.

We might add further reports to the portal on median averages which would help to give a different perspective to the average price.

So when you are investigating the averages and increases in your area, be sure to look into the detail before making selling or buying decisions based on the Property Prices Register data.

 

 

About Debbie Lonsdale

Debbie Lonsdale

Debbie Lonsdale has been working with the Diver Solution as a BI Consultant at Dynamic Business Informatics since 2008. Her previous experience includes computer programming, analytical and technical roles, team management, account management, sales and marketing in a variety of market sectors, including the Travel Industry and Distribution.

She combines this experience as an all round ICT professional in the BI sector.

 

Articles

  • News
  • Accolades
  • Blog
  • Ask Anthony
    • Common ODBC Errors
  • Diver | BI
  • Customer Commendations
  • Videos
  • Case Studies
  • Documents and Brochures
  • Diver BI Group Privacy Policy

Dynamic Business Informatics Ltd

Distributors of The Diver Solution & Diver Platform, providing business consultancy services, products and applications derived from the Diver Solution & Diver Platform.
14 Mellifont Avenue
Dun Laoghaire
Co. Dublin

+353 1 2302022

10 Kenyon Street
Nenagh
Co Tipperary

+353 67 43309

Contact Us

We would love to hear from you! Please submit your query and we will get in touch with you shortly.

Email addresses are never sold, rented, or shared. See our Privacy Policy.

  • This field is for validation purposes and should be left unchanged.

Accolades

  • Dimensional Insight Earns Top Marks in 2021 Wisdom of Crowds Business Intelligence Market Study
  • Best in Klas 2021
  • 5 Takeaways from the 2020 Wisdom of Crowds Report
  • Dimensional Insight Earns Top Marks in 2020 Wisdom of Crowds Business Intelligence Market Study
  • Best in Klas 2020

Copyright © 2022 Diver BI Group · Privacy Policy · website by cubecolour

We use cookies on our website to give you the most relevant experience by remembering your preferences and repeat visits. By clicking “Accept”, you consent to the use of ALL the cookies.
Cookie settingsACCEPT
Privacy & Cookies Policy

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these cookies, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may have an effect on your browsing experience.


What Are Cookies?


As is common practice with almost all professional websites this site uses cookies, which are tiny files that are downloaded to your computer, to improve your experience. This page describes what information they gather, how we use it and why we sometimes need to store these cookies. We will also share how you can prevent these cookies from being stored however this may downgrade or 'break' certain elements of the sites functionality.


For more general information on cookies, please read "What Are Cookies".


How We Use Cookies


We use cookies for a variety of reasons detailed below. Unfortunately in most cases there are no industry standard options for disabling cookies without completely disabling the functionality and features they add to this site. It is recommended that you leave on all cookies if you are not sure whether you need them or not in case they are used to provide a service that you use.


Disabling Cookies


You can prevent the setting of cookies by adjusting the settings on your browser (see your browser Help for how to do this). Be aware that disabling cookies will affect the functionality of this and many other websites that you visit. Disabling cookies will usually result in also disabling certain functionality and features of the this site. Therefore it is recommended that you do not disable cookies.


The Cookies We Set




  • Account related cookies


    If you create an account with us then we will use cookies for the management of the signup process and general administration. These cookies will usually be deleted when you log out however in some cases they may remain afterwards to remember your site preferences when logged out.




  • Login related cookies


    We use cookies when you are logged in so that we can remember this fact. This prevents you from having to log in every single time you visit a new page. These cookies are typically removed or cleared when you log out to ensure that you can only access restricted features and areas when logged in.




  • Forms related cookies


    When you submit data to through a form such as those found on contact pages or comment forms cookies may be set to remember your user details for future correspondence.




  • Site preferences cookies


    In order to provide you with a great experience on this site we provide the functionality to set your preferences for how this site runs when you use it. In order to remember your preferences we need to set cookies so that this information can be called whenever you interact with a page is affected by your preferences.




Third Party Cookies


In some special cases we also use cookies provided by trusted third parties. The following section details which third party cookies you might encounter through this site.




  • This site uses Google Analytics which is one of the most widespread and trusted analytics solution on the web for helping us to understand how you use the site and ways that we can improve your experience. These cookies may track things such as how long you spend on the site and the pages that you visit so we can continue to produce engaging content.


    For more information on Google Analytics cookies, see the official Google Analytics page.




More Information


Hopefully that has clarified things for you and as was previously mentioned if there is something that you aren't sure whether you need or not it's usually safer to leave cookies enabled in case it does interact with one of the features you use on our site.


However if you are still looking for more information then you can contact us through our contact page

Necessary
Always Enabled
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Non-necessary
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.
SAVE & ACCEPT