Cloud-based data warehouses are quickly replacing their on-premise counterparts, allowing organizations with big data needs to potentially save millions in costs. Amazon Web Services’ Redshift data warehouse platform is one of the most popular, offering relatively easy set up from…
Continue reading Setting Up A Cloud Data Warehouse: A Schema To SQL Tutorial
Amazon Redshift is a massively popular data warehouse service that lives on their AWS platform, making it easy to set up and run a data warehouse. Redshift clusters can range in size from the hundred-gigabyte scale up to the petabyte…
Continue reading Set up Your First AWS Redshift Database: A Schema to SQL Tutorial
Jupyter notebooks have quickly become one of the most popular, if not the most popular way, to write and share code in the data science and analytics community. Jupyter allows you to write code, add text and images, analyze data…
Continue reading Connecting Python pandas and Jupyter Notebooks to PostgreSQL For Data Analysis
Why should people care about visualizing data? Visualizing data can lead to quicker and easier decision making because it allows the user to spot trends, outliers, and other key insights that they wouldn’t have been able to glean from simply…
Continue reading How to Build Visualizations in Tableau Optimally
Is it easy to connect to a data warehouse? Selecting the right tool can help make this connection attainable. Tableau Desktop makes this connection easy, from opening the software to connecting to the five selected data warehouses. Tableau uses the…
Data analyst? You must be familiar with both Tableau and AWS Redshift. And you must know, or at least you should believe me that integrating the Redshift columnar-based database speed with the mature, rich and interactive Tableau creates an awesome…
Continue reading Tableau & Redshift: How to Visualize Amazon Redshift Data
The byproduct of the ever increasing integration of the internet in our daily lives is massive growth of data transitioning between applications and servers every minute. In order to make these transitions fast we needed data structures that are less…
Continue reading Handling and Constructing JSON Semi-Structured Data Models
