Changes between Version 4 and Version 5 of AdvancedReports


Ignore:
Timestamp:
05/25/26 17:48:22 (2 days ago)
Author:
232012
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • AdvancedReports

    v4 v5  
    99==== SQL
    1010
     11{{{
     12SQL CODE
     13}}}
     14
    1115==== Relational Algebra
    1216
     17{{{
     18RELATIONAL ALGEBRA
     19}}}
    1320
    1421== 2. Slow Moving Products
    … …  
    2027==== SQL
    2128
     29{{{
     30SQL CODE
     31}}}
     32
    2233==== Relational Algebra
    2334
     35{{{
     36RELATIONAL ALGEBRA
     37}}}
    2438
    2539== 3. Impact of Admin Discounts on Sales Numbers
    … …  
    3145==== SQL
    3246
     47{{{
     48SQL CODE
     49}}}
     50
    3351==== Relational Algebra
     52
     53{{{
     54RELATIONAL ALGEBRA
     55}}}
     56
    3457
    3558
    3659== 4. Customer Habits and Points Spending
    3760
     61{{{#!div style="text-align: justify; width: 100%;"
     62This report tracks how registered users behave over a **<period of time>** by looking at how they earn and spend their rewards points. It groups buyers based on the year they created their accounts and measures their total shopping history alongside their points balance to see who is saving up thousands of points and who is actively spending them. This helps find high-value users who hold a large number of unspent points, which represents a future discount cost and can indicate if customers stop buying completely once their free rewards are used up.
     63}}}
     64
    3865==== SQL
     66
     67{{{
     68SQL CODE
     69}}}
    3970
    4071==== Relational Algebra
    4172
     73{{{
     74RELATIONAL ALGEBRA
     75}}}
     76
     77