![]() ![]() ![]() Using AWS Athena to understand your AWS billsĬanada Province & Census Division Shapefiles ![]() ![]() 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 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 if the report is a single Metabase question or a dashboard.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 Here we need to know the report type i.e. EmbeddedReport: The Metabase report itself.At this moment, it will only be Metabase, but in the future other tools can be added painlessly. ReportEngine: Represents the tool responsible for creating the report links.We’ll initially need these two database entities: To do so, we’ll use Django to save and display Metabase report links. Since we can embed Metabase reports into our applications, we just need a way to connect the dots. Part 2 - Preparing Django to Integrate with Metabaseĭjango is a very flexible python web framework and allows us to create Rest APIs and/or web pages very easily. Check out the full documentation here.Įmbedded reports can be added or embedded to any application outside of Metabase, making them a great option to include in your own custom applications without having to build them from scratch. Metabase is an incredible tool by itself and the part we will cover in this article will be the Embedded Reports. Those reports can be written in plain SQL or created directly from the interface report building tools, without writing any code. It’s possible to connect several data sources to Metabase (such as PostgreSQL, MySQL, Big Query, MongoDB, etc) and create reports directly from a web interface. Metabase is an open-source tool for business intelligence and data visualization and it allows us to ask “questions” (or create reports) regarding our data and display the answers in formats that make sense, being charts or detailed tables. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |