Business Intelligence: Data Warehousing, EDA, and Regression Analysis

This comprehensive report delves into the realm of Business Intelligence, commencing with a foundational exploration of data warehousing. It defines data warehousing, elucidates its distinctions from transactional databases, and categorizes various data warehouse types, including Enterprise Data Warehouses, Operational Data Stores, and Data Marts. Furthermore, the report contrasts the concepts of data lakes and data warehouses, examining their respective advantages and disadvantages. The report then transitions into Exploratory Data Analysis (EDA) of Boston housing data using RapidMiner, identifying key determinants of house prices through correlation analysis and statistical summaries. A linear regression model is constructed to predict median house values, and its statistical significance is evaluated. Finally, the report presents Tableau graph views to visualize housing data, showcasing trends and patterns related to median house values, crime rates, and pupil-teacher ratios. The report is contributed by a student to be published on Desklib, a platform providing AI-powered study tools for students.