forked from mining/mining
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathindex.html
More file actions
195 lines (164 loc) · 12.1 KB
/
Copy pathindex.html
File metadata and controls
195 lines (164 loc) · 12.1 KB
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
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<meta name="description" content="">
<meta name="author" content="">
<title>Open Mining</title>
<link rel="shortcut icon" href="./img/favicon.ico">
<!-- Bootstrap Core CSS -->
<link href="http://netdna.bootstrapcdn.com/bootstrap/3.0.3/css/bootstrap.min.css" rel="stylesheet" type="text/css">
<!-- Fonts -->
<link href="http://netdna.bootstrapcdn.com/font-awesome/4.0.3/css/font-awesome.min.css" rel="stylesheet" type="text/css">
<link href='http://fonts.googleapis.com/css?family=Lora:400,700,400italic,700italic' rel='stylesheet' type='text/css'>
<link href='http://fonts.googleapis.com/css?family=Montserrat:400,700' rel='stylesheet' type='text/css'>
<!-- Custom Theme CSS -->
<link href="./css/grayscale.css" rel="stylesheet">
<link href="./css/style.css" rel="stylesheet">
</head>
<body id="page-top" data-spy="scroll" data-target=".navbar-custom">
<a href="https://github.com/avelino/mining"><img style="position: absolute; top: 0; left: 0; border: 0; z-index:70;" src="https://camo.githubusercontent.com/8b6b8ccc6da3aa5722903da7b58eb5ab1081adee/68747470733a2f2f73332e616d617a6f6e6177732e636f6d2f6769746875622f726962626f6e732f666f726b6d655f6c6566745f6f72616e67655f6666373630302e706e67" alt="Fork me on GitHub" data-canonical-src="https://s3.amazonaws.com/github/ribbons/forkme_left_orange_ff7600.png"></a>
<nav class="navbar navbar-custom navbar-fixed-top" role="navigation">
<div class="container">
<div class="navbar-header page-scroll">
<h1 class="brand-heading visible-xs"><strong>Open</strong>Mining</h1>
<button type="button" class="navbar-toggle" data-toggle="collapse" data-target=".navbar-main-collapse">
<i class="fa fa-bars"></i>
</button>
</div>
<!-- Collect the nav links, forms, and other content for toggling -->
<div class="collapse navbar-collapse navbar-main-collapse">
<ul class="nav navbar-nav">
<!-- Hidden li included to remove active class from about link when scrolled up past about section -->
<li class="hidden">
<a href="#page-top"></a>
</li>
<li class="page-scroll active"><a href="#why-open-mining">Why Open Mining?</a></li>
<li class="page-scroll "><a href="#cube-dimensions-facts-and-measures">Cube, Dimensions, Facts and Measures</a></li>
<li class="page-scroll "><a href="#features">Features</a></li>
<li class="page-scroll "><a href="#olap-cube">OLAP cube</a></li>
</ul>
</div>
<!-- /.navbar-collapse -->
</div>
<!-- /.container -->
</nav>
<section class="intro">
<div class="intro-body">
<div class="container">
<div class="row">
<div class="col-md-8 col-md-offset-2">
<h1 class="brand-heading"><strong>Open</strong>Mining</h1>
<p class="intro-text">Business Intelligence (BI) Application Server</p>
<div class="page-scroll">
<a href="#why-open-mining" class="btn btn-circle">
<i class="fa fa-angle-double-down animated"></i>
</a>
</div>
</div>
</div>
</div>
</div>
</section>
<section class="container content-section">
<h1 id="why-open-mining">Why Open Mining?</h1>
<p><strong>Open Mining</strong> is software for creating OLAP (online analytical processing) cubes (multi-dimensional) using Numpy,
Scipy and Pandas for data management and flexibility in processing dynamical filters. Open-source provider of
reporting, analysis, dashboard, data mining and workflow capabilities.</p>
<h1 id="cube-dimensions-facts-and-measures">Cube, Dimensions, Facts and Measures</h1>
<p>The application models the data as a cube with multiple dimensions:</p>
<p><img alt="Cube" src="img/cubes-slice_and_dice-cell.png" title="=400x185" /></p>
<p>The most detailed unit of the data is a <em>fact</em>. Fact can be a contract,
invoice, spending, task, etc. Each fact might have a <em>measure</em> – an attribute
that can be measured, such as: price, amount, revenue, duration, tax,
discount, etc.</p>
<p>The <em>dimension</em> provides context for facts. Is used to:</p>
<ul>
<li>filter queries or reporst</li>
<li>controls scope of aggregation of facts</li>
<li>group by fields</li>
<li>used for ordering or sorting</li>
<li>defines master-detail relationship</li>
</ul>
<p>Dimension can have multiple <em>hierarchies</em>, for example the date dimension
might have year, month and day levels in a hierarchy.</p>
<h1 id="features">Features</h1>
<p>Which reporting solution is the best? Which tool to choose?
These are the question that all companies' managers need to answer in the beginning of firm's existence.
Although the choice always depends on customer, there are more and less meaningful features that might
influence on the evaluation. Checking and comparing the most important ones is necessary for distinguishing
worth-interesting solutions from inappropriate ones.
In the case of <strong>Open Mining, crucial features are good enough not to denounce that we're considering a free,
open source software</strong>.</p>
<ul>
<li>The advancement of <strong>reporting algorithm</strong> is probably the strongest side of Open Mining. Complex
system is prepared well enough to support all types of reports regardless of their destination, input data,
and output format.</li>
<li>The ideal situation would be if every department of an enterprise were using one common reporting solution.
Unfortunately, it's rather a rare situation, a possibility for reading reports from all of them is therefore
very useful. And that's what Open Mining offers. <strong>Multiple data sources available</strong> help also with migrating
data if the company thinks about replacing former solutions with one for all. Among many others, these are
the most common data sources operable with Open Mining solutions: Open MiningMetadata and Data Integration, XML XPATH,
JDBC SQL Swing TableModel, POJO, Hibernate HQL, and OLAP MDX.</li>
<li>These days, there's need to spread reports across more and more populous groups. All of them need reports, but each
of them works in a different way using different software. Therefore it's so important to use a reporting tool
supporting <strong>various output formats</strong>. Just like Open Mining. No matter whether we need Excel spreadsheets,
PDF documents, XMLs or CSV files. All these (and not only them) are supported by Open Mining Community.</li>
<li>Sometimes we might need to change report's format quickly and avoid quality and form losses. The feature
responsible for that is <strong>accurate formatting at the pixel level</strong> which assure that all elements stay aligned.
Although it's not realizable in some cases, changes among three most popular formats (HTML, PDF and spreadsheets)
do not cause any noticeable modifications in report's appearance.</li>
<li>The more complex reports we have to prepare the more attention we have to pay to its transparency and legibility.
Thereupon, most of reports include diverse <strong>charts</strong> that are <strong>easy to embed</strong> with Open Mining.</li>
<li>All reports have to be as transparent as possible, therefore we should be provided with a possibility for
defining what ranges and values we want to see. Parameterization options of <strong>Open Mining</strong> are sufficient
for most uses.</li>
<li>People used to attach weight to the number of data included in a report. Nonetheless, the more data we
have the more complex and therefore unclear the report gets. Open Mining supports using sub- or <strong>partial
reports</strong> to relieve the main part.</li>
<li>If there was a one file format better than the rest, for reporting it would be XLS. Excel spreadsheets
seem to be the ideal solution for presenting multiple data and information, therefore diverse reporting
tools, including Open Mining, allow their users to create reports that look like spreadsheets. They
usually are being called the cross tabs.</li>
<li>The report's lifecycle isn't over in the moment of rendering. People used to forget about its importance,
nonetheless a possibility for later editing truly is useful. The <strong>interactivity of reporting</strong> provided by
Open Mining enable end users to have an influence on reports' form, too.</li>
<li>Preparing a transparent report isn't simple, therefore what matter are <strong>various authoring options</strong>.
Open Mining provide its users with WYSIWYG editor to make preparing reports easy as pie.</li>
<li>Open Mining is being supported with <strong>Business Intelligence Server</strong>, multiplying its functionality.
Thank to that, the option of ad hoc reporting is enabled. It's all enough to understand that the
best is not what you have to pay most for - all Open Mining solutions are free for all uses.</li>
<li><strong>Python</strong> of Open Mining makes the tool <strong>easy for extending</strong>. This, followed with <strong>open source license</strong>
<em>MIT</em>, make Open Mining the most easily-customizable tool in the market. We do not have to pay for any
extensions as they're being spread for free. Moreover, we might easily prepare them ourselves - it's
just a matter of practice and there's no system restrictions.</li>
<li>Business needs evolve, reporting solutions have therefore to evolve, too. Unlike any other tool,
Open Mining is <strong>being incessantly developed</strong> if there was any feature missing we might predict it
to be added soon.</li>
</ul>
<p>It's been told that there are plenty of diverse reporting solutions currently accessible in the market
and Open Mining is only one of them. It's been also pointed that the choice of the best one depends on
each customer's needs. Nonetheless, knowing Open Mining's gratuity, we might suppose it to take place
in small and medium-sized companies at most.</p>
<h1 id="olap-cube">OLAP cube</h1>
<p>A cube can be considered a generalization of a three-dimensional spreadsheet. For example, a company might wish to
summarize financial data by product, by time-period, and by city to compare actual and budget expenses. Product,
time, city and scenario (actual and budget) are the data's dimensions.</p>
<p>Cube is a shortcut for multidimensional dataset, given that data can have an arbitrary number of dimensions. The
term hypercube is sometimes used, especially for data with more than three dimensions.</p>
<p>Each cell of the cube holds a number that represents some measure of the business, such as sales, profits,
expenses, budget and forecast.</p>
<p>OLAP data is typically stored in a star schema or snowflake schema in a relational data warehouse or in a
special-purpose data management system. Measures are derived from the records in the fact table and dimensions are </p>
</section>
<!-- Core JavaScript Files -->
<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.10.2/jquery.min.js"></script>
<script src="http://netdna.bootstrapcdn.com/bootstrap/3.0.3/js/bootstrap.min.js"></script>
<script src="http://cdnjs.cloudflare.com/ajax/libs/jquery-easing/1.3/jquery.easing.min.js"></script>
<!-- Google Maps API Key - You will need to use your own API key to use the map feature -->
<script type="text/javascript" src="https://maps.googleapis.com/maps/api/js?key=AIzaSyCRngKslUGJTlibkQ3FkfTxj3Xss1UlZDA&sensor=false"></script>
<!-- Custom Theme JavaScript -->
<script src="./js/grayscale.js"></script>
</body>
</html>