Dan English's BI Blog

Welcome to my random thoughts in regards to Business Intelligence, databases, and other technologies

Now Available: Visualizing Data with Microsoft Power View

Posted by denglishbi on June 5, 2012

[tweetmeme source=”denglishbi” only_single=”false”]

I am very excited and proud to announce that there is a brand new book available on the market and now in print – Visualizing Data with Microsoft Power View.  When I got home after work yesterday there was a box waiting for me and the books were inside.  It is hard to believe that just over a year and a half ago that I received the email from Brian Larson asking – “Ever want to be an author?”

Just got my #powerview book http://www.mhprofessional.com/product.php?isbn=0071780823 #msbi #SharePoint #sqlserver

Here is the outline for the book:

Part I – Power View

  • Chapter 1 – Getting Started
  • Chapter 2 – The Table Visualization
  • Chapter 3 – Additional Visualizations
  • Chapter 4 – Charting
  • Chapter 5 – Bringing Your Data to Life
  • Chapter 6 – Sharing Reports

Part II – Creating a BI Semantic Model (BISM)

  • Chapter 7 – BISM: Getting Started
  • Chapter 8 – Basic BI Semantic Model Design
  • Chapter 9 – BI Semantic Model: Additional Model Features
  • Chapter 10 – Using DAX Expressions
  • Chapter 11 – Deploying Tabular BI Semantic Models

Part III – Appendixes

  • Appendix A – Installing and Configuring the Sample Data
  • Appendix B – Creating a Virtual Learning Environment

The book is loaded with Learn By Doing exercises throughout the book and included with the book is a DVD that includes the sample data, project files, Power View reports, and videos of all of the exercises.

There will be eBook versions made available as well and there is even talks of an enhanced one that would be available in the iTunes Apple Store that would have the videos embedded throughout the chapters for viewing.

So what are you waiting for, check it out now and let us know what you think – Visualizing Data with Microsoft Power View.

Here is an example of one of the videos for a Learn By Doing exercise:

Advertisements

18 Responses to “Now Available: Visualizing Data with Microsoft Power View”

  1. Congrats Dan! Look forward to picking up a copy of it.

  2. Congrats Dan! 🙂

  3. congrats on the book! Picking up a copy today!

  4. Jurgen said

    Dan,

    Any idea on the timeframe when the iBooks enhanced version will be available?

    Congrats!

  5. amit said

    Dear sir, can i use OLAPs with Powerview and how?

  6. sr said

    Dan,

    I am trying to load the sample database(PGHT) from your book “Visualizing Data with Power View” and it fails during RESTORE database looking for a missing file (TGHT_Tourism.mdf and TGHT_Tourism_log.ldf). Just wanted to know, whether you haven’t missed to include these files in the DVD.

    I don’t find those files in the DVD content, which I downloaded from MH. Any help is appreciated, as I am looking to get started on Power View using your book.

    Thanks,
    sr

    • denglishbi said

      Thanks so much for purchasing the book. I am sorry you are having issues with getting the data setup. The files that you mention are actually contained in the SQL Server database backup file that is contained on the media that is named – PGHT_Tourism.BAK. Simply create a folder at the root of your C-drive called PGHTSetup. Copy the backup file to this location. Open up SSMS and connect to your SQL 2012 database engine instance. Open up the file included on the media named – Create and Restore PGHT Database.sql. Execute the entire script.

      The reason that you are most likely receiving the error message you are getting during the RESTORE process is that the PGHT_Tourism database is not created yet. The creation of that database is part of the sql script file that I mentioned above.

      Thanks again for your purchase and please leave a book review once you are done with the book, would enjoy hearing your feedback.

  7. sr said

    Dan,

    Thanks for your quick reply on this. Apparently, there is a database called PGHT_Tourism in my server. Here is what I am seeing in error messages. Thanks a lot for your help!

    Msg 1801, Level 16, State 3, Line 3
    Database ‘PGHT_Tourism’ already exists. Choose a different database name.
    Msg 5133, Level 16, State 1, Line 3
    Directory lookup for the file “C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\TGHT_Tourism.mdf” failed with the operating system error 2(The system cannot find the file specified.).
    Msg 3156, Level 16, State 3, Line 3
    File ‘TGHT_Tourism’ cannot be restored to ‘C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\TGHT_Tourism.mdf’. Use WITH MOVE to identify a valid location for the file.
    Msg 5133, Level 16, State 1, Line 3
    Directory lookup for the file “C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Log\TGHT_Tourism_log.ldf” failed with the operating system error 2(The system cannot find the file specified.).
    Msg 3156, Level 16, State 3, Line 3
    File ‘TGHT_Tourism_log’ cannot be restored to ‘C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Log\TGHT_Tourism_log.ldf’. Use WITH MOVE to identify a valid location for the file.
    Msg 3119, Level 16, State 1, Line 3
    Problems were identified while planning for the RESTORE statement. Previous messages provide details.
    Msg 3013, Level 16, State 1, Line 3
    RESTORE DATABASE is terminating abnormally.

    sr

    • denglishbi said

      Had someone else just report a very similar issue. Try deleting the existing PGHT_Tourism database and then either use the restore option through SSMS at the Database node and/or try running the following script substituting your drive locations for data and log files:

      RESTORE DATABASE [PGHT_Tourism] FROM DISK = N’C:\PGHTSetup\PGHT_Tourism.BAK’ WITH FILE = 1, MOVE N’TGHT_Tourism’ TO N’ C:\Program Files\Microsoft SQL Server\MSSQL11.SQL12\MSSQL\DATA\PGHT_Tourism.mdf’, MOVE N’TGHT_Tourism_log’ TO N’C:\Program Files\Microsoft SQL Server\MSSQL11.SQL12\MSSQL\Log\PGHT_Tourism_1.ldf’, NOUNLOAD, REPLACE, STATS = 10
      GO

      Not sure why you are both running into this issue. Do you by chance have SP1 installed? I believe the other reader did, shouldn’t make a difference, but never know.

  8. sr said

    Absolutely, once I get through the book.

    Cheers,
    sr

  9. Cyrille said

    I have purchased the book via Amazon (Kindle edition). Please could you tell where can I download the DVD?

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: