Tix.is

Um viðburðinn

Data loading and manipulation for Power BI with Power Query and M - With Chris Webb

Power Query is the data loading engine inside Power BI (and also Excel 2016+ and SQL Server Analysis Services Tabular models), and M is the language behind Power Query. On this course you’ll get a comprehensive introduction to all of the functionality of the Power Query engine, including how to connect to data sources and output data in a format suitable for your Power BI dataset. You’ll also learn about the M language and also new features such as dataflows. 

Topics covered will include:

  • Data loading and transformation basic concepts: queries and steps
  • Connecting to different data sources: text files, Excel files, relational databases, web services and web pages
  • Using the UI to transform data and add new columns
  • Working with multiple queries
  • Using parameters
  • Introduction to the M language
  • Using functions to combine data from multiple sources
  • Taking advantage of query folding
  • Data privacy and the formula firewall
  • Using dataflows for advanced data preparation