Excel 2013 PowerPivot workbook with PowerPivot for SharePoint 2010 ?

Last week, One of my customer had interesting issue with PowerPivot Workbooks. Here is scenario: My customer has created a PowerPivot Model by using Excel 2013. As you may know, PowerPivot is now shipped with Excel 2013 and it is another addin shipped with Excel. Please note that imagesbelow are illustrative images. So Customer created…

2

How can I learn Business Intelligence? Part-1

Technorati Tags: Data Warehouse,Learn Business Intelligence,Enterprise Data Warehouse,Dimensional Modeling,SQL,OLTP,OLAP How can I learn Business Intelligence? I have been asked this question by my colleagues & customers several times. Actually It is great to see that people in market now realized that Business Intelligence doesn’t mean SQL Server or Database. In other words, You shouldn’t expect…

0

Identifying Cell by Cell Computation Mode in MDX queries

Some weeks ago I was asked to help with a performance issue with some MDX Queries. I was shown what the customer wanted to achieve, they needed to calculate some metrics including sampling errors using the method of “Conglomerados Últimos” (This can be translated to “Conglomerates Last” Method), this method was created by a Spanish…

0

How to use SSIS to migrate data to Azure database from on-premise database

Today I read an article from msdn, it described Azure database support ODBC, so I did a test to migrate data from on-premise to Azure database. General Guidelines and Limitations (Windows Azure SQL Database) http://msdn.microsoft.com/en-us/library/windowsazure/ee336245.aspx#dlaps Let’s start to see how to use SSIS to migrate data from on-premise database to Azure. Create a DSN via…

0

See you in SQL Saturday in Istanbul on 5th October..

  As Microsoft Premier Field Engineering team, we enjoy contributing events such as SQLPASS, SQLBits and SQL Saturdays. I am pleased to announce that I will be delivering a session about Using “SQL Server Integration Services with Hadoop Cluster”. SQL Saturday #258 will be held in Istanbul, Turkey on 5th October. You can find session…

0

Power View 101 – Fast Reporting on the Edge

This will be a series of posts around Power View and building reports. This is Part 1. We are going to explore Power View requirements for SharePoint and Excel 2013.  We will also demonstrate how to do a basic data model import using SQL Azure Data. In Part 2(which will be published in 2-3 weeks), we…


Analysis Services Tabular Mode Performance Tuning Guide is available!

We recently published performance guidelines for Analysis Service Tabular Model. You can access this white paper from our msdn site: http://msdn.microsoft.com/en-us/library/dn393915.aspx   Feel free to post your questions!   Thanks   Kagan Technorati Tags: SSAS,Tabular,Model,Mode,SSAS 2012,Performance Tuning,Optimisation,Guideline

0

OOPS, I got an error. Ensuring The Correct Bitness Provider is Installed

The field of Business Intelligence involves consolidating and aggregating data from a number of different and often highly disparate data sources. The cool part is that working in the field of BI means that we get to play with a bunch of really neet toys like SSRS, SSIS, and SSAS. Since those neet toys all use data sources and can…

0

Can I use SSDB without installing SSIS?

Recently my customer asked question around SSDB. As you may know, When you install SQL Server Engine only, when you go to management studio, you see, Integration Services Catalogs option.     If you try to create one without installing SSIS, you will get following error message about SSISDBBackup.bak   The catalog backup file ‘C:\Program…

0

An Error when attempting to Preview a Report using SQL Server Data Tools in a Remote Session

A customer with whom I work recently encountered an error message when attempting to preview a report using SQL Server Data Tools (SSDT) in a remote session via Citrix. The error message that was being returned was:   An error prevented the view from loading. (Microsoft Visual Studio) =================================== An error occurred while attempting to start…