Hello!
I have been building quite a lot in Power BI now, but the report is starting to become too big (with too many fact tables and bad schema design). I want to implement a new solution where not all the transformation, merging, appending happens inside Power BI, but would actually be done before coming in to Power BI. I think that would be better, since it's easier then to reuse the tables.
That is usually done with a data warehouse right? I have an Microsoft SQL up and running, but now it only works as a storage for files from other sources, saved in one place. I know there are tools like SSIS, Power B data flows and probably a lot more, but I couldn't find a good overview for it.
In the long term I want to be able to do some machine learning/predictive analytics. Azure seems a bit too big for something that has almost only been handled only inside Power BI.
Please recommend further readings/other forums or recommendation on the topics to look up.
Thanks in advance!
Oh, and while we are here:
- SSIS or SSDT seems like a good beginning, but I was concerned with how little I found on the topic. Is it outdated, too complex or does Power BI handle that better?
- Also, any help regarding best pracises regarding multiple fact tables (I know it's possible with star schema), but more on how to handle something like a "management report" that wants to see everything (sales, purchasing, inventory levels, production productivity etc...). Now I've used ONE big report, but it's slow. Is it better to build many smaller reports and a dashboard instead?
Please help a lost fellow 🙂
