University of Chicago Booth
The University of Chicago Booth School of Business. A highly ranked business school, attracting leaders who want to change the world. At Chicago Booth, you have the freedom to explore your intellectual curiosity in a collaborative community of peers and learn from the world’s leading business school faculty at Booth’s campuses in Chicago, London, and Hong Kong.
Problems
Data Warehouse Enhancement and Data Duplication Resolution.
Booth enlisted TnZ International’s expertise to bolster their data warehouse and tackle critical issues with student data duplication. These challenges manifested across various fronts, including the source system, data warehouse, migration/ETL process, and Cognos reports.
Technologies
Cognos
Excel Power Query Editor
SQL Server Database
SQL Server Integration Services (SSIS)
Solutions We Provided
TnZ International facilitated integration between U of C Booth and Nielsen Data by implementing a data mart to seamlessly integrate Nielsen data into a database, facilitating streamlined analytics using Excel. The creation of a comprehensive Data Warehouse, housing billions of records from consumer market research, empowers students and faculty with unparalleled search capabilities. Leveraging advanced Data Mining techniques, TnZ ensures optimal search efficiency for accessing factual data.
TnZ continues to play a pivotal role in the functional maintenance of day-to-day IT operations and reporting at Booth, ensuring smooth and efficient operations.