Abstract: Techniques for data visualization, in which a template is defined that includes one or more drill paths for data visualization and dynamic code generation is performed to build at least one stored procedure for the one or more drill paths. The dynamic code generation includes generating dynamic code used to calculate data metric fields for the one or more drill paths included in the defined template. The data visualization includes importing, based on user input, the defined template, and the at least one stored procedure, source data that is needed to calculate the data metric fields using the generated dynamic code and caching, in a cache and based on the generated dynamic code, the imported source data and the data metric fields calculated using the generated dynamic code. At least one data structure is generated as data visualization output for one or more user devices based on the cache data.