MicroStrategy Training Courses: A Detailed Curriculum for Analysts, Developers, and Administrators
MicroStrategy Training Courses is divided into three core tracks, ensuring that Analysts/Developers, Architects/Modelers, and Administrators acquire the specific, high-value skills necessary for their respective roles while maintaining a foundational understanding of the overall platform architecture.
Track 1: Analyst and Report Developer Essentials 📊
(Focus: Content Creation, Visualization, and Data Consumption)
This track targets end-users, business analysts, and report developers focused on generating insights and consuming data via the MicroStrategy interface (Workstation, Web, Library).
Module 1.1: Data Access and Preparation
Data Import and Connectivity: Connecting to diverse data sources (spreadsheets, cloud services, databases) using the Data Import feature.
Data Wrangling and Transformation: Cleaning, shaping, and transforming data directly within MicroStrategy Workstation to improve quality and usability.
Derived Elements: Creating simple in-memory metrics, calculated attributes, and custom groups for immediate analysis without modifying the core schema.
Intelligent Cubes (Consumption View): Understanding what Intelligent Cubes are and how they are used to power high-speed, interactive analysis.
Module 1.2: Dossier and Dashboard Design
Visualization Mastery: Selecting and configuring the appropriate visualizations (graphs, maps, network diagrams) for effective data storytelling.
Interactivity: Implementing advanced filters, selectors, grouping, and links to enable dynamic data exploration within Dossiers.
Design Principles: Applying best practices for layout, color theory, and user experience (UX) to create impactful and intuitive dashboards.
Mobile Analytics: Configuring Dossiers for optimal viewing and interaction on mobile devices via MicroStrategy Library Mobile.
Module 1.3: Report Services and Pixel-Perfect Reports
Report Services Documents (RSDs): Designing highly formatted, multi-page documents used for governed reporting (e.g., statements, PDFs for mass distribution).
Report Elements: Working with grids, charts, panel stacks, and advanced layout containers to achieve pixel-perfect formatting.
Transactional Services: Implementing transactional write-back capabilities within reports for capturing user input (e.g., surveys, budget planning).
Track 2: Architect and Modeler Mastery 🧠
(Focus: Semantic Layer Design, Data Governance, and Performance)
This track is essential for the MicroStrategy Certified Developer (MCD) and Certified Platform Architect (CPA), focusing on building the metadata and schema that defines the single version of truth.
Module 2.1: Semantic Layer Fundamentals
Metadata Repository: Deep understanding of the metadata's role as the central hub of all business logic and object definitions.
Project Creation: Using the Project Creation Assistant to set up a new project structure and define connections to the data warehouse.
Object Hierarchy: Distinguishing and managing Schema Objects (Attributes, Facts, Tables) and Public Objects (Metrics, Filters, Reports).
Module 2.2: Data Modeling and Schema Design
Attribute Design: Defining Attribute forms (ID, Description), setting parent-child relationships, and creating user-defined hierarchies for seamless drilling.
Fact and Table Design: Mapping facts to logical tables, defining fact extensions, and utilizing Logical Views to simplify complex SQL queries.
Warehouse Catalog Management: Managing and synchronizing the connection between the MicroStrategy schema and the physical data warehouse tables.
Module 2.3: Advanced Metrics and Query Optimization
Metric Types: Creating complex metrics, including Compound Metrics, Transformation Metrics (e.g., Year-over-Year), and Conditional Metrics.
Level Metrics Mastery: Controlling the aggregation level of metrics regardless of the report template dimensionality (critical for calculating rates and percentages).
VLDB Properties (Strategic): Introduction to Very Large Database (VLDB) Properties and how to strategically tune them at the Report, Metric, and Database Instance levels to optimize SQL generation and query performance.
Track 3: Administrator and Platform Governance ⚙️
(Focus: Installation, Security, Maintenance, and Automation)
This track is mandatory for the MicroStrategy Certified Administrator (MCE), covering the deployment, configuration, security, and health of the platform architecture.
Module 3.1: Platform Architecture and Installation
Architecture Review: Understanding the distributed components: Intelligence Server, Web Server, Library, and Collaboration Services.
Installation and Configuration: Hands-on installation of the Intelligence Server on Windows and Linux, configuring the MicroStrategy Environment.
Clustering: Setting up a highly available Intelligence Server Cluster for automatic load balancing and failover capabilities.
Module 3.2: Enterprise Security and User Management
User Provisioning: Managing users, groups, and security roles through the User Manager and Workstation.
Authentication: Integrating with enterprise authentication systems like LDAP, Active Directory, and Single Sign-On (SSO) via SAML.
Row-Level Security (RLS): Implementing and managing Security Filters to strictly control the data rows users are allowed to see based on their profile.
Object Security: Defining Access Control Lists (ACLs) to control user permissions for viewing, modifying, or deleting reports and objects.
Module 3.3: Performance, Caching, and Lifecycle Management
Caching Strategy: Configuring and managing all cache types, including Intelligent Cubes, Report Caches, and Element Caches to minimize database load and maximize report speed.
System Monitoring: Utilizing MicroStrategy Platform Analytics to monitor system performance, user activity, job execution, and error logs for proactive maintenance.
Automation: Scripting administrative tasks (e.g., user creation, cache deletion, subscription management) using MicroStrategy Command Manager.
Lifecycle Management: Employing Object Manager for governed content migration and promotion across development, test, and production environments, along with Integrity Manager for validating report consistency.
Comments
Post a Comment