Skillwave-logo-in-circle.svg

Workbooks and Supporting Documents

For M is for Data Monkey (1st Edition)

You probably got here from the link in our book ‘M is for Data Monkey’. This is the webpage where you can download all the workbooks that were used in the book.

You might also be interested in…

Check out our other resources and products to help you master Power Query.

Notes/Disclaimers

The Content is provided “as is”, without warranty of any kind, either express or implied. The Content contains valuable, proprietary content owned by the The Publisher and/or The Authors that is protected by state, federal, and international law, including, without limitation, copyright and trade secret laws. You may use the Content strictly for your own individual, personal use. The Content shall not be distributed, re-sold or used in a commercial manner

Addendum on Connecting to our Azure Database

Unfortunately, due to a change in the digital certificate setup for Azure SQL servers, we’ve had to revise the connection information used to connect to our AdventureWorks database.

Database Credentials

Instead of using the connection information found on page 65 of M is for (Data) Monkey, please use the following connection information:

  • Create a new query –> From Azure –> From Microsoft Azure SQL Database
  • Connect to the following database:
    • Server: ptypanama.database.windows.net
    • Database: AdventureWorks2012
When prompted for security information, make sure you select/enter:
  1. Database (not Windows or Microsoft Account)
  2. Username: DataMonkey
  3. Password: D4t4M0nk3y!
(Note that we use a zero in the password, not a capital ‘o’.)

And at that point you should be good to go!

 

Still Can’t Connect?

Our server is running 24/7/365, so the most likely issue is that you are behind a firewall that is blocking your access. Try connecting from another location or via a VPN to see if this is the case.

 

What About Credentials for the SSAS Example?

We apologize for not making this clearer in the text on page 71, but due to the cost of running an SSAS server, we were unable to provide a live connection for you to test this example.

Skillwave is brought to you by:

 

This site is produced and delivered to you by Excelerator BI Pty Ltd., Powered Solutions, & Excelguru Consulting Inc.