microstrategy freeform SQL essentials

  • Basic SQL knowledge
  • MicroStrategy Desktop: Reporting Essentials Training Course or equivalent knowledge
  • MicroStrategy Architect: Project Design Essentials Training Course or equivalent knowledge

MicroStrategy Freeform SQL Essentials Training course covers the capabilities and benefits of freeform SQL reports created in MicroStrategy Desktop.

Participants learn to configure a Freeform SQL database instance, create reports within the Freeform SQL editor, use prompts in these reports, compose advanced queries, access data from non-relational data sources, and implement security features within Freeform SQL reports.

MicroStrategy Report Developers, MicroStrategy Advanced Business Analysts, and anyone who has an interest in learning how to create reports with user-defined SQL queries.

COURSE AGENDA

  • Overview of Freeform SQL report creation
  • Configuring a Freeform SQL database instance
  • The Freeform SQL editor
  • Creating a Freeform SQL report
  • Managed objects
  • Filters and Freeform SQL reports
  • Drilling on Freeform SQL reports
  • Using Freeform SQL reports in documents
  • What is Freeform SQL?
  • What are the benefits of using Freeform SQL?
  • Comparison of Freeform SQL and standard reports
  • Using prompts in Freeform SQL reports
  • Creating a Freeform SQL report with prompts
  • Using derived and common table expressions
  • Using stored procedures
  • Accessing non-relational data sources
  • Configuring access to Freeform SQL objects
  • Using security filters in Freeform SQL reports

Copyright © 2025 All Rights Reserved by Cuesys Infotech.

Designed By  99 DESIGN AGENCY