Image

ETL

Create Reports from Unstructured Data
4 months 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
4 months 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
5 months 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
6 months 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
7 months 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
1 year 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
3 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
4 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
6 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