Use cases
The jobs iDBQuery does with your data — from ad-hoc analysis and board reporting to anomaly investigation, dashboards, reconciliations and tracing a number back to its source.
- How do I do ad-hoc data analysis without writing SQL?
- How do I build board and executive reports with iDBQuery?
- How does iDBQuery enable self-serve BI for a whole team?
- How do I investigate an anomaly or unexpected number in my data?
- How do I turn a question into a live dashboard?
- How do I explore a database I have never seen before?
- How do I answer a question that spans several databases and spreadsheets at once?
- How do I create a shareable report from my data?
- How do I track KPIs and metrics with iDBQuery?
- How do I reconcile numbers that disagree between two systems?
- How do I answer ad-hoc stakeholder questions in seconds instead of days?
- How do I trace a number in a report back to the exact source row?
- How do I run a cohort analysis with iDBQuery?
- How do I analyse customer churn with iDBQuery?
- How do I report MRR and revenue with iDBQuery?
- How do I compare budget vs actual with iDBQuery?
- How do I analyse inventory and stock levels with iDBQuery?
- How do I analyse my sales pipeline with iDBQuery?
- How do I do marketing attribution with iDBQuery?
- How do I speed up month-end close reporting with iDBQuery?
- How do I run data-quality checks with iDBQuery?
- How do I compare this year vs last year with iDBQuery?
- How do I find duplicate records with iDBQuery?
- How do I segment customers with iDBQuery?
- How do I diagnose why a metric dropped with iDBQuery?
- How do I run a funnel or conversion analysis with iDBQuery?
- How do I build a retention curve with iDBQuery?
- How do I calculate customer lifetime value (LTV/CLV) with iDBQuery?
- How do I analyse ARPU (average revenue per user) with iDBQuery?
- How do I measure net revenue retention (NRR) and gross retention (GRR) with iDBQuery?
- How do I do RFM segmentation of customers with iDBQuery?
- How do I do market-basket or product-affinity analysis with iDBQuery?
- How do I analyse price elasticity of demand with iDBQuery?
- How do I measure the impact of discounts and promotions with iDBQuery?
- How do I calculate marketing campaign ROI with iDBQuery?
- How do I analyse customer acquisition cost (CAC) by channel with iDBQuery?
- How do I compare marketing channels and attribute conversions with iDBQuery?
- How do I build a lead-scoring model with iDBQuery?
- How do I measure sales pipeline velocity with iDBQuery?
- How do I analyse sales win rate with iDBQuery?
- How do I build a sales forecast with iDBQuery?
- How do I forecast demand for products with iDBQuery?
- How do I calculate inventory turnover with iDBQuery?
- How do I analyse stockouts and out-of-stock events with iDBQuery?
- How do I run an accounts receivable (AR) aging analysis with iDBQuery?
- How do I run an accounts payable (AP) aging analysis with iDBQuery?
- How do I do cash-flow analysis with iDBQuery?
- How do I analyse gross margin by product with iDBQuery?
- How do I analyse unit economics with iDBQuery?
- How do I calculate burn rate and runway with iDBQuery?
- How do I do headcount planning and analysis with iDBQuery?
- How do I analyse utilization rate with iDBQuery?
- How do I do capacity planning with iDBQuery?
- How do I track SLA compliance with iDBQuery?
- How do I analyse support ticket volume trends with iDBQuery?
- How do I track NPS and CSAT trends with iDBQuery?
- How do I detect anomalies in my metrics with iDBQuery?
- How do I find outliers in my data with iDBQuery?
- How do I analyse seasonality and trends with iDBQuery?
- How do I do week-over-week and month-over-month analysis with iDBQuery?
- How do I do variance analysis with iDBQuery?
- How do I find the correlation between two metrics with iDBQuery?
- How do I do a root-cause drilldown to explain a change in a metric with iDBQuery?
- How do I get top-N and bottom-N rankings with iDBQuery?
- How do I analyse a distribution or build a histogram with iDBQuery?
- How do I do percentile analysis (medians, p90, p95) with iDBQuery?
- How do I read out A/B test results with iDBQuery?
- How do I calculate moving averages with iDBQuery?
- How do I calculate run rate with iDBQuery?
- How do I compare forecast vs actual with iDBQuery?
- How do I find out which products are most profitable with iDBQuery?
- How do I find products that are losing money with iDBQuery?
- How do I find my most profitable customers with iDBQuery?
- How do I find where I can cut costs using iDBQuery?
- How do I find out why my costs are going up with iDBQuery?
- How do I find which projects or jobs are over budget with iDBQuery?
- How do I see how much I am spending with each vendor or category in iDBQuery?
- How do I find out why revenue dropped using iDBQuery?
- How do I check if we are on track to hit our target with iDBQuery?
- How do I find my fastest-growing customer segment with iDBQuery?
- How do I see how many new customers we won this month with iDBQuery?
- How do I find underperforming regions or stores with iDBQuery?
- How do I compare the efficiency of my stores or locations with iDBQuery?
- How do I see what changed in the business since last week with iDBQuery?
- How do I find my top customers with iDBQuery?
- How do I identify customers at risk of leaving with iDBQuery?
- How do I find customers who have not ordered in a while with iDBQuery?
- How do I find which accounts are ready to upsell with iDBQuery?
- How do I track average order value with iDBQuery?
- How do I find which customers cost the most to support with iDBQuery?
- How do I see which deals are most likely to close with iDBQuery?
- How do I find my best-performing salespeople with iDBQuery?
- How do I tell if marketing is generating enough pipeline with iDBQuery?
- How do I see how many leads we generated with iDBQuery?
- How do I find my best marketing channel with iDBQuery?
- How do I find where my marketing budget is being wasted with iDBQuery?
- How do I find which channel brings my best customers with iDBQuery?
- How do I check how much runway I have with iDBQuery?
- How do I check if we are on budget this quarter with iDBQuery?
- How do I find overdue invoices and who owes me money with iDBQuery?
- How do I find out how long customers take to pay with iDBQuery?
- How do I calculate customer acquisition cost with iDBQuery?
- How do I decide which products to reorder with iDBQuery?
- How do I find dead or overstocked inventory with iDBQuery?
- How do I find which suppliers are consistently late with iDBQuery?
- How do I measure our on-time delivery rate with iDBQuery?
- How do I find out who is overallocated or overloaded with iDBQuery?
- How do I find out what is driving a spike in support tickets with iDBQuery?
- How do I find which product features drive retention with iDBQuery?
- How do I track weekly active users with iDBQuery?
- How do I find out why our refund or return rate is high with iDBQuery?
- How do I replace a manual monthly report with iDBQuery?
- How do I quickly pull a number right before a meeting with iDBQuery?
- How do I run a quick one-off analysis to make a decision with iDBQuery?
- How do I answer my own data questions without bugging the data team with iDBQuery?
- How do I spot a data-entry error with iDBQuery?
- How do I prepare the numbers for a board meeting with iDBQuery?