How Business Intelligence enabled American Tire DistributorsAngelic Gibson Eric MelcherDirector, IT Operations Solution DirectorAmerican Tire Distributors Intellinet

SESSION CODE: #####

AMERICAN TIRE DISTRIBUTORSAgenda

Company ProfileBusiness Challenges and PainSolution and ProductsBusiness and IT BenefitsBest Practices and Key LearningFuture Plans

AMERICAN TIRE DISTRIBUTORSCompany Profile

Located in Huntersville, NC Over 2,500 Employees Over 2B in Revenue Privately Held 80,000 Customers Served 85 Distribution Centers 750 Delivery Trucks 4.8 Million Invoices 1,000+ Third Party Transactions Processed per Day Over 7.5 Million Square Feet of Warehouse Space

AMERICAN TIRE DISTRIBUTORSBusiness Challenges and Pain

Company was struggling with reportingBusiness was requesting data that was located in several sourcesNo common processes for development and delivery of reporting needsLegacy reporting applications at end of life

AMERICAN TIRE DISTRIBUTORSSolution Background

Started with Proof of ConceptPartnered with Microsoft & IntellinetFunded by all 3 partnersDemonstrated the business value of BI

Phase 1 projectFocused on an initial set of high visibility sales reportsReports delivered via internal SharePoint PortalCompleted in June 09

AMERICAN TIRE DISTRIBUTORS Solution Background

Solution continues to be expanded iterativelyPhase 2 supported additional data and reports (August 09)

Incorporated new data including commissions and budget dataAdditional reports and dashboards to meet expanding needsEnabled power users to leverage Excel and Excel Services for ad-hoc analysisRolled out to business in February 2010

Phase 3 supports additional areas of the (In Progress) Add marketing and promotions data along with support and security for additional business unitsProvide reporting capabilities to external users to view services related information and inventories outside of the corporate intranet

AMERICAN TIRE DISTRIBUTORS Solution Products & Usage

SQL Server 2008Integration ServicesAnalysis ServicesReporting Services

Microsoft Office SharePoint Server 2007Excel Services

PerformancePoint 2007These products support three distinct sets of end user functionality

AMERICAN TIRE DISTRIBUTORSStandard Reporting

Operational in natureFocused on ease of use and ability to printLargest user baseConsumed within SharePointDistributed via email

AMERICAN TIRE DISTRIBUTORSDynamic Dashboards

Same information as reports, but more dynamic and flexibleUsers can interact with and explore data over the webOffers more strategic views into dataSmaller user base than reports, but fills key business need

AMERICAN TIRE DISTRIBUTORSAd-Hoc Analysis

Leverage Excel against Analysis Services for Ad-hoc analysisHighly flexible, allowing users to answer their own questionsSmall set of Power Users with trainingUsers can publish content back to SharePoint

AMERICAN TIRE DISTRIBUTORSBusiness and IT Value

One stop shopping for information across the organizationSignificant improvement in usability over previous solutions (green screen)Recent acquisition by new private investment firm

Reduced time spent gathering business information from months to a dayClean and accessible sales data improved value of the business

Solution leverages current and mainstream technologies

AMERICAN TIRE DISTRIBUTORS Solution Best Practices and Key Learning's

Proof of Concept is an efficient way to see potential and build business buy-inSelect strategic set of data to focus on initially

Decreases timeline for first releaseProvides opportunity to build out framework components focused on a short amount of sources

Pay attention to security and data accessExpect data quality issues therefore test heavily

AMERICAN TIRE DISTRIBUTORSSolution Futures

Add data to support the entire business, order to cashIntegrate a more streamlined budgeting and forecasting processLeverage new functionality within the platformRoll out to additional users and evolve content

Track Resources

Resource 1

Resource 2

Resource 3

Resource 4

Resources

www.microsoft.com/teched

Sessions On-Demand & Community Microsoft Certification & Training Resources

Resources for IT Professionals Resources for Developers

www.microsoft.com/learning

http://microsoft.com/technet http://microsoft.com/msdn

Learning

Related Content

Breakout Sessions (session codes and titles)

Interactive Sessions (session codes and titles)

Hands-on Labs (session codes and titles)

Product Demo Stations (demo station title and location)

Complete an evaluation on CommNet and enter to win!

© 2010 Microsoft Corporation. All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries.The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to

be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.