Power BI Advanced ~ Data Training

2 days (10:00 AM - 5:00 PM Eastern)

$750.00

Register for a live online class.

Details

Subjects Covered

Prerequisites

Setup Requirements

Details

Course Details

This two-day course covers advanced ways to extract, transform and load data. You will learn a host of Power Query transforms, how to link to APIs, data flows, and other data sources, and how to work with parameters. If your data is perfect (and you just want to learn how to present it) this course is not for you, and you should consider attending our Advanced Power BI Reports course instead.

Subjects Covered

  • 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

Prerequisites

Before Taking this Class

Power BI Fundamentals or equivalent.

Setup Requirements

Software/Setup For this Class

Power BI Desktop

Onsite Training

Do you have five (5) or more people needing this class and want us to deliver it at your location?