DaveWentzel.com            All Things Data


Self-Service BI

I am creating a lot of content as the CTO of Capax Global to showcase our offerings in the cloud and data platform spaces.  Most of my writing and thought leadership will be on that blog, but I'll syndicate that content here when I remember.  
I wrote a whitepaper and have given a few webinars and luncheons on "Self-Service BI".  This is not your typical "deploy Power BI for your users" content that you might expect with a title like that.  Instead, I go through the process of what a modern data analytics pipeline looks like and how you can build one quickly.  The webinar can be downloaded hereThe whitepaper content can be downloaded here.  

Self-Service Analytics Webinar


I recently hosted a Self-Service Analytics Webinar for Capax Global.  

Upcoming Data Science Presentation


Presentation Download  

(check back for an updated link to the presentation materials)

Azure SQL Data Warehouse: Problems, Performance, Things You Need to Understand

This post isn't going to teach you the basics of Azure SQL Data Warehouse (ASQLDW).  This post is going to honestly cover the strengths and weaknesses of the product and will show you the *possible* pitfalls you may encounter.  Let me say upfront, ASQLDW is a *terrific* product, if you understand *exactly* what the use-cases are for the tool.  This is not an ASQLDW 101 post, if I write about a concept you don't understand I assume you can find that info using a basic google search.  To be clear, I have tons of experience in the MPP space...I've used Vertica for years (and I understand the costs/benefits of MPP.  Most of the same "gotchas" with ASQLDW/APS are also true of Redshift, Snowflake, and Vertica.  Each tool has a slightly different take on how to overcome perceived MPP shortcomings when compared to a traditional RDBMS.  Do your research!

Me and The Bricklin on Local Cable

I was asked to bring my Bricklin to Boyertown Auto Museum for a segment of Motor Mouth on local cable TV.  Malcolm Bricklin was the topic of the segment and I'm one of the few people in the area with a (mostly) functional Bricklin SV-1.  


Charter Member of the Microsoft Professional Program in Data Science

Want to be a "data scientist"?  Don't know where to start?  Try the Microsoft Professional Program in Data Science.  I am a charter graduate.  It's a curriculum of edX courses that really help you think differently about your software projects and business.  I certainly won't be adding "Data Scientist" to my resume any time soon, but it is a good first step. 

So You Want to Be a Data Scientist?


Presentation Download  

PerformanceCollector is now available for SQL Azure

PerformanceCollector (PC) is free and open-source software (FOSS) that I developed to monitor and baseline performance of your SQL Server.  There are certainly plenty of commercial tools and even free scripts available on the net that handle all of this.


Subscribe to RSS - blogs