aroundBI - A platform to understand Business Intelligence concepts. Under the gamut, tutorial videos are produced to explain subject matter in a simple and lucid manner. Broder categories are Data warehouse, SAP BusinessObjects, JavaScript and other web technologies that are helpful in creating presentation layer.
Your videos are clear and crisp. I always watch them before any interview this gives me more confidence. Please posting such great videos on DWH concepts. Thank you for great content.
Thank-you for this. Really easy to understand🙏 Request you to help us with a video on Context to resolve loops in Data Foundation in the similar manner by creating scenario.
In our datawarehouse we use type 2 with processdate. This is the date when the data was entered into the table. This allows us to see historical snapshots of data. Which is useful when you are analyzing trends like balances. So you can see how balances change overtime.
So what is the difference between BusinessObjectd, Crystal Reports & Webi??? I am new to SAP, do I need to learn all three or any one of then is enough to get started. I am a business analyst and have good hands on SQL and Power BI. From where should I start?
Can a periodic snapshot contains lowest level of granularity...In other words business wants to take a snapshot of the entire fact table on daily basis, so that on a particular day they want see all the relevant detail rows anytime possible..How to handle this.
DD: Degenerate Dimension is a dimension key in the fact table that does not have its own dimension table. It's like primary key in relational DB table design ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-g9SsEI1ib5U.html Junk Dimension: It's like Enum field in relational DB table design => we don't want keep them in Fact table so we put them in junk dimensions. Couple different columns will be put in one junk dimension ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-g9SsEI1ib5U.html