Monday, September 5, 2016

Periscope data tutorial

1.     Data Base Supported by periscope:
·         MySQL: 3306
·         Postgres: 5432
·         Redshift: 5439
·         Vertica: 5433
·         SQL Server: 1433
·         Oracle: 1521
·         MemSQL: 3306
·         Sybase: 5000
·         Exasol: 8563
·         AMAZON RDS
·         Mircrosoft Azure's SQL Server

2.     Connecting to a SQL Server Database
·         Whitelist the TCP port to access the we can access this port through your firewall, that it responds to TCP
3.     Drilldowns in periscope data
Drill down is possible in periscope
4.     Dependent Filtersin periscope data
Creating dependent filters in Periscope data is very easy.
5.     Creating a Charts
Creating charts in periscope is are possible.
6.     Dashboard and Chart Refresh Mechanic
Configuring the refresh rate for dashboard and reports is possible
7.     Organizing Charts or Dashboard
Top down and theme based dashboard configurations is possible
8.     Pivot Tables creation in Periscope data
Pivot table creation from database is possible, it is an extension to all table data
9.     Auto Time Zone Conversions
 Periscope Data converts the timestamp used in the daterange clause to be in your site's display time zone, and compares it to the range selected
10.  Doubling Query Throughput with Read Replicas
Queries can be pointed at multiple replicas of the same master, and Periscope will distribute the queries over them to improve throughput
11.  Scheduled Email Reports
Emailing reports allows a user to schedule the time and day when they would like to send out a dashboard report. Dashboards that are emailed are always sent out with the default filters. 
12.  Easy Embedding With Shared Dashboards
You can quickly remove the Periscope Data header in your shared dashboard by adding ?embed=true at the end of your shared link.
13.  Embed API
Periscope's Embed API lets you programmatically specify filters and their values in the URL when embedding dashboards.
The embed API URLs take the following form:{data}&signature={signature}
14.  Map Chart Overview
Map Charts can be plotted by selecting a column of latitude points and a column of longitude points in that order. The Map Chart type currently only supports latitude, longitude points. Options for plotting in Points, Bubbles, Heatmaps, and Clusters are available in the Settings Tab.
15.  Graph-like Chart Types and Specials Settings
In addition to generalized chart settings, individual graph-like charts have special settings based on their type.
16.  Mixing Chart Types
The "Series" tab can be used to set individual columns and segments as different chart types. The "Series Type" dropdown tab supports the following Chart Types: Area, Line, Bar, and Scatter. This lets users plot multiple segment types on the same chart.
17.  Heatmaps
18.  Cohort Grids
Cohort Grids are the Periscope Data equivalent of Excel Pivot Tables or Two-way Tables. One series is plotted horizontally, and another is plotted on the vertically. A third series of values is filled in for each cell to calculate the sum of their intersecting cells
19.  Tables
Tables are one of the most straightforward methods to display data and represent the underlying values returned by any query. 
20.  GeoJSON
GeoJSON are JSON blobs that describe arbitrary geometries in geographic space. They are great for plotting specific geographies or the routes of airplanes, ships and cars.
21.  Satellite Maps
To make a map chart, first select latitudes and longitudes and choose the Map chart type. Then change the map tiles to satellite imagery by going to the Settings tab and checking the "Satellite" checkbox in "Map Tile Settings"
22.  Clusters and Bubbles
The "Clusters" and "Bubbles" display settings for Map-based charts are useful for grouping together many data points on the map. 
23.  Cross-Database Joins
If you're on our Enterprise Plan then you have full access to perform cross-database joins. All that you need is for the tables you'd like to join to be on the Periscope Cache.
24.  Materialized SQL Views
SQL Views can be materialized on the Periscope Data Cache. This means that the query must be in Redshift-supported syntax. Once a view has been materialized for the first time, you can call it in a query and see results almost immediately. It is important to note that Periscope searches for view names prior to table names when building the query
25.  Dollars and Percentages
To format a numeric column as dollars, use ":$" in your formatter:
select [sum(price):$] from purchases;
This will give you a comma-delimited number with a dollar sign and two decimal points:
select [cast(count(distinct purchases.user_id) as numeric)/count(1):%]
from purchases left join users on user_id =
26.  Composing SQL Formatters
SQL Formatters can be chained together, one after another. For example, to convert a timestamp to Pacific Time and then aggregate to date, do:
select [created_at:pst:date] from users.
27.  Querying the Periscope Cache
Queries automatically run on the Periscope Cache. If the query fails on the Cache, Periscope Data will run it directly against your database.
28.  Caching Your Data
Customers on the Enterprise Plan have the option of having their data cached on the Periscope Cache.
When Periscope Data caches a table, all of the table's rows are copied into the cache. Three different cache population strategies are used to keep the cache's version of your data in sync with your databases. Many tables use multiple caching strategies in parallel on different schedules to maximize freshness and minimize differences.
29.  Parameterized SQL Snippets
Parameterized snippets allow you to pass values directly into your snippets, so you can cut down on SQL writing. They also help to make your queries more dynamic, and give you a way to imitate passing variables into a function.
30.  SQL Views
Periscope's SQL Views let you define a table once that your whole team will use. If you're using the Periscope Data Cache on the Periscope Enterprise plan, Periscope optimizes the view by keeping it hot in the cache, and keeps it up-to-date at all times.
31.  SSO Overview
Periscope supports OktaOneLogin, and Google Apps SAML 2.0 SSO providers.
32.  Managing User Permissions
User groups let you manage you users' view and edit permissions easily. Admins can quickly set up different user types by modifying the user groups that users belong to and the settings of those groups.
33.  Dashboard Permissions
Once you’ve set up your user groups and user types, you are ready to manage your per dashboard permissions.
Dashboard permissions allow you to specify which user groups have view and edit permissions on a per dashboard basis. Admins and the dashboard owner always have both view and edit level access to dashboards.
34.  Two-Factor Authentication Overview
Periscope supports Two-Factor Authentication (2FA) via QR code. 2FA can be required for the entire organization, or turned on for a specific user. Recommended applications include Authy, Google Authenticator, or Windows Phone Authenticator.
35.  User Types
Periscope supports three different user types: admin, write-access user, and read-only user. These are set up primarily through the use of user groups.
36.  Connecting to a Private Network with an SSH Tunnel
To connect to a database in a private network, create an SSH tunnel using the following steps:
Download our public key and whitelist and through your firewall.