frappe / insights

Open source analytics / business intelligence tool (BI)
https://frappe.io/insights
GNU Affero General Public License v3.0
408 stars 200 forks source link

Insights notebook #121

Closed nextchamp-saqib closed 1 year ago

nextchamp-saqib commented 1 year ago

This pull request adds a new feature - Insights Notebook. With this, users can create complex queries in a single notebook, add context to each query, and visualize the data all in one place.

Insights Notebook addresses the current limitations of the query builder by providing a more intuitive way to build complex queries. Users can now create multiple queries in a single notebook and easily understand which query corresponds to which data. The tool also provides a way to visualize data in the notebook itself, further simplifying the process of understanding data.

Insights Notebook is a flexible and future-proof solution that can accommodate additional features in the future. The query builder in Insights Notebook allows users to build a query step-by-step, starting with the table and then adding filters, columns, and summarizing data.

Preview:

CleanShot 2023-05-09 at 13 32 37

CleanShot 2023-05-13 at 23 11 00

codecov-commenter commented 1 year ago

Codecov Report

Patch coverage: 47.85% and project coverage change: -1.63 :warning:

Comparison is base (18c95ab) 55.95% compared to head (f5ed963) 54.32%.

Additional details and impacted files ```diff @@ Coverage Diff @@ ## develop #121 +/- ## =========================================== - Coverage 55.95% 54.32% -1.63% =========================================== Files 52 58 +6 Lines 2965 3389 +424 =========================================== + Hits 1659 1841 +182 - Misses 1306 1548 +242 ``` | [Impacted Files](https://app.codecov.io/gh/frappe/insights/pull/121?src=pr&el=tree&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=frappe) | Coverage Δ | | |---|---|---| | [...ctype/insights\_data\_source/insights\_data\_source.py](https://app.codecov.io/gh/frappe/insights/pull/121?src=pr&el=tree&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=frappe#diff-aW5zaWdodHMvaW5zaWdodHMvZG9jdHlwZS9pbnNpZ2h0c19kYXRhX3NvdXJjZS9pbnNpZ2h0c19kYXRhX3NvdXJjZS5weQ==) | `68.69% <ø> (ø)` | | | [...hts/doctype/insights\_notebook/insights\_notebook.py](https://app.codecov.io/gh/frappe/insights/pull/121?src=pr&el=tree&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=frappe#diff-aW5zaWdodHMvaW5zaWdodHMvZG9jdHlwZS9pbnNpZ2h0c19ub3RlYm9vay9pbnNpZ2h0c19ub3RlYm9vay5weQ==) | `0.00% <0.00%> (ø)` | | | [...e/insights\_notebook\_page/insights\_notebook\_page.py](https://app.codecov.io/gh/frappe/insights/pull/121?src=pr&el=tree&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=frappe#diff-aW5zaWdodHMvaW5zaWdodHMvZG9jdHlwZS9pbnNpZ2h0c19ub3RlYm9va19wYWdlL2luc2lnaHRzX25vdGVib29rX3BhZ2UucHk=) | `0.00% <0.00%> (ø)` | | | [.../insights/doctype/insights\_table/insights\_table.py](https://app.codecov.io/gh/frappe/insights/pull/121?src=pr&el=tree&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=frappe#diff-aW5zaWdodHMvaW5zaWdodHMvZG9jdHlwZS9pbnNpZ2h0c190YWJsZS9pbnNpZ2h0c190YWJsZS5weQ==) | `56.09% <0.00%> (-10.57%)` | :arrow_down: | | [...ts/insights/doctype/insights\_team/insights\_team.py](https://app.codecov.io/gh/frappe/insights/pull/121?src=pr&el=tree&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=frappe#diff-aW5zaWdodHMvaW5zaWdodHMvZG9jdHlwZS9pbnNpZ2h0c190ZWFtL2luc2lnaHRzX3RlYW0ucHk=) | `81.90% <0.00%> (ø)` | | | [insights/insights/query\_builders/sql\_builder.py](https://app.codecov.io/gh/frappe/insights/pull/121?src=pr&el=tree&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=frappe#diff-aW5zaWdodHMvaW5zaWdodHMvcXVlcnlfYnVpbGRlcnMvc3FsX2J1aWxkZXIucHk=) | `67.02% <10.84%> (-12.21%)` | :arrow_down: | | [insights/decorators.py](https://app.codecov.io/gh/frappe/insights/pull/121?src=pr&el=tree&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=frappe#diff-aW5zaWdodHMvZGVjb3JhdG9ycy5weQ==) | `45.83% <21.73%> (-39.89%)` | :arrow_down: | | [.../doctype/insights\_query/insights\_assisted\_query.py](https://app.codecov.io/gh/frappe/insights/pull/121?src=pr&el=tree&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=frappe#diff-aW5zaWdodHMvaW5zaWdodHMvZG9jdHlwZS9pbnNpZ2h0c19xdWVyeS9pbnNpZ2h0c19hc3Npc3RlZF9xdWVyeS5weQ==) | `23.18% <23.18%> (ø)` | | | [insights/api/\_\_init\_\_.py](https://app.codecov.io/gh/frappe/insights/pull/121?src=pr&el=tree&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=frappe#diff-aW5zaWdodHMvYXBpL19faW5pdF9fLnB5) | `39.47% <32.55%> (-0.11%)` | :arrow_down: | | [insights/api/telemetry.py](https://app.codecov.io/gh/frappe/insights/pull/121?src=pr&el=tree&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=frappe#diff-aW5zaWdodHMvYXBpL3RlbGVtZXRyeS5weQ==) | `64.28% <33.33%> (ø)` | | | ... and [9 more](https://app.codecov.io/gh/frappe/insights/pull/121?src=pr&el=tree-more&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=frappe) | | ... and [1 file with indirect coverage changes](https://app.codecov.io/gh/frappe/insights/pull/121/indirect-changes?src=pr&el=tree-more&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=frappe)

:umbrella: View full report in Codecov by Sentry.
:loudspeaker: Do you have feedback about the report comment? Let us know in this issue.