Accurate, Comprehensive and Easy-to-Use Data Lineage System
for the visualisation of dependencies between reports, transformations and database objects.
Unstable performance?
Frequently changing execution plans?
Unexplainable “EXPLAINs”?
We have a rare combination of intertechnological expertise, optimisation methodology and tools. This enables us to solve problems both within your Teradata system and at the application interface!
Unexpected joins in the metric calculation?
Too many SQL passes?
Aggregation isn’t being used?
With over 15 years of MicroStrategy project experience, we can review your system and effectively help you solve modelling and SQL generation problems!
This practical 3-day workshop is designed for MicroStrategy architects and developers who want to
In most cases over 90% of report duration is consumed only by the execution of generated queries in the database. Therefore the best results in performance optimization can be achieved by SQL tuning. The aim of this workshop is to show corresponding modelling techniques in MicroStrategy.
In general, such performance optimization process can be divided into three steps.
First we try to reduce the number of queries that access big (fact) tables. Then we improve remaining queries helping database optimizer to find a good execution plan. Finally, if neither the number of queries nor their complexity can be reduced, using aggregations provides another way to improve performance of the report.
In our workshop we will discuss optimizations on each of these levels.
ELT Desktop is a tool that helps you to transform your data. Well, there are several tools on the market that do that thing, so what’s the difference? The difference to most of the other tools is:
we do it inside your database!
