A practical guide to using Desktop Power BI app to manipulate large data sets using DAX formulas, measures and calculated columns in Power Query.
Once data is in the correct format we will create Relationships to join tables from different sources and use this data to create interactive visualisations which may be published to the web and shared with colleagues.
• Prepare Reports for import
• Import files
• Importing text files
• Creating DAX formulas
• Calculated columns
• Fields for slicers
• Creating Measures
• Using Slicers to view data
Delegates MUST have completed our Excel Levels 1 - 4 courses or provide evidence that they are already competent to this level to book onto this course. The earlier courses provide foundations for the techniques we teach on this training event.
Delegates should be confident about their Excel skills before joining this class.