#10200
📊 Dive deep into Power Query with our comprehensive course!
Stay ahead of the curve with regularly updated lessons designed to elevate your data skills.
💻 Ready to practice?
All study materials and datasets used in the lessons are available for download on our website — so you can follow along step by step and boost your learning through hands-on experience. 👉🏻https://www.immalytics.com
📺 Watch the entire playlist: 👉🏻 • POWER QUERY COMPLETE FREE COURSE
Chapters
00:00 How to use Math and Statistics buttons in Power Query
00:50 Introducing the "Number Column" group on the Transform tab
02:30 Explaining distinct count vs regular count
04:30 Difference between Divide and Integer Divide (with examples)
05:30 Modulo function: understanding remainders in division
06:20 Calculating percentage of each value (e.g., 10% of all numbers)
07:10 Using "Percent Of" to find how much a value represents of a base
08:00 Exploring absolute value transformation
08:30 Power operations: square, cube, and custom exponent
09:20 Demonstrating square root function
09:40 Using Exponent to raise Euler’s number (e) to power of values
10:20 Log base 10: what power 10 must be raised to get certain numbers
10:50 Natural logarithm (base e): similar concept with Euler’s number
11:30 Factorial function: examples with 2!, 3!, 5!
12:30 Information tool: checking if a number is even
13:30 Applying math functions across different columns
15:30 Strategy for using multiple transformations together
16:10 Tip on reverting changes in Power Query
