1 / 22

Revolutionizing Business Intelligence: American Tire Distributors Case Study

Learn how American Tire Distributors overcame reporting challenges & transformed operations using BI solutions. Discover their success story, benefits, best practices, and future plans.

kimball
Download Presentation

Revolutionizing Business Intelligence: American Tire Distributors Case Study

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Required Slide

  2. Required Slide SESSION CODE: ##### How Business Intelligence enabled American Tire Distributors Angelic Gibson Eric Melcher Director, IT Operations Solution Director American Tire Distributors Intellinet

  3. AMERICAN TIRE DISTRIBUTORSAgenda • Company Profile • Business Challenges and Pain • Solution and Products • Business and IT Benefits • Best Practices and Key Learning • Future Plans

  4. 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

  5. AMERICAN TIRE DISTRIBUTORSBusiness Challenges and Pain • Company was struggling with reporting • Business was requesting data that was located in several sources • No common processes for development and delivery of reporting needs • Legacy reporting applications at end of life

  6. AMERICAN TIRE DISTRIBUTORSSolution Background • Started with Proof of Concept • Partnered with Microsoft & Intellinet • Funded by all 3 partners • Demonstrated the business value of BI • Phase 1 project • Focused on an initial set of high visibility sales reports • Reports delivered via internal SharePoint Portal • Completed in June 09

  7. AMERICAN TIRE DISTRIBUTORS Solution Background • Solution continues to be expanded iteratively • Phase 2 supported additional data and reports (August 09) • Incorporated new data including commissions and budget data • Additional reports and dashboards to meet expanding needs • Enabled power users to leverage Excel and Excel Services for ad-hoc analysis • Rolled 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 units • Provide reporting capabilities to external users to view services related information and inventories outside of the corporate intranet

  8. AMERICAN TIRE DISTRIBUTORS Solution Products & Usage • SQL Server 2008 • Integration Services • Analysis Services • Reporting Services • Microsoft Office SharePoint Server 2007 • Excel Services • PerformancePoint 2007 • These products support three distinct sets of end user functionality

  9. AMERICAN TIRE DISTRIBUTORSStandard Reporting • Operational in nature • Focused on ease of use and ability to print • Largest user base • Consumed within SharePoint • Distributed via email

  10. AMERICAN TIRE DISTRIBUTORSDynamic Dashboards • Same information as reports, but more dynamic and flexible • Users can interact with and explore data over the web • Offers more strategic views into data • Smaller user base than reports, but fills key business need

  11. AMERICAN TIRE DISTRIBUTORSAd-Hoc Analysis • Leverage Excel against Analysis Services for Ad-hoc analysis • Highly flexible, allowing users to answer their own questions • Small set of Power Users with training • Users can publish content back to SharePoint

  12. AMERICAN TIRE DISTRIBUTORSBusiness and IT Value • One stop shopping for information across the organization • Significant 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 day • Clean and accessible sales data improved value of the business • Solution leverages current and mainstream technologies

  13. AMERICAN TIRE DISTRIBUTORS Solution Best Practices and Key Learning's • Proof of Concept is an efficient way to see potential and build business buy-in • Select strategic set of data to focus on initially • Decreases timeline for first release • Provides opportunity to build out framework components focused on a short amount of sources • Pay attention to security and data access • Expect data quality issues therefore test heavily

  14. AMERICAN TIRE DISTRIBUTORSSolution Futures • Add data to support the entire business, order to cash • Integrate a more streamlined budgeting and forecasting process • Leverage new functionality within the platform • Roll out to additional users and evolve content

  15. Required Slide Track PMs will supply the content for this slide, which will be inserted during the final scrub. Track Resources • Resource 1 • Resource 2 • Resource 3 • Resource 4

  16. Required Slide Resources Learning • Sessions On-Demand & Community • Microsoft Certification & Training Resources www.microsoft.com/teched www.microsoft.com/learning • Resources for IT Professionals • Resources for Developers • http://microsoft.com/technet • http://microsoft.com/msdn

  17. Required Slide Speakers, please list the Breakout Sessions, Interactive Sessions, Labs and Demo Stations that are related to your session. 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)

  18. Required Slide Complete an evaluation on CommNet and enter to win!

  19. © 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.

More Related