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:
https://www.periscopedata.com/api/embedded_dashboard?data={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
To make a heatmap,
simply select lats
and lngs using the Map chart type
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 = users.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 Okta, OneLogin, 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 107.23.195.228 and 54.236.224.46 through your
firewall.
Comments
Post a Comment