Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
Hello
I am new to power BI. I am becoming fairly competent at single source, or even 2 or 3 source reports when they are operational, snap show in time type reports. Fairly straight forward.
I have a need to develop a some financial reports against JD Edwards Financial GL data. Reports will need to be over time, historical, rolling date perspectives (month over month, qtr over qtr etc).. May have some complex inner join and query logic.
Is this type of reporting, which would it seems to me, needs a more Kimball style star schema model, with dimensions, measures and fact tables, POSSIBLE in Power BI? If possible, what are the drawbacks, performance issues, stumbling blocks? What are best practices for developing this way?
Or is it the case that it is not really possible?
Do I need / require a data warehouse / cube?
Thanks in advance!
@Anonymous , refer this is possible
https://community.powerbi.com/t5/Desktop/Traditional-Financial-Statements/td-p/7223
Star Schema is recommended
https://www.sqlbi.com/articles/the-importance-of-star-schemas-in-power-bi/
Best Practices
https://maqsoftware.com/expertise/powerbi/power-bi-best-practices
https://docs.microsoft.com/en-us/power-bi/guidance/power-bi-optimization
https://www.c-sharpcorner.com/article/power-bi-best-practices-part-1/
https://www.knowledgehut.com/blog/business-intelligence-and-visualization/power-bi-best-practices
https://community.powerbi.com/t5/MBAS-Gallery/Microsoft-Power-BI-The-Do-s-and-Don-ts-of-Power-BI-Relationships/td-p/712566
https://community.powerbi.com/t5/MBAS-Gallery/Microsoft-Power-BI-My-Power-BI-report-is-slow-What-should-I-do/td-p/712567