Having demonstrated that our initial models were not performing well with the provided data, we redirected our efforts in weeks 6 and 7. Our primary objective remains to support UNICEF in their technological journey and provide them with an AI tool that, even if it doesn't directly identify donors at risk of churning, enables data understanding, facilitating more informed decision-making.

During week 6, we started building an AI assistant designed to empower UNICEF with a tool where they can upload their data and query insights through natural language. The AI assistant tool that we have developed functions with two LLMs. The first LLM translates natural language queries into SQL, allowing the backend to extract relevant data from the database. The second LLM then translates this data into a natural language response. The result is displayed in a user-friendly chat interface. This natural language-to-SQL will enable non-technical people to query their data and give UNICEF a tool to explore and gather insights about their data.

In the same week, we received new data from UNICEF containing the payment history for their donor base. Recognizing the importance of time series data for our task, we noted that the new dataset was limited in scope, containing only a handful of features. Aware of the limitations of the data, towards the end of week 6, we decided to split our team efforts into the AI assistant tool and training new models with the newly available data.

In week 7, we worked on pre-processing the new data and feature engineering. Towards the end of the week, we started training our models concentrating on XGBoost, GBM, and LSTM models, aiming for improved performance. During this week, we also made improvements to the AI assistant. Apart from refining its functionality and appearance, we thought to introduce two additional modes: one for understanding customer segments and another for data visualization. These new features are still under development. 

Feel free to reach out if you have any questions, need more information, or have any advice for us!