Microsoft business intelligence success stories

With data warehouses that included multiple data sources and hundreds of millions of table rows, it could take up to 45 seconds to run a query. Leveraging SQL Server particularly the new in-memory columnstore feature , Azure HDInsight and Power BI for Office , the IT team was able to cut query time to 10 seconds, all while simplifying IT management and allowing them to implement new features without rewriting applications.

Established in , Carnegie Mellon University CMU is a leading research institute with seven globally recognized schools and colleges. CMU sought to manage energy efficiently in large buildings and across multiple sites. CMU reduced energy consumption by 30 percent and has provided access to the data to a range of employees throughout the university. Additionally, it often fielded redundant requests from the sales and editorial teams.

The company implemented a solution based on Power BI for Office , providing cross-platform insights into data from multiple sources and partners. The company cut its redundant reporting tasks by 30 percent. New Zealand application developer and systems integrator Enlighten Designs wanted to ensure that all of its customers — including small businesses and schools — could benefit from BI tools. To unlock data and provide customers with data discovery and analysis capabilities they can use with familiar tools, the company is helping customers implement Microsoft Power BI for Office with Microsoft Excel This provides customers with a cloud-based solution that can be easily used by people at all levels of an organization.

One customer, Waikato Institute of Technology , is now using the tools to identify which students are struggling and in danger of dropping out. New Zealand-based application developer and systems integrator En lighte n Designs wanted to ensure that all of its customers — including small businesses and schools — could benefit from BI tools. To unlock data and provide customers with data discovery and analysis capabilities they can use with familiar tools, the company is helping customers implement Microsoft Power BI with Microsoft Excel This provides customers with a cloud-based solution that can be easily used by people at all levels of an organization.

One customer, Waikato Institute of Technology Wintec , is now using the tools to identify which students are struggling and in danger of dropping out. The technology allows it to track trends across the student population, but also drill down to find and support individual students. Norwegian regional health authority Helse Vest operates 50 healthcare facilities including 10 hospitals. As part of a recent national patient safety program, Helse Vest hospitals were asked to collect, visualize and share medical data to identify quality measures and reporting requirements across all care teams and hospitals.

That required each of the 10 hospitals to combine data from all facilities in its region for analysis — a daunting task because none had an easy method of combining and visualizing the data. By implementing Power BI to combine the data and build analytical reports, Helse Vest reduced the time to build reports from 14 days to less than one day.

Employees can now use the solution to view and visualize data from multiple hospitals in the region. For instance, Helse Vest can now view combined surgery data, providing the ability to compare operating checklist trends from the different hospitals in the region. Global advertising agency MediaCom needed to measure the health of ad campaigns it created to optimize performance and spending.

It needed to pull together the results into a single, composite score within hours. But it was faced with isolated systems, a variety of third-party data sources and expensive and complicated BI software. For years, the North Tees and Hartlepool National Health Services Foundation Trust used an on-premises Ascribe clinical intelligence system to track the clinical use of drugs, the costs associated and efficacy of treatment.

But the system did not allow North Tees to include external data sets or explore the data in real-time. Now North Tees can incorporate external data sets into its analyses, deliver more intuitive and persuasive reports and reduce costs. The hospitals had separate databases that had to be merged for enterprise-wide analyses. For instance, the two radiology departments used various types of medical imaging at different frequencies, making it difficult to determine things like what type of test was more commonly used at one facility.

The Met is home to nearly 2 million works of art. Its Open Access program makes their collection accessible to a global audience, using AI to build new insights and connections. AI is making employment more attainable for people with disabilities. Detailed maps are critical to services and disaster response, but the remotest parts of some countries lack the information needed to help vulnerable people. HOT is improving maps for emergency response. The Freshwater Trust and Upstream Tech developed BasinScout Platform, a tool that uses machine learning to pinpoint the most effective projects to improve groundwater and surface water quantity and quality.

How AI is transforming industries Explore AI customer success stories showing how organizations across industries are leveraging the power of AI and the cloud to accelerate performance. Explore all customer stories Best of Business AI stories. Best of Business AI Learn from 10 leading global organizations who are using AI transformation to tackle the biggest challenges facing their industries.

Manufacturing Explore real-life examples of how AI is driving efficiency in manufacturing and resource management. PepsiCo PepsiCo developed an autonomous AI solution to increase efficiency while maintaining consistency and quality in Cheetos manufacturing. Ricoh Ricoh has created a connected factory improves product quality and production, while reducing costs.

Healthcare AI in healthcare delivers benefits to patients, providers, and payors through innovative solutions to meet unique challenges. Novartis Microsoft has partnered with Novartis to accelerate drug discovery and development to unprecedented speed by placing the power of AI directly in the hands of researchers.

Government Explore how leaders in the public sector are applying AI to improve the speed and quality of the government services they offer to citizens. Axilion Axilion uses AI to help cities manage traffic, boost safety, and improve urban life. Anglian Water The company uses AI tools in Microsoft Azure to understand the behavior of reservoirs under different conditions, including time of day, seasonality and meteorological. New College Lanarkshire As part of its commitment to developing skills in a way that improves the employment prospects of its students, New College Lanarkshire has integrated Microsoft accreditations into the curriculums of its computer science courses.

Aberdeen City Council Aberdeen City Council is improving its services and efficiency with enhanced team collaboration, streamlined remote work, predictive scheduling, chatbots and process automation.

Retail Retail digital transformation relies on AI that can leverage the proliferation of data-driven customer recommendations, while also improving inventory and supply chain management.

Walgreens Boots Alliance WBA Walgreens and Boots stores are undergoing a multi-phase digital transformation across all facets of their business, including chatbots for customer service, AI-powered data analytics, and streamlining operations.

Loblaw Loblaw has created an AI culture of experimentation and innovation that enables them to improve digital retail experiences for their customers.

Play the Loblaw video. Boggi Milano Boggi Milano uses AI from Evo Pricing to manage their supply chain and predictive pricing, an innovation that delivered revenue growth. Financial services AI can help meet the needs of shareholders, customers, and regulators.

Progressive Insurance Progressive reaches customers through new channels using an AI-powered chatbot that answers questions, provides quotes, and even offers a bit of witty banter in the voice of their well-known spokesperson, Flo.