1. For the first, Task both parts where answered in two seperate sql queries. q1p1 and q1p2.

2. For the second task, all of the questions where answerd in four seperate parts. (q2p1,q2p2,q2p3 and q2p4).

• I have imported the Holidays csv file to the Database.

Based on Query results, We can see a huge differnece between dialy average of sales in holidays and non-holidays. Additionaly based on queries, it is obvious that holidays may have an absoloute impact on Providers Availability.

4. In my opinion It is impossible to to analyze the campgain imapct on holidays without datails of holidays before starting campgain.

5. I have set a docker container for metbase using metabase official docker image.

The commands are as below:

1. docker pull metabase/metabase:latest
2. docker run -d -v /path/to/db:/mock_DG.db --name metabase -e MB_DB_FILE=/mock_DG.db -p 3000:3000 metabase/metabase where the volume path was "C:\Users\Lenovo\Desktop\DgTask\mock_DG.db"
3. Runing docker container on localhost:3000
4. giving sqllite db path to metabase and after connection, Creating Dashboards.

5. Adding sql questions and visulize them and finnaly adding them to a dashborad.

Sql quries in metabase are shown as below:

6. The Final Dashboard is :