Category: Dashboard

What is Stored Procedure Transformation in Informatica

Informatica BI

Stored Procedure Transformation in Informatica is a passive transformation and can be used in both connected and unconnected mode. The stored procedures are stored and run within the database and it also contains a pre-compiled collection of PL-SQL statements. Some of the tasks you can do with stored procedures areCheck the status of a target database before loading data into it.Determine if enough space exists in a database.Perform a specialized calculation.Dropping and recreating indexes. Informatica stored procedures must exist in the database before creating a stored procedure transformation and the stored procedure can exist in a source, target or any database with valid connection to the integration service. 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 +

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 +

Top reasons to use Tableau

Top Tableau

Tableau enables teams to perform accelerated analysis and gain better insights into the data provided. It plays a vital role in viewing and understanding the data. It best suits to perform distinct business needs and requirements. Creating dashboards and reports. Self-Service BI. Expert in providing Statistical analytics like forecasting and trends. Helps to leverage the power of the database. No question of coding.Tableau recently included a feature, Ask data, to leverage the natural language processing and enable the users to ask questions of their data in plain language. This has made Tableau become indispensable for businesses that are constantly looking for valuable insights to grow.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 +

Supported and Unsupported Data values in Amazon Quicksight

Amazon Quicksight

Currently Amazon QuickSight supports the following primitive data types such as Date, Decimal, Integer, and String. ● Date primitive type supports both 24-hour and 12-hour clocks. It also supports in the range from Jan 1, 1400 00:00:00 UTC to Feb 26, 2364 23:59:59 UTC for SPICE datasets.● Whereas the decimal data type supports up to only four decimal points and if it is higher scale then it will be truncated to the four decimal places.● Boolean data types are converted to integers in Amazon QuickSight.● If a certain field contains values which are not being recognised by Amazon QuickSight then the rows with these values will be skipped.● In a few cases a particular data field might contain values that the JDBC driver can’t interpret for the source database then those values are being replaced by null.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 +

Dashboard Elements in Amazon QuickSight

Amazon QuickSight

Dashboard Elements in Amazon QuickSight provide various options such as zoom in or Zoom out, filtering the data, and exporting the data. Specific data fields can be excluded or focussed action can be performed. If your dashboard contains data on which you can drill down or up, you can drill up to a higher level or drill down to explore deeper details. If the dashboard contains custom actions you can activate them by choosing a data point.Amazon QuickSight allows changing the chart colors or the specific field colors as a part of these elements. 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 +

SISENSE Insights Webinar: Customize & Embed Your Dashboards

SISENSE

SISENSE Insights Webinar: Customize & Embed Your Dashboards No images? Click here Customize & Embed Your Dashboards  Insights For Everyone! Webinar: Wednesday, July 22, 10 AM PT Reserve my Seat   Presenter: Eric Pouliot     Sisense delivers real business insights with radically innovative business analytics. By empowering your business users to independently manage, analyze, and visualize, complex data is delivered quickly and cost-effectively. DataTerrain’s certified Sisense implementation partner, Precisio provides enterprise-class, cloud-ready business intelligence, analytics, and data science solutions.  End To End Implementation (including OEM & SAAS) Dashboard, Report, KPI & Analytics Development Data Engineering Reserve my Seat DataTerrain Inc 228 Hamilton Ave, Palo Alto, CA 94301, USA Preferences  |  Unsubscribe  

Read More +

Big Data Business Intelligence with Jaspersoft

Recent significant growth in data volume and challenges in processing huge data and to streamline customer businesses has paved the way for Big Data Analytics. Jaspersoft has several features that drive Big Data reporting analytics and ensures better business intelligence reporting, analytics and to meet customer’s competitive needs. • Jaspersoft offers Big Data Analytics by providing native Big Data connectors. Users can take advantage of these connectors to connect to big data environment to drill their data. • Jaspersoft’s connectivity to Big Data environments such as Hive for Hadoop, MongoDB, Cassandra etc benefits users for reducing costs and improve the efficiency of operations, decision making, and risk handling. • Connecting to Big Data environment from Jaspersoft studio and sever is quite simple which can be done in a few steps. • Jaspersoft offers an option to natively connect and perform real-time visualization and analytics from numerous big data stores. • Users can build real-time reports, dashboards and analytics directly on top of big data. • Jaspersoft works with many popular Big Data Store including MongoDB, Amazon Redshift, Hadoop, Elasticsearch, Cassandra, Cloudera Solution and DatabricksMapR DataTerrain with years of experience and reliable experts is ready to assist. We have served more […]

Read More +

DataTerrain Expands its Oracle Taleo Support Services

DataTerrain a leader in Business Intelligence migration solutions, announced that it has expanded its oracle TaleoSupport services for customers who are looking at managing and reporting, Recruiting and Performance management using Taleo platform. The support services now include Dashboard creation and enhancement. Taleo dashboards display a variety of summarized, Recruiting metrics like Candidate Stage Conversion, Requisition Activity, Hired Candidates, Offer Success Rate etc. The visualizations are filterable by a set of common filters and can be analyzed in different ways. DataTerrain helps customers create Dashboards from concept or provide Pre-built dashboards which can be customized as per the requirement, saving significant cost and time. DataTerrain has over 10 years of experience in Planning, Designing, Development, Tuning, Support a variety of Business Intelligence tools and reporting solutions. DataTerrain team have in-depth real-world expertise in the industry, leading reporting tools such as OBIEE, Jasper and Taleo and Oracle HCM platforms DataTerrain’sOracle TaleoSupport services include both the creation of new reports and trouble-shooting of existing reports. The primary services are: • Designing custom reports • Enhancing existing reports • Diagnose and resolve report issues • Creating Templates and modifying XML with BI Publisher • Scheduling reports • Creation and customizing Dashboards • Ongoing […]

Read More +