Overall the process was quick, but unnecessarily excessive.
First step involved a HR screener, followed by a 40 minute SQL coding session. After that, I was invited to do a data cleanup + Tableau visualization project where I was given about a week's worth of time to put something together.
I was then scheduled for an onsite with 6 interviews (three 30 min interviews, one 45 min lunch break with staff, one 1 hour white boarding session, and one 1 hour Tableau presentation to a panel). They actually wanted to spread the interview over 2 days, but there was no way I could take 2 days off work for interviews, so I made them do it in 1 day.
The whiteboard session was just a repeat of the SQL live coding session, except I had to do it in front of the hiring manager whereas the live coding session was with another team analyst. The questions aren't complicated, just basic joins, aggregations, common table expressions, and windowing functions.
The Tableau assignment involved some data cleanup using R or Python and then coming up with some insights and visualizations in Tableau and then defending your insight.
At the end of the day, I felt I did really well on the SQL, whiteboard, and Tableau sessions. It was a lot of work. Unfortunately, I was given feedback within 48 hours of the interview that I was overqualified (lol) and didn't get the offer.