This shows the number of views by user in the past 7 days. Limit 200 Dashboard views leaderboard (views in the past week) select u.email, d.name, count(v.id)Īnd v.timestamp > (current_date - interval '7 days') I want to know how much they’re looking at the metrics and whether they’re looking at the dashboards I think they should be looking at. Order by 1 desc Exec team dashboard views in the past weekįor this report, I wanted to know what the exec team was looking at in the past week. Order by 1 desc Questions created in the past week select created_at, name, u.email, ' || d.id as url Where created_at > current_date - interval '7 days' The queries that we use to power the charts: Dashboards created in the past week select created_at, name, u.email, left(description, 40) as description, ' || d.id as url Our Metabase monthly active users along with company milestones We’ve typically seen 75-100% of employees leveraging Metabase on a monthly basis. If you’re considering joining a company – do you want to be at one that uses data to help inform decisions? You can see below that Reforge employees are using data on a regular basis and you can see how it scales as we’ve grown the team and hit key milestones. These stats span across the entire company in terms of usefulness (support, sales, marketing, product, engineering, design, finance, etc) and we strive to make as much information accessible to everyone so that they can be data informed. Since the beginning of the company we’ve looked at data to understand how well we’re tracking against key goals for the company (revenue, applications, content completion, weekly activity, etc). I set this up as a dashboard subscription so it is delivered to my email every week and I can quickly scan it to understand what’s top of mind for the org. Metabase is already storing all of the data we needed to visualize to get answers to our questions. It wouldn’t shock me if this became a paid feature long-term for Metabase on their enterprise plan, but it took less than 30 minutes to figure out their data model and build some quick and dirty SQL questions that produced answers to our most important questions. All we had to do was add the Metabase internal database as a source to Metabase (sounds confusing, but actually quite simple). How engaged our company is with our data & analytics.Who is looking at information on a regular basis.What is most important to our exec team.What questions people are asking of our data.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |