Detaljer
2-dages kursus med fokus på de avancerede funktioner, når der skal bygges og vedligeholdes en Power BI løsning.
Kurset henvender sig til analytikere, controllere og andre der ønsker et bedre kendskab til alle mulighederne der findes i Power BI.
Kurset afholdes i Thorshavn på Færøerne i samarbejde med Bi3, som står for tilmeldingen: https://bi.fo/blog-post/power-bi-intro
Forudsætninger:
- Medbring egen laptop med nyeste version af Power BI Desktop installeret
Kursus agenda:
Module 1: Advanced Power Query Transformations
- Column and Row Operations
- Table Transformations
- Text Transformations
- Numeric Transformations
- Date and time Transformations
- Query operations
Module 2: Power Query Editor
- Power Query Formula Language
- Learning M syntax
- M built-in functions
- Data types, Lists, Records, and tables in M
- Parameterised Queries
- Query folding
Module 3: DAX next step
- Aggregate Functions
- Logical Functions
- Mathematical Functions
- Date and Time Functions
- DAX evaluation Contexts
- Calculate Function
- Using variables
- DAX cheat sheet
Module 4: Common Challenges with DAX
- Time intelligence
- Percentage of All and Parent
- Moving Average
- Running Total
- Parent-Child Hierarchies
Module 5: Row Level Security
- Different views of the data for the same Power BI report
- Manage, create and test roles
- Assign users to roles
- Dynamic Security
Module 6: Create your own layout and theme
- Predefined default values
- Background image
- Setting borders and titles
- Themes gallery
- Color Theme Generator
- How to optimize for mobile
Module 7: Advanced report interactions
- Drillthrough pages and actions
- Bookmarks and selection pane
- Custom navigation pane
- Show and hide visuals
- Report Page Tooltips
- Exporting detail data
Module 8: Power BI service
- Publish and consume reports
- Dashboard vs Report
- Create Reports and pin to Dashboards
- Export and Subscriptions
- Analyze in Excel
- Integration in SharePoint and Teams
Module 9: Power BI distribution
- Share within organization
- Content workflow
- Workspaces in Power BI; Dev/test environment
- Power BI Apps; User environment
- Power BI for mobile
- Share outside organization
Module 10: Administration and governance
- Power BI Admin Portal
- Shared and certified datasets
- Data refresh
- Governance options
- Architecture