Develop advanced Power BI skills for data analysis and reporting. Learn to model and transform data, write DAX calculations, and design interactive dashboards.
Gain insight into how each mode works, where the data lives, when queries run, and the trade-offs involved in choosing one over the other. You will learn why Import mode is the default and best choice for most reports, when DirectQuery is genuinely necessary, and how to connect to a SQL Server database
Learn the complete implementation process, from adding a user-territory lookup table and connecting it to the data model, to creating a dynamic role using the USERPRINCIPALNAME DAX function, to publishing and granting access in the Power BI Service.
Follow a complete walkthrough of implementing static RLS roles, from creating the role and defining its filter rules in Power BI Desktop, to publishing the semantic model to the Power BI Service and assigning users to the role.
Walk through the complete process of creating a numeric parameter, adding it to a report as a slicer, and connecting it to a DAX measure using the SELECTEDVALUE function.
Follow a hands-on example of building a sales report that tracks revenue generated within a defined window after a marketing campaign touch.
Showing 5 of 9 entries