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
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
Author: Patrick LeBlanc
Publisher: John Wiley & Sons
Release Date: 2015-05-06
Leverage the integration of SQL Server and Office for more effective BI Applied Microsoft Business Intelligence shows you how to leverage the complete set of Microsoft tools—including Microsoft Office and SQL Server—to better analyze business data. This book provides best practices for building complete BI solutions using the full Microsoft toolset. You will learn how to effectively use SQL Server Analysis and Reporting Services, along with Excel, SharePoint, and other tools to provide effective and cohesive solutions for the enterprise. Coverage includes BI architecture, data queries, semantic models, multidimensional modeling, data analysis and visualization, performance monitoring, data mining, and more, to help you learn to perform practical business analysis and reporting. Written by an author team that includes a key member of the BI product team at Microsoft, this useful reference provides expert instruction for more effective use of the Microsoft BI toolset. Use Microsoft BI suite cohesively for more effective enterprise solutions Search, analyze, and visualize data more efficiently and completely Develop flexible and scalable tabular and multidimensional models Monitor performance, build a BI portal, and deploy and manage the BI Solution
Author: Michael Alexander
Publisher: John Wiley & Sons
Release Date: 2014-04-17
Bridge the big data gap with Microsoft Business Intelligence Tools for Excel Analysts The distinction between departmental reporting done by business analysts with Excel and the enterprise reporting done by IT departments with SQL Server and SharePoint tools is more blurry now than ever before. With the introduction of robust new features like PowerPivot and Power View, it is essential for business analysts to get up to speed with big data tools that in the past have been reserved for IT professionals. Written by a team of Business Intelligence experts, Microsoft Business Intelligence Tools for Excel Analysts introduces business analysts to the rich toolset and reporting capabilities that can be leveraged to more effectively source and incorporate large datasets in their analytics while saving them time and simplifying the reporting process. Walks you step-by-step through important BI tools like PowerPivot, SQL Server, and SharePoint and shows you how to move data back and forth between these tools and Excel Shows you how to leverage relational databases, slice data into various views to gain different visibility perspectives, create eye-catching visualizations and dashboards, automate SQL Server data retrieval and integration, and publish dashboards and reports to the web Details how you can use SQL Server’s built-in functions to analyze large amounts of data, Excel pivot tables to access and report OLAP data, and PowerPivot to create powerful reporting mechanisms You’ll get on top of the Microsoft BI stack and all it can do to enhance Excel data analysis with this one-of-a-kind guide written for Excel analysts just like you.
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
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!
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
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
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
Written in an easy-to-follow, example-driven format, there are plenty of stepbystep instructions to help get you started! The book has a friendly approach, with the opportunity to learn by experimenting. If you are a BI and Data Warehouse developer new to Microsoft Business Intelligence, and looking to get a good understanding of the different components of Microsoft SQL Server for Business Intelligence, this book is for you. It’s assumed that you will have some experience in databases systems and T-SQL. This book is will give you a good upshot view of each component and scenarios featuring the use of that component in Data Warehousing and Business Intelligence systems.
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: 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.