Challenge
Our client, a Microsoft data analysis team, supports the worldwide partner marketing organizations within Microsoft, and is responsible for creating ad-hoc reports across multiple data systems where reporting does not otherwise exist. Microsoft’s primary challenge and need was the ability to extract information from various systems—including partner, account management, opportunity management, and revenue reporting databases—providing accurate reports and business insights to Microsoft subsidiaries and worldwide marketing teams.
Solution
Allyis provides a managed team of six full-time data analysts to support the analysis group and their reporting needs. The team consults with Microsoft program managers on which systems contain the data they wish to analyze, makes recommendations on reporting layout, data points, and methodologies best suited to their reporting need, and helps them analyze and interpret data. In addition to providing such support for business, operations, IT, and support teams, the Allyis team is also responsible for:
Developing customized service request tracking, reporting, and
workflow tools allowing Microsoft to track all reporting requests, prioritize them, and deliver them within a vigorous Service Level Agreement (SLA).
Monitoring patterns in stakeholder reporting requirements, ensuring Microsoft optimizes existing reports to efficiently fulfill the needs of multiple stakeholders.
Managing
upgrades and migrations supporting emerging Microsoft technologies in reporting spaces—including migrating to SQL Server 2005, SQL Server Integration Services (previously known as DTS), and SQL Reporting Services.
Serving as a liaison between production and user support, operations, and other analysis/engineering resources to research data-related issues and provide feedback and resolutions as appropriate.
Validating data, design, and adoption plans for an OLAP-based data warehouse designated as the repository for all partner data and revenue/licensing data. Creating
adoption and deployment plans to integrate the tool into work scenarios for daily use, ensuring the reporting stakeholders can quickly and easily consume reports and lists generated through the tool.
Key Benefits
Provides Microsoft with complex reporting capabilities not available elsewhere, and ensures continuity of reporting through the client’s constantly evolving infrastructure and systems.
Provides methodologies for on boarding mission-critical applications through rigorous IT requirements, including Microsoft Application Security Assurance Program (ASAP), which meticulously evaluates an application’s compliance with Security, Privacy, Sarbanes-Oxley requirements, and optimization policies.
Creates reports enabling call-down and research activity for marketing initiatives requiring very specific cross-sections of the partner community.
Achieves over 99% QOS as defined in Service Level Agreement.
Provides reporting and metrics that measure the team’s handling of ad-hoc reporting requests. These metrics track important
Key Performance Indicators (
KPIs), helping the client see improvement trends, fluctuations in workload, and additional resource needs.
Products & ServicesAllyis' managed team provides end-to-end support including:
Systems Support
Technologies Used
Excel
Visual Basic for Applications (VBA)
OLAP viewers: ProClarity and panorama
