You are asked to create a view in your lakehouse that combines data from multiple tables related to customer transactions. Describe the steps you would take to create this view, including any necessary joins and transformations. Discuss the advantages of using a view over directly querying the base tables.