Track all of your key business metrics from one screen
GET STARTED
Microsoft Azure
Dashboard and Reporting Software
Connect now
Microsoft Azure is a cloud computing platform offered by Microsoft, providing a vast array of services for building, deploying, and managing applications and services through data centers worldwide.
Visualize important business data from your company’s databases
Use Microsoft Azure SQL queries to pull data from your proprietary database and showcase it alongside data from popular services like Mixpanel, Google Analytics and Salesforce.
With Databox, your most important KPIs will be transformed into meaningful insights and delivered to your mobile, Apple Watch, TV display or Slack channels. One of the key benefits of Databox is the ability to combine multiple data sources in one place.
- Technical Details
- Behavior & Usage
- Help Articles
metrics
Show more...
dashboard templates
Show more...
report templates
Show more...
in the category '${selectedCategoryValue}'
` : ''}.` // ' We have some suggestions for you:'
if (count === 0) {
searchNoResultsEl.classList.remove('hidden');
} else {
searchNoResultsEl.classList.add('hidden');
}
});
const targetTotalCountObserverFn = (val, elem, cntElem) => {
if (cntElem) {
cntElem.innerHTML = val;
}
if (elem) {
if (val === 0) {
elem.classList.add('hidden');
} else {
elem.classList.remove('hidden');
}
}
const count = Object.keys(totalCountObservers).reduce((sum, searchTarget) => {
return sum + totalCountObservers[searchTarget].trackedProp;
}, 0);
// if (totalCountObserver.trackedProp !== count) {
totalCountObserver.trackedProp = count; /* Call onChange even if the numeric value stayed the same, cause inputEl.value could have changed even if the result count is still 0 for example */
// }
};
const loaderObservers = {};
const loaderObserver = new DataboxMetricLibraryUtils.PropertyTracker(false);
loaderObserver.registerOnChange((isLoading) => {
if (isLoading) {
searchResultsEl.classList.add('hidden');
singleLoaderEl?.classList.remove('hidden');
} else {
searchResultsEl.classList.remove('hidden');
singleLoaderEl?.classList.add('hidden');
}
});
const targetLoaderObserverFn = (_val) => {
const isLoading = Object.keys(loaderObservers).map(searchTarget => {
return loaderObservers[searchTarget].trackedProp;
}).some(l => l);
if (loaderObserver.trackedProp !== isLoading) {
loaderObserver.trackedProp = isLoading;
}
};
const metricsEl = el.querySelector('.search-results-metrics');
const metricsCountEl = metricsEl.querySelector('.badge.count');
const metricsSearch = {
id: 'metrics',
el: metricsEl,
fetchHelper: new DataboxMetricLibraryUtils.FetchHelper({
element: metricsEl }, true),
countObserver: new DataboxMetricLibraryUtils.PropertyTracker(0),
loaderObserver: new DataboxMetricLibraryUtils.PropertyTracker(false),
chunkLoaderList: new DataboxChunkLoader.List({
element: metricsEl.querySelector('ul')
}, [], {
item: DataboxMetricLibraryUtils.searchOptions.metrics.listItem
}),
showMoreEl: metricsEl.querySelector('.item-list-show-more'),
fetchParams: {
baseUrl: `https://databox.com/metric-library/wp-json/metric-library/v1/metrics/search`,
pageSize: DataboxMetricLibraryUtils.searchOptions.metrics.pageSize,
projection: DataboxMetricLibraryUtils.searchOptions.metrics.projection
}
};
metricsSearch.countObserver.registerOnChange((val) => {
targetTotalCountObserverFn(
val,
metricsEl,
metricsCountEl )
});
totalCountObservers['metrics'] = metricsSearch.countObserver;
metricsSearch.showMoreEl.classList.add('hidden');
metricsSearch.loaderObserver.registerOnChange(targetLoaderObserverFn);
loaderObservers['metrics'] = metricsSearch.loaderObserver;
const dashboardTemplatesEl = el.querySelector('.search-results-dashboard-templates');
const dashboardTemplatesCountEl = dashboardTemplatesEl.querySelector('.badge.count');
const dashboardTemplatesSearch = {
id: 'dashboard-templates',
el: dashboardTemplatesEl,
fetchHelper: new DataboxMetricLibraryUtils.FetchHelper({
element: dashboardTemplatesEl }, true),
countObserver: new DataboxMetricLibraryUtils.PropertyTracker(0),
loaderObserver: new DataboxMetricLibraryUtils.PropertyTracker(false),
chunkLoaderList: new DataboxChunkLoader.List({
element: dashboardTemplatesEl.querySelector('ul')
}, [], {
item: DataboxMetricLibraryUtils.searchOptions.dashboardTemplates.listItem
}),
showMoreEl: dashboardTemplatesEl.querySelector('.item-list-show-more'),
fetchParams: {
baseUrl: `https://databox.com/metric-library/wp-json/metric-library/v1/dashboard-templates/search`,
pageSize: DataboxMetricLibraryUtils.searchOptions.dashboardTemplates.pageSize,
projection: DataboxMetricLibraryUtils.searchOptions.dashboardTemplates.projection
}
};
dashboardTemplatesSearch.countObserver.registerOnChange((val) => {
targetTotalCountObserverFn(
val,
dashboardTemplatesEl,
dashboardTemplatesCountEl )
});
totalCountObservers['dashboard-templates'] = dashboardTemplatesSearch.countObserver;
dashboardTemplatesSearch.showMoreEl.classList.add('hidden');
dashboardTemplatesSearch.loaderObserver.registerOnChange(targetLoaderObserverFn);
loaderObservers['dashboard-templates'] = dashboardTemplatesSearch.loaderObserver;
const reportTemplatesEl = el.querySelector('.search-results-report-templates');
const reportTemplatesCountEl = reportTemplatesEl.querySelector('.badge.count');
const reportTemplatesSearch = {
id: 'report-templates',
el: reportTemplatesEl,
fetchHelper: new DataboxMetricLibraryUtils.FetchHelper({
element: reportTemplatesEl }, true),
countObserver: new DataboxMetricLibraryUtils.PropertyTracker(0),
loaderObserver: new DataboxMetricLibraryUtils.PropertyTracker(false),
chunkLoaderList: new DataboxChunkLoader.List({
element: reportTemplatesEl.querySelector('ul')
}, [], {
item: DataboxMetricLibraryUtils.searchOptions.reportTemplates.listItem
}),
showMoreEl: reportTemplatesEl.querySelector('.item-list-show-more'),
fetchParams: {
baseUrl: `https://databox.com/metric-library/wp-json/metric-library/v1/report-templates/search`,
pageSize: DataboxMetricLibraryUtils.searchOptions.reportTemplates.pageSize,
projection: DataboxMetricLibraryUtils.searchOptions.reportTemplates.projection
}
};
reportTemplatesSearch.countObserver.registerOnChange((val) => {
targetTotalCountObserverFn(
val,
reportTemplatesEl,
reportTemplatesCountEl )
});
totalCountObservers['report-templates'] = reportTemplatesSearch.countObserver;
reportTemplatesSearch.showMoreEl.classList.add('hidden');
reportTemplatesSearch.loaderObserver.registerOnChange(targetLoaderObserverFn);
loaderObservers['report-templates'] = reportTemplatesSearch.loaderObserver;
function searchFn() {
let fetchParams = {};
fetchParams = JSON.parse(JSON.stringify(fetchBodyBase));
fetchParams.tempBody = {
filter: fetchBodyFilter,
projection: metricsSearch.fetchParams.projection,
sortOrder: fetchBodySort
};
fetchParams.body = JSON.stringify(fetchParams.tempBody);
delete fetchParams.tempBody;
metricsSearch.countObserver.trackedProp = 0;
DataboxMetricLibraryUtils.search([
`${metricsSearch.fetchParams.baseUrl}?pageSize=${metricsSearch.fetchParams.pageSize}&pageIndex=0`,
fetchParams
], metricsSearch);
fetchParams = JSON.parse(JSON.stringify(fetchBodyBase));
fetchParams.tempBody = {
filter: fetchBodyFilter,
projection: dashboardTemplatesSearch.fetchParams.projection,
sortOrder: fetchBodySort
};
fetchParams.body = JSON.stringify(fetchParams.tempBody);
delete fetchParams.tempBody;
dashboardTemplatesSearch.countObserver.trackedProp = 0;
DataboxMetricLibraryUtils.search([
`${dashboardTemplatesSearch.fetchParams.baseUrl}?pageSize=${dashboardTemplatesSearch.fetchParams.pageSize}&pageIndex=0`,
fetchParams
], dashboardTemplatesSearch);
fetchParams = JSON.parse(JSON.stringify(fetchBodyBase));
fetchParams.tempBody = {
filter: fetchBodyFilter,
projection: reportTemplatesSearch.fetchParams.projection,
sortOrder: fetchBodySort
};
fetchParams.body = JSON.stringify(fetchParams.tempBody);
delete fetchParams.tempBody;
reportTemplatesSearch.countObserver.trackedProp = 0;
DataboxMetricLibraryUtils.search([
`${reportTemplatesSearch.fetchParams.baseUrl}?pageSize=${reportTemplatesSearch.fetchParams.pageSize}&pageIndex=0`,
fetchParams
], reportTemplatesSearch);
}
searchFn();
});
General
-
DescriptionMicrosoft Azure is a cloud computing platform offered by Microsoft, providing a vast array of services for building, deploying, and managing applications and services through data centers worldwide.
-
CategoriesCloud Warehouses
-
Statusstable
Specification
-
Authentication Methodother
-
Shareable ConnectionYes
-
Time ZoneUser- or source-specific
-
Datasets AvailableYes
-
Media Creatives AvailableNo
-
Metric Builder AvailableYes
Metric Builder
-
Run Query- The metrics are categorized under the "general" type.
- Granularities available are hourly, daily, weekly, monthly, quarterly, yearly and all-time.
- Custom relative periods are available.
-
Missing data on Databoard with the SQL query pushing several values to the same day (1 value)
Databox recommends to group data by day in the SQL query in Metric Builder. If you have several entries for the same date, you need to configure your SQL query to group all values for the given day. You can use Aggregation Functions such as SUM, MIN, MAX, AVG, Count in the SQL query and GROUP BY date DESC to take all values for a day into consideration and compute them based on used Aggregated Function to display all data from your SQL database.
You can learn more about Data Types in Databox here.
