Applied Microsoft Business Intelligence

  • 5h 31m
  • Dejan Sarka, Dustin Ryan, Jessica M. Moss, Patrick LeBlanc
  • John Wiley & Sons (US)
  • 2015

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

About the Authors

Patrick LeBlanc is a Microsoft SQL Server and Business Intelligence Technical Solution Professional. He holds a Masters of Science from Louisiana State University and has authored four SQL Server books.

Jessica M. Moss, a Microsoft SQL Server MVP, is a well-known practitioner, author, and speaker in Microsoft SQL Server business intelligence. She has created numerous data warehousing solutions for companies in the retail, internet, health services, finance, and energy industries.

Dejan Sarka, MCT and SQL Server MVP, focuses on development of database and business intelligence applications. He is the founder of the Slovenian SQL Server and .NET Users Group.

Dustin Ryan, a Senior Business Intelligence Consultant and Trainer at Pragmatic Works, is a blogger, speaker, and author in the Microsoft SQL Server Business Intelligence field. He has developed enterprise business intelligence solutions and provided training for customers in the retail, finance, transportation, healthcare, energy, and manufacturing industries.

In this Book

  • Which Analysis and Reporting Tools Do You Need?
  • Designing an Effective Business Intelligence Architecture
  • Selecting the Data Architecture that Fits Your Organization
  • Searching and Combining Data with Power Query
  • Choosing the Right Business Intelligence Semantic Model
  • Discovering and Analyzing Data with Power Pivot
  • Developing a Flexible and Scalable Tabular Model
  • Developing a Flexible and Scalable Multidimensional Model
  • Discovering Knowledge with Data Mining
  • Choosing the Right Business Intelligence Visualization Tool
  • Designing Operational Reports with Reporting Services
  • Visualizing Your Data Interactively with Power View
  • Exploring Geographic and Temporal Data with Power Map
  • Monitoring Your Business with PerformancePoint Services
  • Implementing a Self-Service Delivery Framework
  • Designing and Implementing a Deployment Plan
  • Managing and Maintaining the Business Intelligence ronment
  • Scaling the Business Intelligence Environment
SHOW MORE
FREE ACCESS