Sunday, March 29, 2015

PASS Excel BI VC presents Devin Knight on Getting Started on PowerQuery

Come join us Thursday April 2nd for an Excel BI virtual chapter session at noon central with Pragmatic Work’s Devin Knight who will help us get started with PowerQuery.

Thu, Apr 02 2015 12:00 Central Daylight Time


Getting Started with Power Query by Devin Knight

RSVP: https://attendee.gotowebinar.com/register/1373099073018225154

GETTING STARTED WITH POWER QUERY

Power Query is a free add-in for Excel 2010 or 2013 that provides users an easy way to discover, combine and refine data all within the familiar Excel interface. With Power Query you can now combine and transform data from a variety of data sources all within Excel, which would have previously required a complex ETL tool. Join Devin and learn how you can use Power Query to take your Self-Service BI solutions to the next level. You will also see quick ways to visualize this new data appropriately. BIO Devin a Microsoft SQL Server MVP and the Training Director at Pragmatic Works Consulting. He is an author of six SQL Server books and speaks at conferences like PASS Summit, PASS Business Analytics Conference, SQL Saturdays and Code Camps. He is also a contributing member to the PASS Business Intelligence Virtual Chapter. Making his home in Jacksonville, FL, Devin is the President of the local users’ group (JSSUG).


Devin Knight a Microsoft MVP and the Training Director at Pragmatic Works Consulting. He is an author of six SQL Server books and speaks at conferences like PASS Summit, PASS Business Analytics Conference, SQL Saturdays and Code Camps. He is also a contributing member to the PASS Business Intelligence Virtual Chapter. Making his home in Jacksonville, FL, Devin is the Vice President of the local users group (JSSUG).

Tuesday, March 3, 2015

Simple-Talk Article

In December, I was asked to write an article(s) on Database Refactoring. It started as 2 topics, but then consolidated into one. I really wanted to talk about the database design issues I see with a development department. Please give some time to reading the article and comment. First, I would like to thank for Simple-Talk team for the editing process which was first class and very, very useful.

https://www.simple-talk.com/sql/t-sql-programming/defusing-database-time-bombs-avoiding-the-need-to-refactor-databases/

The comments are really for the new developer who needs some guidance on designing databases. I wish everybody had the MIS class I took at LSU for Entity-Relationship diagrams. Back then(86-91), the ER Diagram and Data Diagram were 2 separate pieces to the database. You looked at the conceptual design before the physical implementation.

I am started to wonder if Agile/Scrum methods are starting to water down the design sessions for application development. Or maybe not :)