Understanding Your Data - Forloop Asaba

Getting started with Firebase Analytics with BigQuery and Google Data Studio.

Transcript

1. Understanding your data Presented by Nosakhare Belvi Nov 10, 2017 Telling better stories with Firebase Analytics, BigQuery and Data Studio
2. How Firebase Analysis Works Your data Your Reports
4. NO Ad hoc historic queries Specialized report Export / combine data
5. And why can’t I do all of that ? Oga, You don’t have access to the raw data !
6. But all hope is not lost ! We have BigQuery Fam !
7. BigQuery Data analysis warehouse in the cloud. Service designed to run very fast query over very large amounts of data. And yes, data like the firebase analytic data generated by your app.
8. How Much ? Not really free sha, buh u can do the TSTV style
9. Running Cost ? It Depends on... Storing the Data Loading the Data Querying the Data
10. Let’s Use Sentrix as a case study - Running Cost Sentrix helps users trigger alerts in case of emergencies. (We will come back to this) • 6 events • 3 User Properties • 2 months of historical data • Over 1gb of data
11. Let’s Use Sentrix as a case study - Running Cost Duration Amount Storage (1gb) 1 month 0.0005 Insert 1 month 0 Queries 1 month 0 Falls on the free tier
12. This varies depending on your Usage
13. Now, the Real Deal Sentrix !
14. A demo app to notify nearby users to be rescued when being Assaulted. Sentrix
15. Making Meaning of Sentrix Data What meaning can we make of Sentrix Data Crime Occurrence within a region Crime Occurrence The list is endless really. This is just for the scope of this session
16. The Agenda I will be using Sentrix to demonstrate : View event on Firebase Analytics Records Analysis Event Linking BigQuery with Firebase Understanding the dataset and making sense of the data Visualizing the data and I hope I get awesome feedback !
17. 17 Codelab bit.ly/forloopAsaba
18. Record Analytic Event Few things to keep in Mind • Events : Events provide insight on what is happening in your app • User Properties : analyze behaviors of various user segments by applying these properties as filters to your reports • Parameters : used as filters in audience definitions that can be applied to every report and in data exported to BigQuery Events values parameter User properties
19. Record Analytic Event Event, parameters and user properties Trigger events
20. View Events on Firebase Analytics Prior to logging any event or using analytics, the event page will look like this You can also link from here
21. View Events on Firebase Analytics and here is the event we’ve logged
22. View Events on Firebase Analytics and the user properties are for filtering reports like so:
23. But we still can’t access the data That’s where BigQuery comes in
24. Link BigQuery with Firebase First, let’s Link Firebase Analytics with BigQuery From Project Overview, Select Project Settings Select Link to BigQuery Select Link to Account Linking
25. Link BigQuery with Firebase Click continue ...
26. Link BigQuery with Firebase Manage Linking
27. Link BigQuery with Firebase We can now view our dataset and query our data. Sounds good right? Select View Dataset to View Data Set on Bigquery
28. With BigQuery The floor is firebase analytics data YOU
29. Understanding the DataSet And here is all the data.
30. What Next ?
31. 31 How can we make Meaning of this Data ?
32. Understanding the DataSet A table is created for a particular day Table for the current day Compose sql query to query dataset
33. Understanding the DataSet Records are groups of other data bundled together. See them as See what your data looks like Child of user_dim
34. Understanding the DataSet And here is all the data. Event name Event params keys Access the value with reference to the data type
35. 35 Doesn’t make sense yet ?
36. Making Sense of the Data Checking Crime Occurrence Query the entire table Look out for how we query for data Accessing the bundled data (UNNEST) Here’s the result
37. Making Sense of the Data Crime Occurrence within a region Just a more complex SQL Query to show anything is possible This is as a result of testing. I am not saying men are more assaulted that women !
38. Looking at yourself before Bigquery. Which kain life be that ?
39. 39 Visualising the Data (More Meaning)
40. Seeing your Data
41. Data Studio Build engaging visualizations Transform Your Data Beautiful Reports Put all Your Data to Work Tell Better Stories !
42. 42 Start with https://datastudio.google.com For this Session’s Data Report, see bit.ly/forloopAsabaStudio
43. Visualising your Data Create a new report
44. Visualising your Data Don’t forget to uncheck this. We are using standard SQL Enter your query Connect to start visualization
45. Visualising your Data Confirm to add to Report
46. Visualising your Data Select charts of your choice Define and edit data source Define dimension Define metrics
47. Visualising your Data
48. Mama, We made it ! More complex queries can be achieved. Though your mileage may vary….. This Works Everytime !
49. 49 Tell Better Stories with Your Data.
50. 50 Thank You. So Friends,