CAREER
    CONTACT US
    Avatar_Color
    Back to achievements

    Optimization and maintenance of a Microstategy Platform

    • Practice
    Process Review Training Data Visualization
    • Team

    1 Expert, 3 developpers

    • Technical environment
    Reduction
    in Ticket Volume and Resolution Time
    Increased
    user autonomy
    Stabilized
    BI Platform
    CHALLENGES
    • Over 10 years old, the platform did not adhere to MicroStrategy and SQL Server best practices and standards.

    • High Demand for User Training: Users showed low autonomy with frequent requests for training on tool usage.

    • Significant Ticket Volume: Approximately 100 tickets handled for both RUN and BUILD requests.

    • Performance Issues: Intense usage of email pushes and large exports led to recurring performance bottlenecks.

    • International Scope: The platform supports users across various countries, adding complexity to training and support.
    SOLUTION
    • Implementation of a MicroStrategy Platform Cleanup Project

    • Object Optimization: Masking rarely or unused objects and renaming for unique identification

    • Subscription Optimization: Identification and enhancement of time-consuming subscriptions, with ongoing monitoring of each subscription using Platform Analytics

    • Process Reorganization for RUN Coordination: Established structured processes to streamline collaboration with teams such as ETL

    • English-Language Training for Subsidiaries: Over 15 training sessions organized across two levels—Analyst and Advanced—for both French and international subsidiaries
    BENEFITS
    • Reduction in Ticket Volume and Resolution Time

    • User Training: Increased user autonomy enables users to easily develop their own business use cases, reducing dependency on IT teams.

    • Stabilized BI Platform: Performance enhancement initiatives have contributed to a more stable BI environment.

    • Internal BI Team Skill Development: Ongoing training and coordination rituals enhance the internal BI team’s capabilities and improve team collaboration.