Agenda

Online 4-5 November 2020

00:00

00:00

Day One 

 
Data Extraction and Transformation  
  • Extract data from multiple sources, Transform and clean, and Load it into the Power BI data model, ready for analysis 
  • Identify and join data sets from various sources for holistic analysis and reporting 
  • Create efficient data models: merging, appending and structuring your datasets for optimal performance 
  • Learn techniques to aid in the analysis and reporting to leverage the functionality 
  • Master essential Power Query techniques 
  • How and when to “un-pivot” data to reanalyse 
Introduction to Power BI Desktop 
  • Learn how to confidently navigate the user interface for reporting, data modelling, analysis and publishing 
  • Create multiple levels of drill down/up in your reports 
  • Setup filters across your visuals 
  • See how to use custom visuals that will bring your data to life 
  • Publish your report to Power BI.com
Interactive Exercise: apply your knowledge to a project cost vs budget example
 
Data Modelling and Enrichment - Session One 
  • Understand Relationships to join data in a meaningful manner 
  • Introducing the DAX (Data Analysis Expressions) language, which helps you summarise and extract the information you need from your data 
  • Understand when to use calculated columns in DAX vs Power Query, and when to use measures 
Reporting: Getting the most from your Data 
  • Techniques to ensure data remains up to date and reliable to maintain trustworthy reports 
  • Use advanced DAX formulas to create useful time-based measures for responsive, fast and dynamic reporting 
Interactive Exercise: apply your knowledge to a sales database to import the data, transform it, determine the relationships required, build the data model, and develop the measures required to achieve some specified objectives
 
 
 

Day Two 

 
Power BI Desktop, PowerBI.com and Power BI Mobile 
  • Getting the most out of Power BI desktop and the POWERBI.com platform 
  • Understanding when to use Microsoft Excel and when to leverage Power BI Functionality 
  • Create automatic custom alerts against key metrics for efficient actions 
  • How to develop customised versions of your reports for mobile devices 
  • Securely share reports and dashboards with others to encourage collaboration 
  • Techniques and tips on improving the user experience and how to avoid common pitfalls 
  • Create customised dashboards to consume data easily.  
  • How to create a master list (dimension table) when one doesn’t already exist 
 
Data Modelling and Enrichment – Session Two 
  • Discover the secrets of data shaping and data modelling that will enable you to simplify your DAX functions and calculate reports faster 
  • Learn how to optimise your data models to make them more efficient and summarise large amounts of data quickly 
  • See how to bring in related data from other tables and learn when you should do this 
  • Tips and tools to make your formulas easy to read, faster and more efficient 
  • An introduction into M Language to generate advanced flexible Power Query 
  • Learn a variety of methods for generating calendars used for time intelligence functions 
Interactive Exercise: combining data sets from a database, including merging queries
 
Data Modelling and Enrichment – Session Three 
  • How to automatically combine all the Excel, CSV or text files in a folder into one table and how to apply this 
  • Create Tooltip popups and drill-through reports 
ShapeExtended exercise: develop your sales database example further to incorporate additional datasets, merge these where required, develop more complex measures and construct the reports.