Posts

Showing posts with the label tableau desktop commands

Featured Post

Step-by-Step Guide to Creating an AWS RDS Database Instance

Image
 Amazon Relational Database Service (AWS RDS) makes it easy to set up, operate, and scale a relational database in the cloud. Instead of managing servers, patching OS, and handling backups manually, AWS RDS takes care of the heavy lifting so you can focus on building applications and data pipelines. In this blog, we’ll walk through how to create an AWS RDS instance , key configuration choices, and best practices you should follow in real-world projects. What is AWS RDS? AWS RDS is a managed database service that supports popular relational engines such as: Amazon Aurora (MySQL / PostgreSQL compatible) MySQL PostgreSQL MariaDB Oracle SQL Server With RDS, AWS manages: Database provisioning Automated backups Software patching High availability (Multi-AZ) Monitoring and scaling Prerequisites Before creating an RDS instance, make sure you have: An active AWS account Proper IAM permissions (RDS, EC2, VPC) A basic understanding of: ...

5 Tableau Features Useful for Data Analytics

Image
Below are the top Tableau features for data analytics. Tableau 9 for Data Science engineers. CONNECTING TO LOCAL FILE  Tableau can connect to any local file or database such as Excel  Text File Access  Statistical File, or  Another Database file CONNECTING TO SERVER Tableau can connect to your data server too. It can connect to almost any type of data server. Below are some of the most popular databases that Tableau can connect: Tableau Server Google Analytics Google BigQuery Hortonworks Hadoop Hive MapR Hadoop Hive IBM DB2 IBM BigInsights IBM Netezza Microsoft SQL Server Microsoft Analysis Services Oracle Oracle Essbase MySQL PostgreSQL SAP While working on Tableau, data can have Live Connection where any change in the source data will be automatically updated in Tableau. On the other hand, data can be Extracted to the Tableau repository so that any change made here will not affect the original source data. CONNECTING TO EXCE...