Finding a Great Place to Live: How to Utilize Microsoft Power BI to Analyze Housing Data

Authors
Tyler Mokay
, Miranda Myhill-LaForce
, Andrew Fureno
, Furkan Oztanriseven
, Tracy Couto
Region
North America
Topic
Information Systems
Length
5 pages
Keywords
Power BI
data visualization
Copyright Holder
Society for Case Research
Student Price
$4.00
Target Audience
Graduate Students
Undergraduate Students

This case study explores the application of data visualization techniques in business analytics, using the scenario of Bradley Moore, a real estate agent, assisting Vanessa Francello, a recent MBA graduate, in relocating to New York City for her first job after college. Vanessa is looking for a great place to live in a safe neighborhood with low crime rates, higher average income, and a high-quality school system. Bradley marries his love of real estate with Microsoft Power BI to analyze and visualize data from the NYC dataset, providing insights and recommendations to Vanessa. The study is an introductory lesson on data visualization for business analytics and data science courses, emphasizing Power BI and visualization theories such as retinal visual encodings and Tufte’s information-to-ink ratio

Learning Outcomes

1. Identify the advantages and disadvantages of an integrated platform for business intelligence. 

2. Assess dataset variables to determine a course of action. 

3. Construct visualizations from a clean dataset using retinal visual encodings and Tufte’s information-to-ink ratio theories and interpret the data by providing supporting details. 

4. Develop recommendations for improving an existing business intelligence model.