Advice on choosing tools for web dashboard Announcing the arrival of Valued Associate #679: Cesar Manara Planned maintenance scheduled April 23, 2019 at 23:30 UTC (7:30pm US/Eastern) 2019 Moderator Election Q&A - Questionnaire 2019 Community Moderator Election ResultsMathematics major for data scienceWhat are recommended waystools for processing large data from Excel Files?Connecting Infusionsoft data to Google data studioHow is the salary for Data Scientist different among countries?Best Programming Language for Data ScienceIs Excel sufficient for data science?Advice on how to get started for someone a bit later in life?What can functional programming be used for in data science?Can data aggregation (and statistics) be done using an ETL solution?Want suggestions on choosing open source embedded BI tool
Russian equivalents of おしゃれは足元から (Every good outfit starts with the shoes)
What does 丫 mean? 丫是什么意思？
Are there any irrational/transcendental numbers for which the distribution of decimal digits is not uniform?
As a dual citizen, my US passport will expire one day after traveling to the US. Will this work?
Getting representations of the Lie group out of representations of its Lie algebra
Short story about astronauts fertilizing soil with their own bodies
How can I list files in reverse time order by a command and pass them as arguments to another command?
3D Masyu - A Die
Why do C and C++ allow the expression (int) + 4*5;
How do I say "this must not happen"?
How do Java 8 default methods hеlp with lambdas?
Did John Wesley plagiarize Matthew Henry...?
Any stored/leased 737s that could substitute for grounded MAXs?
What was the last profitable war?
Where and when has Thucydides been studied?
Why did Bronn offer to be Tyrion Lannister's champion in trial by combat?
Twin's vs. Twins'
Random body shuffle every night—can we still function?
Why can't fire hurt Daenerys but it did to Jon Snow in season 1?
One-one communication
Why complex landing gears are used instead of simple, reliable and light weight muscle wire or shape memory alloys?
"Destructive power" carried by a B-52?
How do you cope with tons of web fonts when copying and pasting from web pages?
Why does BitLocker not use RSA?
Advice on choosing tools for web dashboard
Announcing the arrival of Valued Associate #679: Cesar Manara
Planned maintenance scheduled April 23, 2019 at 23:30 UTC (7:30pm US/Eastern)
2019 Moderator Election Q&A - Questionnaire
2019 Community Moderator Election ResultsMathematics major for data scienceWhat are recommended waystools for processing large data from Excel Files?Connecting Infusionsoft data to Google data studioHow is the salary for Data Scientist different among countries?Best Programming Language for Data ScienceIs Excel sufficient for data science?Advice on how to get started for someone a bit later in life?What can functional programming be used for in data science?Can data aggregation (and statistics) be done using an ETL solution?Want suggestions on choosing open source embedded BI tool
$begingroup$
I am working in a small sales company. Started with making relatively easy, small, static reports in Excel, but then it was required to make a lot of highly-customizable and adaptable reports, that are really troublesome to do in Excel. I do a lot of VBA, but that still doesn't meet my needs. Our ERP has no BI solution. Excel can't keep up with amount of data used (millions of lines).
I am only accustomed to JS and HTML and have some experience working with
relational databases (MySQL, MariaDB in particular).
Basically, what I need help with is deciding what tools would be appropriate for my needs considering I am not in a rush and would like to develop some skills along the way.
I would like to create a dashboard that would retrieve data from a local DB and process it. I would also need the dashboard to be dynamic - be able to change some inputs and run calculations accordingly. I am interested in packages that are suitable for mathematical analysis. Reports would include both tables and graphs.
I've read about R and Python packages, but still am not sure which one would be the most appropriate.
In the future I guess I would like to distribute it to other colleagues (run it from a server; have different accounts with different access level etc.).
Will highly appreciate any tips!
data programming
asked Mar 8 at 21:55
Jay SheeJay Shee
111
$endgroup$
add a comment |
$begingroup$
I am working in a small sales company. Started with making relatively easy, small, static reports in Excel, but then it was required to make a lot of highly-customizable and adaptable reports, that are really troublesome to do in Excel. I do a lot of VBA, but that still doesn't meet my needs. Our ERP has no BI solution. Excel can't keep up with amount of data used (millions of lines).
I am only accustomed to JS and HTML and have some experience working with
relational databases (MySQL, MariaDB in particular).
Basically, what I need help with is deciding what tools would be appropriate for my needs considering I am not in a rush and would like to develop some skills along the way.
I would like to create a dashboard that would retrieve data from a local DB and process it. I would also need the dashboard to be dynamic - be able to change some inputs and run calculations accordingly. I am interested in packages that are suitable for mathematical analysis. Reports would include both tables and graphs.
I've read about R and Python packages, but still am not sure which one would be the most appropriate.
In the future I guess I would like to distribute it to other colleagues (run it from a server; have different accounts with different access level etc.).
Will highly appreciate any tips!
data programming
asked Mar 8 at 21:55
Jay SheeJay Shee
111
$endgroup$
add a comment |
$begingroup$
I am working in a small sales company. Started with making relatively easy, small, static reports in Excel, but then it was required to make a lot of highly-customizable and adaptable reports, that are really troublesome to do in Excel. I do a lot of VBA, but that still doesn't meet my needs. Our ERP has no BI solution. Excel can't keep up with amount of data used (millions of lines).
I am only accustomed to JS and HTML and have some experience working with
relational databases (MySQL, MariaDB in particular).
Basically, what I need help with is deciding what tools would be appropriate for my needs considering I am not in a rush and would like to develop some skills along the way.
I would like to create a dashboard that would retrieve data from a local DB and process it. I would also need the dashboard to be dynamic - be able to change some inputs and run calculations accordingly. I am interested in packages that are suitable for mathematical analysis. Reports would include both tables and graphs.
I've read about R and Python packages, but still am not sure which one would be the most appropriate.
In the future I guess I would like to distribute it to other colleagues (run it from a server; have different accounts with different access level etc.).
Will highly appreciate any tips!
data programming
asked Mar 8 at 21:55
Jay SheeJay Shee
111
$endgroup$
I am working in a small sales company. Started with making relatively easy, small, static reports in Excel, but then it was required to make a lot of highly-customizable and adaptable reports, that are really troublesome to do in Excel. I do a lot of VBA, but that still doesn't meet my needs. Our ERP has no BI solution. Excel can't keep up with amount of data used (millions of lines).
I am only accustomed to JS and HTML and have some experience working with
relational databases (MySQL, MariaDB in particular).
Basically, what I need help with is deciding what tools would be appropriate for my needs considering I am not in a rush and would like to develop some skills along the way.
I would like to create a dashboard that would retrieve data from a local DB and process it. I would also need the dashboard to be dynamic - be able to change some inputs and run calculations accordingly. I am interested in packages that are suitable for mathematical analysis. Reports would include both tables and graphs.
I've read about R and Python packages, but still am not sure which one would be the most appropriate.
In the future I guess I would like to distribute it to other colleagues (run it from a server; have different accounts with different access level etc.).
Will highly appreciate any tips!
data programming
data programming
asked Mar 8 at 21:55
Jay SheeJay Shee
111
asked Mar 8 at 21:55
Jay SheeJay Shee
111
asked Mar 8 at 21:55
Jay SheeJay Shee
111
asked Mar 8 at 21:55
Jay SheeJay Shee
111
asked Mar 8 at 21:55
Jay SheeJay Shee
111
111
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
$begingroup$
There are quite a few tools that serve this purpose (E.g.: Tableau , QlikView are expensive but feature rich; Kibana / Dash have Open Source versions).
You can start with Kibana. It will take a week to learn it. Advantages are :
- Part of ElasticSearch stack, it is easy to ingest data (Say that you need to update data from ERP every hour / day /week etc.) 'Logstash' component isused for ingesting / updating data
- Widely used, so tutorials / documentation are easy to look up
- You can customize dashboards with JS / html
- As usage grows, you can add features (Such as access control, periodic email of reports as PDF / Excel etc)
Some tutorials / Documentation :
https://en.wikipedia.org/wiki/Kibana
https://www.elastic.co/products/kibana
https://www.youtube.com/watch?v=gQ1c1uILyKI
answered Mar 9 at 2:35
Shamit VermaShamit Verma
1,6541414
$endgroup$
add a comment |
Your Answer
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "557"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdatascience.stackexchange.com%2fquestions%2f46965%2fadvice-on-choosing-tools-for-web-dashboard%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
$begingroup$
There are quite a few tools that serve this purpose (E.g.: Tableau , QlikView are expensive but feature rich; Kibana / Dash have Open Source versions).
You can start with Kibana. It will take a week to learn it. Advantages are :
- Part of ElasticSearch stack, it is easy to ingest data (Say that you need to update data from ERP every hour / day /week etc.) 'Logstash' component isused for ingesting / updating data
- Widely used, so tutorials / documentation are easy to look up
- You can customize dashboards with JS / html
- As usage grows, you can add features (Such as access control, periodic email of reports as PDF / Excel etc)
Some tutorials / Documentation :
https://en.wikipedia.org/wiki/Kibana
https://www.elastic.co/products/kibana
https://www.youtube.com/watch?v=gQ1c1uILyKI
answered Mar 9 at 2:35
Shamit VermaShamit Verma
1,6541414
$endgroup$
add a comment |
$begingroup$
There are quite a few tools that serve this purpose (E.g.: Tableau , QlikView are expensive but feature rich; Kibana / Dash have Open Source versions).
You can start with Kibana. It will take a week to learn it. Advantages are :
- Part of ElasticSearch stack, it is easy to ingest data (Say that you need to update data from ERP every hour / day /week etc.) 'Logstash' component isused for ingesting / updating data
- Widely used, so tutorials / documentation are easy to look up
- You can customize dashboards with JS / html
- As usage grows, you can add features (Such as access control, periodic email of reports as PDF / Excel etc)
Some tutorials / Documentation :
https://en.wikipedia.org/wiki/Kibana
https://www.elastic.co/products/kibana
https://www.youtube.com/watch?v=gQ1c1uILyKI
answered Mar 9 at 2:35
Shamit VermaShamit Verma
1,6541414
$endgroup$
add a comment |
$begingroup$
There are quite a few tools that serve this purpose (E.g.: Tableau , QlikView are expensive but feature rich; Kibana / Dash have Open Source versions).
You can start with Kibana. It will take a week to learn it. Advantages are :
- Part of ElasticSearch stack, it is easy to ingest data (Say that you need to update data from ERP every hour / day /week etc.) 'Logstash' component isused for ingesting / updating data
- Widely used, so tutorials / documentation are easy to look up
- You can customize dashboards with JS / html
- As usage grows, you can add features (Such as access control, periodic email of reports as PDF / Excel etc)
Some tutorials / Documentation :
https://en.wikipedia.org/wiki/Kibana
https://www.elastic.co/products/kibana
https://www.youtube.com/watch?v=gQ1c1uILyKI
answered Mar 9 at 2:35
Shamit VermaShamit Verma
1,6541414
$endgroup$
There are quite a few tools that serve this purpose (E.g.: Tableau , QlikView are expensive but feature rich; Kibana / Dash have Open Source versions).
You can start with Kibana. It will take a week to learn it. Advantages are :
- Part of ElasticSearch stack, it is easy to ingest data (Say that you need to update data from ERP every hour / day /week etc.) 'Logstash' component isused for ingesting / updating data
- Widely used, so tutorials / documentation are easy to look up
- You can customize dashboards with JS / html
- As usage grows, you can add features (Such as access control, periodic email of reports as PDF / Excel etc)
Some tutorials / Documentation :
https://en.wikipedia.org/wiki/Kibana
https://www.elastic.co/products/kibana
https://www.youtube.com/watch?v=gQ1c1uILyKI
answered Mar 9 at 2:35
Shamit VermaShamit Verma
1,6541414
answered Mar 9 at 2:35
Shamit VermaShamit Verma
1,6541414
answered Mar 9 at 2:35
Shamit VermaShamit Verma
1,6541414
answered Mar 9 at 2:35
Shamit VermaShamit Verma
1,6541414
1,6541414
add a comment |
add a comment |
Thanks for contributing an answer to Data Science Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
Use MathJax to format equations. MathJax reference.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdatascience.stackexchange.com%2fquestions%2f46965%2fadvice-on-choosing-tools-for-web-dashboard%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
