Introduction to MicroStrategy Report Development I

Explore MicroStrategy architecture, from source systems and ETL to star and snowflake schemas, data marts, and the intelligence server, including web and mobile servers and caching for reports.

Explore MicroStrategy metadata, a database that stores object definitions and object ids, maps project objects to data, does not contain data, and records table name, column name, and data type.

Learn about schema, public, and configuration objects in MicroStrategy and how to develop and update them with facts, attributes, prompts, consolidations, and reports across environments.

Explore the MicroStrategy developer and web environment, including project sources, public and schema objects, data explorer, and subscriptions for delivering reports and dashboards.

Practice creating and modifying attributes in MicroStrategy by editing column aliases and data types, building description forms, mapping with lookups, and validating report connectivity.

Learn to create and map a fact in MicroStrategy, build metrics from facts, apply aggregates, and use fact level extension to derive daily data for reports.

Explore how metrics in MicroStrategy build key performance indicators from facts, combining revenue, profit, and quantity with aggregations, filters, and transformations to enable time-based comparisons.

Learn to define and reuse MicroStrategy metrics with base formulas, join types, and conditional metrics, and to apply report and metric level filters for precise data.

Explore how filters in MicroStrategy determine which data to access, apply to metrics, and shape results with qualification, element list, custom expression, and joint element list filters.

Create an attribute element qualification filter in MicroStrategy, apply it to a report, and verify results for selected elements such as Atlanta and Miami.

Navigate the MicroStrategy report editor's design, grid, and graph views to build vertical clustered bar graphs and explore OLAP features like filters and dynamic aggregation.

Explore MicroStrategy report views, including design, grid, graph, and sequel, to build, preview, and optimize reports by dragging objects, adding filters, and viewing execution details.

Explore how to manipulate report data in microstrategy by applying report limits and metric level qualifications, including percentage criteria and automatic condition application.

Apply banding to group rows and columns with alternating colors for easier reading, lock fixed headers, and merge identical row or column headers to simplify MicroStrategy reports.