Before we move on to dashboard creation, in this lesson we will mention a few tips and tricks to ensure your datasets are optimally set up. As we mentioned in the “Connect new data” lesson, to ensure seamless communication between your data server and Luzmo, it might be required to add our IP addresses to your data source’s allowlist to allow us to seamlessly connect to it. Make sure to verify whether or not this would be required from your end, and handle accordingly! This simple yet essential step guarantees that data can flow freely, enabling a smooth and secure interaction between your server and our platform.
Preparing your data for analytics is a pivotal step in unlocking its full potential. The academy article on preparing your data for analytics demonstrates how to achieve this through an example by first normalizing the data, then translating database values to business relevant values, adding additional business logic and linking datasets so they can be used together in a dashboard.
You may also improve the querying performance by enabling query caching, which will keep in memory for a short period of time the results of queries so that if an identical query is necessary for another chart the result will be served from memory and not queried again from your database.
Furthermore, you can choose to activate Warp, also known as accelerating your data, so that a copy of your datasets are periodically downloaded into our fast optimized analytical data store and the dashboards are served using this as the data source.
When linking datasets it is important to keep in mind that they should have at least one common column with the same data type, that you should only link from one side to the other and that this link should be done to a column that only has one entry for each unique value on the origin column. You can find more detailed information in the academy article: Important when linking datasets.
By setting the default data format of the columns on a dataset’s page you may save the time of configuring them individually on each of the charts of your dashboard.
Be sure to take into account the data related performance tips mentioned in the academy, which include:
You may also find it useful to use the data ready for production checklist to ensure everything is correctly set up for your data analytics to take off!