Power BI Level 2 Data Analysis and Visualization - 2-days (16 hours)
Laptops are provided to use with on-site, classroom training
Everyone receives a physical workbook, 16 hours, $225 per person per day

Part 1 - Import data – Day 1
How to use Power Query in Excel and similarities in Power BI
Importing individual Excel files
Power Query to import multiple Excel files from one folder
Importing CSV files and refreshing queries to automatically import data
Change file source settings

Part 2 – Prepare Data – Day 1
Change data types
Move columns, Keep rows, Use First Row as Headers
Split columns, Combining columns, Fill up and fill down data, Duplicate columns
Making a calendar in M language
Using the formula bar and Advanced editor to edit M language

Part 3 – Model Data – Day 2
Make relationships between tables
Create DAX (Data Analysis Expressions) calculated columns and measures
Make measures using SUM, SUMX and concatenate data
DAX CALCULATE and SAMEPERIODLASTYEAR to analyze year-over-year changes in data
Use DAX time intelligence measures including WEEKDAY, TODAY, NOW, and DATESMTD
Make date calendars in DAX

Part 4 – Visualize Data and Share Reports – Day 2
Make clustered, stacked column, bar charts, tree maps, gauges and cards
Filter data using slicers
Make bookmarks
Group, summarize and hierarchy of data
Publish Reports and make a Dashboard in Power BI Services