Key Topics

• Introduction to Data Analytics in Business
• Getting Started with Excel for Data Analysis
• Excel Basics Refresher: Quick recap on essential Excel functions.
• Data Importing: How to import property data from different sources (e.g., CSV, online databases).
• Data Cleaning: Techniques for cleaning and preparing property data for analysis. Key Excel Functions for Property Data Analytics
• VLOOKUP & HLOOKUP: Matching property listings with client preferences.
• Key Excel Functions for Property Data Analytics
• IF Statements & Conditional Formatting: Highlighting key property metrics.
• PivotTables: Summarizing data to track property trends by region, price, etc.
• Data Visualization
• Creating Charts: How to create bar charts, line graphs, and scatter plots to visualize property data.
• Building Dashboards: Step-by-step guide to building a simple Excel dashboard to track property market indicators.

Learning Outcomes

These learning outcomes aim to provide non-tech real estate professionals with a general understanding of Excel and its applications in the real estate industry, equipping them with the knowledge to leverage technologies effectively

• Understand the basics of data analytics and its importance in the real estate sector.
• Efficiently import and clean property-related data from various sources, preparing it for analysis using Excel.
• Apply key Excel functions like VLOOKUP, HLOOKUP, and IF statements to match property listings with client preferences and highlight key metrics.
• Create and use PivotTables to summarize and analyze property data by region, price, and other relevant categories.
• Develop data visualizations using Excel charts, including bar charts, line graphs, and scatter plots to represent property trends.
• Build interactive Excel dashboards that track key property market indicators and provide actionable insights.
• Apply conditional formatting to emphasize critical data points, improving readability and analysis of property data.
• Confidently use Excel as a tool for real estate data analytics to enhance decision-making and business performance.

Who Will Benefit

• Real Estate Agents
• Property Managers
• Real Estate Valuers
• Compliance and Risk Management Professionals
• Marketing and Sales Teams in Real Estate Firms
• Real Estate Consultants

Speaker

Yeu Shun Yee

Shun Yee is an IT professional with extensive experience in business analytics and AI solutions. He holds a Bachelor of Computer Science (First Class Honours) from the University of Manitoba, Canada, and has demonstrated academic excellence throughout his studies. He has a strong background in implementing and migrating business intelligence solutions across various platforms, including SAP, Qlikview, SQL SSAS, and Power BI. He has led teams in Malaysia, Singapore, and Thailand, promoting self-service BI tools and conducting comprehensive training. His previous roles include F&N, Assistant Manager at Hwang-DBS Securities Berhad and Administrative Officer at Bank Negara Malaysia.