PowerPivot for Excel 2013

Posted on by

In the earlier days (Excel 2010), we had to download a separate add-on to be able to use PowerPivot for Excel. Since Excel 2013, there is no longer need to achieve this separate download .

Just follow these steps:

1)  After choosing a blank workbook, go to the File menu 

 

 

 

 

2)  than just go to Options

 

 

 

 

 

 

 

3) Once the Excel Options are displayed, choose Add-ins

 

 

 

 

 

 

 

 

4) Select COM Add-inns in the combo box beneath and press the Go… button

 

 

 

 

 

 

 

5) Then checking the box next to Microsoft Office PowerPivot for Excel 2013 and press the OK button

 

 

 

 

6) As you can see,  Excel added a new ribbon for PowerPivot 

 

Share

1 day course PowerPivot for Business Professionals

Posted on by

About the Course

  •  Are you an Excel power user and working as a business analyst, financial controller, …
  •  Are you looking for a tool to create your own reports without help from IT …
  •  Do you want to combine data from different sources …
  •  Do you want to add your own calculations and analysis to existing reports

… well then PowerPivot is the tool you need!

Topics

  • Introduction to Self Service BI and PowerPivot
  • Importing Data
  • Enriching Data
  • Self-Service Analysis
  • Self-Service Reporting
  • Writing Data Analysis Expressions (DAX)
Date

Wednesday, November 9, 2011 – 09:00 – 17:00

Location
Kohera office, Veldkant 31, Kontich, Belgium

Price
385 EUR excl. VAT

Please register here.

Share

Belgian SQL Server Days 2011

Posted on by

The next SQL Server Days will be held on November 14th & 15th, 2011.
SQL Server Days is the largest SQL Server event in Belgium and Luxembourg.
Early-bird registration is now open until October 1st, 2011.

There are some great speakers, such as Kevin Kline, Chris Webb, Denny Cherry, Jennifer Stirrup,…

For full details on the speakers, the agenda and the registration, go to http://www.sqlserverdays.be/

Hope to see you there.

Share

Today is yet another milestone for the Microsoft Business Intelligence group…

Posted on by

Today is yet another milestone for the Microsoft Business Intelligence group, because I’m very proud to announce that the group now contains 35.000+ members.
Unbelievable, never thought that the group would ever have twice as much members than there are citizens in my town.

Become a member, just follow this.

Thanks for the support.

Share

SQL Server Denali – new features

Posted on by

SQL Server Denali

From today onwards, I’ll discuss the new SQL Server Denali features that are related to Business Intelligence.
First I’ll start with the “traditional tools” :
- Integration Services
- Analysis Services
- Reporting Services
- …
than I’ll move on with the more “new tools” :
- Data Quality Services
- Project Crescent
- …

Share

The Microsoft Data Warehouse Toolkit, 2nd Edition: With SQL Server 2008 R2

Posted on by

The Kimball Group, has released another great book.

This book is interesting to me, because I am a big fan of the Kimball readings and I am a big fan of Microsoft SQL Server.

I ordered the book, but didn’t receive it yet.
I can’t wait to start reading it

Share