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
What differentiates good organizations from bad? The good ones are those that take advantage of the data they already have and use the feedback that business intelligence gives them to improve their processes. SharePoint is now the delivery platform of choice for Microsoft’s business intelligence products, and in this book we reveal how to get the most from developing business intelligence solutions on SharePoint 2010. To understand the various business intelligence offerings in SharePoint 2010, you need to understand the core SQL Server business intelligence concepts, and the first part of the book presents a comprehensive tutorial on those fundamentals. Pro SharePoint 2010 Business Intelligence Solutions then focuses on specific SharePoint business intelligence investments including: Visio Services Excel Services SQL Server Reporting Services Business Connectivity Services PerformancePoint Services All of this is done using a practical, hands-on format, with enough examples to empower you to use these products in your real-life projects. As compelling as SharePoint and SQL Server business intelligence are together, the challenge always has been finding people who understand both SharePoint and SQL Server well enough to deliver such business intelligence solutions. With this book in hand, you become part of that select group. What you’ll learn Understand the fundamentals and framework of business intelligence. Learn how to integrate Visio Services, and discover the developer story. Practice working with the Secure Store Service. Experience authoring and publishing reports using Report Builder and how to re-purpose published reports in Reporting Services. Glean practical advice about deploying and developing for PerformancePoint Services in SharePoint 2010. Learn about the advances in Excel Services and PowerPivot, and their application within SharePoint to practical situations. Gain a deep understanding of the Business Data Services featureset in SharePoint 2010. Who this book is for This book offers SharePoint developers an essential BI foundation experience and an introduction to SQL Server 2008 tools for business intelligence. This book will also benefit SQL Server developers and administrators who require knowledge of setting up the basic infrastructure on the SharePoint platform for business intelligence. Table of Contents Business Intelligence Basics Visio Services Reporting Services Business Connectivity Services Excel Services PerformancePoint Services
To get ahead in today's hyper-competitive marketplace, your business has to take advantage of the data you already have and mine that data to give you new insight, metrics, and clues to what drives successful customer interactions. In Pro SharePoint 2013 Business Intelligence Solutions, you'll learn exactly how to unlock that magic, build business intelligence facilities on SharePoint, and glean insights from data to propel your business to the next level. To understand the various business intelligence offerings in SharePoint 2013, you need to understand the core SQL Server business intelligence concepts, and the first part of the book presents a comprehensive tutorial on those fundamentals. Pro SharePoint 2013 Business Intelligence Solutions then focuses on specific SharePoint business intelligence investments including: Visio Services Excel Services SQL Server Reporting Services Business Connectivity Services Power View and PerformancePoint Services Authors Manpreet Singh, Sha Anandan, Sahil Malik, and Steve Wright walk you through all of this material comprehensively in practical, hands-on format, with plenty of examples to empower you to use these products in your real-life projects. As compelling as SharePoint and SQL Server business intelligence are together, the challenge always has been finding people who understand both SharePoint and SQL Server well enough to deliver such business intelligence solutions. With this book in hand, you become part of that select group. Get your copy of Pro SharePoint 2013 Business Intelligence Solutions today!
Author: Patrick LeBlanc
Publisher: John Wiley & Sons
Release Date: 2015-05-06
Leverage the integration of SQL Server and Office for moreeffective BI Applied Microsoft Business Intelligence shows you how toleverage the complete set of Microsoft tools—includingMicrosoft Office and SQL Server—to better analyze businessdata. This book provides best practices for building complete BIsolutions using the full Microsoft toolset. You will learn how toeffectively use SQL Server Analysis and Reporting Services, alongwith Excel, SharePoint, and other tools to provide effective andcohesive solutions for the enterprise. Coverage includes BIarchitecture, data queries, semantic models, multidimensionalmodeling, data analysis and visualization, performance monitoring,data mining, and more, to help you learn to perform practicalbusiness analysis and reporting. Written by an author team thatincludes a key member of the BI product team at Microsoft, thisuseful reference provides expert instruction for more effective useof the Microsoft BI toolset. Use Microsoft BI suite cohesively for more effective enterprisesolutions Search, analyze, and visualize data more efficiently andcompletely Develop flexible and scalable tabular and multidimensionalmodels Monitor performance, build a BI portal, and deploy and managethe BI Solution
Author: Adam Jorgensen
Publisher: John Wiley & Sons
Release Date: 2011-12-05
Learn to build and deliver SharePoint BI applications Written by a team of leading SharePoint and Business Intelligence (BI) experts, this unique book-and-DVD package shows you how to successfully build and deliver BI applications using SharePoint 2010. Assuming no previous SharePoint experience, the authors deliver a clear explanation of what SharePoint will do for your BI and information management capabilities. Each lesson in the book is reinforced with a helpful tutorial on the DVD and cover topics such as interactive reporting with Excel, document sharing for collaborative reporting, and controlling data sources. As you learn best practices for configuring and securing SharePoint 2010 BI applications and planning and implementing your SharePoint BI project plan, you'll be well on your way to gaining a solid foundation of understanding and working with SharePoint 2010 and BI. Provides an invaluable training book-and-DVD package that takes you through building and delivering BI applications using SharePoint 2010 Features an accompanying video tutorial for each lesson covered in the book, along with a "Try It" section at the end of each lesson Covers interactive reporting with excel Covers Power Pivot advanced analytics Details report and document sharing for collaborative reporting Shows how to use SharePoint lists and libraries for data sources repositories in your BI projects Explains how to control data sources, reports and business intelligence content with permissions and workflow approvals. With this unique book-and-DVD combo, you'll be well on your way to successfully building and delivering BI applications using SharePoint 2010. Note: As part of the print version of this title, video lessons are included on DVD. For e-book versions, video lessons can be accessed at wrox.com using a link provided in the interior of the e-book.
Author: Ken Withee
Publisher: John Wiley & Sons
Release Date: 2010-03-05
Learn to create an effective business strategy using Microsoft's BI stack Microsoft Business Intelligence tools are among the most widely used applications for gathering, providing access to, and analyzing data to enable the enterprise to make sound business decisions. The tools include SharePoint Server, the Office Suite, PerformancePoint Server, and SQL Server, among others. With so much jargon and so many technologies involved, Microsoft Business Intelligence For Dummies provides a much-needed step-by-step explanation of what's involved and how to use this powerful package to improve your business. Microsoft Business Intelligence encompasses a broad collection of tools designed to help business owners and managers direct the enterprise effectively This guide provides an overview of SharePoint, PerformancePoint, the SQL Server suite, Microsoft Office, and the BI development technologies Explains how the various technologies work together to solve functional problems Translates the buzzwords and shows you how to create your business strategy Examines related technologies including data warehousing, data marts, Online Analytical Processing (OLAP), data mining, reporting, dashboards, and Key Performance Indicators (KPIs) Simplifies this complex package to get you up and running quickly Microsoft Business Intelligence For Dummies demystifies these essential tools for enterprise managers, business analysts, and others who need to get up to speed.
Author: Steven Mann
Publisher: Sams Publishing
Release Date: 2011-05-01
SharePoint 2010 is today’s leading presentation and deployment system for Business Intelligence (BI) solutions based on Microsoft technologies. This book brings together all the information you need to successfully implement and use SharePoint 2010’s powerful BI capabilities. It reflects the unsurpassed real-world experience of five expert consultants at RDA, a Microsoft Gold Partner specializing in delivering advanced BI solutions with SharePoint. You’ll first learn how to prepare SharePoint 2010 for the deployment of BI solutions. Next, the authors walk through integrating, configuring, and using Reporting Services, PerformancePoint Services, PowerPivot, Visio Services, and other key related technologies. Building on what you’ve learned, you’ll walk step-by-step through constructing and integrating two end-to-end BI solutions. Finally, in a comprehensive troubleshooting section, the authors present today’s most common SharePoint BI issues, identify proven solutions, and teach effective problem-solving techniques. Get started fast, by using the Business Intelligence Center’s prebuilt site collection and template Build integrated, end-to-end SharePoint BI solutions Present business data to the enterprise through Excel Services Install, configure, and integrate Reporting Services and the Reporting Services Add-In for SharePoint Define document library content types and manage reports Use Report Viewer Web Parts to render reports on SharePoint web pages Build enterprise dashboards with PerformancePoint Services Secure dashboards via data source delegation, SharePoint permissions, and groups Analyze enormous datasets with PowerPivot for Excel and SharePoint Publish Visio 2010 data-driven web diagrams that integrate multiple data sources Utilize the fine-grained security available through Visio Graphics Service Troubleshoot problems with Reporting Services, PerformancePoint Services, PowerPivot, and Visio Services
Apps have taken the world by storm, and now they're taking SharePoint as well. The biggest new thing in SharePoint 2013, apps are the solution to creating custom code that runs on not just your own SharePoint deployment, but also on others' implementations as well. Pro SharePoint 2013 App Development is your must-have guide to developing app solutions that run on the SharePoint 2013 platform. Using step-by-step tutorials, author Steve Wright creates a sample SharePoint app throughout the course of the book, and you can walk with him through the entire lifecycle of a SharePoint app. Get expert guidance and advice on creating an app, provisioning it for use in SharePoint, securing it from unauthorized use and from other applications, integrating your app with SharePoint search and other platform features, and much more. You'll even discover how to present your app to users on mobile devices like iPads, smartphones, and Microsoft Surface tablets. Apps in SharePoint are here to stay. Don't miss out - pick up a copy of Pro SharePoint 2013 App Development and get started on your own custom apps today. Introduces the architecture for creating and hosting SharePoint apps. Leads the reader through the creation and deployment of a complete solution. Provides an understanding of the security features in the SharePoint app model. Helps the organization leverage internal data securely over the network. Leverages SharePoint search and other services to create rich SharePoint solutions. Introduces the techniques for delivering data on a multitude of web and mobile platforms. What you’ll learn Understand the architecture of a SharePoint App. Host SharePoint apps on your site or in the cloud. Create, deploy and manage the lifecycle of your apps. Secure proprietary data while leveraging it in the cloud. Develop modern, sophisticated user experiences. Access data and services from SharePoint and across the web. Leverage SharePoint’s extensive search capabilities and other service applications. Use SharePoint as a social computing platform. Present data on various platforms including Windows RT, Windows Phone and mobile web devices. Who this book is for Pro SharePoint 2013 App Development is for developers and IT professionals responsible for delivering solutions on the SharePoint 2013 platform. These solutions may run on-site, in the cloud or in a hybrid deployment across many locations. Pro SharePoint 2013 App Development provides the background and step-by-step introduction needed to create massively scalable SharePoint applications using standard tools like Visual Studio and web standards like HTML and JQuery. Once created, SharePoint apps can be deployed internally or sold through the Microsoft SharePoint Store across the Internet. Table of Contents1. Introduction to SharePoint Apps 2. Creating and Deploying an App 3. Managing the App Lifecycle 4. Creating Client Side Logic using JQuery 5. SharePoint App Security 6. Business Connectivity Services 7. Web Service Access with REST and OData 8. Accessing the SharePoint Environment 9. App Logic Components 10. Developing the User Experience 11. Using SharePoint Search 12. Using SharePoint’s Social Features 13. Accessing SharePoint Service Applications 14. Interacting with Other App Environments
In just 24 sessions of one hour or less, you’ll learn how to build robust, dynamic, scalable, and manageable business solutions with SharePoint 2010! Using this book’s straightforward, step-by-step approach, you’ll learn how to implement everything from workflows to content management, search to enterprise-class business intelligence. One step at a time, you’ll master new features ranging from Business Connectivity Services to Silverlight rich user interfaces. Each lesson builds on what you’ve already learned, helping you get the job done fast--and do it right! Step-by-step instructions carefully walk you through the most common SharePoint 2010 development tasks. Q&As at the end of each chapter help you test your knowledge. By the Way, Did You Know?, and Watch Out! boxes offer advice and solutions. Learn how to… Make the most of SharePoint 2010’s lists, libraries, and site templates Customize the user interface through web parts, custom actions, and other advanced interface features Develop server-side applications and client-side applications for SharePoint 2010 Manage data using lists, libraries, site columns, content types, custom fields, event receivers, and queries Integrate external data with Business Connectivity Services (BCS) Use “out of the box” workflows and create custom workflows Manage SharePoint with SharePoint 2010 Central Administration Protect applications with claims-based authorization and other security features Integrate advanced search into your applications Build powerful BI solutions for data analysis, presentation, and decision-making
Author: Michael Alexander
Publisher: John Wiley & Sons
Release Date: 2014-04-17
Bridge the big data gap with Microsoft BusinessIntelligence Tools for Excel Analysts The distinction between departmental reporting done by businessanalysts with Excel and the enterprise reporting done by ITdepartments with SQL Server and SharePoint tools is more blurry nowthan ever before. With the introduction of robust new features likePowerPivot and Power View, it is essential for business analysts toget up to speed with big data tools that in the past have beenreserved for IT professionals. Written by a team of BusinessIntelligence experts, Microsoft Business Intelligence Tools forExcel Analysts introduces business analysts to the rich toolsetand reporting capabilities that can be leveraged to moreeffectively source and incorporate large datasets in theiranalytics while saving them time and simplifying the reportingprocess. Walks you step-by-step through important BI tools likePowerPivot, SQL Server, and SharePoint and shows you how to movedata back and forth between these tools and Excel Shows you how to leverage relational databases, slice data intovarious views to gain different visibility perspectives, createeye-catching visualizations and dashboards, automate SQL Serverdata retrieval and integration, and publish dashboards and reportsto the web Details how you can use SQL Server’s built-in functionsto analyze large amounts of data, Excel pivot tables to access andreport OLAP data, and PowerPivot to create powerful reportingmechanisms You’ll get on top of the Microsoft BI stack and all it cando to enhance Excel data analysis with this one-of-a-kind guidewritten for Excel analysts just like you.
Author: Steve Fox
Publisher: "O'Reilly Media, Inc."
Release Date: 2011-06-22
Your expert guide to building Microsoft® SharePoint® applications in the cloud Deliver custom, cloud-based business solutions using SharePoint 2010 and Windows Azure™ together. By applying hands-on techniques from Microsoft cloud development expert Steve Fox, you'll learn how to increase the reach, resource capability, and reusability of your apps. Get the practical code exercises and solid advice you need—whether you're planning to build complete data-driven applications or hybrid solutions with simple Web parts. Discover how to: Deliver data from Windows Azure Marketplace DataMarket into SharePoint and Microsoft Office applications Use Microsoft Business Connectivity Services to connect to SQL Azure™ data Create advanced web parts to surface SQL Azure data in Bing™ Maps, using the SharePoint client object model Manage files in Windows Azure using BLOB storage Deploy Windows Communication Foundation (WCF) services to Windows Azure Build business intelligence solutions, using SQL Azure, Microsoft SQL Server® Reporting Services (SSRS) Get code samples on the web Ready to download at http://go.microsoft.com/FWLink/?Linkid=000000. For system requirements, see the Introduction.
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 features in SharePoint 2013—and use the right combination of tools to deliver compelling solutions. Take control of business intelligence (BI) with the tools offered by SharePoint 2013 and Microsoft SQL Server 2012. Led by a group of BI and SharePoint experts, you’ll get step-by-step instructions for understanding how to use these technologies best in specific BI scenarios—whether you’re a SharePoint administrator, SQL Server developer, or business analyst. Discover how to: Manage the entire BI lifecycle, from determining key performance indicators to building dashboards Use web-based Microsoft Excel services and publish workbooks on a SharePoint Server Mash up data from multiple sources and create Data Analysis Expressions (DAX) using PowerPivot Create data-driven diagrams that provide interactive processes and context with Microsoft Visio Services Use dashboards, scorecards, reports, and key performance indicators to monitor and analyze your business Use SharePoint to view BI reports side by side, no matter which tools were used to produced them