No items found.
Community

The Periscope Data Community’s Top 10 Posts

Earlier this year, we launched the Periscope Data community — a space for data professionals to ask, share and learn analytics tips and tricks. Curious about the content that’s already published? We’ve curated a list of our top 10 community posts below to illustrate the type of content you’ll find there. Don’t forget to become a member of the Periscope Data community to see more posts like this and join the conversation!

1. Troubleshooting Best Practices

Curious to learn more about the tips and tricks our Solutions Team uses to debug those long SQL queries in minutes? Check out this post on the community to resolve those head-scratching queries with ease.

2. Adding a Total Row/Column to your Cohort Grid

Provide a summary of your cohort grid metrics! This post outlines how you can create total rows or total columns to your analyses, giving a high-level overview of your granular breakdowns.

3. Everything about CTEs

CTEs (also known as “with” clauses) are a powerful functionality in SQL, allowing users to create a sort of “temp” table that can be referenced within a query, and doesn’t need to be dropped! Learn the use cases for CTEs and how to set them up in the step-by-step guide above.

4. The Ultimate Custom Aggregation Filter

Looking for more aggregation options? This post outlines how you can build your own custom aggregation filter, with examples of the different aggregation types you can incorporate in your analyses. Does your team want to see data aggregated by every five minutes, twice a month, or once every two months? You can do all that too.

5. Top 4 Reasons your View isn’t Materializing

A succinct and thorough review of view materialization requirements, common errors and how you can resolve them.

6. Transposing Tables using Python Pandas

Periscope’s Python Integration makes this quick and simple, offering increased customizability to your final output.

7. Regression Models in R and Python

Alright, we kind of cheated here. These are actually two community posts that walk through the basics of linear regression models using the Periscope Python and R integration. While both Python and R are extremely powerful for linear regressions, users do tend to prefer one or another, so we built guides for both languages!

8. Contract Adherence KPI Chart

Looking for more powerful ways to illustrate your metrics or simply looking for an exciting new chart type? This chart type quickly shows usage in an easy-to-read manner, perfect for your sales and leadership teams.

9. Using the Embed Refresh Trigger

Looking to set a refresh rate for your embedded dashboards? Look no further than the Embed Refresh trigger! This allows your embedded dashboards to refresh without having to trigger a browser refresh.

10. Connecting your Periscope Warehouse to PSQL or SQL Workbench

This one is especially useful for our users on the Warehouse infrastructure. Users with Warehouse can use PSQL or SQL Workbench to connect to the warehouse to drop tables, manage database user permissions, or run ad-hoc queries.


… And there’s many more! With users posting content every day, there’s always something new to learn from the community. Sign up today and join the discussion with data experts from around the world.

Want to discuss this article? Join the Periscope Data Community!

Neha Kumar
Neha is passionate about creating powerful data visualizations, spreading awareness of analytics best practices and learning about the latest and greatest advancements in data science. She strives to leverage multiple programming languages for analyses that are more efficient and effective than current methodologies.
No items found.