| Presentation: | A SQL Developer’s Guide to MDX Basics |
| Level: Intermediate | |
| Date: | Monday, July 25th, 2016 |
| Time | 6:30 – 8:30 PM ET |
| Place: | South Terraces Building (Auditorium Room) 115 Perimeter Center Place Atlanta, GA 30346 |
| Overview: | MDX is an industry standard query language for OLAP systems and is used to query Microsoft Analysis Services (SSAS). Custom MDX queries can be authored in SQL Server Management Studio (SSMS), Reporting Services, Power BI and custom applications. While SQL and MDX share some common keywords, they have very different syntax and concepts. This session is for anyone familiar with SQL who wants to get started with MDX. In this session we will first explore data organization in SSAS in multidimensional mode using AdventureWorks sample database. Then we will review a couple of MDX and SQL queries that return the same results and continue to learn MDX fundamentals by running queries in SSMS. We will see how certain queries are much easier to write in MDX, especially when it comes to querying data with hierarchies such as a date rollup. Finally, we will learn how to capture MDX queries generated by Excel and SSMS, to use as practical examples of how to write MDX queries. |
| Speaker: | Shabnam Watson is an independent business intelligence consultant with 15 years of experience developing end-to-end data warehouse and business intelligence solutions using Microsoft technologies. 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 worked with OLAP since SQL Server 7.0 and specializes in solving complex MDX and design challenges with Analysis Services. |
| Sponsor: | Pyramid Analytics is a global BI&A leader offering an analytics platform that helps companies compete as world-class data-driven organizations. Pyramid Analytics’ mature BI Office Version 6 is an enterprise business analytics platform that puts the power of analytics into the hands of every user across an organization, making it possible to model, discover, communicate and distribute data for better corporate decision making. Pyramid Analytics was again recognized in Gartner’s 2016 Magic Quadrant Business Intelligence and Analytics (BI&A) Platforms Report for BI Office’s capabilities as a balanced analytics platform with strong governance, metadata management, security, and user administration. |
Atlanta MS BI and Power BI Group Meeting
- This event has passed.
Atlanta MS BI and Power BI Group Meeting
July 25, 2016 @ 6:30 pm - 8:30 pm
Follow Us
Prologika is a boutique consulting firm that specializes in Business Intelligence consulting and training. Our mission is to help organizations make sense of data by applying effectively BI technologies.
