MicroStrategy Enterprise Analytics Administration Training Course
| Course code | SD-BI-040 |
|---|---|
| Duration | 5 days |
| Level | Intermediate |
| Category | Business Intelligence |
| Delivery | Classroom or live online |
| Language | English |
| Certificate | Certificate of completion |
Course overview
MicroStrategy environments fail operationally when metadata changes are unmanaged, security filters are inconsistently applied, Intelligence Server capacity is guessed rather than measured, or production deployments overwrite trusted content. This course addresses the day-to-day administration work behind dependable enterprise analytics: maintaining project sources, controlling access to shared dossiers and reports, diagnosing service issues, and moving validated objects between development, test, and production without disrupting users.
Participants build practical administration skills across MicroStrategy architecture, Intelligence Server configuration, metadata management, user and group security, object permissions, authentication options, monitoring, cache management, and governed deployment. They learn to use MicroStrategy Workstation, Developer, Library, and Command Manager to inspect environments, configure administration settings, manage project objects, schedule operational tasks, and apply repeatable migration procedures. The course also covers capacity indicators, audit data, error investigation, and recovery considerations for enterprise BI services.
Instruction combines focused demonstrations with guided administration labs based on a multi-project analytics environment. Participants configure a security model, investigate a simulated performance incident, prepare a migration package, and document an operating procedure for a controlled release. They leave with an administration runbook containing environment checks, access-control decisions, deployment steps, monitoring measures, and escalation actions that can be adapted to their own MicroStrategy estate.
The course is best suited to professionals responsible for administering, supporting, governing, or releasing MicroStrategy analytics in established business intelligence teams. It gives managers a structured way to reduce reliance on individual platform specialists and establish more consistent operational control.
Course objectives
By the end of this course, participants will be able to:
- Configure MicroStrategy Intelligence Server, project sources, and core administration settings for a multi-project environment
- Administer users, groups, security roles, object permissions, and security filters using a documented access model
- Manage MicroStrategy metadata objects, project configuration, and object ownership to maintain governed shared content
- Use MicroStrategy Workstation and Developer to inspect projects, administer objects, and troubleshoot operational issues
- Analyze Intelligence Server statistics, audit information, caches, and logs to identify performance bottlenecks
- Plan and execute controlled object migrations between development, test, and production environments
- Automate repeatable administrative actions with MicroStrategy Command Manager scripts and task sequences
- Produce an enterprise MicroStrategy administration runbook covering monitoring, releases, recovery, and escalation
Benefits of attending
For you
- Build credible, hands-on experience administering MicroStrategy Intelligence Server and project environments
- Gain a repeatable method for diagnosing access, metadata, cache, and report-execution problems
- Develop evidence-based performance troubleshooting skills using server statistics, audit data, and logs
- Learn to plan safer MicroStrategy releases rather than relying on manual object copying
- Leave with a practical administration runbook that demonstrates operational capability to employers
For your organisation
- Reduce avoidable production disruption through controlled migration and rollback procedures
- Improve protection of sensitive analytics through consistent groups, permissions, and security-filter administration
- Shorten incident resolution by giving support staff a structured approach to logs, statistics, caches, and audit evidence
- Increase confidence in analytics releases through documented development-to-production controls
- Reduce dependency on a single MicroStrategy specialist by establishing shared operating practices and runbooks
Target competencies
Who should attend
- MicroStrategy Administrators — who configure, secure, monitor, and maintain enterprise analytics environments
- Business Intelligence Platform Administrators — who support shared BI infrastructure and need MicroStrategy-specific operational controls
- MicroStrategy Developers — who need to understand metadata, security, and migration impacts on production content
- Data and Analytics Support Analysts — who investigate user access, report execution, and service-performance incidents
- BI Technical Leads — who define release practices, environment standards, and platform operating procedures
- Data Platform Managers — who need stronger governance, resilience, and support coverage for MicroStrategy services
Requirements and prerequisites
Participants should have hands-on experience using MicroStrategy as a developer, power user, support analyst, or junior administrator. They should understand the purpose of projects, dossiers, reports, attributes, metrics, prompts, user groups, and basic relational data sources. Familiarity with Windows Server administration, SQL query concepts, and enterprise authentication terminology such as LDAP or Active Directory is useful. Participants should be able to navigate MicroStrategy Library or Developer before attending. Deep database administration, scripting expertise, cluster engineering, or prior Command Manager experience is not required; these are introduced where needed.
Training methodology
The instructor uses a working MicroStrategy enterprise environment with separate development, test, and production project contexts. Short technical briefings establish the operating model, followed by guided labs in Workstation, Developer, Library, and Command Manager. Participants work through realistic incidents involving failed user access, slow report execution, stale caches, and conflicting metadata changes. Small-group reviews compare security and deployment decisions, while instructor feedback links each choice to supportability and risk. The final workshop converts lab decisions into an administration runbook and an application plan for the participant's own environment.
Course outline
Day 1: MicroStrategy architecture and administration foundations
- MicroStrategy enterprise architecture and component roles
- Intelligence Server services and project source connections
- Metadata repository purpose, dependencies, and administration considerations
- MicroStrategy Workstation administration interface and environment navigation
- Developer and Library roles in enterprise operations
- Project configuration, project loading, and project availability controls
- Administration baselines, naming standards, and environment documentation
Workshop: Participants map a supplied MicroStrategy environment, validate project connectivity, and produce an initial administration baseline for its development and production services.
Day 2: Security, access control, and governed content
- User accounts, groups, security roles, and inherited privileges
- Object permissions and folder-level access design
- Security filters and data-level access enforcement
- Authentication models including LDAP and Active Directory integration
- Library access, dossier sharing, and subscription permission considerations
- Object ownership, object dependencies, and shared-content governance
- Security administration audit checks and access-review evidence
Workshop: Participants configure a role-based security model for finance, sales, and external users, then test permissions and data visibility against defined scenarios.
Day 3: Performance monitoring and operational troubleshooting
- Intelligence Server statistics and operational health indicators
- Report execution lifecycle and common performance constraints
- Cache types, cache management, and cache invalidation decisions
- MicroStrategy audit data for usage and failure investigation
- Server logs, error messages, and structured incident triage
- Job prioritisation, workload patterns, and capacity planning inputs
- Troubleshooting slow reports, failed jobs, and unavailable project services
Workshop: Participants investigate a simulated month-end performance incident using server statistics, audit evidence, and logs, then produce a prioritized remediation report.
Day 4: Deployment, migration, and administration automation
- Development, test, and production environment design
- Object migration dependencies and impact assessment
- MicroStrategy object packages and controlled promotion procedures
- Conflict resolution, overwrite decisions, and rollback planning
- Command Manager syntax, scripts, and administrative commands
- Automation of user, group, and object administration tasks
- Release records, change approvals, and post-deployment validation
Workshop: Participants create a controlled release package, execute a staged migration scenario, and draft a Command Manager script for repeatable group administration.
Day 5: Enterprise operations, resilience, and administration planning
- Daily, weekly, and monthly MicroStrategy administration routines
- Backup, recovery, and metadata protection considerations
- Service continuity, escalation paths, and operational ownership
- Monitoring thresholds and alert-response procedures
- Capacity review and environment health reporting
- Administration runbook structure and support knowledge transfer
- Governance roadmap for MicroStrategy platform improvements
Workshop: Participants complete an enterprise administration runbook and present a 90-day improvement plan covering monitoring, security, releases, and support ownership.
Tools & standards covered
MicroStrategy Workstation, MicroStrategy Developer, MicroStrategy Library, MicroStrategy Command Manager
A typical training day
| 08:30 – 10:30 | First session |
| 10:30 – 10:45 | Refreshment break |
| 10:45 – 12:30 | Second session |
| 12:30 – 13:30 | Lunch and networking |
| 13:30 – 15:00 | Third session |
| 15:00 – 15:15 | Refreshment break |
| 15:15 – 16:30 | Workshop and daily review |
Live online deliveries follow the same structure in the East Africa Time zone, with shorter screen blocks and longer breaks.
What the fee includes
- Instruction by a practitioner facilitator
- Full course workbook and materials
- Exercise files, templates and case studies
- Certificate of completion
- Refreshments and lunch (classroom deliveries)
- Post-course application plan
- Facilitator follow-up on request
- Group rates from five participants
How you can take this course
Classroom
Scheduled sessions in Nairobi, Mombasa, Kigali, Dar es Salaam, Dubai and Cape Town.
Live online
The same facilitator and materials, delivered live for distributed teams and individuals.
In-house
Delivered privately for your team, at your offices or a venue of your choice, tailored to your context. Request a proposal.
Certification
Participants who complete the full five days receive the Skillset Development Certificate of Completion, stating the course title, course code, dates and delivery format — suitable for professional-development records and employer reimbursement.
Frequently asked questions
Upcoming sessions
New dates are being scheduled. Ask us about the next session or an in-house delivery for your team.
Ask about datesGroup of 5+?
Request in-house delivery or group rates →Related courses in Business Intelligence
Microsoft Fabric Business Intelligence Development Training Course
Business intelligence teams are often expected to deliver trusted Power BI reporting while data is spread across operational systems, spread…
Tableau Data Visualisation and Interactive Dashboards Training Course
Business teams often have access to large volumes of sales, operational, customer and financial data but still rely on static spreadsheets, …
SAP BusinessObjects Reporting and Semantic Layer Training Course
Business users and analysts often receive reports that are slow to build, inconsistent across teams, or dependent on IT to interpret databas…
Business Intelligence Reporting for Business Analysts Training Course
Business analysts are often asked to turn operational data into reports that answer management questions, expose performance gaps and suppor…