Example of a Data Flow in Tableau Prep But Don’t Throw Away Your Current ETL Tool Just Yet Tableau recently promoted its Maestro beta program to a licensed data cleansing and modification tool called Prep. Tableau Prep comes bundled with Tableau Desktop in their new Creator license. The purpose of bundling the two products together…
Best Tech Events for October 2017
Fall is finally here! Grab your jackets and boots, and join us for a tech event! Check out our list of upcoming events this month in the DC metro area. Applying Analysis in an Agile World; Presented by: Stephanie Vineyard Organized by: Washington DC Scrum User Group Monday, October 2nd 6 PM Arlington Tech eXchange – Arlington,…
Highlights from the Deep Learning Summit: Neural Networks Demystified and Domain Adaptation
I recently had the pleasure of attending REWORK’s Deep Learning Summit in Boston. Two topics stood out to me as eminently huge forces in deep learning: a powerful way to understand neural networks (and its practical benefits), and domain adaptation. These are both topics the community should be aware of, so let’s discuss them. 1….
Teaching Machines: What is Machine Learning?
Data Science and machine learning have generated a lot of discussion surrounding them in the past few years. Between them, they are poised to take over and transform the ways that we do many things in our everyday lives: how we drive our cars, manage our money, and make smart decisions. If we asked you…
USAJOBS: Using Analytics to Improve Testing Strategies
The USAJOBS Program Management Office understands that better testing leads to a better product for their customers. The team wondered how to collect the most practical data on customer behavior to perform the most effective testing. Excellian and OPM PMO Team Member Cory Benavente and OPM Testing Coordinator Dywane Boyd weigh in how the USAJOBS’…
Reviewing AWS Data Integration with Matillion
This month, we extended our overview of ETL tools from Open Source to include Matillion, an ETL/ELT software available from the AWS Marketplace that has been optimized for Amazon Redshift and the AWS ecosystem. Matillion pushes down all the data transformations to Redshift which is unique to Matillion and gives a tremendous performance for both the…
Open Source ETL Tools
Imagine that you have been charged with getting data from multiple sources – a flat file, a query from your data warehouse – and you need to bring it together so that it can be used to feed a report or a dashboard. What are your options? You’re not a developer who writes scripts and…
Self-Service or IT Managed BI Tools – What You Need to Know
My non-techie spouse just built his own small business website for a fledgling custom guitar-making business. All by himself. It did not take him long – some dragging and dropping, a little typing and a picture upload later – and it looks good. Ten years ago he would not have even attempted it and instead…
Enabling Hadoop in the Amazon Cloud
At Excella, we wanted a Big Data sandbox area for our research and prototyping efforts. We frequently work in the Amazon Cloud and chose Amazon’s Elastic Compute Cloud (EC2) – a “use what you need when you need it” virtual computing environment that allows subscribers to launch computing instances with different configurations. Here are five…
Agile Data Conversion: 5 Keys to Success
Imagine that you are a Product Owner on the replacement of a legacy operations system using an Agile approach. You may have experienced a mad scramble to complete the conversion of the data from one system to the other. This scramble may have been the culmination of all the design changes between the original design…