Image

ETL

Monetizing Your Valuable Data Assets
1 month ago

Monetizing Your Valuable Data Assets

A goldmine lurks within your valuable data assets for anyone to start mining. Every organization has raw masses of data stored within systems of record, content management systems, reports, Adobe …
Read More

Free Trifacta Wrangler Data Prep Gets Much Better
9 months ago

Free Trifacta Wrangler Data Prep Gets Much Better

Today super cool, “machine learning” powered data prep vendor Trifacta announced several significant enhancements for the free, community edition of Wrangler. For those of you that are not familiar with this nice …
Read More

Create Reports from Unstructured Data
1 year ago

Create Reports from Unstructured Data

In this Oceans of Data series article, I will share a tip on creating reports from unstructured data. Unstructured data refers to information that either does not have a pre-defined data …
Read More

Solving Hybrid BI Data Gravity Pain with Attunity Solutions
1 year ago

Solving Hybrid BI Data Gravity Pain with Attunity Solutions

One of the top challenges for BI and analytics professionals in a cloudy, big data world is data movement and integration. The growing complexity of reporting across large volumes of …
Read More

Datawatch Monarch – Market Leading Self-Service Data Prep
9
1 year ago

Datawatch Monarch – Market Leading Self-Service Data Prep

Datawatch invented self-service data prep with Monarch. Twenty years ago Monarch answered the vexing data challenge of the time – unlocking mainframe print spool data for reporting. Over the years …
Read More

Predictive Model Data Prep: An Art and Science
1 year ago

Predictive Model Data Prep: An Art and Science

As promised in the Moving Beyond Data Visualization to Predictive Analytics article, I have collected the following predictive modeling data preparation tips for you. My intent is to enlighten and …
Read More

Data Virtualization for Hybrid Data Integration
1 year ago

Data Virtualization for Hybrid Data Integration

A perfect storm of growing data sources, volumes, and varieties along with empowerment of self-service business analytics is driving the need for rapid, agile access to hybrid integrated data sources. …
Read More

NEW Alteryx Visual Analytics Kit for Microsoft
2 years ago

NEW Alteryx Visual Analytics Kit for Microsoft

Alteryx is a rising star in the world of self-service ETL and analytics. I wrote about their offering from time to time when I was an independent analyst and truly …
Read More

What Lies Beneath the Surface
2 years ago

What Lies Beneath the Surface

In the spirit of Discovery #SharkWeek and a recent personal shark encounter, I was inspired to explore shark versus alligator (or crocodile) attacks. “Sharkigator” attack data is easy to collect …
Read More

Alteryx – Rising Star in the Analytics World
3 years ago

Alteryx – Rising Star in the Analytics World

I first came across Alteryx about a year and a half ago. To be completely honest, I was tough on them. In our initial meeting, I literally blurted out “why …
Read More

Customer Data Quality with D&B Data Services
3 years ago

Customer Data Quality with D&B Data Services

In the business to business sales world, D&B is a well-known and highly regarded company that has been monitoring and evaluating business profiles, credit, payment performance and a variety of …
Read More

Power Query = the Shining Star of Power BI
4 years ago

Power Query = the Shining Star of Power BI

I have written a few times this year about Data Explorer, now called Power Query for Excel 2010 and 2013, in blogs New Data Explorer for Excel and Self-Service ETL …
Read More

New Data Explorer for Excel 2010 and 2013
4 years ago

New Data Explorer for Excel 2010 and 2013

I recently blogged about Self-Service ETL Tool Options. That blog was pretty much a high level summary of current market solutions in that space with links to further explore the …
Read More

Self-Service ETL, Data Quality, Cleansing, Prep and other Analytic Data Goodies
5 years ago

Self-Service ETL, Data Quality, Cleansing, Prep and other Analytic Data Goodies

By  •  ETL

As promised, I wanted to share some of the options out there that I have been evaluating for self-service ETL, data quality and cleansing. In this post I will briefly …
Read More

Data Warehousing Best Practices and Resources
7 years ago

Data Warehousing Best Practices and Resources

Data Warehousing and Dimensional Modeling

Data Warehouse Fundamentals http://it.toolbox.com/wiki/index.php/Data_Warehouse_Fundamentals and http://www.rkimball.com/html/articlesFundamental.html

Kimball Group http://www.kimballgroup.com/data-warehouse-business-intelligence-resources/

Data Warehouse Toolkit Collection http://www.amazon.com/Kimballs-Data-Warehouse-Toolkit-Classics/dp/0470479574

Best Practices for Data Warehousing with SQL Server 2008 http://msdn.microsoft.com/library/cc719165.aspx

DWMantra.com …
Read More

Top