Monday, August 29, 2011

SQL Saturday 85 for a Mid Level Business Intelligence Developer

 SQL Saturday 85 is just a little under 4 weeks away, and you if you are a Mid Level Business Intelligence Developer you maybe wondering what SQL Saturday could offer to you.  The answer is PLENTY!

“But Balls,” you say, “You’re not a Business Intelligence guy, how would you know if there is a lot to offer?”

That is an excellent point Dear Reader.  I’m not a BI Developer.  My work with cubes, SSAS, SSRS, and many things in between is slim.  Don’t get me wrong I’ve worked with it, but not to the extent that I do pure DBA work on a regular basis.  But one of the great advantages I have to putting together the schedule is that I am learning A LOT about my speakers.  And let me tell you who we have speaking.

 We have two dedicated BI tracks, an Microsoft Certified Master presenting on Parallel Data Warehouse, a SQL SSAS Maestros Instructor, Three SQL Server MVP’s presenting on BI topics, and one of the original team members that developed the Powerpivot plug-in for Excel, and Developed most of the Client.

And that isn’t to mention the Pre-Con’s!


 We have not one, not two, not three, BUT FOUR of the best Business Intelligence Experts in the game today training you in the full Business Intelligence Stack from start to finish.  These four experts are none other than SQL MVP  Jorge Segarra (@SQLChicken | Blog), Mike Davis (@MikeDavisSQL | Blog), Bradley Schacht (@BradleySchacht | Blog), and Kyle Walker (Blog).   All four are out in the field working with clients for Pragmatic Works and doing what you do every day. But don’t take my word for it, let’s get the word from the guys.  Gentlemen what will you be covering in your pre-con?

In this full-day workshop, you'll learn from the author team of Jorge Segarra, Mike Davis, Brad Schacht, and Kyle Walker how to build a data warehouse for your company and support it with the Microsoft business intelligence platform. We'll start with how to design and data model a data warehouse including the system preparation. Then, we'll jump into loading a data warehouse with SSIS. After SSIS, you're ready to roll the data up and provide the slice and dice reporting with SSAS. The team will walk through cube development and data enrichment with things like key performance indicators, which are essential for your future dashboards. Lastly, we will cover how to report against the data warehouse with SSRS including a primer in how to write MDX queries against the SSAS cube.
Take Home Skills:
  1. Practical knowledge of building a Dimensional Model
  2. Designing a simple ETL process using SSIS
  3. Designing a Cube
  4. Designing simple SSRS Reports
  5. Building an integrated process that fully leverages the entire MS BI stack to load a Data Warehouse

Now normally if you went to a pre-con like this at the PASS Summit you would be paying hundreds of dollars.  But we are offering this Dear Reader for $99, and this includes all the tea & coffee you can drink in a day, and lunch.  As a Mid level Business Intelligence Developer come and see the experts up close.  This will be a good way to see what you can become if you work hard and keep learning.  So do not delay!  Join us on Friday September 23rd.    Click Here to go to the Full Day Business Intelligence  Pre-Con site!


So  here we are you went to the Pre-con, you got to talk to Jorge, Mike, Bradley, and Kyle up close and personal.  You are brimming with new skills, what should you tackle?

Michael Antonovich (@MPAntonovich|Blog)- Introduction to PowerPivot for Excel
Eric Wisdahl(@EricWisdah | Blog)– SSIS Data Flow Buffer Breakdown
Phillip E. Rosen(@BIwPhil) – Biz Intel Dashboards W/Excel OLAP formulas
Robert Biddle(@Robert_Biddle | Blog )– Loading a Data Warehouse with SSIS
William E. Pearson III(@Bill_Pearson ) – Becoming DAX: An Introduction...
Brian Mitchell(@brianwmitchell | Blog) – Applying FastTrack & PDW Best Practices to your Data Warehouse

I’ve had the opportunity to see Michael Antonovich present at MagicPASS, the SQL Server User Group we both call home.  And I saw this presentation.  And let me tell you that if you are not using PowerPivot by the time you are done you will understand it’s power and have a few great selling points for your boss.  After a great day of Pre-con Training where this topic will be covered, this session is icing on the SQL Cake.

Eric Wisdahl is next up, and he is covering a subject that will be advanced enough to challenge you, and pertinent enough to make you WANT to listen to everything he has to say.  He will be covering how the Buffer’s work in the internal SQL Memory and how they work with SSIS.  SSIS likes to use memory and Eric will give you some tips on how to troubleshoot your systems, and make sure the memory is being used properly.

Phillip Rosen will be covering how you utilize Dashboards and he will cover the different ways you can view them.  Saving them locally to the PC using Excel, publishing them using SharePoint, and using Excel OLAP formulas.  Before this session is done he will cover SharePoint 2010 BI Center and give you some references to continue your learning.

Robert Biddle will be covering something that is a must know in our field.  How to load a Data Warehouse using SSIS, after all you’ve got your OLTP database.  You need to put the data in a Data Warehouse, but what is the best way to go about it.  Maybe you’ve done this before, but it never hurts to get the tips and tricks from the experts.  Go check out Roberts session and walk out of it with more confidence for the next time you need to pull some SSIS tricks out of your hat.

William E. Pearson III will give you an Introduction to DAX.  Being self taught often times I find that I’m missing some fundamentals.  When I go to a SQL Saturday it is always a great opportunity to find experts in the field and see how they go about doing things.  If you already know DAX, or if you are a beginner wouldn’t you want to get your tips from a SQL Server MVP?  Well look no further because William is a SQL Server MVP.  Go to his session and walk out with the tips and tricks of an MVP under your belt.

Brian Mitchell is a Microsoft Certified Master.  Brian Mitchell is a Microsoft employee.  Brian Mitchell is a Microsoft Premier Support Field Engineer that specializes in Parallel Data Warehouse.  Maybe your company isn’t looking at PDW, maybe it is.  Either way it would not hurt to go learn what a Master has to teach.  I saw Brian at SQL Rally earlier this year and it was one of the best sessions that I sat in.  He is smart, he is quick, and he knows his stuff inside and out.  What better way to end a great day of learning than with a Master.

Okay Dear Reader,  GO Sign Up for the SQL Saturday Full Day BI Pre-Con and then Go Register for SQL Saturday 85.  I look forward to seeing you on Friday September 23rd and on Saturday September 24th for two incredible days of learning!



No comments:

Post a Comment