Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

Zillow.com is an onine, web-based real estate site helping homcowners, buyers, s

ID: 3195868 • Letter: Z

Question

Zillow.com is an onine, web-based real estate site helping homcowners, buyers, sellers, renters real estate agents, mortgage professionals, property owners, and property managers thd and share information about real estate and morlgages. Zillow alows users to access, anonymoushy and free of charge, the kinds of tools and information previously reserved for real estate profes- slonals. Zillow's databases cover more than 90 milion homes, which represents 95 percent of the homes in the United States. Adding to the sheer size of its databases, Zilow recalculates home valuations for each property every day, so it can provide historical graphs on home time. In some areas, Zilow is able to displhy 10 years of valuation history, a value-added benefit for many of its customers. This collection of data represents an operational data warehouse for anyone isiting the website. valuations over As soon as Zillow launched its website, i immediately generated a massive amount of traftk. As the company expandod its services, the founders knew the key to its success would be the site's ablity to process and mansge massive amounts of data qickly, in real time. The company ident ted a need for accessible, scalable, relable, secure databases that would enable it to continue to increase the capacity of its iIntrastructure indefinitely without sacrilicing performance, Z continues to grow despite the weakened real estate market the company is experiencing annue raflic growth of 30 peroent, and about a thicd of all U.S. mortgge professkinals visit the site in agiven month ilow's traffic t us aodtpow Business Intelligence Zestimate values on Zillow use data-mining features for spotting trends across property valuatiors. Data mining also allows the company to see how accurate Zestimate values are ower time. Zilow has also built the industry's first search by monthly peymert, allwing users to find homes that are for sak and rent based on a monthly payment they can affard. Nong with the manthly payment search, usars can also enter search criteria such as the number of bedrooms or bathrooms illow also launched a new service aimed at changing the way Amenicans shop for mortgages. Borrowers can use Zillows new Mortgage Marketplace to get custom loan quotes from lenders without having to give their names, addresses, phone numbers, or Soclal Seaurty numbers, or field unwanted telephione cal's from brokers competing for their business. Borrowers reveal thoir identities only after contacting the lender of their choice. The rompany i emering·ind of Httllhed not. gage sites such as LendingTree.com and Experian Group's Lowermybils.com, which charge mortgage companles for borrower information. Zitow, which has an advertising modet, says it does not plan to charge for leads For mortgage companies, the anoniymous leads come free; they can make a bid based on information provided by the borrower, sach as salary, assets, credit score, and the type of loan Lenders can browse borrower requests and see competing quntes from other brokers before mak- Ing a bid Questions 1. What Is the source data for Zilw? 2. Describe how Zillaw uses business inteligence to create a unique product for its customers, 3. Why would a person 4 wi)y would Zilow use a data lake? searching Zilow want to use a data mart? Explain dirty data and its Impact on a business. 6. What woukd happen to Zilaw if it experienced dirty data?

Explanation / Answer

At Zillow, people themselves find and share the information.

Thus, the source data for Zillow is: homeowners, buyers, sellers, renters, real estate agents, mortgage professionals, property owners and property managers.