Power BI Advanced ~ Data Training

PDF

• Column transforms
  • Splitting (3 methods)
  • Extracting data
  • Merging columns
• Creating columns
  • Columns by example
  • Custom columns in M
  • Conditional columns
  • Index columns
• Combining queries
  • Combining files from folders
  • Merging queries
  • Fuzzy merge
  • Appending queries
• Manipulation transforms
  • Pivoting and unpivoting
  • Grouping queries
  • Transposing data
• Normalizing tables
  • Getting unique lists
  • Adding id numbers
  • Replacing text with id numbers
  • Final relationships
• Dealing with errors
  • Data profiling
  • How Power Query handles errors
  • Fixing errors in situ
  • Fixing in a separate table
• Data flows and data sets
  • Dataset limitations
  • Creating dataflows
  • Using dataflows in Power BI Desktop
• Simple parameters
  • Creating parameters
  • Switching data sources
  • Using to filter data
  • Parameters and templates
• Dropdown parameters
  • Dropdowns based on lists
  • Dropdowns based on queries
• Stored procedures
  • Loading from stored procedures
  • Dynamic parameters
• Dynamic connections
  • Dynamic SQL Server connections
  • Dynamic Excel workbook links
  • Dynamic worksheet links
• Custom functions
  • How custom functions work
  • Case study - parsing postcodes
  • Case study - combining worksheets
  • Case study - combining webpages
• Loading HTML
  • The HTML.Table function
  • Scraping websites in Power Query
• JSON and XML
  • Parsing JSON
  • Expanding your results
  • APIs
  • How they work
  • Simple examples
  • Exchange rates
  • Bridging tables
• Data insights
  • Language detection
  • Key phrases
  • Sentiment analysis
  • Image tagging

Before Taking this Class

Software/Setup For this Class

Power BI Desktop