Analysis Services and MDX Essentials
SQL Server Analysis Services is the foundation of Microsoft’s Business Intelligence platform. SSAS multidimensional, originally called OLAP services, has been part of the SQL Server family since 1998 and is now the core technology for newer in-memory analytics tools like Power Pivot and SSAS Tabular. By using SSAS cubes and models effectively, you can query and analyze large volumes of data with complex calculations very quickly. In this session, you’ll learn to build a basic semantic model and use MDX (multi dimensional expressions) to write queries for reporting and self-service browsing. I’ll share some real-world examples of reporting tools that utilize SSAS & MDX including Excel, SSRS and Datazen, Microsoft’s new mobile dashboard solution.
Paul (Blog | LinkedIn | Twitter) is a Mentor with SolidQ and a Microsoft SQL Server MVP. He consults, writes, speaks, teaches & blogs about business intelligence and reporting solutions. He works with companies around the world to visualize and deliver critical information to make informed business decisions. He is a Director of the Oregon SQL PASS chapter & user group, the lead author of Professional SQL Server 2012 Reporting Services and 13 other titles from Wrox, Packt & Microsoft Press.
I will discuss ways you can bring more movement into your day without interfering with your work. Long hours of sitting can take its toll on your body. In fact, sitting for long hours during the day has been compared to smoking as a health risk. It’s time to change your mindset about how to go about your work day, and learn to get moving even when you may feel chained to the desk.
Jennifer currently resides in Portland, Oregon and travels around the city working as a yoga instructor, nutritionist, and personal trainer. Jennifer works within each of these modalities to help her clients find balance, the key to health and wellness. Jennifer’s holistic based practice includes good nutrition, emotional health, and consistent exercise. In Jennifer’s classes she enjoys challenging her students. Sometimes that challenge lies in learning a new pose, but sometimes it lies in finding the ability to remain still, allowing for time to rest and recuperate. In each of Jennifer’s classes there is a strong focus on alignment and safety. Jennifer also holds a black belt in Taekwondo and leads local and international yoga and wellness retreats.
Refreshments graciously provided.
Featured Sponsor: Intertech
Visit our website for more details.
We wish to acknowledge the OSHU Information Technology Group for supporting Oregon SQL by generously providing the meeting venue.