Using logical views to map schema objects to SQL queries

Training Overview

Learn about advanced data warehousing design & how to work with these complexities when architecting a MicroStrategy project. Understand how to implement logical views to solve data modelling & schema design issues.

Learning Objectives:

  • Model a flexible schema with logical views
  • Implement table aliases to create multiple logical tables that point to the same physical table
  • Use logical views to create attribute & fact expressions
  • Understand star schemas

Content Outline

a- Welcome to your training!

Understanding logical views in MicroStrategy

Creating logical views

Using logical views with a star schema

Quiz: Using logical views to map schema objects to SQL queries

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 have 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 session 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, those 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 & in any time zone. 

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.

Send a Message.


  • Enroll