Data Analyst
Current● Collect and analyze office building market information data in Chicago's urban and suburban areas (approximately 4,000+ data per quarter), including rent, vacancy rate, supply and absorption, etc. Use tools such as Excel and MySQL to analyze the market status and future trends, conduct q-o-q and y-o-y comparisons, and use Tableau tools to form quarterly market reports.● Use MySQL from 0 to 1 to build an online database specifically designed for brokerage teams, customers and operations teams, covering a total of 200+ office buildings and industrial parks in urban and suburban areas of Chicago. Also, use Tableau to build a dashboard for the above data, and maintain the database weekly.● Use Excel to build a series of data statistical tables for the brokerage team, asset management team and engineering team, streamlining the previous form process by 50% and increasing the accuracy by 70%. At the same time, Python was used to analyze transaction information to increase the accuracy of project advertising and increase the transaction rate by 11%.