“But Balls,” you
say, “You’re not a Business Intelligence
guy, how would you know if there is a lot to offer?”
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!
FULL DAY OF BI
TRAINING
 |
| http://www.flickr.com/photos/headlouse/1484615917/sizes/m/in/photostream/ |
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?
Abstract:
|
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:
|
|
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!
THE SCHEDULE
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!
Thanks,
Brad
