Category Archives: Data Mining

Power BI Certification: 70-778 – Analyzing and Visualizing Data with Microsoft Power BI (beta)

Khilitchandra's Business Intelligence Blog Posted on by

Hi Guys, I have been waiting for an official certification from Microsoft on Power BI. And finally I saw the exam opened up. 🙂 Even though it is still marked in Beta but you can go-ahead and schedule if you want. Or you can start gearing up with necessary technical knowledge to complete the certification. Please check-out below link which has everything that you need to know and get prepared for it. Find out more @ https://www.microsoft.com/en-us/learning/exam-70-778.aspx Thanks, Khilit

Continue reading →

MERGE your knowledge from EXPERTS – “Project BOTTICELLI”

Khilitchandra's Business Intelligence Blog Posted on by

Hi guys, I am just about to write an introduction of “Project Botticelli” for you; but they gave their introduction in very nice and precise manner so I decided to extract that and put it here for your quick reference. (Excerpt from https://projectbotticelli.com/about-project-botticelli-ltd) “Project Botticelli Ltd is a small company offering online training by business intelligence experts and consulting services focused on advanced analytics, with a focus on data mining, predictive and statistical analysis.” I have seen couple of their videos and I am impressed with explanation & demonstrations. Please check out their contents on their website (https://projectbotticelli.com/). Currently there … Continue reading →

MDX and DAX Query Formatter …. is back :)

Khilitchandra's Business Intelligence Blog Posted on by

Hi Friends, Just to share with you quickly that “MDX and DAX Query Formatter” site is back online. Here is the link: http://formatmdx.azurewebsites.net/ Thanks, Khilit

Continue reading →

What is OLAP Database ? What is FASMI?

Khilitchandra's Business Intelligence Blog Posted on by

Hi guys, i was reading an article and came across this term “FASMI“. i have done a little bit of RnD to find out its head & tail. This is what it means: FASMI is an acronym of “Fast Analysis of Shared Multidimensional Information“. A database when called “OLAP Database” if it satisfies following FASMI rules. 1. Fast Analysis (FA): Data retrieval should be less than 5 seconds. Should support any business scenarios for any type of analysis. The structure should support such flexibility that new calculations can be easily and quickly defined.

Continue reading →

Data Mining for Social Moderation – Event @ Microsoft, Singapore on 6th Feb 2012

Khilitchandra's Business Intelligence Blog Posted on by

The BBC (the British Broadcasting Company), a known media force in Europe, implemented an in-database data mining solution for their public-facing website. The BBC encourages users to post comments and become part of their social media community. In this project, the BBC needed a way to improve the social moderation of millions of posts on thousands of forums. This presentation covers how SQL Server helped designing a model to dramatically help improving the quality and efficiency of the moderation. We also discuss cost efficiencies obtained in this project. More and more organizations will need to use enterprise solutions to handle … Continue reading →