1 / 17

SSRS vs Google Analytics Decision Making

Learn about the process of decision making and how to use SSRS and Google Analytics for key decision making. Presented by Katie & Emil Glownia, Independent SQL Server BI contractors.

mdianne
Download Presentation

SSRS vs Google Analytics Decision Making

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. SSRS vs Google AnalyticsDecision Making Presented by: Emil Glownia Reports created by: Katie Glownia

  2. Who are we? Name: Katie & Emil Glownia Role: Independent SQL Server BI contractors SSRS, SSIS, SSAS, Kimball Data warehousing, bespoke one day training and presentations Blog: http://www.sql-server-business-intelligence.com/blog Email: katie@itcouple.co.uk emil@itcouple.co.uk

  3. What can you expect? I will show you: • Briefly several slides about process of decision making • Decisions I want to make today • Excellent self-service BI tool related to websites and its limitations for key decision making • How I make key decisions and analysis using SSRS • How to do Sparkline in 5 minutes

  4. Website Traffic

  5. Decision making definition • Decision making(Wikipedia) can be regarded as the mental processes resulting in the selection of a course of action among several alternative scenarios.

  6. Decision making process

  7. Components of decision making

  8. Decisions Find most efficient ways to increase traffic for existing pages (= key factors)and make decision which one to choose. Key areas (options): • Top Pages / Keywords that lost traffic • Pages / Keywords that are close to significant increase • Develop “long tail” keywords

  9. Google Analytics Page views by Page Title

  10. Google Analytics Page views by Keyword

  11. Google Analytics Page views by City / Country

  12. Our Dashboard & Data Warehouse We have created requirements driven data warehouse & dashboard to support well formulated key decisions and support creation of “to do list” for chosen decision. The initial purpose of the data warehouse and dashboard: 1) IS NOT to discover new data (we have only key data not everything) 2) IS NOT to perform ad-hoc analysis (although that is one of the current “side affects”) 3) IS NOT to provide “big picture” of everything we do (only key factors) 4) IS NOT to have perfectly clean data (Our data is acceptable but not 100% clean or accurate, as it is affected by many factors but this is fine because it doesn’t affect our key decisionsand it would take some time to clean it properly and I don’t need it….yet! So I will clean it on “as needed” basis.

  13. SSRS or Google Analytics Final Verdict I LOVE Google analytics as a self service BI tool! But…. I prefer SSRS for supporting key decision making So… I use both!

  14. Before we go to final slide…are there any questions? E-mail: katie@itcouple.co.uk emil@itcouple.co.uk Website: www.sql-server-business-intelligence.com Blog: www.sql-server-business-intelligence.com/blog Linked in: http://uk.linkedin.com/in/katieglownia http://uk.linkedin.com/in/emilglownia Twitter: https://twitter.com/#!/katieglownia https://twitter.com/#!/emilglownia

  15. THE END • Thank you • Please provide feedback. It is extremely useful for us.

  16. Coming up… • #SQLBITS

  17. Thank you

More Related