1 / 47

From Microsoft Access 1997 to Microsoft SharePoint/Office 2010 in 7 Years with Multi-Channel Retailer Studio Moderna

Required Slide. SESSION CODE: BIC203. From Microsoft Access 1997 to Microsoft SharePoint/Office 2010 in 7 Years with Multi-Channel Retailer Studio Moderna. Miha Kovač IT Manager Studio Moderna Matej Kralj Analyst Manager Studio Moderna. Question – Where is Slovenia ?. Slovenia.

art
Download Presentation

From Microsoft Access 1997 to Microsoft SharePoint/Office 2010 in 7 Years with Multi-Channel Retailer Studio Moderna

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 SESSION CODE: BIC203 From Microsoft Access 1997 to Microsoft SharePoint/Office 2010 in 7 Years with Multi-Channel Retailer Studio Moderna Miha Kovač IT Manager Studio Moderna Matej Kralj AnalystManager Studio Moderna

  2. Question – Where is Slovenia?

  3. Slovenia • populationof 2.06 M • 20,273 squarekm • Ljubljana • Euro • Drive on rightside • Wine: 43l percapita • Wine: US9.6lpercapita • Beer: 83l percapita • Beer: US 85l percapita

  4. Agenda • Studio Moderna • Business Intelligence in Studio Moderna/historical overview • Technology Adoption Program (TAP) • Power Pivot for Microsoft Excel 2010 • Power Pivot experience in Studio Moderna • BI road map to company success • Demo Share Point 2010/Power Pivot for MS Excel 2010 • Q&A

  5. Studio Moderna VIDEO

  6. Studio Moderna • 20 markets • MultiChannel(DRTV, Internet, Print, Telemarketing, Homeshopping, Retail, Wholesale) • 200 hours daily on TV • 35 call centers • 3000+ employees • Brand development

  7. Agenda • Studio Moderna • Business Intelligence in Studio Moderna/historical overview • Technology Adoption Program (TAP) • Power Pivot for Microsoft Excel 2010 • Power Pivot experience in Studio Moderna • BI road map to company success • Demo Share Point 2010/Power Pivot for MS Excel 2010 • Q&A

  8. Aggressive Revenue growth in Studio Moderna

  9. Aggressive growth of BI users in Studio Moderna

  10. Business intelligence in Studio Moderna

  11. PIS Basic informaton for TV products PIS Graphic and movie materials OLAP CPO OLAP Supply chain OLAP Costumer behavior OLAP For sales OLAP Finance SHAREPOINT integrated  Business intelligence in Studio Moderna Solution CPO 2005 e-ordering 2003 CPO For DRTV only CPO Multi priceing CPO Print PIS 2002 OLAP PBX OLAP 2002 Navision Local implementation start Navision Local version Navision Corporate edition E-ordering Multi distribution centers E-ordering Multi channel E-ordering Single sales channel CRMCatPro Multi company / channel & delivery planning CRMCatPro Costumer orientated CatPro Order taking and invoice generation Navision 1999 CRM 1996 Time versioning 2003 2004 2005 2006 2007 2008 2009 2010 2011

  12. Business intelligence in Studio Moderna Microsoft SQL 2000

  13. Businessintelligence in Studio Moderna Microsoft Analysis Services 2000

  14. Business intelligencein Studio Moderna UDM Analysis Services DW RDBMS +

  15. MOLAP OLAP Proclarity MOLAP OLAP MS Excel Datamart Usertool (1) Datamart Usertool (2) Business intelligence in Studio Moderna Datasource Data Model EnduserTools DW Dashboard Doublemodels Doubledata

  16. Problems/Issues • Different IT systems; from SQL 2000 to SQL 2008 • Different entry points for final users • Which data are correct? • Administration interferes development • Double system => locally and central • Old habits die hard=> habit goes to bad habit • Demanding final users

  17. BI modernization • Proof of Concept • Business process analysis • System analysis • Goal: • BI modernization • One platform for BI • Local OLAP servers to Central OLAP server • Consolidating OLAP server in central system • New Microsoft technology - one • DW scalability, powerful DW, reliable DW,…. • What to do with final user interface (ProClarity)

  18. Agenda • Studio Moderna • Business Intelligence in Studio Moderna/historical overview • Technology Adoption Program (TAP) • Power Pivot for Microsoft Excel 2010 • Power Pivot experience in Studio Moderna • BI road map to company success • Demo Share Point 2010/Power Pivot for MS Excel 2010 • Q&A

  19. TechnologyAdoptionProgram (TAP) • Testing of Microsoft product in test and/or production environment during „Beta“ phases • Why - Microsoft? • Feedback • Testing different scenario, new functionalities and product as a package • Seeking for new ideas and business needs; for first release and for the future • Reference, Case Study, Release video, …

  20. TechnologyAdoptionProgram (TAP) • Why - Customer? • New Technology • Connection directly with production group (very good also for further collaboration, influence on final product) • Full support during TAP environment • Reference, Case Study, Release Videos, … • Additional “sweets” => Case Study, promotion, free entry fees  • TAP in Slovenia • Studio Moderna experience

  21. Agenda • Studio Moderna • Business Intelligence in Studio Moderna/historical overview • Technology Adoption Program (TAP) • Power Pivot for Microsoft Excel 2010 • Power Pivot experience in Studio Moderna • BI road map to company success • Demo Share Point 2010/Power Pivot for MS Excel 2010 • Q&A

  22. Microsoft Vision and StrategyDemocratizing Business Intelligence Improving organizations by providing business insights toall employees leading to better, faster, and more relevant decisions • Delivered through a familiar environment • Integrated into business productivity infrastructure • Built on a trusted and extensible platform

  23. Microsoft Business IntelligenceGet more out of products wealready own Familiar User Experience Self-service Access and Insight Data Exploration and Analysis Predictive Analysis Data Visualization Contextual Visualization Business User Experience Integrated Content and Collaboration Thin Clients Dashboards BI Search Content Management Compositions Business Collaboration Platform Data Infrastructure and BI Platform Data Infrastructure and BI Platform Analysis Services Reporting Services Integration Services Master Data Data Mining Services Data Warehousing

  24. Microsoft BI Vision BI for Everyone BI for a Few

  25. Empowering the End User Analysis and query Self-service reporting Sharing and collaboration 25

  26. PowerPivot Retrieving and Combining unlimited data • Users experience with reports: • What they have • What is usefull • Where to find • How to use them • IT managing reports : • Security, scalability, …

  27. PowerPivot Manageable Self Service BI PowerPivotfor Excel PowerPivotfor SharePoint

  28. Agenda • Studio Moderna • Business Intelligence in Studio Moderna/historical overview • Technology Adoption Program (TAP) • Power Pivot for Microsoft Excel 2010 • Power Pivot experience in Studio Moderna • BI road map to company success • Demo Share Point 2010/Power Pivot for MS Excel 2010 • Q&A

  29. New IT Platform in Studio Moderna UDM Analysis Services DW RDBMS +

  30. Power Pivot – Studio Moderna • Add-in for Excel – mass BI • Excel environment => daily user experience • Data visualization • Sparklines • Exception Highlights • Slicer (multi options) • Multi-Chart • Databars Advantages

  31. Power Pivot – Studio Moderna • Fast development (new model/new report) • Combining data from different sources; OLAP cubes, Reporting Services, SQL Query, Excel Tables,… • Function “in-memory” actually works on desktop (data quantity) • Collaboration with SharePoint-om/Sharing • Update on data source / Off line usage • Excel Services insight SharePoint-a • IT => less work Advantages

  32. Power Pivot – Studio Moderna • IT person / Advance Analyst => Who will create models? • Speed issue with usage of multi-fact tables • New language; DAX • Analysis Services vs. Power Pivot • Slicer has no support for dimension structure • No import for OLAP dimensions • SQL AS 2000 is not supported (MDX) • Primary key support only one column • “Large” Excel files 500mb+ • Combining two or more OLAP cubes; wizard? Disadvantages / Issues

  33. Power Pivot – Studio Moderna • End user tool for advance analyst • Combining data from different sources • Datawarehouse - database normalization rules • PowerPivot ≠ Datawarehouse • Creating Models vs. Using Models • Great end user experience => Visualization • RAM plays significant role on desktop client computer Conclusion

  34. Agenda • Studio Moderna • Business Intelligence in Studio Moderna/historical overview • Technology Adoption Program (TAP) • Power Pivot for Microsoft Excel 2010 • Power Pivot experience in Studio Moderna • BI road map to company success • Demo Share Point 2010/Power Pivot for MS Excel 2010 • Q&A

  35. BI road map to company success Drive plan • Unified Business Intelligence (Central BI) • Dedicated Datawarehouse server (MS SQL 2008 R2) • Logging daily data transfer • Combining data from multi IT system on one unique platform (product, sales channel, geography) • Implementing user groups (400+ users) • One Point Entry for all users • Substitution for ProClarity

  36. BI road map to company success Whodecideandhowdecide? Top Management Strategic MiddleManagement Analytics Tactical Daily operative Number of decisions / Reports

  37. BI road map to company success Visualization – WhoandHow? Professional analytical tools Development Advance Reporting Tools Advance Analyse Portal - SharePoint Open Navigation Simple Reporting Tools Lead Navigation “Dashborad”, “Scorecard”,... Static Reports Pre-prepared Reports Top Management Middle Management Operative Analytics

  38. BI road map to company success Microsoft SharePoint 2010 – 360 ͦ • MS SharePoint 2010 (Excel Services) introduction / BI tool / end users exprerince • One point for all users; from top management to supervisor in CC • Power Pivot users – development • Power Pivot users – user; consumer • Excel for drill down • Collaboration among Countries, Sales Channels, People and Business roles • Soft approach with new end user tool (ProClarity 8 years; 4 versions)

  39. BI road map to company success

  40. SharePoint 2010/Power Pivot for MS Excel 2010 Matej Kralj Analyst Manager Studio Moderna DEMO

  41. Q&A IF {Question = 0} THEN {write=“Thank you”} ELSE {write= “Oh nooo, we ran out of time ”}

  42. Required Slide Speakers, please list the Breakout Sessions, Interactive Sessions, Labs and Demo Stations that are related to your session. Related Content • BIC06-INT | SQLCAT: PowerPivot Best Practices and Enterprise Case Studies • BIC201 | Customer Experiences with Business Intelligence • TLC-65 | Microsoft SQL Server 2008 R2 Business Intelligence • BIO03-HOL | Managing Microsoft PowerPivot for Microsoft Excel 2010 Solutions in SharePoint Server 2010 • BIO207 | BI Power Hour!

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

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

  45. Sign up for Tech·Ed 2011 and save $500 starting June 8 – June 31st http://northamerica.msteched.com/registration You can also register at the North America 2011 kiosk located at registrationJoin us in Atlanta next year

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

  47. Required Slide

More Related