Now Available: Visualizing Data with Microsoft Power View
Posted by denglishbi on June 5, 2012
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?”
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:
Devin Knight said
Congrats Dan! Look forward to picking up a copy of it.
Jason Thomas said
Congrats Dan! 🙂
Frank Kearney said
congrats on the book! Picking up a copy today!
Jurgen said
Dan,
Any idea on the timeframe when the iBooks enhanced version will be available?
Congrats!
denglishbi said
I am looking into this with our publisher. I will let you know as soon as I have an update.
amit said
Dear sir, can i use OLAPs with Powerview and how?
denglishbi said
Currently Power View will only work with Tabular BISM which is either PowerPivot in SharePoint or Tabular SSAS. The SSAS team knows this is a concern to existing companies with Multidimensional SSAS and they are dedicated to providing a solution provide where DAX queries will work against these models. They listed this here if you look at the second to last paragraph – http://blogs.msdn.com/b/analysisservices/archive/2011/05/16/analysis-services-vision-amp-roadmap-update.aspx. So this is coming, but an exact time has not been set, but it will most likely be an update to existing SQL 2012 version.
denglishbi said
Just wanted to let you know that a CTP release of SQL 2012 has been made available that will now allow you to use Power View against a multidimensional SSAS database. You would need to upgrade your database to SQL 2012 first. More details here – http://blogs.msdn.com/b/analysisservices/archive/2012/11/29/power-view-for-multidimensional-models-preview.aspx
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.
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.
sr said
Thanks, it works now.
And on SP1, no I haven’t installed it.
Thanks,
sr
denglishbi said
Great to hear and thanks for the information.
If you could leave a review on Amazon about the book we would greatly appreciate your feedback, thanks again for buying our book!
http://www.amazon.com/Visualizing-Data-Microsoft-Power-View/product-reviews/0071780823/ref=cm_cr_dp_see_all_summary/187-5222271-2298660?ie=UTF8&showViewpoints=1
sr said
Absolutely, once I get through the book.
Cheers,
sr
Cyrille said
I have purchased the book via Amazon (Kindle edition). Please could you tell where can I download the DVD?
denglishbi said
You can download the content from the McGraw Hill media download center here – http://mhprofessional.com/mediacenter/ and you simply have to enter in the eBook ISBN number of 0071780831. An email when then be sent to you with a direct link to the zip file that you can download which is like 3.41GB.
Cyrille said
Thank you!