![]() Having all the data stored in a database dedicated to performing analytics you can: Most certainly you will also want to enrich this data with others coming from your ticketing system, your accounting software, or your marketing platform. No matter the product of your company, the chances are that the most valuable data, this capturing your customers’ interaction with your company will be held in your production PostgreSQL database.įrom the users’ interaction with your platform or e-shop to product descriptions and user-generated events, this data needs to be further analyzed in order to identify what aspects of the product you need to focus on next, what are the most commonly faced problems, and how you can possibly get extra traction and more users. However, if you plan to push the data to another PostgreSQL database then you probably don’t have to worry about the data types, unless you have some reasons related to the analysis that you will perform. While for the most common data types the mapping choices may seem to be obvious, each database system will most probably support a set of more “sophisticated” and database-specific types whose mapping choices requires careful consideration since they can limit the expressivity of your queries and restrict your analysts on what they can do directly out of the database. Again, depending on the system that you will send the data to you will have to make the right choices. Also, you have to choose the right data types.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |