Category Archives: Suggestion

“Quick Insights” feature in Power BI

Khilitchandra's Business Intelligence Blog Posted on by

What is it? How does it work? How it can be helpful? Power BI quickly searches different subsets of your dataset while applying a set of sophisticated algorithms to discover potentially-interesting insights. Power BI scans as much of a dataset as possible in an allotted amount of time. You can run Quick Insights against a dataset or tile (Related Insights). You can readily use any of suggested visualizations (i.e. quick insights) and build Report or Dashboard in minutes 🙂 So, in short – You can build your Report or Dashboard quickly by browsing through Dataset’s data insights. Then choose whatever … 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 →

SSRS Chart – Displaying % sign on Y axis + Displaying % sign on Data Labels

Khilitchandra's Business Intelligence Blog Posted on by

Hi guys, Today i would like to show you the little trick for your SSRS graphs. Issue: I am displaying values (percentage values) in my bar charts as “Data Labels”. But the “Y” axis of my bar char still displays value without the “%” sign. What I need: The bar chart should display the “%” value in Data Labels as well as on my Y axis. Simple try: When you format the Data Label to apply “%” sign by making it of type “Percentage” in “Series Label Properties” -> “Number” -> “Percentage”. It actually multiply the value by 100 and … Continue reading →

SSRS Report is asking for Username and Password while executing

Khilitchandra's Business Intelligence Blog Posted on by

Hi all, I want to bring to your focus a very minor detail which could eat-up your time when it happens. This is the case when your SSRS report is deployed on ReportServer and you are accessing thru any application or interface e.g. SharePoint. Your SSRS report is using Integrated Security and hence no need to provide Username and Password if you have access to the Report. And everything works fine up to this point. After some days, if you notice that your SSRS Report is not working as expected and it has started asking for Username and Password while … Continue reading →

Best Practices : Writing Stored Procedures

Khilitchandra's Business Intelligence Blog Posted on by

Hi All, I would like to share a handy list which I found today from my old collection during files clean-up. These are few quick tips that every developer should bear in mind while writing T-SQL codes particularly Stored Procedures. It’s always hard to find the best version of such list but we can definitely make a better version, so you are welcome to make this as a better-list by adding/editing below tips.

Continue reading →

Passing Multiple Parameter Values from Parent Package to Child Package

Khilitchandra's Business Intelligence Blog Posted on by

Hi All, I would like to bring to your attention a potential improvement in SSIS. When we need to pass parameter value from parent package to child package, we mostly use “Parent package variable” configuration type in child package. But when we need to read multiple values from parent package, we need to create multiple “Parent package variable” configuration type in child package. There are few work-arounds in order to pass multiple parameter values from parent package to child package without creating multiple “Parent package variable” configurations in child package. But we do need a good method of implementing this … Continue reading →

Demo Site is ready with full featured “SQL Server 2012 RC0” to play with

Khilitchandra's Business Intelligence Blog Posted on by

Note: This site requires Windows 7, Windows Vista with SP1/SP2 or Windows XP wth SP3 to have the correct RDP client to use this site. Go to this site http://fs.mssalesdemos.com/, Login with your live ID. Select the “Catalog” tab. Select “New SQL Server 2012-RC0 fully integrated Demo“. The new SQL Server 2012-RC0 demo is fully integrated with SQL Server 2012, SharePoint 2010 and Office 2010 including: • PowerPivot and MDS Excel integration • Reporting Services integration with SharePoint • Power View integrated with SharePoint • Data Quality Services

Continue reading →

When my SQL table was updated???

Khilitchandra's Business Intelligence Blog Posted on by

Here is very tiny SQL query which will help you find out when the tables are modified in the SQL server database. First you try the * (get all the columns) and then choose the selected ones. — List all the tables updated in SQL Server (in desc order) Use your Database Name Select * from sys.tables order by Modify_date desc Like wise, you can also check few more readymade tables which store some helpful information for you.

Continue reading →

Select records from one table which are not available in another table

Khilitchandra's Business Intelligence Blog Posted on by

Hi guys. I have seen people having hard time when they try to achieve similar functionality which is provided by “Except” keyword in T-SQL. I am talking about the case when people need to select those records from one table which are not available in another table. Well, if both these tables are in one database, you can definately use SQL query and make use of Except keywork. But if tables are in different database then… And then people start experimenting with Merge Join Task and later start googling it. One of the mandatory condition while using the Merge Join … Continue reading →