Abstract: Certain embodiments described herein relate to data analysis systems, methods, and devices that comprise one or more processes and/or methodologies to add structure around a tabular database. By doing so, certain data analysis systems, methods, and devices can provide similar analytical functionalities as structured databases on one hand, as well as similar scalability and/or performance capabilities as tabular databases. In some embodiments, an add-in to a tabular data engine, such as Microsoft Excel, can be provided, through which a user can be allowed to input one or more dimensions and/or variables as desired for generating an analytical report. Based on such input, in certain embodiments, the system can be configured to build one or more data analysis expression (DAX) queries to dynamically generate a report, which can subsequently be displayed in the tabular data engine.

Abstract: Certain embodiments described herein relate to data analysis systems, methods, and devices that comprise one or more processes and/or methodologies to add structure around a tabular database. By doing so, certain data analysis systems, methods, and devices can provide similar analytical functionalities as structured databases on one hand, as well as similar scalability and/or performance capabilities as tabular databases. In some embodiments, an add-in to a tabular data engine, such as Microsoft Excel, can be provided, through which a user can be allowed to input one or more dimensions and/or variables as desired for generating an analytical report. Based on such input, in certain embodiments, the system can be configured to build one or more data analysis expression (DAX) queries to dynamically generate a report, which can subsequently be displayed in the tabular data engine.