Blog - comments

Hi Olivier,DELAYED_DURABILITY doesn't change the SQL Server behavior of opening the data and log fil...
Hi David,Thanks for this demo with write functions. As much I know, SQL Server always access files (...
Olivier Berthommé
Thank you for your feedback. I will build a test environment and realize a guide to deploy Grid Infr...

Hi Greg,

Thanks

great job Dave ! thanks

greg
Blog Stephane Haby Office 2013 and SQL Server 2012: an integrated, powerful BI solution

dbi services Blog

Welcome to the dbi services Blog! This IT blog focuses on database, middleware, and OS technologies such as Oracle, Microsoft SQL Server & SharePoint, EMC Documentum, MySQL, PostgreSQL, Sybase, Unix/Linux, etc. The dbi services blog represents the view of our consultants, not necessarily that of dbi services. Feel free to comment on our blog postings.

  • Home
    Home This is where you can find all the blog posts throughout the site.
  • Categories
    Categories Displays a list of categories from this blog.
  • Tags
    Tags Displays a list of tags that have been used in the blog.
  • Bloggers
    Bloggers Search for your favorite blogger from this site.
Posted by on in Technology Survey

Office 2013 and SQL Server 2012: an integrated, powerful BI solution

I have recently read that PowerPivot and Power View are natively present in Office 2013 and especially in Excel 2013. I found this fun and decided to install the preview of Office 2013!Laughing

First, what are PowerPivot and Power View?

PowerPivot is an add-on to Excel which is used for adding and integrating large amounts of data in Excel workbooks.

More information here.

Power View is a feature of SQL Server 2012 Reporting Services Add-in for an interactive data exploration, visualization, and presentation experience.

More information here.

Office 2013, a native Business Intelligence tool

Don't download additional add-ons anymore, with Office 2013 these 2 Business Intelligence add-ons are directly present in the Office edition.

For the license, no problem, it’s included in the Office price!

To see all new features in Office 2013, go to this web site.

Excel 2013 configuration

The first thing we can see are the new Office icons with Outlook in blue (before, it was yellow).

Now, run the Excel 2013 Preview.

Select a blank workbook, then go to the FILE tab.

Click on Options.

In Add-Ins, you can see the 2 cCom Add-Ins (PowerPivot and Power View). This is just to verify that they are installed.

HOHOHO! I was talking about Add-on in my introduction and now about Add-in...

Do you see the difference? Surprised

No! Ok, I explain it to you:

  • Before Office 2013 --> Separated installation  --> Add-On term is used
  • Since Office 2013   --> Included in Office setup --> Add-In term is used

Power View Reports in Excel 2013

Go to INSERT tab and you can see two sections:

  • PowerPivot with PivotTable and Recommended PivotTables
  • Power View with Power View Reports

Click on Power View Reports.

Enable the add-in.

Continue and wait...

And Oops, a warning is displayed!

Indeed, Silverlight is a requirement for PowerView, so you have to install it.

Now, we can unleash our creativity for our reports.

Conclusion

I'm very impressed with the easy integration of SQL BI in Office. I hope that this short article gives you the desire to try it as well, go further and create great reports.

Your boss will be impressed if you use these news features from Microsoft Office...Cool


Rate this blog entry:
1

Stéphane Haby is Delivery Manager and Senior Consultant at dbi Services. He has more than ten years of experience in Microsoft solutions. He is specialized in SQL Server technologies such as installation, migration, best practices, and performance analysis etc. He is also an expert in Microsoft Business Intelligence solutions such as SharePoint, SQL Server and Office. Futhermore, he has many years of .NET development experience in the banking sector and other industries. In France, he was one of the first people to have worked with Microsoft Team System. He has written several technical articles on this subject. Stéphane Haby is Microsoft Certified Solutions Associate MCSA) for SQL Server 2012 as well as Microsoft Certified Technology Specialist (MCTS) and Microsoft Certified IT Professional (MCITP) for SQL Server 2008. He is also ITIL Foundation V3 certified. He holds a Engineer diploma in industrial computing and automation from France. His branch-related experience covers Chemicals & Pharmaceuticals, Banking / Financial Services, and many other industries.


MCSA  MCSE  mvp

Comments

  • No comments made yet. Be the first to submit a comment

Leave your comment

Guest Thursday, 02 October 2014
AddThis Social Bookmark Button
Deutsch (DE-CH-AT)   French (Fr)

Contact

Contact us now!

Send us your request!

Our workshops

dbi FlexService SLA - ISO 20000 certified.

dbi FlexService SLA ISO 20000

Expert insight from insiders!

Fixed Price Services

dbi FlexService SLA - ISO 20000 certified.

dbi FlexService SLA ISO 20000

A safe investment: our IT services at fixed prices!

Your flexible SLA

dbi FlexService SLA - ISO 20000 certified.

dbi FlexService SLA ISO 20000

ISO 20000 certified & freely customizable!

dbi services Newsletter