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!
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.
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.
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.
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.
A succinct and thorough review of view materialization requirements, common errors and how you can resolve them.
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!
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.
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.
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.