BI Recruitment Task

This repo provide a set of preconfigured tools that can be used for the recruitment task for IFT:

• PostgreSQL database
• DBT
• Grafana

Tasks

One goal of the BI team is to design and implement dashboards to help Projects Lead have an overview of their project. Those dashboards will be use for the progress reporting, evaluating the project adoption, and identify improvment.

In the Database, you will find data extracted from one of our Github Project and wake financial data. With those, create some indicators concerning:

• The repartition of the issues.
• The activity on different repos.
• The Cost of the project.

The github data are base on the project Waku.

The database configuration:

• host: recruitment.free.technology
• port: 5432
• user: will be provided
• password: will be provided
• database name: recuitment_task
• schemas: raw_github,raw_finance

This repo contain a preconfigured partial stack to let you focus on the data manipulation. However, you are free to use any free technology you like, on the condition we can easily reproduce the result.

Expectations

We estimate the task you must spend on the task to be approximatively 5 hours, however we don't a full solution. If you send us a Proof of Concept with documentation to explain how you would continue the work is fine.

With this task, our goals are to:

• Understand your approch to a real problem.
• Evaluate some keys skills (Data transformation, graph creation).

It is recommended to submit the tasks result as a git repository containing all the files to reproduce the result.

If you are using this repo, we recommand that you export the grafana dashboard and add it with the dbt models to the git history.

Requirements

• Have docker installed

Usage

• Deploy the container with make run
• Shutdown the containers with make down
• Build the dbt models with make dbt-buidlt
• Compile the dbt models with make dbt-compile

The data from the database and grafana are persisted with docker volumes.