Advertisements

Archive

Posts Tagged ‘Business Intelligence’

Power Pivot and Power View now available in Excel 2013.

August 1, 2012 1 comment

In Excel 2013, much of that functionality, including the infrastructure that supports it, is built directly into the Data Model in Excel. Without installing a separate add-in, PowerPivot and Power View add-ins are installed by default. But they are not automatically enabled.  You have to do some menu/dialog box acrobatics to turn them on, but it’s a one-time set-and-forget requirement.

If you’d like to try it yourself, click through File|Options|Add-Ins|Manage COM Add-Ins|Go… and then enable the add-ins by checking them off and clicking OK.

Read more…

Advertisements

Introduction and Installation of Data Quality Services for Denali

May 24, 2012 2 comments

Data Quality Services (DQS)  enables you to discover, build, and manage knowledge about your data. You can then use that knowledge to perform data cleansing, matching, and profiling

DQS is not installed automatically with Microsoft SQL Server Denali CTP3.  You must perform additional following steps to complete your Data Quality Server installation, configure it, and then use it. Read more…

VertiPaq Engine Renamed as xVelocity in SQL Server 2012(Denali).

VertiPaq engine is currently only available to PowerPivot for Excel in SQL Server 2008 R2. After the amazing success of PowerPivot for Excel in the previous release of SQL Server 2008 R2 this engine moved to the server side with the same InMemory BI and compression and it’s called the VertiPaq Engine or the Analysis Services Tabular Mode. Data retrieval and calculations happen at a much faster rate as its entire database is in-memory.Vertipaq enables Excel to process hundreds of millions of rows with sub-second response times on desktop hardware. Read more…

%d bloggers like this: