We use databases to store, organize, query, and process structured data in computer systems quickly and efficiently. In this post, I will highlight how two leading databases, MySQL and Oracle, are different. Without delay, let’s now jump into the details…
Blog
Data Warehousing Concepts: Everything You Need to Know in 4 Minutes
Data Warehousing
Just ten years ago, even the most advanced analytics professionals only had to manage a handful of data sources. But data volume, velocity, and variety are now increasing exponentially.In 2016, IBM estimated that 90% of the world’s data had been…
Continue reading Data Warehousing Concepts: Everything You Need to Know in 4 Minutes
Business Intelligence and Data Warehousing Meet: Magic Ensues
BI and Data Visualization Data WarehousingHumans are visually motivated. When we see a movie, we’re drawn to the most beautiful and exotic settings, the most striking and recognizable actors, the biggest explosions. What we don’t spend a lot of time thinking about is the work…
Continue reading Business Intelligence and Data Warehousing Meet: Magic Ensues
Becoming an analytics driven organization: challenge accepted
Being Data-DrivenBoth business and tech analysts agree that a capacity for advanced analytics is becoming mission-critical to the basic viability for all companies. While some believe that we are only three to five years to this point, others estimate that there…
Continue reading Becoming an analytics driven organization: challenge accepted
Cloud Data Warehouse Costs: A Build Vs. Buy Analysis
Analytics LeadershipBuild vs. Buy—tale as old as time, song as old as…”I need that analysis yesterday!”Historically, a build vs. buy analysis was focused on on-premises vs. cloud. As cloud-based software services and data analytics tools have increased in popularity, the value…
Continue reading Cloud Data Warehouse Costs: A Build Vs. Buy Analysis
PostgreSQL vs. MongoDB
PostgresThis series of posts analyzes how specific databases stack up against each other. We’ve covered the following comparisons so far:In this post, we’ll see how PostgreSQL compares to MongoDB. Who Uses These Databases?The following companies use either PostgreSQL or MongoDB.PostgreSQL: Apple,…
Women Who Kick @$$ in Data Analysis, Science and Engineering
Analytics Leadership
International Women’s Day is a day when women are recognized for their achievements without regard to divisions, whether national, ethnic, linguistic, cultural, economic or political.As we #PressforProgress on International Women’s Day we want to raise awareness of:To that end, we’re…
Continue reading Women Who Kick @$$ in Data Analysis, Science and Engineering
The Worst Advice We’ve Ever Heard About ETL
ETL and ELTETL. It should be fairly straightforward, right? We extract data, transform it as needed, and load it into the target application. But like the recipe for the perfect Bloody Mary or the ideal hamburger, someone else’s way of doing things…
Continue reading The Worst Advice We’ve Ever Heard About ETL
10 Minutes To A High-Performance Big Data Stack. Really.
Data StackNearly everyone in the IT world has heard the quote from Facebook’s Mark Zuckerberg about the need for speed and performance in technology—“Move fast, break things.” While that might apply to social media platforms, there is less forgiveness for breaking…
Continue reading 10 Minutes To A High-Performance Big Data Stack. Really.
9 Things Your Boss Wants to Know About Data Warehousing
Best Practices Data WarehousingAs an analyst who deals with data from many data sources daily, you might find yourself as the go-to source for information about business intelligence in your office. While it’s cute when your grandma asks about what it is you…
Continue reading 9 Things Your Boss Wants to Know About Data Warehousing
Get Stacked: Designing a High Performance, High ROI Data Stack
Data StackYour company sits on an immense treasure trove of data, but tapping this data and accessing its value can be a challenge. The complexity of legacy systems is compounded by internal teams that need various combinations of system data in easily…
Continue reading Get Stacked: Designing a High Performance, High ROI Data Stack
Redshift Benchmark: A First Test of the Entire Data Funnel
RedshiftAmazon Redshift is a very powerful data warehouse, optimized for analyzing massive amounts of data in a blink of a second, when configured right.It’s a highly robust system, complete with features for configuring every step of the process with absolute…
Continue reading Redshift Benchmark: A First Test of the Entire Data Funnel