1 of 1 people found this helpful
I did use maximum upto 7 data sources with avg 15000 rows in each data source in a dashboard file. If we are connecting to server then the dashboard becomes heavy and it takes some time to refresh. But as you have the data sources of max of 1000s of rows, I guess there wouldnt be a problem in speed.
An update on this question with some empirical data: one of the dashboards has 13 worksheets drawing from 12 datasources. Directly attached to the MS Access data sources, the dashboard takes 3 minutes to display and update. Using extracts, refresh time is 7 to 8 seconds in Tableau Desktop, and pretty close to that in Tableau Server, which is acceptable performance for our needs.
can we created a chart like the below example ? can we get trend lines along with a mesaures on single worksheet ?
one morething can extract handles 10million rows of data
sales xcolumn category
1 trend lnes text
2 trendline text
Extracts can be over a billion rows, I don't know the upper limit there.
To do the chart you want, you'd need to have two worksheets (one with the 1/2/3/4 dimension and trendline, the other with the dimension and text), then put the two worksheets on a dashboard and hide the header for the 2nd worsheet.
There's an Idea to let this all be done in one worksheet, here's the link: http://community.tableau.com/ideas/1181
one more question,how to install tableau server in coprporate environment ?
Should i install tableau server on networkdrive in my company so that end users can access tableau server ?
i can install tableau desktop on my laptop ? is this correct way to install ?
any other tips need to follow while installing ?
I suggest you look at some of the resources on the Tableau website to learn more about Tableau Server, for example the whitepaper linked to on this page: http://www.tableausoftware.com/learn/whitepapers/tableau-enterprise. Tableau Server runs as an application on a device that is then accessed via a web browser. You can install Tableau Server on anything from a laptop to a dedicated box to a virtual machine.
Tableau Desktop can be installed on a laptop, desktop, or even within a windowing environment like Citrix. Requirements are pretty minimal, and you can be up and running in minutes.
i have gone thru all those docs but still not sure how to install on network drive ? i need users to access tableau server right ? so i should add end users in tableau server ?
Users access Tableau Server through a web browser, i.e. http://mytableau.mycompany.com/, not via Windows Explorer. They don't run the Tableau Server executable, they run Chrome, IE, etc. to access Tableau Server.
Tableau Server is installed on a machine (or virtual machine), so you decide where it's installed just like any other application. As part of the set up of Tableau server you set the HTTP port it's listening to. Then you can add the users via the Tableau Server admin interface.
The only potentially tricky bit is when you want Tableau Server to update extracts or have a live connection to the data, the user that Tableau Server runs as must have access to the data sources along with your Tableau Desktop users.
I am connecting teradata database and working on some 20 dimensions and measures.
while i am creating extract i am getting below error message
Database Error 0x80004005:[Teradata][ODBC Teradata Driver][teradata Database] Row Size or Sort Key Size Flow
how to resolve this issue ?
I'm sorry, I haven't used Teradata so I'm not familiar with this error message. Given that the question really has nothing to do with the original topic of this thread, I suggest either posting a question in a new thread with the error message in the subect and/or contacting Tableau tech support.