We have a need to create an independent data analytical system using PowerBI visualization, that will connect with all of our events and user properties so that we can accurately measure behavior, performance, cohorts, segmentation, funnels, etc..
**** We will start the project with the first phase as described below, split into 3 milestones:****
1. Integration between Firebase Big Query (take daily events data from there) and cloud server (new instance will be provided).
2. The data in raw format must be stored, both the data model and database must be selected for import into it. You will decide the most efficient database for us. Please indicate in your cover letter what you will use.
3. The single analytics query must be implemented over that data on the first stage. The query details will be provided later.
The task solution must have a vision on the future query extension so that the data structure will be optimized for that. The additional type of queries will be discussed before starting the first phase.