This report explores the current trends in data warehousing, business intelligence, and data mining. It discusses the use of Microsoft Excel for pre-processing, analyzing, and visualizing data to determine the decline in sales/profits. It also examines the advantages and disadvantages of Weka tool over Microsoft Excel. Additionally, it explains the process of clustering using Weka and the most common methods of data mining.