-
Notifications
You must be signed in to change notification settings - Fork 8
/
AnalyzeCategory.html
367 lines (255 loc) · 19.8 KB
/
AnalyzeCategory.html
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
<!DOCTYPE html>
<!--[if IE 8]><html class="no-js lt-ie9" lang="en" > <![endif]-->
<!--[if gt IE 8]><!--> <html class="no-js" lang="en" > <!--<![endif]-->
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>Analyze Tab — valQ Custom Visual for Microsoft Power BI 1.0.0 documentation</title>
<script type="text/javascript" src="_static/js/modernizr.min.js"></script>
<script type="text/javascript" id="documentation_options" data-url_root="./" src="_static/documentation_options.js"></script>
<script type="text/javascript" src="_static/jquery.js"></script>
<script type="text/javascript" src="_static/underscore.js"></script>
<script type="text/javascript" src="_static/doctools.js"></script>
<script type="text/javascript" src="_static/language_data.js"></script>
<script type="text/javascript" src="_static/js/theme.js"></script>
<link rel="stylesheet" href="_static/css/theme.css" type="text/css" />
<link rel="stylesheet" href="_static/pygments.css" type="text/css" />
<link rel="stylesheet" href="_static/theme_overrides.css" type="text/css" />
<link rel="index" title="Index" href="genindex.html" />
<link rel="search" title="Search" href="search.html" />
<link rel="next" title="Storage and Collaboration" href="Storage and Collaboration.html" />
<link rel="prev" title="Simulate Tab" href="SimulateCategory.html" />
</head>
<body class="wy-body-for-nav">
<div class="wy-grid-for-nav">
<nav data-toggle="wy-nav-shift" class="wy-nav-side">
<div class="wy-side-scroll">
<div class="wy-side-nav-search" >
<a href="index.html" class="icon icon-home"> valQ Custom Visual for Microsoft Power BI
<img src="_static/vbilogo.png" class="logo" alt="Logo"/>
</a>
<div role="search">
<form id="rtd-search-form" class="wy-form" action="search.html" method="get">
<input type="text" name="q" placeholder="Search docs" />
<input type="hidden" name="check_keywords" value="yes" />
<input type="hidden" name="area" value="default" />
</form>
</div>
</div>
<div class="wy-menu wy-menu-vertical" data-spy="affix" role="navigation" aria-label="main navigation">
<p class="caption"><span class="caption-text">Contents:</span></p>
<ul class="current">
<li class="toctree-l1"><a class="reference internal" href="Copyright.html">Copyright</a><ul>
<li class="toctree-l2"><a class="reference internal" href="Copyright.html#trademark-information">Trademark Information</a></li>
<li class="toctree-l2"><a class="reference internal" href="Copyright.html#patent-information">Patent Information</a></li>
<li class="toctree-l2"><a class="reference internal" href="Copyright.html#microsoft-power-bi-trademarks">Microsoft Power BI Trademarks</a></li>
</ul>
</li>
<li class="toctree-l1"><a class="reference internal" href="Introduction.html">Introduction</a><ul>
<li class="toctree-l2"><a class="reference internal" href="Introduction.html#document-history">Document History</a></li>
<li class="toctree-l2"><a class="reference internal" href="Introduction.html#who-should-read-this-guide">Who should read this guide?</a></li>
<li class="toctree-l2"><a class="reference internal" href="Introduction.html#what-is-the-visual-bi-valq-for-power-bi-as-a-custom-visual-component">What is the Visual BI valQ for Power BI as a Custom Visual Component?</a></li>
</ul>
</li>
<li class="toctree-l1"><a class="reference internal" href="Definitions.html">Definitions</a></li>
<li class="toctree-l1"><a class="reference internal" href="Generalfeatures.html">General Features of valQ Custom Visual</a><ul>
<li class="toctree-l2"><a class="reference internal" href="Generalfeatures.html#instructions-for-valq-custom-visual">Instructions for valQ Custom Visual</a></li>
<li class="toctree-l2"><a class="reference internal" href="Generalfeatures.html#input-data">Input Data</a></li>
<li class="toctree-l2"><a class="reference internal" href="Generalfeatures.html#tree-drill-down">Tree Drill Down</a></li>
<li class="toctree-l2"><a class="reference internal" href="Generalfeatures.html#zoom-and-pan">Zoom and Pan</a></li>
<li class="toctree-l2"><a class="reference internal" href="Generalfeatures.html#expand-collapse-of-tree-view">Expand/Collapse of Tree View</a></li>
<li class="toctree-l2"><a class="reference internal" href="Generalfeatures.html#value-display-and-simulation-period">Value Display and Simulation Period</a></li>
<li class="toctree-l2"><a class="reference internal" href="Generalfeatures.html#sub-models-filters">Sub Models - Filters</a></li>
<li class="toctree-l2"><a class="reference internal" href="Generalfeatures.html#kpis">KPIs</a></li>
<li class="toctree-l2"><a class="reference internal" href="Generalfeatures.html#data-simulation">Data Simulation</a></li>
<li class="toctree-l2"><a class="reference internal" href="Generalfeatures.html#key-inputs">Key Inputs</a></li>
<li class="toctree-l2"><a class="reference internal" href="Generalfeatures.html#scenarios-functionality">Scenarios Functionality</a></li>
<li class="toctree-l2"><a class="reference internal" href="Generalfeatures.html#constraints">Constraints</a></li>
<li class="toctree-l2"><a class="reference internal" href="Generalfeatures.html#visualization">Visualization</a></li>
<li class="toctree-l2"><a class="reference internal" href="Generalfeatures.html#contextual-help-information">Contextual Help Information</a></li>
</ul>
</li>
<li class="toctree-l1"><a class="reference internal" href="Generalfeatures.html#understanding-variances">Understanding Variances</a></li>
<li class="toctree-l1"><a class="reference internal" href="Generalfeatures.html#understanding-the-node-widget-information">Understanding the Node Widget Information</a></li>
<li class="toctree-l1"><a class="reference internal" href="Generalfeatures.html#conducting-what-if-analysis">Conducting what-if analysis</a></li>
<li class="toctree-l1"><a class="reference internal" href="Generalfeatures.html#getting-more-information-about-a-value-driver">Getting more information about a Value driver</a></li>
<li class="toctree-l1"><a class="reference internal" href="Generalfeatures.html#saving-and-opening-scenarios">Saving and Opening Scenarios</a></li>
<li class="toctree-l1"><a class="reference internal" href="valQ.html">valQ in Power BI</a></li>
<li class="toctree-l1"><a class="reference internal" href="ModelCategory.html">Model Tab</a><ul>
<li class="toctree-l2"><a class="reference internal" href="ModelCategory.html#new-tab">New Tab</a><ul>
<li class="toctree-l3"><a class="reference internal" href="ModelCategory.html#open-a-sample-model">Open a Sample Model</a><ul>
<li class="toctree-l4"><a class="reference internal" href="ModelCategory.html#general">General</a></li>
<li class="toctree-l4"><a class="reference internal" href="ModelCategory.html#configuration">Configuration</a></li>
<li class="toctree-l4"><a class="reference internal" href="ModelCategory.html#display">Display</a></li>
<li class="toctree-l4"><a class="reference internal" href="ModelCategory.html#simulation">Simulation</a></li>
<li class="toctree-l4"><a class="reference internal" href="ModelCategory.html#business-definition">Business Definition</a></li>
<li class="toctree-l4"><a class="reference internal" href="ModelCategory.html#conditional-formatting">Conditional Formatting</a></li>
<li class="toctree-l4"><a class="reference internal" href="ModelCategory.html#secondary-kpis">Secondary KPIs</a></li>
</ul>
</li>
<li class="toctree-l3"><a class="reference internal" href="ModelCategory.html#create-a-simple-model">Create a Simple Model</a><ul>
<li class="toctree-l4"><a class="reference internal" href="ModelCategory.html#read-only-dynamic-tree-in-editor">Read only Dynamic Tree in Editor</a></li>
<li class="toctree-l4"><a class="reference internal" href="ModelCategory.html#dynamic-scaling-on-dynamic-tree">Dynamic Scaling on Dynamic Tree</a></li>
</ul>
</li>
<li class="toctree-l3"><a class="reference internal" href="ModelCategory.html#create-an-advanced-model">Create an Advanced Model</a></li>
<li class="toctree-l3"><a class="reference internal" href="ModelCategory.html#import-an-advanced-model">Import an Advanced Model</a><ul>
<li class="toctree-l4"><a class="reference internal" href="ModelCategory.html#import-from-excel">Import from Excel</a></li>
<li class="toctree-l4"><a class="reference internal" href="ModelCategory.html#import-from-an-export-file">Import from an Export File</a></li>
</ul>
</li>
<li class="toctree-l3"><a class="reference internal" href="ModelCategory.html#additional-properties-of-new-tab">Additional Properties of New Tab</a></li>
</ul>
</li>
<li class="toctree-l2"><a class="reference internal" href="ModelCategory.html#node-tab">Node Tab</a><ul>
<li class="toctree-l3"><a class="reference internal" href="ModelCategory.html#quick-editor-in-node-tab">Quick Editor in Node Tab</a></li>
<li class="toctree-l3"><a class="reference internal" href="ModelCategory.html#additional-properties-of-node-tab">Additional Properties of Node Tab</a></li>
</ul>
</li>
<li class="toctree-l2"><a class="reference internal" href="ModelCategory.html#data-series-tab">Data Series Tab</a><ul>
<li class="toctree-l3"><a class="reference internal" href="ModelCategory.html#data-series-manager">Data Series Manager</a></li>
<li class="toctree-l3"><a class="reference internal" href="ModelCategory.html#time-aggregation-labels">Time Aggregation Labels</a></li>
<li class="toctree-l3"><a class="reference internal" href="ModelCategory.html#data-sorting">Data Sorting</a></li>
<li class="toctree-l3"><a class="reference internal" href="ModelCategory.html#additional-properties-of-data-series-tab">Additional Properties of Data Series Tab</a></li>
</ul>
</li>
<li class="toctree-l2"><a class="reference internal" href="ModelCategory.html#settings-tab">Settings Tab</a><ul>
<li class="toctree-l3"><a class="reference internal" href="ModelCategory.html#navigation-panel">Navigation Panel</a></li>
<li class="toctree-l3"><a class="reference internal" href="ModelCategory.html#nodes">Nodes</a><ul>
<li class="toctree-l4"><a class="reference internal" href="ModelCategory.html#contribution-and-performance-variance-percentage">Contribution and Performance Variance Percentage</a></li>
</ul>
</li>
<li class="toctree-l3"><a class="reference internal" href="ModelCategory.html#canvas">Canvas</a></li>
<li class="toctree-l3"><a class="reference internal" href="ModelCategory.html#number-formatting">Number Formatting</a></li>
<li class="toctree-l3"><a class="reference internal" href="ModelCategory.html#id1">Conditional Formatting</a></li>
<li class="toctree-l3"><a class="reference internal" href="ModelCategory.html#color-theme">Color Theme</a></li>
<li class="toctree-l3"><a class="reference internal" href="ModelCategory.html#additional-properties-of-settings-tab">Additional Properties of Settings Tab</a></li>
</ul>
</li>
<li class="toctree-l2"><a class="reference internal" href="ModelCategory.html#general-tab">General Tab</a><ul>
<li class="toctree-l3"><a class="reference internal" href="ModelCategory.html#license-registration">License Registration</a></li>
<li class="toctree-l3"><a class="reference internal" href="ModelCategory.html#export">Export</a></li>
<li class="toctree-l3"><a class="reference internal" href="ModelCategory.html#writeback">Writeback</a></li>
<li class="toctree-l3"><a class="reference internal" href="ModelCategory.html#additional-properties-of-the-general-tab">Additional Properties of the General Tab</a></li>
</ul>
</li>
</ul>
</li>
<li class="toctree-l1"><a class="reference internal" href="PlanCategory.html">Plan Tab</a><ul>
<li class="toctree-l2"><a class="reference internal" href="PlanCategory.html#understanding-the-features">Understanding the features</a></li>
<li class="toctree-l2"><a class="reference internal" href="PlanCategory.html#budgeting-allocation-scenarios">Budgeting & allocation scenarios</a></li>
<li class="toctree-l2"><a class="reference internal" href="PlanCategory.html#other-features">Other features</a><ul>
<li class="toctree-l3"><a class="reference internal" href="PlanCategory.html#adding-a-note">Adding a Note</a></li>
<li class="toctree-l3"><a class="reference internal" href="PlanCategory.html#view-history">View History</a></li>
</ul>
</li>
</ul>
</li>
<li class="toctree-l1"><a class="reference internal" href="SimulateCategory.html">Simulate Tab</a></li>
<li class="toctree-l1 current"><a class="current reference internal" href="#">Analyze Tab</a><ul>
<li class="toctree-l2"><a class="reference internal" href="#variance-analysis">Variance Analysis</a></li>
</ul>
</li>
<li class="toctree-l1"><a class="reference internal" href="Storage and Collaboration.html">Storage and Collaboration</a></li>
<li class="toctree-l1"><a class="reference internal" href="Knownissues.html">Known Issues and Limitations</a></li>
</ul>
</div>
</div>
</nav>
<section data-toggle="wy-nav-shift" class="wy-nav-content-wrap">
<nav class="wy-nav-top" aria-label="top navigation">
<i data-toggle="wy-nav-top" class="fa fa-bars"></i>
<a href="index.html">valQ Custom Visual for Microsoft Power BI</a>
</nav>
<div class="wy-nav-content">
<div class="rst-content">
<div role="navigation" aria-label="breadcrumbs navigation">
<ul class="wy-breadcrumbs">
<li><a href="index.html">Docs</a> »</li>
<li>Analyze Tab</li>
<li class="wy-breadcrumbs-aside">
</li>
</ul>
<hr/>
</div>
<div role="main" class="document" itemscope="itemscope" itemtype="http://schema.org/Article">
<div itemprop="articleBody">
<div class="section" id="analyze-tab">
<h1>Analyze Tab<a class="headerlink" href="#analyze-tab" title="Permalink to this headline">¶</a></h1>
<p>The Analyze Tab allows the user to run advanced analyses on the data. With 1.4, Variance Analysis has been introduced. Several other features such as Sensitivity Analysis and Time Series Analysis are to be released in the upcoming versions.</p>
<div class="section" id="variance-analysis">
<h2>Variance Analysis<a class="headerlink" href="#variance-analysis" title="Permalink to this headline">¶</a></h2>
<p>Variance Analysis displays the variance between the Base and Compared series across all nodes in the model.</p>
<p>On clicking the ‘Analyze’ Tab, you will be able to view the Variance Analysis option.</p>
<div class="figure align-center" id="id1">
<img alt="alternate text" src="_images/VA_1.png" />
<p class="caption"><span class="caption-text">Analyze Tab</span><a class="headerlink" href="#id1" title="Permalink to this image">¶</a></p>
</div>
<p>The Variance Analysis page is displayed, showing the variance between the Base and Compared data series.</p>
<div class="figure align-center" id="id2">
<a class="reference internal image-reference" href="_images/VA_2.png"><img alt="alternate text" src="_images/VA_2.png" style="width: 1000px;" /></a>
<p class="caption"><span class="caption-text">Variance Analysis Page</span><a class="headerlink" href="#id2" title="Permalink to this image">¶</a></p>
</div>
<p>The series that were created in the ‘Plan’ Tab can also be selected as Base Series or Compared Series by clicking on the drop-down.</p>
<div class="figure align-center" id="id3">
<a class="reference internal image-reference" href="_images/VA_3.png"><img alt="alternate text" src="_images/VA_3.png" style="width: 1000px;" /></a>
<p class="caption"><span class="caption-text">Choosing series created using Plan Tab</span><a class="headerlink" href="#id3" title="Permalink to this image">¶</a></p>
</div>
<p>The period across which the two series are to be compared can be customized by clicking on the drop-down in the ‘Period’ field.</p>
<div class="figure align-center" id="id4">
<a class="reference internal image-reference" href="_images/VA_4.png"><img alt="alternate text" src="_images/VA_4.png" style="width: 1000px;" /></a>
<p class="caption"><span class="caption-text">Customizing periods</span><a class="headerlink" href="#id4" title="Permalink to this image">¶</a></p>
</div>
<p>Variance analysis can also be performed for the two series across different periods by selecting the ‘Compare to different period’ option and choosing the period in the drop-down.</p>
<div class="figure align-center" id="id5">
<a class="reference internal image-reference" href="_images/VA_5.png"><img alt="alternate text" src="_images/VA_5.png" style="width: 1000px;" /></a>
<p class="caption"><span class="caption-text">Comparing across different periods</span><a class="headerlink" href="#id5" title="Permalink to this image">¶</a></p>
</div>
<p>It is to be noted that Base Series and Compared Series cannot be same when comparing for the same Base Period. However, when comparing across different periods Base Series and Compared Series can be same.</p>
<p>The ‘Filter’ option has the ability to filter the nodes based on the ‘Variance’ values. The number of nodes and the period can be selected by the user.</p>
<div class="figure align-center" id="id6">
<a class="reference internal image-reference" href="_images/VA_6.png"><img alt="alternate text" src="_images/VA_6.png" style="width: 1000px;" /></a>
<p class="caption"><span class="caption-text">Filtering the top 10 nodes based on monthly variance values</span><a class="headerlink" href="#id6" title="Permalink to this image">¶</a></p>
</div>
<p>The user can also choose to display either Absolute Variance or % Variance or both by selecting the appropriate checkboxes.</p>
<div class="figure align-center" id="id7">
<a class="reference internal image-reference" href="_images/VA_7.png"><img alt="alternate text" src="_images/VA_7.png" style="width: 1000px;" /></a>
<p class="caption"><span class="caption-text">Displaying Absolute Variance and/or % Variance values</span><a class="headerlink" href="#id7" title="Permalink to this image">¶</a></p>
</div>
<p>It is possible to download the results of the analysis as an Excel file when using Power BI Service.</p>
<div class="figure align-center" id="id8">
<a class="reference internal image-reference" href="_images/VA_8.png"><img alt="alternate text" src="_images/VA_8.png" style="width: 1000px;" /></a>
<p class="caption"><span class="caption-text">Downloading as Excel</span><a class="headerlink" href="#id8" title="Permalink to this image">¶</a></p>
</div>
<p>The downloaded analysis looks like the one shown below.</p>
<div class="figure align-center" id="id9">
<a class="reference internal image-reference" href="_images/VA_9.png"><img alt="alternate text" src="_images/VA_9.png" style="width: 1000px;" /></a>
<p class="caption"><span class="caption-text">Downloaded analysis result</span><a class="headerlink" href="#id9" title="Permalink to this image">¶</a></p>
</div>
</div>
</div>
</div>
</div>
<footer>
<div class="rst-footer-buttons" role="navigation" aria-label="footer navigation">
<a href="Storage and Collaboration.html" class="btn btn-neutral float-right" title="Storage and Collaboration" accesskey="n" rel="next">Next <span class="fa fa-arrow-circle-right"></span></a>
<a href="SimulateCategory.html" class="btn btn-neutral float-left" title="Simulate Tab" accesskey="p" rel="prev"><span class="fa fa-arrow-circle-left"></span> Previous</a>
</div>
<hr/>
<div role="contentinfo">
<p>
© Copyright 2019, Visual BI Solutions
</p>
</div>
</footer>
</div>
</div>
</section>
</div>
<script type="text/javascript">
jQuery(function () {
SphinxRtdTheme.Navigation.enable(true);
});
</script>
</body>
</html>