{"id":4683,"date":"2011-02-03T08:59:00","date_gmt":"2011-02-03T16:59:00","guid":{"rendered":""},"modified":"2024-01-22T22:50:07","modified_gmt":"2024-01-23T06:50:07","slug":"department-store-chain-stein-mart-speeds-their-reporting-saves-600000-a-year-in-tech-costs","status":"publish","type":"post","link":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/2011\/02\/03\/department-store-chain-stein-mart-speeds-their-reporting-saves-600000-a-year-in-tech-costs\/","title":{"rendered":"Department Store Chain Stein Mart Speeds Their Reporting, Saves $600,000 a Year in Tech Costs"},"content":{"rendered":"


Florida-based <\/span><\/span>Stein Mart<\/span><\/span><\/span><\/a>, a large department store chain with 268 locations in the US, <\/span>relies heavily on up-to-date data analysis and reporting for inventory management and promotional reviews<\/span>. <\/span><\/span>Unfortunately, the company\u2019s data warehouse system, which was based on IBM DB2 and AS\/400 data servers, had performance issues that often led to data reporting delays and cost the company thousands of dollars a month in hardware, licensing, and maintenance. <\/p>\n

<\/span><\/span><\/span>In order to lower cost and speed up turnaround time on their critical reports, Stein Mart turned to a new Microsoft solution based on <\/span>Microsoft SQL Server 2008 Enterprise database software, SQL Server 2008 Reporting Services, and SQL Server Fast Track Data Warehouse. The solution also includes Excel Services in Microsoft Office SharePoint Server 2007. <\/p>\n

<\/span><\/span>As a result of the new solution, weekly Stein Mart sales reports are processed in less than 3 hours, compared to 14 hours with the previous system. \u201cQuerying data is much faster than before with the new solution based on SQL Server 2008 and SQL Server Fast Track Data Warehouse,\u201d Ilan Wajsman, Data Systems Manager at Stein Mart. \u201cNow, our executives can access the latest business data on time.\u201d <\/p>\n

<\/span>Additionally, <\/span>Stein Mart now has the ability to pull transactional data and analyze its business from end to end. Using SQL Server 2008 Reporting Services, for instance, the company can perform in-depth business analysis of its transactional database. \u201cWith SQL Server 2008 and SQL Server Fast Track Data Warehouse, we can look at our entire transaction history and do market analysis and business forecasting, which we could not do previously.\u00a0 <\/span>This technology gives us the ability to be more fact-based as a company,\u201d says Wajsman. \u201cWe can make business decisions based on demonstrated sales history.\u201d <\/p>\n

<\/span><\/span>By implementing the Microsoft solution, Stein Mart was also able to consolidate its IT costs, contributing to a monthly savings of $50,000 in hardware leasing and maintenance costs. <\/p>\n

<\/span>To read more about Stein Mart\u2019s solution, visit the case study <\/span>here<\/span><\/span><\/a> or watch the video at: http:\/\/cm-edgetun.pages.dev\/servers\/missioncritical\/CIOBlogs.aspx<\/a><\/span><\/span><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

Florida-based Stein Mart, a large department store chain with 268 locations in the US, relies heavily on up-to-date data analysis and reporting for inventory management and promotional reviews.<\/p>\n","protected":false},"author":1457,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"ep_exclude_from_search":false,"_classifai_error":"","_classifai_text_to_speech_error":"","footnotes":""},"post_tag":[],"product":[],"content-type":[2424,2445],"topic":[],"coauthors":[2487],"class_list":["post-4683","post","type-post","status-publish","format-standard","hentry","content-type-best-practices","content-type-thought-leadership"],"yoast_head":"\nDepartment Store Chain Stein Mart Speeds Their Reporting, Saves $600,000 a Year in Tech Costs - Microsoft SQL Server Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/2011\/02\/03\/department-store-chain-stein-mart-speeds-their-reporting-saves-600000-a-year-in-tech-costs\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Department Store Chain Stein Mart Speeds Their Reporting, Saves $600,000 a Year in Tech Costs - Microsoft SQL Server Blog\" \/>\n<meta property=\"og:description\" content=\"Florida-based Stein Mart, a large department store chain with 268 locations in the US, relies heavily on up-to-date data analysis and reporting for inventory management and promotional reviews.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/2011\/02\/03\/department-store-chain-stein-mart-speeds-their-reporting-saves-600000-a-year-in-tech-costs\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft SQL Server Blog\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/www.facebook.com\/sqlserver\" \/>\n<meta property=\"article:published_time\" content=\"2011-02-03T16:59:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-01-23T06:50:07+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/08\/cropped-microsoft_logo_element.png\" \/>\n\t<meta property=\"og:image:width\" content=\"512\" \/>\n\t<meta property=\"og:image:height\" content=\"512\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"SQL Server Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SQLServer\" \/>\n<meta name=\"twitter:site\" content=\"@SQLServer\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"SQL Server Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 min read\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/cm-edgetun.pages.dev\\\/en-us\\\/sql-server\\\/blog\\\/2011\\\/02\\\/03\\\/department-store-chain-stein-mart-speeds-their-reporting-saves-600000-a-year-in-tech-costs\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/cm-edgetun.pages.dev\\\/en-us\\\/sql-server\\\/blog\\\/2011\\\/02\\\/03\\\/department-store-chain-stein-mart-speeds-their-reporting-saves-600000-a-year-in-tech-costs\\\/\"},\"author\":[{\"@id\":\"https:\\\/\\\/cm-edgetun.pages.dev\\\/en-us\\\/sql-server\\\/blog\\\/author\\\/sql-server-team\\\/\",\"@type\":\"Person\",\"@name\":\"SQL Server Team\"}],\"headline\":\"Department Store Chain Stein Mart Speeds Their Reporting, Saves $600,000 a Year in Tech Costs\",\"datePublished\":\"2011-02-03T16:59:00+00:00\",\"dateModified\":\"2024-01-23T06:50:07+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/cm-edgetun.pages.dev\\\/en-us\\\/sql-server\\\/blog\\\/2011\\\/02\\\/03\\\/department-store-chain-stein-mart-speeds-their-reporting-saves-600000-a-year-in-tech-costs\\\/\"},\"wordCount\":346,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/cm-edgetun.pages.dev\\\/en-us\\\/sql-server\\\/blog\\\/#organization\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/cm-edgetun.pages.dev\\\/en-us\\\/sql-server\\\/blog\\\/2011\\\/02\\\/03\\\/department-store-chain-stein-mart-speeds-their-reporting-saves-600000-a-year-in-tech-costs\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/cm-edgetun.pages.dev\\\/en-us\\\/sql-server\\\/blog\\\/2011\\\/02\\\/03\\\/department-store-chain-stein-mart-speeds-their-reporting-saves-600000-a-year-in-tech-costs\\\/\",\"url\":\"https:\\\/\\\/cm-edgetun.pages.dev\\\/en-us\\\/sql-server\\\/blog\\\/2011\\\/02\\\/03\\\/department-store-chain-stein-mart-speeds-their-reporting-saves-600000-a-year-in-tech-costs\\\/\",\"name\":\"Department Store Chain Stein Mart Speeds Their Reporting, Saves $600,000 a Year in Tech Costs - Microsoft SQL Server Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/cm-edgetun.pages.dev\\\/en-us\\\/sql-server\\\/blog\\\/#website\"},\"datePublished\":\"2011-02-03T16:59:00+00:00\",\"dateModified\":\"2024-01-23T06:50:07+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/cm-edgetun.pages.dev\\\/en-us\\\/sql-server\\\/blog\\\/2011\\\/02\\\/03\\\/department-store-chain-stein-mart-speeds-their-reporting-saves-600000-a-year-in-tech-costs\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/cm-edgetun.pages.dev\\\/en-us\\\/sql-server\\\/blog\\\/2011\\\/02\\\/03\\\/department-store-chain-stein-mart-speeds-their-reporting-saves-600000-a-year-in-tech-costs\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/cm-edgetun.pages.dev\\\/en-us\\\/sql-server\\\/blog\\\/2011\\\/02\\\/03\\\/department-store-chain-stein-mart-speeds-their-reporting-saves-600000-a-year-in-tech-costs\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/cm-edgetun.pages.dev\\\/en-us\\\/sql-server\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Department Store Chain Stein Mart Speeds Their Reporting, Saves $600,000 a Year in Tech Costs\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/cm-edgetun.pages.dev\\\/en-us\\\/sql-server\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/cm-edgetun.pages.dev\\\/en-us\\\/sql-server\\\/blog\\\/\",\"name\":\"Microsoft SQL Server Blog\",\"description\":\"Official News from Microsoft\u2019s Information Platform\",\"publisher\":{\"@id\":\"https:\\\/\\\/cm-edgetun.pages.dev\\\/en-us\\\/sql-server\\\/blog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/cm-edgetun.pages.dev\\\/en-us\\\/sql-server\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/cm-edgetun.pages.dev\\\/en-us\\\/sql-server\\\/blog\\\/#organization\",\"name\":\"Microsoft SQL Server Blog\",\"url\":\"https:\\\/\\\/cm-edgetun.pages.dev\\\/en-us\\\/sql-server\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/cm-edgetun.pages.dev\\\/en-us\\\/sql-server\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/cm-edgetun.pages.dev\\\/en-us\\\/sql-server\\\/blog\\\/wp-content\\\/uploads\\\/2019\\\/08\\\/Microsoft-Logo.png\",\"contentUrl\":\"https:\\\/\\\/cm-edgetun.pages.dev\\\/en-us\\\/sql-server\\\/blog\\\/wp-content\\\/uploads\\\/2019\\\/08\\\/Microsoft-Logo.png\",\"width\":259,\"height\":194,\"caption\":\"Microsoft SQL Server Blog\"},\"image\":{\"@id\":\"https:\\\/\\\/cm-edgetun.pages.dev\\\/en-us\\\/sql-server\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"http:\\\/\\\/www.facebook.com\\\/sqlserver\",\"https:\\\/\\\/x.com\\\/SQLServer\",\"https:\\\/\\\/www.youtube.com\\\/user\\\/MSCloudOS\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Department Store Chain Stein Mart Speeds Their Reporting, Saves $600,000 a Year in Tech Costs - Microsoft SQL Server Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/2011\/02\/03\/department-store-chain-stein-mart-speeds-their-reporting-saves-600000-a-year-in-tech-costs\/","og_locale":"en_US","og_type":"article","og_title":"Department Store Chain Stein Mart Speeds Their Reporting, Saves $600,000 a Year in Tech Costs - Microsoft SQL Server Blog","og_description":"Florida-based Stein Mart, a large department store chain with 268 locations in the US, relies heavily on up-to-date data analysis and reporting for inventory management and promotional reviews.","og_url":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/2011\/02\/03\/department-store-chain-stein-mart-speeds-their-reporting-saves-600000-a-year-in-tech-costs\/","og_site_name":"Microsoft SQL Server Blog","article_publisher":"http:\/\/www.facebook.com\/sqlserver","article_published_time":"2011-02-03T16:59:00+00:00","article_modified_time":"2024-01-23T06:50:07+00:00","og_image":[{"width":512,"height":512,"url":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/08\/cropped-microsoft_logo_element.png","type":"image\/png"}],"author":"SQL Server Team","twitter_card":"summary_large_image","twitter_creator":"@SQLServer","twitter_site":"@SQLServer","twitter_misc":{"Written by":"SQL Server Team","Est. reading time":"1 min read"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/2011\/02\/03\/department-store-chain-stein-mart-speeds-their-reporting-saves-600000-a-year-in-tech-costs\/#article","isPartOf":{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/2011\/02\/03\/department-store-chain-stein-mart-speeds-their-reporting-saves-600000-a-year-in-tech-costs\/"},"author":[{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/author\/sql-server-team\/","@type":"Person","@name":"SQL Server Team"}],"headline":"Department Store Chain Stein Mart Speeds Their Reporting, Saves $600,000 a Year in Tech Costs","datePublished":"2011-02-03T16:59:00+00:00","dateModified":"2024-01-23T06:50:07+00:00","mainEntityOfPage":{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/2011\/02\/03\/department-store-chain-stein-mart-speeds-their-reporting-saves-600000-a-year-in-tech-costs\/"},"wordCount":346,"commentCount":0,"publisher":{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/#organization"},"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/2011\/02\/03\/department-store-chain-stein-mart-speeds-their-reporting-saves-600000-a-year-in-tech-costs\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/2011\/02\/03\/department-store-chain-stein-mart-speeds-their-reporting-saves-600000-a-year-in-tech-costs\/","url":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/2011\/02\/03\/department-store-chain-stein-mart-speeds-their-reporting-saves-600000-a-year-in-tech-costs\/","name":"Department Store Chain Stein Mart Speeds Their Reporting, Saves $600,000 a Year in Tech Costs - Microsoft SQL Server Blog","isPartOf":{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/#website"},"datePublished":"2011-02-03T16:59:00+00:00","dateModified":"2024-01-23T06:50:07+00:00","breadcrumb":{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/2011\/02\/03\/department-store-chain-stein-mart-speeds-their-reporting-saves-600000-a-year-in-tech-costs\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/2011\/02\/03\/department-store-chain-stein-mart-speeds-their-reporting-saves-600000-a-year-in-tech-costs\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/2011\/02\/03\/department-store-chain-stein-mart-speeds-their-reporting-saves-600000-a-year-in-tech-costs\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/"},{"@type":"ListItem","position":2,"name":"Department Store Chain Stein Mart Speeds Their Reporting, Saves $600,000 a Year in Tech Costs"}]},{"@type":"WebSite","@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/#website","url":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/","name":"Microsoft SQL Server Blog","description":"Official News from Microsoft\u2019s Information Platform","publisher":{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/#organization","name":"Microsoft SQL Server Blog","url":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png","contentUrl":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png","width":259,"height":194,"caption":"Microsoft SQL Server Blog"},"image":{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/"},"sameAs":["http:\/\/www.facebook.com\/sqlserver","https:\/\/x.com\/SQLServer","https:\/\/www.youtube.com\/user\/MSCloudOS"]}]}},"msxcm_animated_featured_image":null,"bloginabox_display_generated_audio":false,"_links":{"self":[{"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/4683","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/users\/1457"}],"replies":[{"embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/comments?post=4683"}],"version-history":[{"count":0,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/4683\/revisions"}],"wp:attachment":[{"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/media?parent=4683"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/post_tag?post=4683"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/product?post=4683"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/content-type?post=4683"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/topic?post=4683"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/coauthors?post=4683"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}