It is definitely different and I miss things like pivot tables. However, there are work arounds and it does great for what I need these days.
This is the biggest omission in Numbers. You can kind of fake it with SUMIF, but the lack of pivot tables prevents me using it as a real spreadsheet
Oddly, even full on Excel on Mac lacks Power Query and Power Pivot, so not suitable for advanced users