Data Model for User Activity Flow

Hi, SanthiyaMallow 

Based on your description, It sounds like you are trying to design a schema for tracking user activity flow in a booking application. One approach to consider is using a graph database to model the relationships between events. In a graph database, you can represent events as nodes and the relationships between them as edges. This allows you to easily model complex relationships between events and track the flow of user activity through the application.

For example, you could have a node for each screen in your application, such as the home screen, pickup location selection screen, and check fare display screen. You could then create edges between these nodes to represent the flow of user activity from one screen to another. Each edge could have properties such as a unique ID and a timestamp to track when the user moved from one screen to another. This would allow you to easily query the database to see the flow of user activity and generate reports for your needs.

Another approach could be to use a relational database and create a table to store user activity events. Each row in the table could represent a single event, such as a user moving from the home screen to the pickup location selection screen. You could include columns for the event ID, timestamp, user ID, and any other relevant information. You could then use SQL queries to analyze the data and generate reports.

These are just a couple of ideas to consider. The best approach will depend on your specific needs and the requirements of your application.

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum