Modeling: Denormalized Dimension Tables with Materialized Views for Business Users Gap analysis to find missing values in a sequenceĮstimating Demand Curves and Profit-Maximizing Pricing Querying JSON (JSONB) data types in PostgreSQL Using SQL to analyze Bitcoin, Ethereum & Cryptocurrency Performance Multichannel Marketing Attribution ModelingĪnalyzing Net Promoter Score (NPS) surveys in SQL to improve customer satisfaction & loyalty SQL's NULL values: comparing, sorting, converting and joining with real values SQL Server: Date truncation for custom time periods like year, quarter, month, etc.įilling Missing Data & Plugging Gaps by Generating a Continuous Seriesįinding Patterns & Matching Substrings using Regular ExpressionsĬoncatenating Rows of String Values for Aggregation
#DATAGRIP ATHENA SERIES#
Redshift: Generate a sequential range of numbers for time series analysis MySQL: Generate a sequential range of numbers for time series analysis
Understanding how Joins work – examples with Javascript implementation
First steps with Silota dashboarding and chartingĬalculating Exponential Moving Average with Recursive CTEsĬalculating Difference from Beginning RowĬreating Pareto Charts to visualize the 80/20 principleĬalculating Summaries with Histogram Frequency DistributionsĬalculating Relationships with Correlation MatricesĪnalyzing Recency, Frequency and Monetary value to index your best customersĪnalyze Mailchimp Data by Segmenting and Lead scoring your email listĬalculating Top N items and Aggregating (sum) the remainder into "All other"Ĭalculating Linear Regression Coefficientsįorecasting in presence of Seasonal effects using the Ratio to Moving Average method