Microsoft Data Analyzer, $170. Microsoft Corp., (800) 426-9400. http://www.microsoft.com
Technology editor Lori MacVittie has been a software developer and a network administrator. Most recently, she was a member of the technical architecture team for a global transportation and logistics organization. Write to her at [email protected].
When we set out to test business-intelligence solutions we began searching for large volumes of data. We managed to obtain more than 2 million CRM (customer-relationship management) records from our corporate headquarters and imported them into a Microsoft SQL Server 2000 database in our Green Bay, Wis., Real-World Labs®. The CRM data consisted of subscriber information from a number of CMP publications--with identifying information about the subscriber (e-mail address, telephone and fax number, last name) removed during the export process.
We cleaned up the data, created all the necessary supported tables and then used that data as the basis for our tests. Each BI product was installed on a Dell Optiplex running Microsoft Windows 2000 Server and used our SQL Server installation as the data source. We evaluated each product based on its architecture, its method of accessing remote data sources and its metadata management.
That enabled us to build and run queries and analyses against an extremely wide data set. Each data set had an average of 600 columns and several hundred thousand records. We evaluated the products in terms of the ease with which reports were built and presented, and we performed a loose performance evaluation while reports were run. There was a huge difference between the products that stored metadata and query information locally versus MicroStrategy 7i, the single product that used a remote data store as its metadata repository.
To evaluate report building, we asked each product to attempt to answer a couple of questions:
To realize the benefits of cloud-native software, an application must actually be cloud-native—designed to run in the cloud, interacting with disaggregated cloud services, fully manageable as code—to deliver the expected benefits.
By combining resources and expertise, the AI-Enabled ICT Workforce Consortium will offer a blueprint for how industries can adapt to an AI-dominated future.
IT leaders should heed the guidance of cybersecurity insurance providers who think businesses should prioritize security education, incident preparedness, regular internal audits, and ongoing vulnerability scanning and patching.
