You are working with a large transactional dataset that needs to be partitioned for efficient querying in your lakehouse. Describe the process of implementing file partitioning and discuss the benefits of using this approach over storing data in a single file.