Neal Waterstreet

  • Home
  • About
  • Book Reviews
    • 2018 Reading List
    • 2017 Reading List
    • 2016 Reading List
    • 2015 Reading List
    • 2014 Reading List
    • 2013 Reading List
  • Projects
    • OBi200
    • DS716+ memory upgrade
    • Cord cutting
  • Presentations
  • Contact

DAX vs MDX Smackdown!

March 4, 2013 by neal 2 Comments

Last Monday Damu Venkatesan and I presented DAX vs MDX Smackdown! to the Atlanta Microsoft BI group. I thought it went well, but could definitely use some tweaking. In fact, it may be worth it to overhaul the presentation and focus on DAX. Here are a few of my thoughts about the presentation:

  1. More needs to be added to establish the use of DAX. I didn’t do a good job with this and assumed everyone was familiar with the Tabular model.
  2. I showed all of the queries in SSMS, which confused some people. The resolution here is to build a PowerPivot report and show the result from there. Then I can take it into SSMS and show the end result in PowerPivot and finally Power View.
  3. I need to spend more time telling the story of each query. Some of this was due to technical issues, but I still need to improve here. Damu did a very good job with stories about the MDX queries.
  4. Make sure the entire environment is installed on my VM. I had multiple SSAS instances, but didn’t have Excel or SharePoint installed. This would have helped me to elaborate on several questions.

On the technical side there were issues too. My Lenovo had issues with the projector and I could only see on screen and not the laptop. This was also at a very low resolution, so all of my work setting up SSMS for readability was lost. I need to find a backup plan here and find out what other people are doing.

I’d also like to thank Teo Lachev for his help before, during and after the presentation.

All in all it went well. It is always easier to pick out what went wrong instead of what went well. I am looking forward to doing it again soon.

Filed Under: DAX, Power View, PowerPivot, Tabular

Comments

  1. Lance England says

    March 6, 2013 at 11:21 am

    Again, hats off to you and Damu for presenting. You went for degree of difficulty by trying to present two topics by two presenters, with two different kinds of demos. And you guys pulled it off! I did a brief recap on my blog at http://lance-england.com/blog/2013/3/5/recap-of-d…

    I look forward to your idea of a DAX and Tabular-focused presentation.
    Keep up the good work!

    Log in to Reply
    • neal says

      March 8, 2013 at 11:09 am

      Thanks Lance. Now it is your turn to try presenting to the group!

      Log in to Reply

Leave a Reply Cancel reply

You must be logged in to post a comment.

March 2013
M T W T F S S
 123
45678910
11121314151617
18192021222324
25262728293031
« Nov   Apr »

Blogroll

  • Atlanta MDF
  • Atlanta Microsoft Business Intelligence Group
  • Atlanta Modern Excel User Group
  • Chris Webb's BI Blog
  • codegumbo
  • Lance England
  • PowerPivotPro
  • Prologika
  • SQLBI

Tags

Aereo Atlanta Microsoft BI Backups BA Conference Batch blog Business Rules Certification Chicago coffee Coursera Data Modeling Data Quality Data Warehouse DAX DVR Entity-based staging Error Messages ETL Excel Goals google Headphones HTPC Leaf Tables MDM MDS news OT PASS Healthcare VC Power BI Power Pivot Power View review Roku SQLSaturday SQL Saturday 272 SQL Server SSIS Subscription View Tabular Tech Training Validation Work

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org

Copyright © 2021 · Minimum Pro Theme on Genesis Framework · WordPress · Log in