Encourage. Energize. Empower.

There is no tool for development more effective than the empowerment of women.  – Kofi Annan

In the above quote, Secretary Annan was referring to women in developing nations.  However, it’s just as apt a description of women in technology. 
Encourage. Energize. Empower.  Those are pretty tall orders. The YOU is implied. How about we imply instead that it’s WE? As working women with a voice,  WE need to support each other. WE need to encourage each other to try harder, to reach farther and to stand taller. WE need to energize each other when we’re tired, when we stumble and when we need to rest. 
Where should you start? How about right here?  Here is a great place to start. 
We’ll do it together.

A SQL Developer’s Guide to MDX Basics

Wed, Sep 14 2016 16:00 UTC

A SQL Developer’s Guide to MDX Basics

You already know how to write SQL queries against a data warehouse but your new job responsibilities require you to write MDX queries against Analysis Services (SSAS). MDX is the query language of SSAS in multidimensional mode. While SQL and MDX share some common keywords, they have very different syntax and concepts. In fact, the common keywords can be confusing if you are used to thinking in SQL. In this session you will explore how data is organized in SSAS in a data structure called a cube. Next, we will write MDX queries while comparing them with SQL queries that return similar results. You will see how certain queries are much easier to write in MDX, especially when it comes to querying data that contains hierarchies such as a date rollup. Finally, you will learn how to capture MDX queries generated by Excel and SQL Server Management Studio, to use as practical examples of how to write MDX queries.

Shabnam Watson

Shabnam Watson is a Business Intelligence consultant. She has 15 Years of experience developing data warehouse and business intelligence solutions. Her work focus within the Microsoft BI Stack has been on SQL Server Analysis Services staring with SQL Server 7. She has helped many companies with their Analysis Services design and implementations as well as performance tuning queries and Analysis Services servers. She holds a master's degree in computer science and a Certified Business Intelligence Professional (CBIP) certification by The Data Warehouse Institute (TDWI). She has spoken at PASS Summit, PASS SQL Saturdays, Women In Technology virtual Chapter, and Atlanta MDF and Atlanta BI SQL Server user groups.

SQL Saturday WIT Events

Is your SQL Saturday organizing a PASS WIT panel session?  If so, let us know! Has your SQL Saturday team recently hosted a PASS WIT Panel session? Share your pictures, thoughts and experience with us! Email us at wit@pass.org

Upcoming Events:

Many upcoming SQLSaturday events will feature Women in Technology panels or discussions. Check out our calendar for details.

Back to Top