POWER BI Master Class – DAX and visualisation

• Anyone who wants to master reporting in Power BI from all perspectives.
• Anyone who prefers hands-on experience and a highly interactive teaching style.
• Anyone who prefers knowledge of lecturers/consultants with real projects experience.

• You will know how to structure information in reports and how to choose the right components in Power BI Service.
• Through the Data Story-telling technique, you will learn how to effectively present your data and choose the right charts/visuals.
• You will learn to use advanced functions and calculations in the DAX language.
• You will get to know the advanced functionalities in Power BI Service, such as Scorecards, Dashboards, Applications, Insights, etc.

• Completion of a basic Microsoft Power BI Desktop course or another basic course or training in Power BI.
• Basic knowledge of DAX, visualizations in Power BI Desktop and the Power BI Service environment.

Data analysis (are you reporting the right data?)
• Data purity reporting

General Power BI knowledge (always know what is going on)
• Licensing and how the levels relate to data analytics capabilities
• Roles and responsibilities in the world of Power BI
• Detailed Power BI architecture
• A model for multilingual reports
• Dataset/Dataflow and its limitations
• When to use DAX and when to use M

Power BI Desktop (Save time by using visuals and metrics properly)
• Correct settings and limits

Visualizations (how to use visuals to create clear reports?)
• Basic and advanced visualizations (KPI visual, Key influencer, shape map, tree map)
• Correct formatting of visuals
• Bookmarks and tooltips
• Advanced conditional formatting
• Sort columns based on values
• Custom visuals
• Power Apps and Power Automate in Power BI

DAX & Calculations (give data a new dimension and use its full potential!)
• CALCULATE, SUMMARIZE, FILTER, ALL, ALLSELECTED, ALLEXCEPT, RANKX and more functions
• Advanced functions in DAX
• Naming convention in DAX
• Metrics organization
• Data grouping
• Metrics vs Calculated Columns
• Variables in DAX
• Time Intelligence functions
• Row Level Security
• DAX functions documentation

Power BI Service (are you using the potential of all visual components?)
• Power BI Service artifacts
• Naming convention of artifacts in Power BI Service (Reports, Dashboards, Goals, etc.)
• Exporting/Embedding Artifacts
• Artifact settings
• Roles in PBI workspace
• Insights, Scorecards, Q&A, Apps

Relationships in Power BI Service
• Relationships basics and use cases in DAX
• Cross filters and functions CROSSFILTER, USERELATIONSHIP, RELATED

Administration (are the reports being used? Do they have an impact?)
• Visual artifacts usage metrics
• Certifications and promoting content

Data storytelling in reporting (Don't overwhelm your audience with information. Learn to give answers!)
• Storytelling (How to tell a story with a report)
• How to structure reports (UX and UI in reporting)
• Magic Box and Pixel Perfect Approach
• Colors and icons in reports
• Report components and their purpose
• Mobile and Smart Watch view
• Reporting checklist

External Tools (You do not need to have talent. The right tools will do a lot of the work for you.)
• Just Color Picker
• Power Toys
• FlatIcon
• Map shaper

Previous courses

Microsoft Power BI Desktop - Advanced Techniques [PBID2]

Related courses

POWER BI Master Class - Power Query and integration [PBIMC_DA]