w ww.KatieAndEmil

1. www.KatieAndEmil.com The webinar will start soon.If you have any questions related or unrelated to this webinar than please use the chat window.I will answer any questions before the webinar starts or at the end.

2. www.KatieAndEmil.com Webinar:SSRS Snapshots Start recording

3. Introduction 5 min • Polls5min • Why snapshots are helpful?15 min • What is an SSRS Snapshot? 10 min • Overview of SSRS Snapshots 10 min • DIY Tasks 5 min • Summary 5 min • Questions and Answers (optional) 5+ min Webinar agenda:

4. Why this webinar? Snapshots are SSRS often undiscovered gem. It can tremendously help business especially when there is no data warehouse which captures historical changes.

5. Webinar Goal Understand the concept of snapshots and, what SSRS has to offerand how to implement SSRS Snapshots. KEBI Academy Members Learning Plan with videos will be create later on.

6. ClickWebinar Software • Full Screen • use ESC button to exit • Chat Window (Questions) is located in the bottom left corner • I will answer ALL questions at the end. • You can type your questions during the webinar.

7. Start the polls Polls

8. Snapshot Definition • What is a snapshot (data)? • Data Snapshot shows state of data at a particular point in time. • “Freeze” the data. • “Copy” of the data.

9. Snapshot Example • New Members by month • Exclude Full Refunds • Include Partial Refunds • Include cancellations • On 1st of November 2014 • October 2014 – 27 new members • On 5th of November 2014 • October 2014 – 26 new members • On 1st of December 2014 • October 2014 – 25 new members

10. Solution? • Snapshot the data (make a copy at a point in time) • If we snapshot data on 1st of November 2014 than we can refer to a snapshot of data as of 1st of Nov.

11. Why snapshots are useful? • We can see what the data was like a certain point in time even if: • The data changed. • Business rules changed. • Structure of data changed. • We can compare periods of the same data using either multiple snapshots or a snapshot and live data. (Data Validation). • We can schedule snapshots at important points in time (risks are the snapshot may fail) • Snapshots have the same data and are not affected by updates. Useful then multiple people work on the data and need the same result.

12. SSRS Snapshots • SSRS Snapshots “freeze” data & layout at a given point in time and store in “Report Server” database. • Dual Purpose: • “Freeze” data at a certain point in time. • Control Report Processing • Scheduled snapshots • Improved performance

13. SSRS Snapshots Limitations • They “freeze” data and worke best with “previous period” (e.g. last month) and not month on month data. • All or nothing “freeze”. We are not able to “combine” snapshots. • Easy to implement however long term the cost and risks may lead to a data warehouse solution. • They are not a replacement for a data warehouse with Slowly Changing Dimensions and Fact Tables Snapshots. • Lower Data Security

14. SSRS Snapshots • Demo

15. Do It Yourself (DIY) Tasks: • Find a good example where snapshots make sense. • Try out different options SSRS snapshots. • Manual Snapshots. • Scheduled Snapshots. • See how they work with parameters.

16. Summary • What is a snapshot. • When to use a snapshot. • Overview of SSRS Snapshots • We gave you DIY Tasks What next? • www.KatieAndEmil.com/webinars • 29th SSRS Change Requests (Cancelled). • 6th of December – Applying for SSRS Jobs.

17. Questions & AnswersShare links in chat windowhttps://www.katieandemil.com/kebi-academy-webinarshttps://www.katieandemil.com/kebi-academy-webinar-recordingsExplain BI Team Boot Camp (min 5 Project Managers)https://www.katieandemil.com/bi-team-boot-camps