For those of you who have seen our team present, we always do our best to make it really informative, drive value and give you something you can leave with and immediately use without a lot of fuss and muss. Well there is some exciting news. We are up for a possible PreCon at the SQLRally event that is being held in Orlando next year. There is some stiff competition, but with all due respect to those who are also up for selection in the BI Session category, our session will cover more, be more entertaining and make the day a better value for your hard earned PreCon dollar.
We realize that many of you are paying you own way to these events in this economy and using them to smartly network, grow your skills and hopefully make a career move that will either put you back to work or move you to the right place on the ladder or a better, sturdier ladder altogether. This is no Survey session, we will deliver Solid , specific instructional techniques for all layers of the stack to get you up and running and most important have the context to make an impact. Ther eis no jumping around, since we follow a specific prescriptive method that works! No sales pitches, all action packed BI! You will leave with a much better understanding of how to use these tools in a BI Environment and how to use them to improve your existing BI or get BI going at your firm.
BI is one of the hottest markets right now and I can tell you that the skills we will cover will enable you to get started creating whole solutions, not just loading data or writing reports. Some folks say we can’t do it in a day, but I think that is selling you short. We have the utmost respect for the community and even our naysayers, but every time we do this session the feedback is stellar and folks are clamoring for more. We would like very much to get to present and have fun with you folks at SQL Rally and spend the day getting our learning on! So please – VOTE FOR US !!!! You know us, you love us, you know we’ll entertain and educate. So let’s make it happen. We’re in your hands ! ! !
Pre Conference seminar voting is up now here:
Go make it happen! There’s a lot of good seminars that you can read about here:
Developer Sessions: http://www.sqlpass.org/sqlrally/2011/PreConsforVotingDev.aspx
Here’s the description of our session:
Business Intelligence Workshop
Patrick LeBlanc, Devin Knight , Mike Davis, & Adam Jorgensen
In this full-day workshop, you’ll learn from the author team of Mike Davis, Adam Jorgensen, Devin Knight , and Patrick LeBlanc 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:
- Practical knowledge of building a Dimensional Model
- Designing a simple ETL process using SSIS
- Designing a Cube
- Designing simple SSRS Reports
- Building an integrated process that fully leverages the entire MS BI stack to load a Data Warehouse
Patrick LeBlanc , SQL Server MVP and author, is currently a Business Intelligence Architect for Pragmatic Works. He has worked as a SQL Server DBA for the past 9 years. His experience includes working in the Educational, Advertising, Mortgage, Medical, and Financial Industries. He is also the founder of TSQLScripts.com, SQLLunch.com and is the President of the Baton Rouge Area SQL Server User Group. Patrick is a regular speaker at various SQL Server community events, including SQL Saturday, User Groups, and SQL Lunch. Patrick is also a regular speaker at various Microsoft events in the US.
Devin is a Senior BI Consultant at Pragmatic Works Consulting. Previously, he has tech edited the book "Professional Microsoft SQL Server 2008 Integration Services" and was an author in the books "Knight’s 24-Hour Trainer: Microsoft SQL Server 2008 Integration Services," and "Knight’s Microsoft Business Intelligence 24-Hour Trainer." Devin has spoken at past conferences like PASS Summit and at several SQL Saturday events. He is a contributing member to the Business Intelligence Special Interest Group (SIG) for PASS as a leader in the SSIS Focus Group. Making his home in Jacksonville, FL, Devin is the Vice President of the local users’ group (JSSUG).
Adam Jorgensen, MBA, MCITP: BI, MCDBA is the President of Pragmatic Works Consulting, and has been delivering SQL Server and Business Intelligence (BI) solutions for over a decade. His passion is finding new and innovative avenues for clients and the community to embrace BI and lower barriers to implementation. Adam is a PASS regional mentor and member of the regional mentor committee, and a Virtual Technology Specialist for Microsoft. He is also an active member of the South Florida SQL Server User Group (SFSSUG) and is a co-founder of BIDN.com (Business Intelligence Developer Network). Adam co-hosts SQLLunch.com, is a co-chair of the PASS Virtual Chapter for Business Intelligence, and serves on other groups and boards. He regularly speaks in person and virtually at industry group events, major conferences, Code Camps, and SQL Saturday. He has co-authored white papers and books on business intelligence and business topics.
Mike Davis is a Senior BI Consultant and Trainer at Pragmatic Works. He was an author on the book "Knight’s 24-Hour Trainer: Microsoft SQL Server 2008 Integration Services." Mike is an experienced speaker and has presented at many events including several SQL Server User Groups across the US, Code Camps, SQL Server launches, and SQL Saturday events. Mike is an active member at his local user group (JSSUG) in Jacksonville, FL.