As business intelligence grows, organizations are leveraging data warehouses for strategicdecision-making. However, traditional data warehouses face challenges with processingaggregated data and supporting advanced analytics. Implementing a semantic layer on top ofdata warehouses can enhance business analytics by providing a more intuitive, businesscentric view. This approach significantly improves data accessibility, governance, andvisualization, enabling organizations to unlock the full potential of their data assets. In thispaper we will discuss two approaches to build a semantic layer. We will also look at the stepsinvolved in the two methods and their pros and cons.