ETL refers to "Extract, Transform, and Load". By this point, the concept of ETL is well-established within the data industry and there are a number of enterprise-proven "ETL Tools" available to assist organizations with the movement and transformation of data. An ETL Tool is simply software that's designed to help organizations move and transform data [...]
Databricks is now available in both AWS and Azure so it’s getting a lot of buzz! Let’s discuss 5 things you should know about Databricks before diving in. 1. Databricks is a managed Spark-based service for working with data in a cluster Databricks is an enhanced version of Spark and is touted by the Databricks [...]
While the data warehouse isn’t a new concept, many are left wondering – what is a data warehouse? And why do I need one? I'm sad to tell you that when we say "data warehouse", we aren't referring to a physical building that stores data! Datalere’s official definition of a data warehouse is the following [...]
Did you know that Power BI supports custom, interactive visualizations using the Plotly library in R? This capability is exciting, and many organizations are intrigued! We’ll use this blog post to discuss these interactive custom visualizations from a high level by discussing the benefits and tradeoffs. Anytime you make anything custom, there are always tradeoffs. [...]
Business intelligence systems are data systems built into an organization’s architecture. When done correctly, business intelligence systems enable data science at every step in the process. Organizations with sophisticated business intelligence systems automatically pull data from multiple sources into a single repository, such as a data lake, a data mart, or a data warehouse. [...]
This is part 1 of the Getting Started with Power BI series. Power BI is a powerful reporting and dashboarding tool; in which, organizations of all sizes can leverage to tell their data story. This series walks through the creation of building out a social media dashboard. Introduction With the advent of SQL Server 2016 [...]