Microsoft Parallel Data Warehouse keeps giving updates and new features. In my first consultancy, I transitioned a mortgage company from Oracle OBIEE to Microsoft Parallel Data Warehouse to greatly reduce the mortgage approval time. There's a feature that allows users to set alerts on triggers within reports, enabling timely actions on pending applications and effectively reducing waiting time. It extracts data from the ERP system, and we are doing extensive data analytics. The system handles target marketing for a company which does 85 to 90% of its business in wholesale. We have a variety of clients from mom-and-pop stores to big box stores, and we have intermediaries. We sell through approximately 13 retail channels including Etsy, our retail website, Faire, Wayfair, and Walmart. Each channel requires different types of inventory updates and packaging, which is managed automatically. A significant amount of development is done on Microsoft Parallel Data Warehouse where all these processes are automatically fed out and updated. We also conduct inventory analysis and aging analysis. We identify seasonal buyers, track their purchasing habits, and auto-trigger campaigns for them, sometimes offering discounts on various items. We've found that combining top-selling items with non-selling items can lead to increased sales, as people often buy additional items when they find one on sale.
