Business Intelligence Blogs

View blogs by industry experts on topics such as SSAS, SSIS, SSRS, Power BI, Performance Tuning, Azure, Big Data and much more! You can also sign up to post your own business intelligence blog.

EasyDNNNewsCalendar
«October 2017»
MonTueWedThuFriSatSun
2526272829301
2345678
9101112131415
16171819202122
23242526272829
303112345

03 May
2017
Author: Anil
Anil

WELCOME TO NEPAL POWER BI USER GROUP

26 September
2016
Author: Anil
Anil
26 September
2016
Author: Anil
Anil
http://netdna.webdesignerdepot.com/uploads/2012/02/0002_amp.png 11 August 2016 00:00

Speaking at SQL Server Geeks Annual Summit 2016, Asia’s Only Data & Analytics Conference.

Export event8/11/2016 - 8/14/2016
23 March
2016
Author: Anil
Anil

Speaking at SQLSaturday Nepal SQLSaturday #482 .

Firstly I am happy and excited that I will be speaking at SQLSaturday#482 on March 26 2016. This is my second time for this International SQLSaturday event and I’m really excited that I will be speaking this time. I will be speaking on ‘Using power query to tell your story...
06 May
2014
Author: Anil
Anil

Using Power Query to tell your story form your Facebook Data.

Using Power Query to tell your story form your Facebook Data.

Most of the time of this weekend, I spent my time to extract the story behind my Facebook data by using Power Quer

16 April
2014
Author: Anil
Anil

How to transpose rows to columns in oracle.

In some case we need to transpose the table data that means we need to change the rows value into columns, and then this blog post will be surely helpful.

Let’s say we have to find ou

23 January
2014
Author: Anil
Anil

How to Schedule and Automate backups of all the SSAS catalogs within the Server Instance.

This is a research project that I had done; the main goal of this project is to schedule the backup of all the SSAS catalogs and SQL database from the server to the specific location automatically. With the course of time, you might need to backup all the SSAS databases within a server instance...
07 November
2013
Author: Anil
Anil

Questions on Power Maps for Excel 2013.

Hello to all,

Been quite long time, I really miss the blogging world. This blog is mainly about the question that I asked on the webinar.

Just recent, I have attended the Pragmatic

20 August
2013
Author: Anil
Anil

dynamic-partition

  Rownum	Quries	Location
1 select * from FactInternetSales
WHERE $PARTITION.PART_FUNC(OrderDateKey) = '1'
; E:\Anil Research\AdventureWorks
2 select * from Fac