Early Bird Offer if ticket is bought by 25th December (Christmas Day)
Sale Date Ended
Early Bird Offer if ticket is bought by 25th December (Christmas Day)
Sale Date Ended
Introduction
What is good data
Importing Data
Advanced Data Cleaning tricks
Connecting, Blending & Shaping Data
Merge and Append queries
Pivot vs. Unpivot data
Conditional Columns
Grouping & Aggregating data
Segmentation: Use Grouping to cluster multiple items
Segmentation: Use Binning to put values into equally sized groups
Connecting, Blending & Shaping Data
Table relationships
"Snowflake" Schemas
Visualizing Merge Join Types in Power BI (LEFT, RIGHT, INNER, OUTER)
Adding a Calculated Column
Adding a Measure
New Measure or New Column - Which one to use when?
Visualization Elements
Essential Formatting settings: Color, Data Labels, Axis, Placement; Time series; Matrix Visuals; Date Slicers; Cards & KPIs; Text Cards; Map Visuals;
Treemaps; Line & Area Charts; Trend Lines & Forecasts; Gauge Charts; Scatter Plot; Control Report Interactions; Drill down Filters; Report Bookmarks
Projects
Creating a dashboard
Pulling data from the Web