Skip to main content

Business Intelligence, the Microsoft style

Of course, Microsoft has been in the Business Intelligence (BI) game for some time now, but until now the solution sets lacked focus, clarity, consistency, and homogeneity. Well, in my opinion that is. But wait no longer, the company is bringing its a game to BI with clear and concise messaging and a much more focused and simplified tool set:
  • Excel – one authoring tool for your BI. And a great “Personal BI” solution.
  • SharePoint – the best solution for sharing, collaborating, and adding mobility (tablets, smartphones) to your BI. And a great “Group BI” solution.
  • SQL Server – rock solid high-performance, high-availability data platform for supporting very large data sets, and providing reporting, analysis, and integration services. And a great “Corporate BI” solution.

As far as BI solutions go, it hardly gets any simpler than that. And in full recognition that it's a big world out there (or is it a Big Data world?) there's plenty of support for non-Microsoft platforms - Oracle, SAP, Hadoop, Hive, etc.:
So, arm yourself with the awesome, easy to use tools like PowerPivot and PowerView and Explore, Visualize, and Control:


  1. SQL Server is rock solid high-performance, high-availability data platform for supporting very large data sets, and providing reporting, analysis, and integration services.
    iDeals data room due diligence

  2. Hi, the information you provided here is very informative and useful for me. If anyone interested to learn AngularJS Training reach GangBoard. MSBI Training | Hadoop Training

  3. valuable post! I really like and appreciate your work, thank you for sharing such a useful information about business intelligence management strategies, keep updating the information, hear i prefer some more information about jobs for your career hr jobs in hyderabad .

  4. You are shared valuable information with us, It's very useful for learners. Thanks for sharing info about MSBI Online Training


Post a Comment

Popular posts from this blog

Skype for Business and VTC Interoperability

Skype for Business (SfB) has a very, very strong potential, I have written about it in my previous post. I can't think of any other platform that shows as much promise in terms of bridging personal and business communications as well as unifying different modes and mediums. And all of this may have started with a strategic acquisition of Skype by Microsoft in 2011.

That said, the road ahead is not without challenges. For example, interoperability with other platforms. Making SfB work with existing Video TeleConferencing (VTC) systems, many of which represent significant capital investments in organizations' infrastructure, could be of a particular importance.

After reading statements like Skype for Business is based on Session Initiation Protocol (SIP) standards and supports H.264 (MPEG-4 video coding standard) one can come to a quick conclusion that integration and/or interoperability with other VTC solutions is easy or nearly automatic. Unfortunately, the industry is not qui…

PoSh Disable and Move AD Users

A quick and easy way to disable user accounts and move them into designated OU:

Import-Csv "C:\TEMP\users.csv" | ForEach-Object { `      $u=$_."sAMAccountName"; $l="Disabling and moving: " +$u; write-output $l; `      Get-ADUser -Identity $u | `      Disable-ADAccount -PassThru | `      Move-ADObject -TargetPath "OU=Disabled Users,OU=Organization,DC=domain,DC=local"
Input is provided via a CSV file:
users.csv (username) sAMAccountName  jdoe1  jdoe2  jdoe3  jdoe4  jdoe5  

To generate input file run something like this, review and edit as necessary:
Search-ADAccount –UsersOnly –AccountInactive –TimeSpan 180.00:00:00 | `      where {$_.enabled} | `      Get-ADUser | `      select sAMAccountName | `      Export-Csv -Path "C:\TEMP\users.csv"

WordPress displays weird characters

Sometimes after a database conversion (e.g. from MySQL to MariaDB) or due to encoding issues a situation might arise when WordPress is showing weird characters. A quick way of remedying the situation would involve examining the pages to discover a pattern (what characters are being substituted, in the example below the apostrophe was replaced by â€™) then running an queries against the database to reverse the effect. Here's a quick example (common tables that store content):

UPDATE wp_posts SET post_content = REPLACE(post_content, 'Â', '')     UPDATE wp_posts SET post_content = REPLACE(post_content, '’', "'")     UPDATE wp_postmeta SET meta_value = REPLACE(meta_value, 'Â', '')     UPDATE wp_postmeta SET meta_value = REPLACE(meta_value, '’', "'")     
Please, keep in mind that to permanently resolve the issue you would need to get to the root of the problem and may need to adjust encoding, run a databas…