Create dynamic business intelligence (BI) solutions for SharePoint faster and with more capabilities than previously possible. With this book, you’ll learn the entire process—from high-level concepts to development and deployment—for building data-rich BI applications with Visual Studio LightSwitch, SQL Server 2012, and a host of related Microsoft technologies. You’ll learn practical techniques and patterns necessary to use all of these technologies together as you build an example application through the course of the book, step by step. Discover how to solve real problems, using BI solutions that will evolve to meet future needs. Learn the fundamentals of SharePoint, LightSwitch, and SQL Server 2012 Get a solid grounding in BI application basics and database design principles Use LightSwitch to build a help desk app, including data model design and SharePoint data integration Build a tabular cube with Microsoft’s Business Intelligence Semantic Model (BISM) Dive into the data visualization stack, including Excel and SQL Server Reporting Services Create reports with Excel Services, Report Builder, and PowerView Use tips and tricks for setting up your BI application development environment

Learn how to install, configure, and maintain the latest release of Microsoft’s popular SharePoint Server, SharePoint 2016. This latest version brings with it many changes for IT professionals. With this book you will learn how to create an efficient and stable SharePoint environment for your organization. What You’ll Learn Install SharePoint Server 2016, both using the user interface provided by Microsoft, and by using PowerShell Understand your authentication options and associated security considerations Deploy add-ins, either from the store, or from your own custom app catalog Configure Search Service Application using either the provided UI or PowerShell Configure business intelligence components such as Excel Services, SQL Server Reporting Services, and PowerPivot Migrate to SharePoint Server 2016 from either SharePoint Server 2010 or 2013 Understand approaches to high availability, disaster recovery, patching, and ways to monitor and maintain your SharePoint 2016 deployment once it’s up and running Who This Book Is For Anyone tasked with installing, configuring, and maintaining SharePoint Server 2016 in their organization. This book assumes some working knowledge of a previous release of SharePoint Server, such as SharePoint 2010 or SharePoint 2013

Presents a comprehensive tutorial on the core SQL Server concepts needed to understand the Sharepoint business intelligence investments offered in the text, which include Visio services, Excel services, business connectivity services, and Power View and PerformancePoint services.

The next wave of business intelligence, Self-Service BI, seeks to meet the demands of powerful hardware and shorter decision time frames. This book introduces PowerPivot for Excel and SharePoint, showing you how to use this innovative software for self-service analytics and reporting. Authored by key members of the Microsoft team that built the product, this book will guide you through the use of in-memory BI server technology, data analytics eXpressions, and report gallery. The book also discusses how to deploy and manage sandbox servers, and a companion website provides sample reports and applications.

Business intelligence (BI) software allows you to view different components of a business using a single visual platform, which makes comprehending mountains of data easier. BI is everywhere. Applications that include reports, analytics, statistics, and historical and predictive modeling are all examples of business intelligence. Currently, we are in the second generation of business intelligence software—called BI 2.0—which is focused on writing business intelligence software that is predictive, adaptive, simple, and interactive. As computers and software have evolved, more data can be presented to end users with increasingly visually rich techniques. Rich Internet application (RIA) technologies such as Microsoft Silverlight can be used to transform traditional user-interfaces filled with boring data into fully interactive analytical applications that quickly deliver insight from large data sets. Furthermore, RIAs now include 3D spatial-design capabilities that move beyond a simple list or grid and allow for interesting layouts of aggregated data. BI 2.0 implemented via an RIA technology can truly bring out the power of business intelligence and deliver it to an average user on the Web. Silverlight 4 Business Intelligence Software provides developers, designers, and architects with a solid foundation in business intelligence design and architecture concepts for Microsoft Silverlight. This book covers key business intelligence design concepts and how they can be applied without an existing BI infrastructure. Author Bart Czernicki provides you with examples of how to build small BI applications that are interactive, highly visual, statistical, predictive—and most importantly—intuitive to the end-user. Business intelligence isn’t just for the executive branch of a Fortune 500 company—it is for the masses. Let Silverlight 4 Business Intelligence Software show you how to unlock the rich intelligence you already have.

Dive into the business intelligence (BI) features in SharePoint 2010—and use the right combination of tools to deliver compelling solutions. This practical guide helps you explore several BI application services available in SharePoint 2010 and Microsoft SQL Server 2008 R2. You’ll learn each technology with step-by-step instructions, and determine which ones work best in specific BI scenarios—whether you’re a SharePoint administrator, SQL Server developer, or business analyst. Choose the BI tools that meet your needs—and learn how they work together Examine the BI lifecycle, from determining key performance indicators to building dashboards Take Microsoft Excel further—gain more control and functionality with web-based Excel Services Mash up data from multiple sources using PowerPivot for Excel 2010 Create data visualizations with objects, context, and metrics using Microsoft Visio Services Build dashboards, scorecards, and other monitoring and analysis tools with PerformancePoint Services Use SharePoint to view BI reports side by side, no matter which tools were used to produced them Your companion web content includes: Interactive exercises that help you try out concepts or techniques Code samples that enable you to work with the exercises

Covers SharePoint 2013, Office 365’s SharePoint Online, and Other Office 365 Components In SharePoint 2013 Field Guide, top consultant Errin O’Connor and the team from EPC Group bring together best practices and proven strategies drawn from hundreds of successful SharePoint and Office 365 engagements. Reflecting this unsurpassed experience, they guide you through deployments of every type, including the latest considerations around private, public, and hybrid cloud implementations, from ECM to business intelligence (BI), as well as custom development and identity management. O’Connor reveals how world-class consultants approach, plan, implement, and deploy SharePoint 2013 and Office 365’s SharePoint Online to maximize both short- and long-term value. He covers every phase and element of the process, including initial “whiteboarding”; consideration around the existing infrastructure; IT roadmaps and the information architecture (IA); and planning for security and compliance in the new IT landscape of the hybrid cloud. SharePoint 2013 Field Guide will be invaluable for implementation team members ranging from solution architects to support professionals, CIOs to end-users. It’s like having a team of senior-level SharePoint and Office 365 hybrid architectureconsultants by your side, helping you optimize your success from start to finish! Detailed Information on How to… Develop a 24-36 month roadmap reflecting initial requirements, longterm strategies, and key unknowns for organizations from 100 users to 100,000 users Establish governance that reduces risk and increases value, covering the system as well as information architecture components, security, compliance, OneDrive, SharePoint 2013, Office 365, SharePoint Online, Microsoft Azure, Amazon Web Services, and identity management Address unique considerations of large, global, and/or multilingual enterprises Plan for the hybrid cloud (private, public, hybrid, SaaS, PaaS, IaaS) Integrate SharePoint with external data sources: from Oracle and SQL Server to HR, ERP, or document management for business intelligence initiatives Optimize performance across multiple data centers or locations including US and EU compliance and regulatory considerations (PHI, PII, HIPAA, Safe Harbor, etc.) Plan for disaster recovery, business continuity, data replication, and archiving Enforce security via identity management and authentication Safely support mobile devices and apps, including BYOD Implement true records management (ECM/RM) to support legal/compliance requirements Efficiently build custom applications, workflows, apps and web parts Leverage Microsoft Azure or Amazon Web Services (AWS)

SQL Server takes advantage of the new capabilities of Windows Server 2012, Windows Server 2012 R2 and Windows Server 2016 to provide unparalleled scalability for database applications on a physical or virtual environment. SQL Server also incorporates new capabilities on big data and business intelligence that will be developed throughout this book.

Microsoft's revolutionary Power Pivot is a tool that allows users to create and transform data into reports and dashboards in new and much more powerful ways using the most-used analytical tool in the world: Excel. This book, written by a member of Microsoft's Power Pivot team, provides a practical step by step guide on creating a financial dashboard. The book covers in detail how to combine and shape the relevant data, build the dashboard in Excel, providing layout and design tips and tricks, prepare the model to work with fiscal dates, and show values used in many financial reports, including year-to-date, variance-to-target, percentage-of-total, and running totals reports. Accessibly written, this book offers readers a practical, real-world scenario and can be used as a day-to-day reference. Though the guide focuses on Power Pivot for Excel 2010, a chapter that discusses Power View—compatible with Excel 2013— and Power BI is also included.

Conquer SharePoint 2013—from the inside out! You’re beyond the basics, so dive right into SharePoint 2013—and really put your business collaboration platform to work! This supremely organized reference packs hundreds of timesaving solutions, troubleshooting techniques, and workarounds. It’s all muscle and no fluff. Discover how the experts facilitate information sharing across the enterprise—and challenge yourself to new levels of mastery. Efficiently manage documents throughout the enterprise Build team sites and collaborate with Microsoft OneNote and SkyDrive Design workflows with SharePoint Designer and Microsoft Visio Produce e-forms using Microsoft InfoPath and Access Manage community sites using business social features Connect SharePoint to external data and business systems Create business intelligence dashboards and key performance indicators Customize and control Sharepoint enterprise search