Datama Compare on Power BI
Using Datama Solutions as a Power BI extension is a great way to make your report more insightful with the benefits of both Datama and Power BI.
Here is what you get on this page:
- Overview
- Features
- Installation
- Free trial Period
- How to use
- Read your analysis
- Settings
- Get more insights
- Support and resources
- Release
1. Overview
This document provides detailed documentation for the “Datama Compare - What’s driving my variation” Plugin, a powerful extension for Power BI. This plugin enhances data analysis capabilities by explaining performance variations with easy to understand data visualization graph.
Watch this video to properly understand our extension and how to use it.
2. Features
Here are the main features this extension is providing. These features will be completed step by step with new improvements and functionnalities such as automated comments and title, hypothesis “What if” modelisation…
- Waterfall & tree analysis: Explore detailed waterfall charts, complemented by a performance tree, for in-depth data examination.
- Smart scoring engine: Automatically identifies and displays key factors that best explain performance variations, simplifying complex multi factors variations.
- Mix effect analysis: Assess the specific impact of Mix effect on your performance metrics.
- Intelligent Comments: Convert data analysis into smart, actionable insights, presented in a consolidated and understandable format.
- Interactive charts: Engage with your data through zoom, click, filter, and drill-down options for deeper exploration.
- Customization options: Tailor your experience with adjustable colors, units, fonts, and chart types.
3. Add the extension into your report
Follow one or the other steps to install the Datama plugin:
- Download the Plugin from the Marketplace:
- Navigate to “Insert” > “More Visuals” > “From appSource”.
- Search for “Compare - What’s driving my variation”.
- The visual will appear as a new icon in the visualization pane. Click on it to create the visual on the report canvas.
- or Install from the Visualization Pane:
- In the visualization pane, click on the ellipsis (“…”) to import a custom visual.
- Select “Import a custom visual”.
- Choose the Datama visual from the list provided.
- The visual will now appear as a new icon in the visualization pane. Click on it to create the visual on the report canvas.
4. Get a free trial period
Datama extension in Power BI allows you to benefit from all features.
On top of this, the paid version allows you to
- Remove Datama Branding (Background logo and free pop in)
- Let any other viewer of your dashboard to see Datama’s extension
You can get a free trial period of 7 days allowing you to test the full version of the extension by following these steps :
- Click on “Trial version” link of Datama footer
- Click on “Upgrade”
- Create your Datama account
- Get your Trial extension with no engagement, and no credit card required
See here our different plans.
5. Getting Started
Once you’ve imported the extension, here is how you can use it.
1. First think at your use case: You need first to consider which KPI you want to analyse and what are the steps that lead to the main KPI.
2. Prepare your dataset: 4 steps are needed to properly set your dataset.
- Main KPI: Define the main KPI you want to compare (e.g. Revenue, Leads, Margin…)
- Comparison Dimensions: Define on which elements you want to compare your KPI (e.g. Period: Compare Month over Month, Country: Compare one country to the other…)
- by default, Datama will select the first two elements of your dimension, or split a date range in two.
- Steps: Define the steps that correspond to the funnel that lead to your main KPI. For example (eCommerce funnel, or Finance funnel) See dataset examples
- To better define your steps (or metric equation), you can read our dedicated article.
- Explanation dimensions: Add Dimensions that will be used to explain the variations of your performance. Each variation will have an interest score to see how important they are to explain your variations.
3. Custom settings: Click on the “Settings” icon on the top right corner of Datama’s widget. You can adjust the methodology for comparison explanation and define which metric you want to analyse in the market equation pane
4. Save settings: Once you are happy with your settings, in the Power BI side panel, in the “Format your visual” tab, paste the JSON automatically added to your clipboard in the “Config JSON” field.
5. Leave edit mode: In the Power BI side panel, in the “Format your visual” tab, untick the “Edit mode” toggle. Dashboard viewers won’t see the top header and footer anymore, for a smoother experience.
5. Read your analysis
- Performance overview: Each blue bar represents the performance of your main KPI, using your chosen comparison dimension. helping you quickly gauge performance across different segments.
- Intermediary step analysis: Intermediary steps depict the ratio evolution of your KPI. The impact is quantified in the units of your main KPI, allowing for a consistent measurement of progress or regression.
- By default, the most interesting dimension will be selected for this zoomed step. You can change the selected dimension for this zoomed step by changing right clicking on the boxes of a segment and select the appropriate dimension in the “split by”. You can unzoom by clicking on other steps or clicking on the box again.
- In-Depth exploration: By interacting with a step—simply click on it—you’ll delve into the underlying dimensions that are most influential in explaining your performance variances at each stage of your funnel.
To discover more about how to read a Waterfall, you can read our dedicated section
7. Settings - Advanced Usage
Follow this link to get the full view of the extension Settings.
8. Get more insights
Explore related documentation to understand how to generate and read insights in Datama Compare
9. Support and Resources
If you require assistance or have any questions, feel free to reach out. We’re here to help!
- 📧 Email: Send us an email at contact@Datama.fr for any inquiries or support issues.
- 🌐 Contact Form: Prefer to use a form? Fill out our online contact form, and we’ll get back to you promptly.
10. Power BI Version History
- 1.0.0.1 (2024-01-20): Initial release.
- 1.3.14.0 (2024-07-01): Beta for comments, multiple fix.