Queries to MongoDB for reporting purposes

Employer

Krzysztof Fraus

Description

For the purpose of internal reporting, I will commission the preparation of several database queries.

Reports(queries) to be prepared:

- users

- active users per day

- average of examples made

- number of registrations per day

- most popular (progress of users)

- top 3 courses(+ by language)

- top 10 lessons(+ by language)

- top 10 examples in a given language

- learning mode

- time of day/learning

- sales

- monthly

- monthly by language

- total per year

- number of repeat buyers

- average time to buy again after previous subscription ends

- average time to purchase after registration

- number of users with more than one language

Published

on 2024-03-06

Offers sent (13)

API

aws

canva

+ 13 more

data analysis

data visualizations

git

+ 2 more

aws

backend

databases

+ 9 more

agile development

C Sharp

general applications

+ 7 more

databases

delphi

+ 6 more

3D CAD software

+ 642 more