Want to know Business Intelligence and Business Analytics on Small Data, Big Data, All Data?

Check out these series of videos..   https://www.youtube.com/watch?v=dBkzmwaSRUc A Growing World of Data – Part 1 of a 4 part series on Microsoft’s unique approach to Business Intelligence and Big Data – Published on Jun 3, 2013 – 2.53 minutes https://www.youtube.com/watch?v=UiIVUV8evtk The World of Big Data – Part 2 of a 4 part series on…


How to apply Filter in Data Explorer Formula

I ran into below particular scenario. My Sample Table:   Desired Output:   In PowerPivot DAX Formula, I could easily achieve this as this – Actual Formula: =[Market Value]/SUMX(FILTER(mySampleTable,mySampleTable[PlanName]="ABC"),mySampleTable[Market Value])   How can I achieve this in Data Explorer?  Let’s see – Step1: Open Data Explorer, select table and choose “From Table” option   Step…


Amazing Bing Map Apps

Did you know there are lots of free Bing Map Apps available? Just go to http://www.bing.com/maps click on More Apps You will some amazing apps available for free!  


Changing System Administrator Account for Master Data Services–would need this after restoring MDS database to another instance of SQL Server

When you try to restore MDS database from one server to another server in a different domain where you don’t share same system administrator account, you will need to change the internal sys admin account for MDS database after the restore is done, so that you can connect to restored DB’s MDS UI.  This article…


Objects Overview in MDM database created by Master Data Services in SQL Server 2012 RC0

There are so many objects in MDM database that gets created when you create a model in Master Data Services.  Below outlines the significance of each object: Schema Name Type Of Object Object Name Sample Purpose/Comments Created or Used or Referenced in/by User defined process? Mdm Tables Mdm.tbl_N_N_XX These are internal system tables and should…


Registering multiple servers in Central Management Server (CMS) using PowerShell Script

  Below are the steps using PowerShell script (learned from another Kalyan Yella, Microsoft): Step 1: Open notepad and copy and paste below PowerShell script and save the file as “RegisterServers.ps1”  at c:\scripts\   — you can save anywhere you want – just make a note of it as you will use this in next step…


Importing Data from MS Access 2010 64-bit .accdb database into SQL Server using SSIS

  Problem: You can’t connect using Native OLEDB \Microsoft Jet 4.0 OLEDB Provider.  It fails with following error message: Test connection failed because of an error in initializing provider. Unrecognized database format ‘C:\Users\vishah\Documents\myDB.accdb’. Solution: Download 2007 Office System Driver: Data Connectivity Components from here – http://www.microsoft.com/downloads/en/details.aspx?familyid=7554f536-8c28-4598-9b72-ef94e038c891&displaylang=en then choose Microsoft Office 12.0 Access Database Engine OLE…