business intelligence

To ETL or not to ETL? The benefits and limitations of ETL Tools over data scripting languages

2019-06-11T09:27:13-06:00

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 [...]

To ETL or not to ETL? The benefits and limitations of ETL Tools over data scripting languages2019-06-11T09:27:13-06:00

5 Things to Know about Databricks

2019-01-30T13:17:42-07:00

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 [...]

5 Things to Know about Databricks2019-01-30T13:17:42-07:00

What is a data warehouse and why do I need one?

2019-01-29T12:53:09-07:00

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 [...]

What is a data warehouse and why do I need one?2019-01-29T12:53:09-07:00

Interactive Custom Visualizations in Power BI using Plotly

2019-01-29T11:41:56-07:00

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. [...]

Interactive Custom Visualizations in Power BI using Plotly2019-01-29T11:41:56-07:00

How do data science and business intelligence work together?

2019-01-29T13:25:39-07:00

  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. [...]

How do data science and business intelligence work together?2019-01-29T13:25:39-07:00

Getting Started with Power BI: Setup (Part 1 of 3)

2019-01-30T10:33:49-07:00

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 [...]

Getting Started with Power BI: Setup (Part 1 of 3)2019-01-30T10:33:49-07:00