Category: tableau

Integrating Python and Tableau using Tableau Python Server

Python with Tableau

TabPy (the Tableau Python Server) is an external service implementation which expands Tableau’s capabilities by allowing users to execute Python scripts and saved functions via Tableau’s table calculations. TabPy allows Tableau to remotely execute Python code. Python has vast libraries to connect various tools, and hence it is becoming popular in automation and data science projects. One such module that we will be discussing here is TabPy which can be used to connect Python with Tableau. It has two components: A process built on Tornado, which allows for the remote execution of Python code through a set of REST APIs. The code can either be immediately executed or persisted in the server process and exposed as a REST endpoint, to be called later. A tools library that enables the deployment of such endpoints, based on Python functions.Tableau can connect to the TabPy server to execute Python code on the fly and display results in Tableau visualizations. Users can control data and parameters being sent to TabPy by interacting with their Tableau worksheets, dashboard or stories. DataTerrain, with years of experience and reliable experts, is ready to assist. We have served more than 250 customers in the US and over 70 […]

Read More +

The Tableau Suite of Products

Tableau Suite of Products

The Tableau Platform consists of several products that are designed to enable users to integrate various data sources and create data visualizations that can be shared across the enterprise. Tableau PrepTableau Prep allows users to prepare data for analysis by combining, transforming, and cleaning data into a usable format without writing any code.Tableau DesktopTableau Desktop has a rich feature set and allows you to code and customize reports.Tableau PublicIt is Tableau version specially build for the cost-effective users. By the word “Public,” it means that the workbooks created cannot be saved locally; in turn, it should be saved to the Tableau’s public cloud which can be viewed and accessed by anyone.Tableau ServerThe software is specifically used to share the workbooks, visualizations that are created in the Tableau Desktop application across the organization.Tableau OnlineIt is same as Tableau Server, but the data is stored on servers hosted in the cloud which are maintained by the Tableau group.Tableau ReaderTableau Reader is a free tool which allows you to view the workbooks and visualizations created using Tableau Desktop or Tableau Public. DataTerrain, with years of experience and reliable experts, is ready to assist. We have served more than 250 customers in the US […]

Read More +

Tableau Server Management

Tableau Server Management

Tableau Server Management makes it easier to run large, mission-critical Tableau Server deployments. With Tableau Server Management, you can react quickly to the changing needs of your business and save time by streamlining the management process. Better visibility for efficient Server managementTableau’s Windows or Linux deployment provides improved monitoring through its agent-based Tableau Resource Monitoring Tool. With increased visibility into hardware utilization, VizQL sessions, data source queries, backgrounder workloads and more, it’s easier to manage and precisely tune the performance of your server.Simplified content migrationSimplify and streamline your workbook and data source content workflows with the Tableau Content Migration Tool. Manage the movement of content between projects, sites or Tableau Server environments.Leverage cloud services for better reliability and scalabilityFor large deployments hosted on AWS or Azure, customers can choose to host their Tableau Server metadata repository externally, with Amazon RDS Postgres or Azure Database for PostgreSQL. DataTerrain, with years of experience and reliable experts, is ready to assist. We have served more than 250 customers in the US and over 70 customers worldwide. We are flexible in working hours and do not need any long-term binding contracts..

Read More +

Time-series and predictive analysis using Tableau

Tableau Time series

Tableau natively supports rich time-series analysis, meaning you can explore seasonality, trends, sample your data, run predictive analyses like forecasting, and perform other common time-series operations within a robust UI. Easy predictive analytics adds tremendous value to almost any data project. By supporting both complex configuration and simple interactive modeling, Tableau serves both the data scientist and the end user.The feature resources for time-series and predictive analysis:Time-series Analysis (In Action) : Tableau is a tool that lets you leverage Time Series Analysis to analyze important trends. Tableau Time Series Analysis lets you utilize its drag-and-drop feature to evaluate times by day of the week, drill down with a click and perform time comparisons like Moving Averages and Year-Over-Year growth easily.Forecasting : Forecasting in Tableau uses a technique known as exponential smoothing. Forecast algorithms try to find a regular pattern in measures that can be continued into the future. Add a forecast to a view that contains a date field and at least one measure. However, in the absence of a date, Tableau can create a forecast for a view that contains a dimension with integer values in addition to at least one measure. DataTerrain, with years of experience and reliable […]

Read More +

Scenario and what-if analysis in Tableau

Tableau Scenario

Tableau’s flexible front-end combined with powerful input capabilities, helps you quickly modify calculations and test different scenarios. With sets, groups, drag-and-drop segmentation, and parameters, Tableau makes it possible to move from theories and questions to a professional-looking dashboard that allows even non-experts to ask questions and test their own scenarios.Streamlining what-if analysis empowers you to focus on the more complex aspects of your analysis and deliver greater insights. At the same time, it’s easy to create intuitive visuals that help anyone engage with data. Tableau features can be used for scenario and what-if analysis: Parameters: The parameters in Tableau are the workbook variables like a number, date, or calculated field that allow users to replace a constant value in a calculation, filter, or reference line. Stories: In Tableau, a story is a sequence of visualizations that work together to convey information. You can create stories to tell a data narrative, provide context, demonstrate how decisions relate to outcomes, or to simply make a compelling case. DataTerrain, with years of experience and reliable experts, is ready to assist. We have served more than 250 customers in the US and over 70 customers worldwide. We are flexible in working hours and do […]

Read More +

Data extraction in Tableau

Tableau Data Extraction

Data extraction in Tableau is useful in increasing performance by applying filters. It also helps in applying some features of Tableau to data which may not be available in the data source like finding the distinct values in the data. However, the data extract feature is most frequently used for creating an extract to be stored in the local drive for offline access by Tableau. Creating an ExtractExtraction of data in Tableau is done by following the menu – Data → Extract Data. It creates many options such as applying limits to how many rows to be extracted and whether to aggregate data for dimensions.Applying Extract FiltersTo extract a subset of data from the data source, you can create filters which will return only the relevant rows. Let’s consider the Sample Superstore data set and create an extract. In the filter option, choose Select from list and tick mark the checkbox value for which you need to pull the data from the source.Adding New Data to ExtractTo add more data for an already created extract, you can choose the option Data → Extract → Append Data from File. In this case, browse the file containing the data and click OK […]

Read More +

What is Tableau Prep Conductor

Tableau Prep Conductor

Tableau Prep Conductor runs in a centralized, scalable, and reliable server environment so your data is always up to date and easy to share. Clean and Shape Data: Add missing rows in a seriesWhen you have gaps in your sequential data set, it can be difficult to analyze your data, spot trends, or normalize dates. To address this, you can now use the New Rows step type to generate those missing rows for numeric or date fields.After adding the new step type New Rows to your flow, select either a single field (numeric or date) or a range of fields (date fields only) where missing rows exist and enter your configuration parameters. New rows are generated to fill the gaps in your data.Preview the results in the Generated Rows pane. Set new row values to zero, Null, or copy the value from the previous row. Add the new rows to your existing field or create a new field to preserve your original data. Keep Flow Data Fresh: Schedule flow tasks to run one after the otherIf data for one flow is dependent on the output from another flow or you just want to set your flows to run in sequence, […]

Read More +

How to connect to XML as an ODBC Data Source in Tableau


To connect to XML as an ODBC Data Source in Tableau, you would need to specify connection properties in an ODBC DSN (data source name). You can use the Microsoft ODBC Data Source Administrator to create and configure ODBC DSNs. The data provider models XML APIs as bidirectional database tables and XML files as read-only views (local files, files stored on popular cloud services, and FTP servers). The major authentication schemes are supported, including HTTP Basic, Digest, NTLM, OAuth, and FTP.After setting the URI and providing any authentication values, set DataModel to more closely match the data representation to the structure of your data. The DataModel property is the controlling property over how your data is represented into tables and toggles the following basic configurations.● Document (default): Model a top-level, document view of your XML data. The data provider returns nested elements as aggregates of data.● Flattened Documents: Implicitly join nested documents and their parents into a single table.● Relational: Return individual, related tables from hierarchical data. The tables contain a primary key and a foreign key that links to the parent document. DataTerrain, with years of experience and reliable experts, is ready to assist. We have served more than […]

Read More +

Tableau Latest Features

Tableau Features

Tableau 2021.3 includes the latest capabilities to bring efficiency to your workflows and organization at scale. Some exciting features in the Tableau 2021.3 release:● Get Tableau notifications directly in Slack for data-driven alerts, @mentions in comments, and sharing activity to stay on top of your data, from anywhere.● Better prep and management of your data with new improvements to Data Management, including linked tasks and generate rows for Tableau Prep, and data quality warnings (DQWs) in subscription emails and inherited descriptions in web authoring for Tableau Catalog.● Safely explore data and save content on your Tableau Server or Online site before it’s ready to be shared with others with Personal Space.● Enable your Desktop users with curated, custom sample workbooks in Tableau Desktop. DataTerrain, with years of experience and reliable experts, is ready to assist. We have served more than 250 customers in the US and over 70 customers worldwide. We are flexible in working hours and do not need any long-term binding contracts.

Read More +