Saturday, June 25, 2022
HomeBusiness IntelligenceThe best way to Clear Your BI Challenge

The best way to Clear Your BI Challenge


Protecting a clear, organized knowledge catalog is important to bettering the usability and sustaining the accuracy of a enterprise intelligence (BI) challenge. Disorganized reporting will usually show to be the downfall of any long-lasting knowledge challenge, however the simple practices we are going to assessment on this article may also help stop points attributable to disorganized knowledge.

The Significance of a Clear BI Challenge

Lengthy-lasting and well-liked dashboards are likely to scale over time, which might result in a number of essential upkeep points. These points stem from the widespread have to repeatedly add new insights, metrics, experiences, or visualizations to dashboards. When constructing strong dashboards, it’s essential to think about the next questions.

  • What number of metrics or experiences are not in use and may very well be deleted?
  • Which metrics and datasets are related and will due to this fact be included in a report?
  • How can you make sure that solely related adjustments are revealed and {that a} backup model of the BI challenge is accessible?

Correctly navigating these challenges is essential to sustaining correct, dependable analytics. Within the following sections, we are going to reveal how integrating GoodData into your software program stack can mitigate points attributable to disorganized BI initiatives.

Determine Irrelevant Metrics and Reviews

Expertise with BI instruments of any type teaches us one factor: It’s a lot simpler and extra widespread so as to add new metrics and experiences to an answer than it’s to take away them. Whereas it’s not usually a functionality you’d think about to be essential initially of a BI software implementation, the power to establish whether or not a selected metric may very well be deleted is important because the BI challenge reaches its peak utilization.

With GoodData, figuring out objects to take away has by no means been simpler. With just some clicks, customers can simply see if a specific metric is being utilized in one other metric or if it is part of any current insights or experiences. This characteristic permits customers to simply establish metrics and experiences which can be both inconsistent or just not used sufficient to justify retaining them.

Within the following instance, we’re capable of see that the metric Income is utilized in 17 metrics and 9 insights.

Dropdown menu on GoodData displaying the metrics and insights a metric is connected to.
Simply view related metrics and insights with GoodData.

Guaranteeing that everybody in your group can clearly establish metrics which can be important versus ones that may very well be deleted will enable the challenge to stay related and usable for for much longer.

Set up Your Metrics in Understandable Folders

Analytics is repeatedly changing into extra accessible with self-service functionalities, permitting enterprise customers to assemble experiences and dashboards by themselves. For the common enterprise person, understanding the construction of the Logical Knowledge Mannequin (LDM) and the way the relationships between completely different metrics and attributes are outlined is often pointless.

Nevertheless, if finish customers don’t really feel assured that your knowledge is correct and dependable, the interpretation of your knowledge and actions taken based mostly on it may very well be largely affected. Issues may come up if finish customers are unsure whether or not the metrics used within the report are literally working within the desired approach. Guaranteeing that the tip person understands which metrics and datasets are related is important. Contemplate the instance report beneath:

Graph chart displaying number of orders by state.
Graph chart visualization in GoodData

The top person constructs a easy report displaying the variety of orders by state. Prior to creating any choice on whether or not to shut the Iowa department, the tip person will marvel if the data is right and might be trusted. To make an knowledgeable choice, we would ask the next questions that you just, as an information analyst, or your BI challenge itself ought to have the ability to reply.

Query #1: Is the variety of orders really based mostly on buyer gross sales or on the shop’s stock?

Right here GoodData has acquired you coated. The LDM in GoodData routinely creates subgroups of attributes that are seen and accessible within the Analyze part.

View of subgroup which displays information about its connected attributes.
Subgroups of attributes in GoodData

With the power to see that State belongs to the Clients dataset, we might be able to say that the orders are, actually, coming from the shoppers. A follow-up query could come up.

Query #2: What in regards to the # of Orders metric? I don’t see it saved in the identical subgroup. How can I embody it within the Clients subgroup?

On this instance, the # of Orders metric is definitely positioned in a separate group referred to as Ungrouped:

View of two untagged metrics which are stored in the subgroup called Ungrouped.
Untagged metrics are positioned within the Ungrouped subgroup.

To assist customers establish which metrics and attributes are related, GoodData affords a performance referred to as tags. Including tags to a selected metric will enable the tip person to position it in the identical subgroup because the related related attributes. We will do that with a easy API PUT name:

Screenshot of an API PUT call.
Tag metrics utilizing an API PUT name.

And similar to that, the # of Orders metric, which was beforehand untagged, is now part of the Clients subgroup.

View of metrics and attributes located under a subgroup called Customers.
Simply place metrics and attributes below particular subgroups.

Query #3: I additionally wished so as to add the Marketing campaign Spend metric to the report, however for some motive this metric is not seen. What occurred to it?

The easy reply is that GoodData sees the Marketing campaign Spend metric as unrelated to what’s already chosen within the report. This can be a relatively useful characteristic which prohibits the usage of unrelated attributes and metrics in a single report. GoodData hides the unrelated objects for us and lets us know that they’re nonetheless there, simply not for use on this report.

Unrelated objects are separated from related objects in a report.

This characteristic will stop finish customers from setting up a report that’s nonsensical, due to this fact growing the reliability of our BI challenge.

Add Versioning to Your Analytics

The objective right here is easy. We wish our finish customers to get pleasure from a seamless analytics expertise the place no intensive technical information is required. On the similar time, we wish our knowledge engineers and designers to have the ability to work with the analytics in a approach that’s acquainted to them. GoodData’s objective is to seamlessly combine into your current tech ecosystems, together with the most typical collaboration and versioning instruments reminiscent of Git.

With GoodData.CN, all created and adjusted objects (e.g., dashboards, experiences, and metrics) in your analytics initiatives have an current, digestible API layer. This API layer might be simply accessed, versioned, and adjusted each on the UI and code degree — all based mostly in your choice and degree of technical experience.

Definition of a metric stored in the API layer.
All created and adjusted objects have an current, digestible API layer.

The definition of the Income metric featured above is a major instance of how versioning analytics in GoodData might work wonders for your enterprise. The MAQL a part of the code is the place the definition of the metric lies. That is one thing that may very well be both written within the UI degree or saved inside the declarative API setting.

As talked about beforehand, all experiences, metrics, and dashboards are outlined in the identical trend. This implies you can simply maintain observe of adjustments, restore earlier variations of your analytics, or collaborate together with your BI group. Code versioning instruments like GitHub can simply retailer all adjustments and variations of your analytics.

Able to Attempt GoodData?

Are any of the organizational challenges that we mentioned acquainted to you? Are you desirous to see how GoodData could make your analytics extra constant and simpler to grasp? Attempt the free model of our answer, and don’t hesitate to request a demo.




Please enter your comment!
Please enter your name here

Most Popular

Recent Comments