Training Overview
Learn about various ways to optimize the MicroStrategy schema to improve performance. Monitor the objects in your project to determine what is being used, & what objects can be deprecated. Use aggregate tables & data marts to reduce query times. Partition large fact tables into smaller tables, reducing the amount of time needed to load & scan data. Enable users to access data not already in your project with data import.
Learning Objectives:
- Monitor objects
- Create a data mart & aggregate tables
- Partition fact tables
- Create an MTDI cube
Content Outline
Welcome to your training!
Managing projects to improve performance
Reducing query time with aggregate tables
Improving query performance with partitioning
Accessing additional data not already in your project with data import
Quiz: Optimizing the schema
Certification
Project Architects Certification
FAQs
A: This training provides training on all the topics & tools covered on the Alteryx Advanced Certification Exam.
You will be able to leverage Alteryx Designer to create advanced solutions, including building dynamic workflows & macros, as well as design analytic apps & deploy them to Alteryx Server. The training will also cover reporting, data investigation, spatial tools, & data wrangling techniques.
A: To attend the training session, you should've an operational Desktop or Laptop with the required specification, along with a good internet connection to access the labs.
A: We would always recommend you attend the live sessions to practice & clarify the doubts instantly & get more value from your investment. However, if, due to some contingency, you have to skip the class, Radiant Techlearning will help you with the recorded session of that particular day. However, the recorded sessions are not meant only for personal consumption & NOT for distribution or any commercial use.
A: Radiant Techlearning has a data centre containing a Virtual Training environment for the purpose of professional hand-on-practice.
Professionals can easily access these labs over Cloud with the help of a remote desktop connection.
Radiant virtual labs provide you with the flexibility to learn from anywhere in the world & at any time
A: The professionals will be enthralled as we engage them the real-world & industry Oriented projects during the training program. These projects will improve your skills & knowledge & you will gain a better experience. These real-time projects will help you a lot in your future tasks & assignments.