a blog by Rajesh

Regression analysis Regression Analysis a statistical tool for the investigation of relationships between variables. Usually, the investigator seeks to ascertain the causal effect of one variable upon another , the effect of a price increase upon demand, for example, or the effect of changes in the money supply upon the inflation rate. Regression Analysis with Excel In this example, Sales Qty is the predictable variable and Price and Advertising are the unpredictable variables. Using Regression Analysis we will find out the relationship between the variables. The big question is: is there a relation between Sales Qty (Output) and Price and Advertising (Input). In other words: can we predict Quantity Sold if we know Price and Advertising? Click on Data Analysis from the Data Menu from the ribbon as follows : Click on Regression as follows : Select the settings as shown below.  The Input Y Range is the predicable variable and the Input X is the unpredictable v

SDLC with ALM  Development is certainly the fundamental part of application lifecycle management. Once the business case is approved, the software development lifecycle begins. If we expanded the SDLC parts of the Development line shown in the figure below, a modern process would probably show software development as a series of iterations. Each iteration would contain some requirements definition, some design, some development, and some testing. This iterative style of development isn’t always appropriate—some projects are still better done using more traditional methods—but it’s becoming the norm in many areas. Once the SDLC process for version 1 of the application is complete, the application is deployed. For most applications, however, deployment doesn’t mark the end of development. Instead, the application needs periodic updates, as shown in the figure, and perhaps one or more full SDLC efforts to create new versions, as in this example. For some applications, the mon

Sharepoint Server 2013 Architecture Factors Logical architecture Sites Service Applications Search Word/PowerPoint Automation Services Translation services Physical architecture Databases Sharepoint Farm Office Web Apps Server Farm Workflow App Management Office Web Apps Server Social Architecture Distributed cache News feeds High availability and disaster recovery  Monitoring and Manageability Arcitectural improvements for WAN environments and offline scenarios OneDrive for Business for Sharepoint libraries Minimal Download Bandwidth engineering improvements Efficient File I/O

Designing Solution Integration with SharePoint : Mobile integration : 1. Infragistics Shareplus : Mobile UI ( http://www.infragistics.com/shareplus ) CRM & Best User friendly UI 2. Sales force - for better efficient UIs and workflows ( http://www.salesforce.com/ap/ ) Best looking public facing sites : 3. Sitecore : to create public facing websites more easily. ( http://www.sitecore.net/ ) Workflows : 4. K2 : powerful workflows ( http://www.k2.com/platform/workflow-software ) 5. Ninetex : user friendly workflows (  http://www.nintex.com/ ) 6. Bamboo : another well known workflow tool ( https://store.bamboosolutions.com/c-16-workflow.aspx ) Project management Tool : 7. Jira : Issue and Agile project tracking tool ( https://www.atlassian.com/software/jira ) BI & Dashboards : 8. Power BI : Powerful BI customization ( https://powerbi.microsoft.com/ ) 9. ArcPlan : Best BI dashboards  ( http://www.arcplan.com/en/solutions/sharepoint-int

Content Hub Publishing : Sharepoint content hub publishing can be tedious some times with some of the following issues : 1. Content type publishing fails with the pre-import check on the existing sitecolumns 2. Cleaning up of the published content types 3. Rolling back to the previous stage Content Hub cleanup solution : Recently , I surfaced the above issues in implementing few content types in a content hub. It took  hours of tiresome troubleshooting on the content hub, ULS and content type error log. Finally, the issues have been resolved with loads of powershell scripts. I have posted the scripts in codeplex in thought of helping someone having the similar issues.  The scripts are free to download and availale at the following link : https://rajesh.codeplex.com/releases/view/616417 Hope it helps someone out there. Happy Sharepointing!

8 Principles of Document Writing :   1.Cohesive            The statements have to be well-integrated and unified.   2.Complete     The document has to be complete.   3.Consistent     The statements should have consistent presence through out.   4.Correct     The information must be correct.   5.Feasible     The document should be readable by the Users.   6.Modifiable     Contents are grouped so the changes doesn't need to modify.   7.Testable     A document must be reviewable   8.Unambiguous     Statements should be not give more than one interpretation.

Information Architecture Information architecture determines how the information in that site or solution—its webpages, documents, lists, and data—is organized and presented to the site’s users. Information architecture is often recorded as a hierarchical list of content, search keywords, data types, and other concepts. Ways to improve the organization's information architecture efficiencies Use metadata to make it easier to search for and compare related data or content. Manage versions and records to ensure that you can tell which is the authoritative version of a document. Catalog and store information properly so decision-makers can find and rely on the right data. Design navigation and present information so that users can find important sites and information. Integrate your information architecture with your environment's search strategy, so your users can find the right information. Information architecture includes the wireframe and site map, search an

Windows 10 Insider Preview ISO Windows 10 will be officially launched by 29 Jul. Here is the insider preview ISO , if you want to evaluate the software. http://windows.microsoft.com/en-us/windows/preview-iso

For troubleshooting managed property for search refiners : Type the <Managedpropertyname>=<the value> in the search box. If the search results return the searchresults filtered by the managed property, the managed property is available for search refiners. Managed properties also can be queried with the < (lesser than) , > (greater than) symbols. Happy Sharepointing!

http://www.collabshow.com/ http://www.sharepointpals.com/ http://sharepointr.blogspot.sg/ http://sharepointpromag.com/ http://sympmarc.com/ http://www.ashokraja.me/tools/ http://absolute-sharepoint.com/ http://blog.pathtosharepoint.com/ http://sharepoint-blog.com/ http://sharepoint-community.net/profiles/blog/list http://sharepoint-community.net/page/top-blogs https://www.collaboris.com/blogs/how-to-sharepoint http://www.harbar.net/ http://zimmergren.net/ http://sharepoint.asia/ http://www.keremozen.com/ http://davecoleman146.com/ http://o365.technology/ http://veroniquepalmer.com/ http://www.jeremythake.com/ http://www.sharepointnutsandbolts.com/ http://www.sharenotes.pro/ http://wendy-neal.com/ http://www.jeremythake.com/ http://www.cleverworkarounds.com/ http://www.pointbeyond.com/ http://veroniquepalmer.com/ http://blog.pentalogic.net/ http://joelblogs.co.uk/ http://thuansoldier.net/ http://www.toddklindt.com/blog/default.aspx http://spsite.pro/

Microsoft confirmed that SharePoint Server 2016 will become generally available in Q2 2016, with a public beta planned for Q4 2015. What to expect in 2016? On-premises support will be around for the foreseeable  future. Continued support on combination of on-premises, cloud and hybrid deployments for many years to come. Microsoft is moving more to a cloud-based identification model with SAML and OAuth Nondefault ports can be used for connection encryption, rather than just using Port 25 Site creation is no longer a "heavy operation" but now will be "small and fast" Project Server will be integrated into SharePoint content databases (although you don't get it for free) Microsoft will make "durable links" for finding files so that it won't matter if the file name gets changed or if the file gets moved Microsoft is adding an ODF file saving capability Improved user experiences Cloud-inspired infrastructure Compliance and reporting

Recently there was a request from a user to display the list of sites where the user has access rights. It took a while to figure out how to get it work. Here is how it was done : Add Search core results webpart. To display the all the sites that the current user has access : In the results query option -> Fixed Keyword Query  add the following : contentclass:STS_Site To filter few sites from the the sites that user can access : contentclass:STS_Site NOT (path:http://yoursite1/* AND path:http://yoursite2/*) To display specific sites if the user has access : contentclass:STS_Site AND (path:http://yoursite1/* OR path:http://yoursite2/*) Knowledge is for sharing.. Keep sharing.. and keep growing