How can you use Power Pivot in Excel to create a star schema model and integrate it with Power BI for reporting?
How can Power Pivot in Excel be used to design a star schema model, and what are the steps to integrate this model with Power BI for advanced reporting? What are the benefits of using a star schema for analytics in Power BI?