05302nam 2200661 450 991082191540332120230912173039.01-118-96178-11-118-96179-X(CKB)3710000000412049(EBL)1895172(SSID)ssj0001535451(PQKBManifestationID)11828706(PQKBTitleCode)TC0001535451(PQKBWorkID)11502366(PQKB)10182660(Au-PeEL)EBL1895172(CaPaEBR)ebr11100831(OCoLC)913797327(CaSebORM)9781118961773(MiAaPQ)EBC1895172(MiAaPQ)EBC4509724(EXLCZ)99371000000041204920160407h20152015 uy 0engurunu|||||txtccrApplied microsoft business intelligence /Patrick LeBlanc [and three others]1st editionIndianapolis, Indiana :Wiley,2015.©20151 online resource (432 p.)Includes index.1-119-18357-X 1-118-96177-3 Cover; Title Page; Copyright; Contents; Introduction; Part I Overview of the Microsoft Business Intelligence Toolset; Chapter 1 Which Analysis and Reporting Tools Do You Need?; Selecting a SQL Server Database Engine; Building a Data Warehouse; Selecting an RDBMS; Selecting SQL Server Analysis Services; Working with SQL Server Reporting Services; Understanding Operational Reports; Understanding Ad Hoc Reporting; Working with SharePoint; Working with Performance Point; Using Excel for Business Intelligence; What Is Power Query?; What Is Power Pivot?; What Is Power View?; Power MapWhich Development Tools Do You Need?Using SQL Server Data Tools; Using SQL Management Studio; Using Dashboard Designer; Using Report Builder; Summary; Chapter 2 Designing an Effective Business Intelligence Architecture; Identifying the Audience and Goal of the Business Intelligence Solution; Who's the Audience?; What Is the Goal(s)?; What Are the Data Sources?; Using Internal Data Sources; Using External Data Sources; Using a Data Warehouse (or Not); Implementing and Enforcing Data Governance; Planning an Analytical Model; Planning the Business Intelligence Delivery SolutionConsidering Performance Considering Availability; Summary; Chapter 3 Selecting the Data Architecture that Fits Your Organization; Why Is Data Architecture Selection Important?; Challenges; Benefits; How Do You Pick the Right Data Architecture?; Understanding Architecture Options; Understanding Research Selection Factors; Interviewing Key Stakeholders; Completing the Selection Form; Finalizing and Approving the Architecture; Summary; Part II Business Intelligence for Analysis; Chapter 4 Searching and Combining Data with Power Query; Downloading and Installing Power Query; Importing DataImporting from a Database Importing from the Web; Importing from a File; Transforming Data; Combining Data from Multiple Sources; Splitting Data; Aggregating Data; Introducing M Programming; A Glance at the M Language; Adding and Removing Columns Using M; Summary; Chapter 5 Choosing the Right Business Intelligence Semantic Model; Understanding the Business Intelligence Semantic Model Architecture; Understanding the Data Access Layer; Using Power Pivot; Using the Multidimensional Model; Using the Tabular Model; Implementing Query Languages and the Business Logic LayerData Analytics Expressions (DAX)Multidimensional Expressions (MDX); Direct Query and ROLAP; Data Model Layer; Comparing the Different Types of Models; Which Model Fits Your Organization?; Departmental; Team; Organizational; Summary; Chapter 6 Discovering and Analyzing Data with Power Pivot; Understanding Hardware and Software Requirements; Enabling Power Pivot; Designing an Optimal Power Pivot Model; Importing Only What You Need; Understanding Why Data Types Matter; Working with Columns or DAX Calculated Measures; Optimizing the Power Pivot Model for ReportingUnderstanding Power Pivot Model BasicsLeverage 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 queriesBusiness intelligenceComputer programsBusiness planningBusiness intelligenceComputer programs.Business planning.658.47028Leblanc Patrick1701576Leblanc PatrickMiAaPQMiAaPQMiAaPQBOOK9910821915403321Applied microsoft business intelligence4085425UNINA