From Basic Excel Data to Insights: Build a Comprehensive HDB Resale Dashboard

[Real-Life Data: Singapore HDB Resale Data] Transform Basic Excel Data into Powerful Insightful

Do you have basic Excel data and want to transform it into something truly insightful?

In this video, I'll show you how simple it is to convert raw HDB resale flat data into this comprehensive and dynamic dashboard that delivers meaningful insights into HDB resale trends.

What's included:
1. How to transform a basic Excel file into a powerful dashboard featuring key indicators like Total Transactions, Highest Price, and Median Price for any selected period, location and price range.
2. Visualise transaction and price trends over time
3. Analyse resale prices across different regions, towns, and flat attributes such as age, type and storey
4. Explore the distribution of transactions with intuitive visualisations
5. Drill down into detailed transaction data with a single click

This video is perfect for anyone looking to elevate their data analysis skills. Whether you're a beginner or an experienced Power BI user, you'll discover how easy it is to turn basic data into a dashboard that provides deep insights.

Resources:
Data file on Singapore HDB resale flat prices for period from Jan-2017 to Aug-2024 - download on 7 August 2024
https://beta.data.gov.sg/
Download BI Dashboard Template
https://drive.google.com/drive/folder...
Microsoft Power BI Desktop Download Link
https://powerbi.microsoft.com/en-us/d...

Timestamp:
00:00 Introduction
00:17 Dataset - Download Site and Excel Data File
00:57 Dashboard Overview
03:16 Resale Transactions above $1million
07:05 Extract Detailed Transactions
08:13 Resale Market Analysis (Buyer/Seller)

   / @katedashboards  

Thanks for watching!

#powerbi #dashboard #template #kpi #exceltopowerbi #propertydashboard #datavisualisation #businessintelligence #businessreview #freedownload #hdb #resaleprice