Then, in 2015, Microsoft solution provider US Medical IT helped the zoo enhance its RFID system with a Microsoft SQL Server 2016-based data warehouse hosted on Microsoft Azure. The data warehouse synchronizes the RFID daily data and links it to five other data sources, all of which in turn is made available to Power BI analysis and reporting services. Now the zoo can collect and analyze data across multiple years, and kiosks at the exhibit can show visitors the exact location of each elephant.
The zoo is now interested in how the technology can be adapted to other species, and other institutions are asking Nancy Scott, coordinator of Elephant Behavioral Science at the Dallas Zoo, how the technology could be adapted to their organizations.
"The RFID and Microsoft solution really has the potential to increase the quality of life and care we can provide to animals worldwide," Scott says. "It's also an incredible tool to help us tell the story of elephants in human care today."
Meijer boosts profitability with data insights
Supermarket chain Meijer, one of the U.S.’s largest private companies, had become dependent on its IT organization to extract insight from its data. To gain agility, it needed to create a more self-sufficient BI environment.
"No matter where I go, the demand for BI is always greater than the supply," says Marilyn Richards, director of business intelligence and collaboration at Meijer. "And people don't always have time to wait for IT to build every report. Plus, they were unable to do on-the-fly, ad hoc analysis easily. We have to empower the business customers with relevant and timely reporting to react quickly and appropriately."
With the help of Microsoft BI partner obviEnce, Meijer connected Power BI to an on-premises SQL Server Analysis Services cube with 20 billion rows of data refreshed in near-real time.
"With Power BI and SQL Server Analysis Services, teams can pull in the data they need and ask their own questions, instead of my having to create a solution that answers every single question," says Joseph Openshaw, Meijer's IT manager of business intelligence.
Real Madrid analyzes social media data to customize marketing campaigns
With 450 million global supporters, Real Madrid is the leading sports franchise in the world. The majority of the club’s fans live outside of Spain and can’t make it to the stadium. Real Madrid needed a technology solution that would support digital services and allow it to collect and analyze data on its fans.
"We wanted to connect with all the people who support Real Madrid in the world," says José Ángel Sánchez, CEO of Real Madrid. "It is critical for us to understand and learn from them, because in the end, the club belongs to them."
Sign up for CIO Asia eNewsletters.