Welcome!

Blog Feed Post

Tips & Tricks: Tracking Usage & Performance of Metric Insights

The Dashboard database is the backbone of Metric Insights. It contains your metric data along with the definitions for all of your metrics and reports. It contains user information such as email addresses, group membership, and access permissions. It even contains usage data such as the number of elements viewed by each user, and performance data such as run-times for data collection triggers. All of this data can be set forth in metrics and reports, just like the data from any of your other sources. In this issue of Tips & Tricks, we’ll show you how.

 

The Dashboard Database

Data Dashboard SQL Builder

The first thing to do is to get an overview of the Dashboard database.That might be a daunting task, as the database contains more than 300 tables. Fortunately, most of the data that you’ll need can be found in a handful of key tables.

 

For example:

 

  • dashboard_element: Element metatada such as name, fetch command, and creation date
  • update_trigger_event_run_log_detail: Element run statistics such as start time, finish time, and success indicator
  • user_element_view_log_detail: History of elements viewed by each user, including dates and times

 

Here are some other key tables:

 

  • metric_measured_value
  • segment_value
  • source_database_connection
  • update_trigger_event
  • update_trigger_event_run_log
  • user
  • user_annotation

 

You can learn more about the Dashboard database by clicking the new SQL Builder link in the metric or report editor.

If you’ve selected the Dashboard DB as your data source, you’ll get a list of tables belonging to the Dashboard database. Drag any table onto the main screen to see a list of fields belonging to it. Drag fields from one table to another to create joins. Construct basic SQL queries by making selections from the drop-downs.

Visual SQL Query Builder

Note: The SQL Builder will work with any data source, not just the Dashboard database. It is included in version 3.1 of Metric Insights. If you don’t have version 3.1 yet, you can get a list of tables by creating a report whose SQL command is simply, ‘show tables’. Once you’ve found a table that interests you (e.g., dashboard_element), you can get a list of fields by creating a report whose SQL command is simply, ‘desc dashboard_element’.

Once you understand the key tables, you’ll be able to create a rich set of usage and performance reports. We’ll be happy to help you. In fact, we can even send you a file that you can use to create a starter set of reports. Please let us know if you’re interested!

The post Tips & Tricks: Tracking Usage & Performance of Metric Insights appeared first on Push Intelligence.

Read the original blog entry...

More Stories By Marius Moscovici

Marius Moscovici is the founder and CEO of Metric Insights (http://www.metricinsights.com/). He founded the company in 2010 with the goal of transforming the way business intelligence is performed so that organizations of any size can quickly and easily deploy powerful analytics. Marius has over 20 years of experience in analytics and data warehousing and was previously the co-founder and CEO of Integral Results, a leading business intelligence consulting company that was acquired by Idea Integration. Marius also formed and led the data warehousing and real-time analytics group at Linden Lab, the creators of Second Life.

Latest Stories
"Space Monkey by Vivent Smart Home is a product that is a distributed cloud-based edge storage network. Vivent Smart Home, our parent company, is a smart home provider that places a lot of hard drives across homes in North America," explained JT Olds, Director of Engineering, and Brandon Crowfeather, Product Manager, at Vivint Smart Home, in this SYS-CON.tv interview at @ThingsExpo, held Oct 31 – Nov 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA.
SYS-CON Events announced today that Conference Guru has been named “Media Sponsor” of the 22nd International Cloud Expo, which will take place on June 5-7, 2018, at the Javits Center in New York, NY. A valuable conference experience generates new contacts, sales leads, potential strategic partners and potential investors; helps gather competitive intelligence and even provides inspiration for new products and services. Conference Guru works with conference organizers to pass great deals to gre...
DevOps is under attack because developers don’t want to mess with infrastructure. They will happily own their code into production, but want to use platforms instead of raw automation. That’s changing the landscape that we understand as DevOps with both architecture concepts (CloudNative) and process redefinition (SRE). Rob Hirschfeld’s recent work in Kubernetes operations has led to the conclusion that containers and related platforms have changed the way we should be thinking about DevOps and...
The Internet of Things will challenge the status quo of how IT and development organizations operate. Or will it? Certainly the fog layer of IoT requires special insights about data ontology, security and transactional integrity. But the developmental challenges are the same: People, Process and Platform. In his session at @ThingsExpo, Craig Sproule, CEO of Metavine, demonstrated how to move beyond today's coding paradigm and shared the must-have mindsets for removing complexity from the develop...
In his Opening Keynote at 21st Cloud Expo, John Considine, General Manager of IBM Cloud Infrastructure, led attendees through the exciting evolution of the cloud. He looked at this major disruption from the perspective of technology, business models, and what this means for enterprises of all sizes. John Considine is General Manager of Cloud Infrastructure Services at IBM. In that role he is responsible for leading IBM’s public cloud infrastructure including strategy, development, and offering m...
The next XaaS is CICDaaS. Why? Because CICD saves developers a huge amount of time. CD is an especially great option for projects that require multiple and frequent contributions to be integrated. But… securing CICD best practices is an emerging, essential, yet little understood practice for DevOps teams and their Cloud Service Providers. The only way to get CICD to work in a highly secure environment takes collaboration, patience and persistence. Building CICD in the cloud requires rigorous ar...
Companies are harnessing data in ways we once associated with science fiction. Analysts have access to a plethora of visualization and reporting tools, but considering the vast amount of data businesses collect and limitations of CPUs, end users are forced to design their structures and systems with limitations. Until now. As the cloud toolkit to analyze data has evolved, GPUs have stepped in to massively parallel SQL, visualization and machine learning.
"Evatronix provides design services to companies that need to integrate the IoT technology in their products but they don't necessarily have the expertise, knowledge and design team to do so," explained Adam Morawiec, VP of Business Development at Evatronix, in this SYS-CON.tv interview at @ThingsExpo, held Oct 31 – Nov 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA.
To get the most out of their data, successful companies are not focusing on queries and data lakes, they are actively integrating analytics into their operations with a data-first application development approach. Real-time adjustments to improve revenues, reduce costs, or mitigate risk rely on applications that minimize latency on a variety of data sources. In his session at @BigDataExpo, Jack Norris, Senior Vice President, Data and Applications at MapR Technologies, reviewed best practices to ...
Widespread fragmentation is stalling the growth of the IIoT and making it difficult for partners to work together. The number of software platforms, apps, hardware and connectivity standards is creating paralysis among businesses that are afraid of being locked into a solution. EdgeX Foundry is unifying the community around a common IoT edge framework and an ecosystem of interoperable components.
"ZeroStack is a startup in Silicon Valley. We're solving a very interesting problem around bringing public cloud convenience with private cloud control for enterprises and mid-size companies," explained Kamesh Pemmaraju, VP of Product Management at ZeroStack, in this SYS-CON.tv interview at 21st Cloud Expo, held Oct 31 – Nov 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA.
Large industrial manufacturing organizations are adopting the agile principles of cloud software companies. The industrial manufacturing development process has not scaled over time. Now that design CAD teams are geographically distributed, centralizing their work is key. With large multi-gigabyte projects, outdated tools have stifled industrial team agility, time-to-market milestones, and impacted P&L stakeholders.
"Akvelon is a software development company and we also provide consultancy services to folks who are looking to scale or accelerate their engineering roadmaps," explained Jeremiah Mothersell, Marketing Manager at Akvelon, in this SYS-CON.tv interview at 21st Cloud Expo, held Oct 31 – Nov 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA.
Enterprises are adopting Kubernetes to accelerate the development and the delivery of cloud-native applications. However, sharing a Kubernetes cluster between members of the same team can be challenging. And, sharing clusters across multiple teams is even harder. Kubernetes offers several constructs to help implement segmentation and isolation. However, these primitives can be complex to understand and apply. As a result, it’s becoming common for enterprises to end up with several clusters. Thi...
"Infoblox does DNS, DHCP and IP address management for not only enterprise networks but cloud networks as well. Customers are looking for a single platform that can extend not only in their private enterprise environment but private cloud, public cloud, tracking all the IP space and everything that is going on in that environment," explained Steve Salo, Principal Systems Engineer at Infoblox, in this SYS-CON.tv interview at 21st Cloud Expo, held Oct 31 – Nov 2, 2017, at the Santa Clara Conventio...