Data Warehouse and Business Intelligence Architect

Author: Vince Napoli

Vince Napoli is a Data Warehouse and Business Intelligence Architect with over 20 years’ focus on DW/BI and SQL Server. A Mainframe developer since 1987, Vince specializes in MVS technical support, System Testing, Data Warehousing/ Business Intelligence architecture and development, SQL Server DBA/ ETL and database development. He is a Professional Association of SQL Server member and former president of the Philadelphia SQL Server User group.

A View to Success: Reasons Why SQL Server Database Views Lead to Better Reporting

Analytics & Insights

Author: Vince Napoli

A View to Success: Reasons Why SQL Server Database Views Lead to Better Reporting

Baking Custom Event Tables Into Your Reporting Environment.

The Power of the Bus Matrix

Beware of the Tool Trap

To Schema or not to Schema

ETL vs ELT

How to Leverage an Under-Utilized SQL Technique to Find Max Date Across Columns

Using Computed Column as a Primary Key

The Important Role of Metadata in Business Intelligence

Creating query aliases in TSQL and MDX

Connecting to SQL Server Analysis Services (SSAS) through Windows firewall

Gotcha on named instance migration for SSRS

Fix to SSRS Export to Excel error

.NET related issue with DQS Client for 2012

Group_Concat functionality for SQL Server

Ready to get started?

Enter your information to keep the conversation going.

Solutions

Industries

Company

Resources

Careers

Contact Info