Showing posts from August, 2015

Tabbed View Report using SSRS

Today, I published my first Tech Net article about creating Tabbed View Report using SSRS. SQL Server Reporting Services is a powerful BI tool by Microsoft.
Soon, I will publish articles about SSRS and its integration with SharePoint. Read my article from the following link and share your valuable comments: Tabbed View Report using SSRS Scenario Explained in the article: Suppose take an example employee database which stores their professional summary, salary information, personal information, etc. The end user will search for an Employee by Emp ID as the parameter only one time and the result will be displayed in a tabbed view like professional summary in one tab, salary in another tab and personal information in another tab. Each tab should be clickable and when a Tab1 is clicked, other Tab result should be hidden. In the similar way, show and hide data should work for all the other tabs. Don't forgot to share this post if this helps you!

Update 22-Sep-2015
I am happy to share wit…

Deprecated Features in SharePoint 2016 Preview

SharePoint Foundation 1. SharePoint Foundation 2013 remains available for use 2. Previous releases of SharePoint Server included SharePoint Foundation, a free edition of SharePoint that included most of the core functionality and architecture provided by the commercial editions of SharePoint. SharePoint Foundation is no longer available in the SharePoint Server 2016 release. Standalone Install mode SharePoint Server 2016 IT Preview doesn't support the standalone install option, so it is no longer available in the setup program. Use the MinRole during installation and choose one of the available install options. The Single Server Farm option where everything is installed on the same computer is supported for dev/test/demo purposes. When you use this option, you must install SQL Server yourself and then run the SharePoint Server 2016 farm configuration wizard.. For more information, see "MinRole farm topology" in New and improved features in SharePoint Server 2016 IT Previe…

SharePoint 2016 Preview Arrived

I am excited to share the news with my blog readers that SharePoint 2016 Preview is arrived and it is available for download in the below link:

SharePoint 2016 Forum Discussions:
Customer Feedback Link:

Soon will explore on SharePoint 2016 and post you all about the new features and updates :)

Power BI in SharePoint Online

I am very excited after Microsoft released Power BI GA (general availability) at the end of July. It comes with list of impressive new features which is explained in detail in this MSDN article.
I want my blog readers to know what is Power BI and how it can be used with SharePoint Online to leverage the BI capabilities of SharePoint. Let's learn the basics in this article:

Microsoft came with a new tool for BI for the following reasons:
Use the known tool  - ExcelDiscover More  - Power QueryAnalyze More – Power PivotVisualize  - Power View / Power MapCombine with Office 365 – share with any onePower BI sites – collaborate and share the data sets with your teamDive into Q & A – ask a question and get answers visuallyStay Connected – Mobile AppsSchedule data refresh and create security settings easilySo what is Power BI?
Cloud based service works with excel to provide users a complete self-service BI solution Available in SharePoint & Excel 2013 Online (available only in E3 / …

Power Query and Power Map in Excel 2013

As you all know, Microsoft is improving the BI capabilities with a lot of new features with exciting releases in the year 2015. Microsoft has introduced new add-ins called Power Query and Power Map for Excel 2013.
Believe me guys, this is really awesome add-ins which taken the Microsoft's BI capabilities one step ahead of all other BI competitors!
Let's try to create a power map by searching a public data using power query in Excel 2013 in this article.
Before trying a sample, let's understand what is power query and power map for excel 2013 and it's download links:
Power Query:
MicrosoftPowerQueryforExcel (a data analysis tool) is an Excel add-in that enhances the self-service Business Intelligence experience in Excel by simplifying data discovery, combine, refine, access and collaborate.Power Query supports importing data from a wide range of Web sources, including scrapping tables from HTML pages, as well as importing data from Web APIs. Power Query supports XML, JSO…