Hot answers tagged

10

Don't worry - your hard-earned Python skills are still important ;) Tableau is not a replacement - it is essentially a means of sharing your insights/findings. It is a wrapper around your normal toolkit (Pandas, Scikit-Learn, Keras, etc.). It can do some basic analysis (just using basic models from sklearn), but the powerful thing is it can deploy your ...


6

There is the official answer and the realistic answer (from a business perspective): Official Officially the greatest thing your Python skills will bring you is flexibility. If you are going to run some economical model where you want to show a gradient uncertainty or something else crazy, doing that manually in any Data Visualization/Business Intelligence ...


6

Finally solved the issue. You should go to: Data –> your_data_source –> Edit Aliases –> Measure Names And see full mapping between variables/aggregations and aliases.


4

If you don't need other columns, here is a solution. It splits the column, stacks in vertically and combines with "permalink" column df.set_index('permalink').category_list.str.split('|', expand=True).stack().reset_index('permalink').rename(columns={0:'category'}) permalink category 0 /organization/-qounter Application Platforms 1 /organization/-...


3

There is one big economic difference between the two: ggplot2 is an open source package for an open source programming language. On the contrary Tableau is a proprietary software. That might be a dependency that you might not want to risk, e.g. you do everything in Tableau but then the license gets more expensive and your organization does not want to spend ...


3

This is something you can get in Tableau in 10 minutes. What you need is year binning, skills weights and length(year_end - year_start) for Gannt chart:


2

I don't think that you will learn much about data science (meaning, acquire understanding and skills) by using software tools like Tableau. Such tools are targeting mainly advanced users (not data scientists), for example analysts and other subject matter experts, who use graphical user interface (GUI) to analyze and (mostly) visualize data. Having said that,...


2

Slightly variation of the @init-random's first plot is use of Boxplot. Here example for the TotalSize using same setup for d xy <- boxplot(TotalSize ~ start.decade , data = d, ylab="sum of skill levels", xlab="start.decade", main= "Skill per Decade - TotalSize") But this actually ignores the factor and interprets it as numbers. To draw ...


2

You can, as an example, create a binned field for the measure. The value range can be specified in the tooltip. I used a single color based continuous palette since (population) total is a continuous field. [Edited] Based on your comment, I tested with a fixed dimension based binned field for the continuous measure. At least in my example file, the values ...


1

I wrote the question above, worked on the problem a little longer, and came to the following solution. Warning: it is anything but ideal, but it works. Put simply I wrote a small Python script using only one external library - pyautogui - the others are all native (time json requests) which retrieves my data online, updates a local file and executes the ...


1

As someone who worked on a competitor to Tableau, Data Science skills have largely superseded the need for Bi Software for data munging, complex analysis and ad hoc reports. But BI Software can still be beneficial if you need to deploy your results to lots of people, often with varying rights to view something (e.g. you can only see your performance stats, ...


1

This doesn't answer your Tableau questions, but I can say a few things about ggplot2. ggplot2's has reasonable defaults but nearly everything about the plots can be changed to make the results more clean aesthetically. One package I use all the time is called 'cowplot': https://cran.r-project.org/web/packages/cowplot/vignettes/introduction.html ggplot2 also ...


1

I don't think there is a well-defined (or well enough defined) terminology for that. Multi-variate means that it involves multiple (dependent or independent) variables. Which is pretty clear. Multi-dimensional in mathematical sense means that the data points are from a multi-dimensional space (typically vector space). This is exactly the same as multi-...


1

Set the latitude and put it under rows, select longitude and put it under cols. Select value and drop it to the center of the sheet. And under the marks dropdown select filled maps. Make sure you see filled maps in the dropdown and that the value column is selected for color. Edit: Do this for gradual color in heatmap- click on color tab. Select edit ...


1

I see that Kobol offers a REST API. Thus, one could create WebDataConnector to fetch the data in Tableau. If that's an overkill, you could write a script in e.g. Python which extracts the data from the REST API and creates a csv file. REST API http://support.kobotoolbox.org/en/articles/592398-api-and-rest-services REST API -> Tableau https://www.youtube....


1

Can you share all available columns in the data set? its hard to tell what data is there to use. Given the data you show, I would have started with some explaratory analysis: Group data per shops, check user activity ( how much purchases they do per month/week, what is AOV, LTV, etc). Idealy, its good to use email marketing, because its cheaper that paid ads ...


1

To my knowledge you have to create an auxiliary variable If [Entity] == "Industy" THEN [Volume] ELSE 0 END Then you can sort by this. Right click on State then select sort and choose sort by auxiliary variable.


1

Each line is treated independently at prediction, so you can be sure that the data is kept in the same order. For simplicity, you can keep your data in a pandas dataframe. Here's a short working example: import pandas as pd from sklearn.linear_model import LogisticRegression from sklearn.datasets import make_classification from sklearn.model_selection ...


1

Both of these options have value if interpreted properly. You are trying to answer the question (I assume): 'are we doing better this week than last week?' I don't know what industry you're in or how variable (or volatile) your metric is, but I'd advise caution in interpreting changes week to week. I might suggest that alongside your weekly (or whatever) ...


1

Yes, you can do this without reworking your, and as always, there are few ways to do it. Without seeing exact data, I would try setting table calculation to percent of total and then alter compute with to Table Down / Table Across depending on the data layout


1

Update Picking up from where we left off in the original post a quick interactive view to of the background areas can be made. I show this in a gif file here as you would need either the free Wolfram CDF Player or Mathematica installed to see the interactivity (there is also the Wolfram Cloud that does not need an install but I don't want you all using up ...


1

I can't comment due to reputation, but you really need to tell us what version of SQL Server you are running, maybe some more information about how the data is structured and how you're pulling the data into these dashboard. Maybe even how long it's taking and what resources you have available that actually know what they are doing. OLTP That said, it ...


1

We have dashboards that show information about some processes, which have billions of rows in the database. It's not queried directly though, but instead from pre-aggregated data. We have automated scripts running in database that populate the aggregated data tables specifically for dashboards. In most extreme cases the raw data is so large and comes in at ...


1

Go to pubmed. http://www.ncbi.nlm.nih.gov/pubmed/ typing the key words of your interest, you will able to pull all the public health research papers with the keywords chronologically from all the journals.


1

For my research on medical data, I am very pleased with the features RapidMiner offers. Rapidminer


1

Data science is a new somewhat vague terminology. You will find much more information by using keywords such as: epidemiology, population health, public health surveillance, public health, statistics, evidence based medicine, biostatistics, statistical epidemiology, clinical decision making, interventions etc. The question as posted is overly broad. On the ...


1

What information should be shown on the charts are based on what the viewer wants. From your sample charts, the x axis indicates 'date'. For time serial analysis, people usually want to know the trending of the metrics and to predict the performance in the future. Here are 2 suggestions: People may want to know how it will perform in the future. Add a ...


1

Found it myself. Go to context menu right clicking to the dimension field. Go to Aliases... and change the labels.


Only top voted, non community-wiki answers of a minimum length are eligible