A New Chapter…

June 4, 2015

It’s going to take some getting used to. For you and for me, but it’s worth it.

Introducing the New Me

I changed my name to Stacia Varga last month because (drumroll) on May 18 I was part of a fabulous #sqlwedding in Las Vegas in which @mr_stacia and I said some special words to each other and at which @mr_denny officiated.

TMC_9042

It’s official!

I promised @mr_stacia some time ago that I would be Mrs. Varga if he would be @mr_stacia. He did, so I did, and here we are! I admit I’m still mangling my name when I try to say it or spell it, only because I was Stacia Misner for a very long time and I’m not a spring chicken anymore. I just need more practice with the new name!

Something borrowed, something blue.

Something borrowed, something blue.

I’m hopeful that people can pronounce Varga more easily than Misner (which 50% of the time was mispronounced). The name Stacia is challenging enough for some people (and for those who don’t know yet, it’s Stay-sha).  As for name recognition at conferences and on my books, I’ll just take my chances. I don’t know of any Stacia’s in the BI space at this time, so I expect everyone will figure out that Stacia Misner and Stacia Varga are one and the same at some point!

@mr_stacia has been a wonderful addition not only to my personal life, but also to my business life. He helps me manage Data Inspirations, edits my Pluralsight videos, and assists with so many other tasks that now I cannot fathom how I functioned without him previously. If you ever attend a conference, you’re likely to see him with me and perhaps one day you’ll even see him speak with me. (We have some clever ideas for some joint presentations in the future!)

What Else is New?

Oh my, 2015 has been such a busy year for me which is why I’ve been relatively quiet on the blog. I’ve been working with several clients on their data warehouse projects and really fallen head over heels in love with BIML (… @mr_stacia understands how I feel about technology, so it’s ok). I have praised its virtues in conference sessions previously, but I rarely have time to get into any depth about the benefits I’ve experienced first-hand and a full set of code to demonstrate a complete solution. To fix that, I’ve decided that my next Pluralsight course will give you a gentle introduction to BIML and show you how to approach an end-to-end data warehouse ETL solution and how easy to implement schema changes or even add new subject areas to the data warehouse after the first phase of development. I’m excited to work on this course because although there are a lot of great online BIML resources, there’s nothing comprehensive to show an end-to-end design. Expect to see this course available online this summer!

And More BI Love!

Every year there seems to be something new in the Microsoft BI stack. Most recently, much attention was given to cloud and Power BI. Just when we get our arms around a particular feature set, new features get added! But I get asked a lot why we haven’t seen a lot of love given to the on-premises BI components of SQL Server. I’m happy to say the love is coming back around. Jen Underwood (b|t)has a great overview in her post Microsoft Breathes Life Back into SQL Server BI On-Prem.

You can bet I’ll be doing some writing this year myself about all this good stuff in the Microsoft BI space, including SQL Server 2016. Probably more than one new chapter!

0

Getting Some Learnin’ On

March 26, 2015

With apologies to The Beatles, the theme song that’s been stuck in my head this month goes something like this,

Learn, learn, learn

There’s nothing you can do that can’t be done

Nothing you can build that can’t be built

Nothing you can learn that can’t be learnt

It’s easy…

I spend a lot of my time helping people learn about business intelligence and I do that in many different ways. I’ve been doing this type of work for a long time, but each year I try to learn how to do a better job of helping the people around me learn more about BI. As I review my plans for the first half of the year, I see a whole lotta learnin’ going on! Maybe you can join me…?

In the Classroom

First, there’s the traditional route that involves teaching in the classroom. For a multi-day experience, I will be providing an intense dive into BI at the Immersion Event – Business Intelligence (IEBI) in Chicago, May 4-8. I love this class because we get to cover a lot of BI ground with some really practical stuff, and I had a burst of inspiration this month on how to make it even better based on an experience I recently had working with a client and fixing up some problems they were having. I really like practical, and so do my IEBI students, one of whom said:

Any presenter can teach someone how to use a tool, but how best to use that tool to interact with the business in order to have a successful implementation that you’re confident business can adopt is what set this apart.

On the Road for SQLSaturday

SQLSaturdays are great events where you see local speakers and speakers from the national and international conferences present on our favorite subject, SQL Server, FOR FREE!!! I don’t have a complete schedule yet for 2015, but so far I am committed to speak at:

In fact, in Boston, I am also presenting a full-day preconference workshop, SQL Server Reporting Services Rookie to Rockstar for a nominal charge on Thursday, April 16. This is another class that is getting a makeover this year based on some new ideas I’ve been exploring, so I’m really excited to get Boston to see it come to life!

Oh, and I’m putting together our second SQLSaturday in Las Vegas. The location and date are still in the works, but we’re aiming for September!

On a Ship

Yes, that’s right! It’s a classroom on a ship! Specifically, SQLCruise Meditarranean, June 14-21, sailing from Barcelona with an amazing group of technical leads: Grant Fitchey , Aaron Bertrand, Andrew Kelly, and Argenis Fernandez. It’s a conference, it’s a classroom, it’s a classroom-conference! But it’s better because we get to spend time together talking SQL-ly things in a relaxed environment. But don’t think that cruising thing gets in the way of learning. In fact, it’s pretty conducive because there are a lot less work/life distractions to steal your attention away.

In Video

I’ve been a Plurasight author for several years now, and I really appreciate hearing from viewers from time to time about how much they learn from the material available. I’m very pleased to announce the release of my 10th video, Advanced Integration Services Part 2. Because apparently the first Advanced Integration Services wasn’t enough! After teaching Integration Services in the classroom for clients a few times, I was asked some questions that led me to develop the content for this newest course. A Twitter follower said “thanks, you’ve just made my ‘Todo’ list longer :)”. I think that’s a compliment, right?

I love working with Pluralsight. Creating courses for video has really forced me to rethink how I approach the education process. Earlier this month, I went to Utah for Author Summit 2015 and learned a lot of amazing things that I’m still trying to digest, but I’ll work these ideas into future content – whether live or recorded. It’s been amazing to see how Plurasight has evolved over the years and I’m excited to see the direction they want to go in the future. I am also very pleased to be part of a Women in Technology discussion that was recorded and published on YouTube.

imagejpeg_0

Park City Ski Lesson

Pluralsight sponsored a snow day at Park City after the summit where this girl got to learn (or at least attempt to learn) how to ski for the first time ever. Apart from my partner, I was old enough to be the other students’ mom … I guess what they say (sort of) is true: there’s… Nothing you can learn that can’t be learnt, at any age!

 

 

0

PASS Summit 2014… 10 Year Milestone!

November 1, 2014
Tags:

This year I’m celebrating my 10th anniversary of both attending and speaking at PASS Summit, and therefore it seems appropriate to mark this milestone with a reflection of what PASS Summit means to me. My ten years have not been consecutive. My very first Summit was in 2002. At the time, I worked for a boutique consulting firm in Seattle. I was encouraged by my manager to get engaged with the SQL community and submit a session to speak and… it happened! At the time, I knew no one. Or practically no one. I didn’t go to sessions, I didn’t participate in after hours events. I simply showed up for my session, I spoke, and… I got heckled!!! By none other than Dan Bulos, who has turned out to be a very dear friend. (I’ll save the point of dispute for another day as I can envision an entire blog post dedicated to the topic.) We still agree to disagree about the particular point of heckling, but we have been conference pals ever since and he even hired my daughter, Erika, away from me in 2012 (with my blessing). Dan happens to be presenting two sessions this year:

I have many sessions that I want to attend, but for Dan’s sessions…. I plan to be there front and center…and perhaps heckle (with love). It seems only fair.

Because I worked for a consulting firm back in 2002, I couldn’t plan on attending PASS Summit every year thereafter. It was only when I went independent in 2006 that I had my next opportunity to participate. I was incredibly honored to be selected to speak that year and have continued to be honored to speak every year since then. But more importantly, I became engaged with the community. I attended other people’s sessions. I talked to people at coffee breaks and lunch. I went to after hours events. I met people. (You would probably be shocked to know that I was incredibly shy once upon a time and this “breaking out” was a very big deal for me!) The circle of people that I knew grew exponentially. So much so that every passing year becomes a greater challenge to spend time with everyone that I have come to know over the years. But it’s a challenge I embrace!

I have been to many technical conferences in my career, but none compare to the experiences I’ve had since I began participating at PASS Summit. Whether you’re a speaker or an attendee, your experience will be enhanced exponentially by participating. First timer? No problem! This community welcomes you and wants you to have a positive experience. How cool is that? All you have to do is engage with other people. Smile. Ask a question. Offer up something from your experience when you hear people discussing a problem. The interpersonal exchanges at PASS Summit enhance the value of session attendance. And who knows… you might even make a life-long friend. There’s a reason we refer to our friends from PASS Summit as #sqlfamily.

 

0

Introducing the 2014 BI Immersion Experience

January 30, 2014
Tags: ,

In just a couple of weeks, I’ll be in Tampa, FL to launch the new BI Immersion experience. I’ve been teaching this class for several years, adding in elements relevant to the latest releases of SQL Server and Office that relate to BI along the way. Students have always been able to follow along with demos and I’ve even had students drive the demos in front of class as I talk them through the steps. But I thought it was time to shake things up a bit and add in another component for some added hands-on experience.

The addition of a hands-on portion of the class means some of the topics we used to cover in class are gone – like installation and configuration of BI components. I used the feedback from prior classes to determine what should go and what should stay. The result is still a great comprehensive class that teaches you everything you need to know about working with the Microsoft BI stack.

And of course, if you have questions about the things I left out, all you have to do is ask! Another benefit of attending BI Immersion is that we get to hang out and talk over lunch and during some of the evening networking activities.

What’s in the class?

A lot. Your brain will be full by the end of the week. I promise.

We start with an overview of relational data warehousing and then move into using Integration Services to populate a staging environment and a data warehouse. We’ll talk about maintaining and tuning packages. Then we build a cube using Analysis Services to consume that data warehouse and learn how to tune the performance of cubes, for both processing and querying. We’ll also review the differences between multidimensional and tabular models in Analysis Services and learn the basics about the languages that each model uses, MDX and DAX. We wrap up the week with a review of presentation layer tools: Reporting Services, Excel, and Power BI.

You can find the complete agenda HERE.

Why should you go?

You will learn a lot of things about Microsoft BI. Not just features and functions, but how to get started on a new project, how to pick the right technology for your solution, and how to avoid the perils and pitfalls that certain approaches can create. I’ve been working with Microsoft BI for a very long time (since 2000) and have helped clients in all kinds of industries build BI solutions that work. I haven’t learned how to perform the Vulcan Mind Meld yet, but this class is the next best thing!

But that’s just my opinion. What have past students said about the class?

  • Relational Data Warehousing/SSIS

I’ve been in and out of BI since 1999 and a surprising amount of this seemed new.

Loved the interactive modeling exercise!

Relational Data Warehousing/SSIS

  • SSAS

It finally made sense to me.

  • MDX

This was all new and gave me a great starting point. Thx!

I had basic understanding of MDX before going to this class. The light bulb came on after Stacia explained the key of MDX.

  • SSRS / Excel / PowerPivot

Great coverage of BI presentation layer at an understandable level.

  • Overall Class

A lot of info to hold in my brain.

Best class so far on BI. I learned so much more here than [from a competitor].

Great tips and tricks. Like the pragmatic/common sense/non-marketing approach.

Very informative and relative to the real world.

BI is a huge topic and Stacia does an excellent job hitting every major area…I would highly recommend this class. The first training session I’ve attended that took full advantage of my time away from the office. This was money well spent.

Any presenter can teach someone how to use a tool, but how best to use that tool to interact with the business in order to have a successful implementation that you’re confident business can adopt is what set this apart.

How can you sign up?

There’s still time to sign up for the Tampa class which runs Monday to Friday, February 10-14. All you have to do is click HERE.

0

From Reporting Services Rookie to Rockstar

October 7, 2013
Tags: ,

One week from today, I will be conducting a pre-conference workshop at PASS Summit 2013, “From Reporting Services Rookie to Rockstar.”

The official abstract provides a brief description of the workshop:

Join this introduction to SQL Server Reporting Services, designed specifically for report developers who have no prior experience with the product, and learn how to use the development tools effectively, how to present and enhance data in a report, and how to create dynamic reports. Even if you have some experience with Reporting Services, this session will explore aspects that aren’t intuitive or well-documented, helping you expand your skills and make the most of this powerful reporting tool.

In a jam-packed day of discussions and demonstrations focused on SQL Server 2008 Reporting Services and later, you’ll learn:

• How to approach the report development process
• How to manage key components of a report project: data sources, datasets, report items, and data regions
• How to use a tablix effectively to design the layout of data with creative groupings
• How to use expressions to display data or change the appearance and behavior of a report in practical ways
• How to use report parameters with and without query parameters
• How to use data visualization features to enhance the communication of information
• How to add interactivity to reports
• How to work with pagination and rendering features to manage page layout
• And more!

Want to know more specifically what topics we’ll be covering? Here’s a breakdown of the workshop:

Report Planning
Knowing Your Audience
Reviewing Report Options
Developing Standards

Basic Report Development
Data Sources
Datasets
Report Items
Data Regions

Tablix Concepts
Tablix Data Regions
Tablix Cell Content
Cell Scope
Grouping on Rows and Columns
Static Columns
Adjacent Groups
Expressions
Expression Usage
Placeholders
Global Collections
Expression Editor
Expression Examples
Built-in Fields
Aggregate Functions
Variables

Parameters
Report Parameter Usage
Report Parameter Properties
Report Parameter Filters
Linked Reports
Subreports and Drillthrough Reports
Parameters in Expressions
Query Parameters
Cascading Parameters

Data Visualization
Charts
Data Bars
Sparklines
Gauges
Indicators
Spatial Data Types
Points, Lines, and Polygons
Map Wizard

Interactivity
Report Layout

  • Interactive Sort
  • Fixed Headers
  • Tooltips
  • Visibility

Navigation Aids

  • Document Map
  • Actions
  • Embedded HTML

Pagination
Rendering
Page Structure
Page Breaks

I hope this additional information helps you decide whether this workshop is right for you. If so, I look forward to seeing you in Charlotte next week!

0