Microsoft Business Intelligence For Dummies

Sold by John Wiley & Sons
1
Free sample

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.

Read more
Collapse

About the author

Ken Withee is a Microsoft SharePoint and Business Intelligence consultant and a Microsoft Certified Technology Specialist. He is certified in SharePoint, SQL Server, and .NET. Among his many published works are a book on SSRS 2008 and a featured article on Self-Serve Business Intelligence in The Architecture Journal.
Read more
Collapse
4.0
1 total
Loading...

Additional Information

Publisher
John Wiley & Sons
Read more
Collapse
Published on
Mar 5, 2010
Read more
Collapse
Pages
432
Read more
Collapse
ISBN
9780470606346
Read more
Collapse
Read more
Collapse
Read more
Collapse
Language
English
Read more
Collapse
Genres
Computers / Enterprise Applications / Business Intelligence Tools
Computers / Information Technology
Read more
Collapse
Content Protection
This content is DRM protected.
Read more
Collapse
Read Aloud
Available on Android devices
Read more
Collapse

Reading information

Smartphones and Tablets

Install the Google Play Books app for Android and iPad/iPhone. It syncs automatically with your account and allows you to read online or offline wherever you are.

Laptops and Computers

You can read books purchased on Google Play using your computer's web browser.

eReaders and other devices

To read on e-ink devices like the Sony eReader or Barnes & Noble Nook, you'll need to download a file and transfer it to your device. Please follow the detailed Help center instructions to transfer the files to supported eReaders.
PowerPivot comprises a set of technologies for easy access to data mining and business intelligence analysis from Microsoft Excel and SharePoint. Power users and developers alike can create sophisticated, online analytic processing (OLAP) solutions using PowerPivot for Excel, and then share those solutions with other users via PowerPivot for SharePoint. Data can be pulled in from any of the leading database platforms, as well as from spreadsheets and flat files.

PowerPivot for Business Intelligence Using Excel and SharePoint is your key to mastering PowerPivot. The book takes a scenario-based approach to showing you how to collect data, to mine that data through insightful analysis, and to draw conclusions that drive business performance. Each chapter in the book is focused on a specific challenge that you’ll encounter when using PowerPivot. Each chapter takes you through a solution technique that’s been proven in the real world.

Covers the leading technology for bringing data analytics to the desktop Presents real-world solutions to real-world scenarios Written by a Microsoft Virtual Technical Specialist (VTS) for business intelligence What you’ll learn Install and verify the PowerPivot software Integrated existing, available data to deliver business intelligence Leverage Time Intelligence to report change over time Write Data Analysis Expressions (DAX) to create custom measures Identify and implement solutions for role-playing dimensions Recognize and work-around PowerPivot’s missing features Who this book is for

PowerPivot Solutions for Excel and SharePoint is aimed at information workers and data analysts who typically use Excel to drive business decisions. The book shows how you can apply PowerPivot to problems typically addressed through complicated and arcane spreadsheet techniques. Business people without the time and interest in learning Excel arcane will especially appreciate how PowerPivot enables them to easily create models and perform analysis far in advance of anything they could do using Excel alone.

Table of Contents Getting Started with PowerPivot for Excel Hello World, PowerPivot Style Combining Data Sources Data Analysis Expressions A Method to the Madness Installing PowerPivot for SharePoint Collaboration, Version Control, and Management PowerPivot As a Data Source PowerPivot and SQL Server Reporting Services PowerPivot and Predictive Analytics Tips, Tricks, and Traps
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
Data virtualization can help you accomplish your goals with more flexibility and agility. Learn what it is and how and why it should be used with Data Virtualization for Business Intelligence Systems. In this book, expert author Rick van der Lans explains how data virtualization servers work, what techniques to use to optimize access to various data sources and how these products can be applied in different projects. You’ll learn the difference is between this new form of data integration and older forms, such as ETL and replication, and gain a clear understanding of how data virtualization really works. Data Virtualization for Business Intelligence Systems outlines the advantages and disadvantages of data virtualization and illustrates how data virtualization should be applied in data warehouse environments. You’ll come away with a comprehensive understanding of how data virtualization will make data warehouse environments more flexible and how it make developing operational BI applications easier. Van der Lans also describes the relationship between data virtualization and related topics, such as master data management, governance, and information management, so you come away with a big-picture understanding as well as all the practical know-how you need to virtualize your data. First independent book on data virtualization that explains in a product-independent way how data virtualization technology works. Illustrates concepts using examples developed with commercially available products. Shows you how to solve common data integration challenges such as data quality, system interference, and overall performance by following practical guidelines on using data virtualization. Apply data virtualization right away with three chapters full of practical implementation guidance. Understand the big picture of data virtualization and its relationship with data governance and information management.
Learn all the ins and outs of SharePoint 2016, launch your site, collaborate with coworkers, and go mobile

There's no doubt about it, SharePoint is a complex creature. But when broken down into easily digestible chunks, it's not quite the beast it appears to be right out of the gate—that's where SharePoint 2016 For Dummies comes in! Written in plain English and free of intimidating jargon, this friendly, accessible guide starts out by showing you just what SharePoint 2016 is, translating the terminology, and explaining the tools. Then it helps you create a site, work with apps, and master basic SharePoint administration. Next, you'll learn to use SharePoint 2016 to get social, go mobile, manage content, and connect with others through working with Office 365, archiving documents, developing workflows, and so much more.

SharePoint is truly one of Microsoft's crown jewels. Launched in 2001, it offers organizations a secure place to store, organize, share, and access information under the Microsoft Office system umbrella—all in a single portal. Whether you're new to SharePoint 2016 or new to SharePoint altogether, SharePoint 2016 For Dummies is the fast and painless way to get a site up and running, branded, and populated with content. Plus, this new edition adds the need-to-know information for administrators, techsumers, and page admins who want to leverage the cloud-based features online, either as a standalone product or in conjunction with an existing SharePoint infrastructure.

Get up to speed with SharePoint 2016 and take advantage of new features Set up and effectively manage your SharePoint site Use SharePoint 2016 in the Cloud with SharePoint Online Leverage SharePoint 2016 capabilities to drive business value

If you want to learn SharePoint from the ground up, get your site going, and start collaborating, SharePoint 2016 For Dummies will be the dog-eared reference you'll turn to again and again.

©2019 GoogleSite Terms of ServicePrivacyDevelopersArtistsAbout Google|Location: United StatesLanguage: English (United States)
By purchasing this item, you are transacting with Google Payments and agreeing to the Google Payments Terms of Service and Privacy Notice.