Archive
Power Pivot and Power View now available in Excel 2013.
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.
SQL Azure Reporting.
Get a comma separated list in SQL & MDX.
Change the Look & Feel of the Report Manager.
Why we need to change the Look & Feel of the Report Manager?
Ans- If we have different environments to deploy the reports like QA, DEV, PROD. that time User/Developer can get the more idea once open the Report Manager. Read more…
SQL+MDX in one Apartment (Hybrid Query).
BIDS No More Exist in SQL Server 2012.
Once you will installed SQL Server 2012 you could not find the BIDS to develop SSAS/SSIS/SSRS application. BIDS will replace with SSDT i.e. SQL Server Data Tools.
Comparison of SQL Server 2012 Vs SQL Server 2008 R2. 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…
BI Big Data Authors
Sandip Shinde
Manish Kaushik
Suhas Kudekar(MCC)
Umesh M Patil
YashwantOur Visitors
Big Data, Data Analytics and Data Science | BI-BIGDATA.com 