In my team BI Devs would mostly build the end to end flow as well as the dashboards at the end of the process. There are some who just do the visualisations as they excel there - in that case a DA would do the analysis work first.
DAs, again just my opinion, should be writing SQL or python rather than just using Excel.