Project Botticelli

DAX AW Sample Data Set Purchase this course

30 October 2012 · 4 comments · 2740 views

PowerPivot Workbook for Learning DAX

If you would like to follow Marco and Alberto’s demos, you will find it easier if you use the same data as they do in the video. This workbook already contains calculated columns and measures created in the video. You can create new ones or remove the existing ones and creating the same ones as you have seen in the video. We offer this workbook as a free bonus for Full Access Members who are following our DAX online course.

Log in or purchase access below to the premium version of this content.

Purchase This Course or Full Access Subscription

Single Course

$250/once

Access this course for its lifetime*.
Purchase
Subscription Best Value

$480/year

Access all content on this site for 1 year.
Purchase
Group Purchase

from $480/year

For small business & enterprise.
Group Purchase

  • Redeem a prepaid code
  • Payment is instant and you will receive a tax invoice straight away.
  • Your satisfaction is paramount: we offer a no-quibble refund guarantee.

* We guarantee each course to be available for at least 2 years from today, unless marked above with a date as a Course Retiring.

Comments

arthurjenkins1969 · 6 January 2013

Hello Marco. I have downloaded the DAX AW Data Set but it does not seem to work correctly in Excel 2013. Is there any reason why this might be so?

Thank you.

Arthur Jenkins

Marco Russo · 8 January 2013

Arthur,

I just tried it and it works.
When you open the workbook, you have to confirm that you want to upgrade the PowerPivot data to the new version - this happens as soon as you try to open the PowerPivot Manage window.
Please let me know if it works to you, or what error you have if otherwise.
Thanks,

Marco

qwiksilver96 · 16 July 2014

Marco, I too have the same issue as Arthur Jenkins. Running Excel 2013 and get notified that the data model needs to be upgraded. Upon clicking OK, I receive the following error: "PowerPivot is unable to load the Data Model".

Thank you,
Frank

Marco Russo · 16 July 2014

Frank,
you have to extract the file from the original ZIP first. After you extracted and saved the Excel file in a folder, you open the file in Excel and the upgrade works.
What you described seems the behavior you have by opening the file directly from the ZIP file (it's saved in a temp directory but you cannot upgrade in that case).

Marco

Online Courses