Posts

Showing posts from July, 2023

My first data analyst job

Image
Previous work experience : estimating housing prices To place this experience in time, MS Excel still had a limit of 64k rows in 2005… My first paid job as an economist was when I worked on a project, where the leader Hungarian Bank wanted to have a real estate value estimator model, based on their data. The bank outsourced the data cleaning and experimenting phase to a smaller company. The goal of the project was to aid the in-house house appraisers to make better appraisals and reduce the chances of collusion. In those times, it was pretty common that the appraised value 'miraculously' matched the value needed for the buyers to cover the missing money to buy the property... Due to the Hungarian mortgage laws the major threat of losing money for the Bank was a VERY bad appraisal, as one still owned money if the amount from the sold property did not cover the debt. One of the key challenges of the project was to build a training dataset , as the appraisers used Excel files fo...

Capturing Key Insights: The Power of Documentation

In my journey of learning from personal experiences, I inherited a simple yet effective method from my father during my time working at his dairy farm. As the CEO and major shareholder, he relied on a diary to record the day's significant events and key numbers. Despite the convenience of technology at my disposal, I realized the value of his approach when it came to quick queries like historical harvest dates or weather anomalies. From this experience, I wholeheartedly recommend everyone to document their own experiences. Personally, I leverage cloud-based platforms for this purpose. By recording the date, using relevant metadata such as keywords like "Python", "BigQuery", or "algorithms", and summarizing the main takeaways in my own words, I create a comprehensive record. Additionally, I can easily incorporate code snippets, images, or links if necessary. With advancements in LLM technology, usability has improved significantly: autocorrection featur...