Course Syllabus

Module 1: Data Warehousing & BI Concepts (4 hrs)

• Foundations of BI & DWH: OLTP vs OLAP, star/snowflake schemas, dimensional modeling with fact/dimension tables.

Module 2: MicroStrategy Overview & Architecture (6 hrs)

• Platform Fundamentals: MicroStrategy components (Desktop, Web, Intelligence Server, Distribution, Object Manager, Integrity Manager).
• Tool usage: Desktop vs Web interfaces, metadata repository, and object layering.

Module 3: Installation & Server Configuration (4 hrs)

• Setup best practices: OS and database prerequisites, ODBC/DSN configuration, licensing, Intelligence Server setup.

Module 4: Project & Metadata Objects (4 hrs)

• Meta‑database creation: Designing attributes and hierarchies, facts, metrics, filters, prompts, templates, and VLDB options.

Module 5: Basic Reporting (6 hrs)

• Report creation: Grid, graph, cross-tab, and map reports; sorting, filtering, pivoting, hierarchies, drill functionality, and caching.

Module 6: Advanced Reporting & Manipulation (4 hrs)

• Rich reporting: Templates, advanced prompts, metrics formatting, HTML report output, freeform SQL, Query Builder usage, hyperlinking, and VLDB tuning.

Module 7: OLAP & Intelligent Cubes (4 hrs)

• OLAP services: Intelligent Cube creation, ROLAP vs dynamic sourcing, incremental refresh, derived elements, grouping/filters.

Module 8: Dashboards & Scorecards (4 hrs)

• Visual insights: Build scorecards and dashboards using panels, dossiers, threshold-based alerts, and publishing to Mobile and Web.

Module 9: Performance & Security (4 hrs)

• Optimization: Report execution tuning (limit, joins, metrics), VLDB properties.
• Governance: User/groups, roles, object permissions, security model implementation.

Module 10: Administration & Troubleshooting (4 hrs)

• Platform admin: Server monitoring, command manager, Object Manager, system logs, change journals, Smart Health.

Module 11: Ecosystem Tools & SDK (2 hrs)

• Integrations: Enterprise Manager, Narrowcast, SDK, and MicroStrategy plugins.

Module 12: Capstone & Certification Prep (2 hrs)

• Hands‑on project: Build full BI solution (data model → dashboard → OLAP cube)
• Certification guidance: Aligns with MCSA/MicroStrategy cert exams, including best practices and exam prep.

• Key Features

    70% hands-on labs: real‑world BI workflows—report building, cube design, dashboards, OLAP setup.

    Project-based learning: mini‑projects per module and capstone dashboards/dossiers.

    Interactive mentoring: live Q&A, peer review sessions, and mock interviews.

    Full-stack tool exposure: Desktop, Web, Developer, Admin—plus SDK, Object Manager, Command Manager.

    Performance clinics: VLDB tuning, indexing, report caching, and smart health checks.

    Security governance: detailed coverage of roles, permissions, and enterprise best practices.

    Certification alignment: mock tests, structured guideposts, career coaching.

    Support & resources: access to recorded sessions, sample apps, user community, and lifetime learning support.