Differenze
Queste sono le differenze tra la revisione selezionata e la versione attuale della pagina.
| Entrambe le parti precedenti la revisione
Revisione precedente
Prossima revisione
|
Revisione precedente
Prossima revisione
Entrambe le parti successive la revisione
|
mds:lbi:start [26/11/2021 alle 08:24 (2 anni fa)]
Anna Monreale [Class calendar - (2021-2022)] |
mds:lbi:start [26/11/2021 alle 08:39 (2 anni fa)]
Anna Monreale [Class calendar - (2021-2022)] |
| |16. | 15.11 11:00-12:45 | OLAP with SQL Server Analysis Services (SSAS): data source views, dimensions, hierarchies. Data cubes, Parent-child hierarchies. | {{ :mds:lbi:lds.09.ssas-21.pdf |}} | {{ :mds:lbi:foodmart_monreale_full-cube.zip |}} | | | Monreale | | |16. | 15.11 11:00-12:45 | OLAP with SQL Server Analysis Services (SSAS): data source views, dimensions, hierarchies. Data cubes, Parent-child hierarchies. | {{ :mds:lbi:lds.09.ssas-21.pdf |}} | {{ :mds:lbi:foodmart_monreale_full-cube.zip |}} | | | Monreale | |
| |17. | 18.11 11:00-12:45 | Cube deployment. Measure setup, Calculated Members, Excel power pivot integration. ROLAP, MOLAP, HOLAP definition and setup. Cache management.| | {{ :mds:lbi:foodmartexplorative.xlsx |}} {{ :mds:lbi:foodmart_monreale_complete.zip |}}| | | Monreale | | |17. | 18.11 11:00-12:45 | Cube deployment. Measure setup, Calculated Members, Excel power pivot integration. ROLAP, MOLAP, HOLAP definition and setup. Cache management.| | {{ :mds:lbi:foodmartexplorative.xlsx |}} {{ :mds:lbi:foodmart_monreale_complete.zip |}}| | | Monreale | |
| |18. | 22.11 11:00-12:45 | Introduction to MDX | | | Since the video of this lecture has some issue I'm linking the Video of the last year. It is not exactly equal but very similar. The videos are two because the lectures of these year could not be completely aligned. [[https://web.microsoftstream.com/video/691fe567-b0f9-4994-8ec8-1b4dc5a3d9c4 | Video1]] [[https://web.microsoftstream.com/video/f1392414-f329-4769-9475-cb3457dbd712|Video2]]| Monreale | | |18. | 22.11 11:00-12:45 | Introduction to MDX | | {{ :mds:lbi:2021-mdxquery-demo-partial.mdx.zip |}}| | Monreale | Since the video of this lecture has some issue I'm linking the Video of the last year. It is not exactly equal but very similar. The videos are two because the lectures of these year could not be completely aligned. [[https://web.microsoftstream.com/video/691fe567-b0f9-4994-8ec8-1b4dc5a3d9c4 | Video1]] [[https://web.microsoftstream.com/video/f1392414-f329-4769-9475-cb3457dbd712|Video2]]| |
| |19. | 25.11 09:00-11:00 | Practice on MDX | | | | Monreale| | |19. | 25.11 09:00-11:00 | Practice on MDX | Exercises to be done before next lecture: 1) Queries you have already answered by Excel in Lecture N.17 2) This list of queries: {{ :mds:lbi:mdx-ex.pdf |}} | {{ :mds:lbi:2021-mdxquery-demo.mdx.zip |}} | | Monreale| [[https://unipiit.sharepoint.com/sites/a__td_524292/Shared%20Documents/General/Recordings/General-20211125_091132-Registrazione%20della%20riunione.mp4?web=1|Video 1]] [[https://unipiit.sharepoint.com/sites/a__td_524292/Shared%20Documents/General/Recordings/General-20211125_103239-Registrazione%20della%20riunione.mp4?web=1|Video 2]] | |
| |
| |
