# prefect-community

Hui Huang

02/26/2022, 6:53 PM
Hi, Prefect experts. 😄 We are bootstrapping our analytics stack. I was evaluating different modern solutions. We have production data in SQL database. We want to work on some analytics cleanup & transformation and ship to PowerBI. Based on the research I have done, it looks to me the viable solution for us will be dbt + warehouse(snowflake) + visualization(power bi). If that is the case, it sounds like we do not need prefect to orchestrate python based tasks. Do you have case study that is applying prefect to analytics pipeline achitecture? Hope someone can give me some direction.
@Anna Geller Hello!~~ I just found some blogs you guys wrote about dbt+prefect+snowflake. OMG 🥺 will read them this weekend. 🐇 🕳️

Anna Geller

02/26/2022, 8:04 PM
Hi @Hui Huang, regarding your question I already answered when you asked in the #random channel. LMK if you have any specific questions I can help with
👍 1