LEADER 05302nam 2200661 450 001 9910821915403321 005 20230912173039.0 010 $a1-118-96178-1 010 $a1-118-96179-X 035 $a(CKB)3710000000412049 035 $a(EBL)1895172 035 $a(SSID)ssj0001535451 035 $a(PQKBManifestationID)11828706 035 $a(PQKBTitleCode)TC0001535451 035 $a(PQKBWorkID)11502366 035 $a(PQKB)10182660 035 $a(Au-PeEL)EBL1895172 035 $a(CaPaEBR)ebr11100831 035 $a(OCoLC)913797327 035 $a(CaSebORM)9781118961773 035 $a(MiAaPQ)EBC1895172 035 $a(MiAaPQ)EBC4509724 035 $a(EXLCZ)993710000000412049 100 $a20160407h20152015 uy 0 101 0 $aeng 135 $aurunu||||| 181 $ctxt 182 $cc 183 $acr 200 00$aApplied microsoft business intelligence /$fPatrick LeBlanc [and three others] 205 $a1st edition 210 1$aIndianapolis, Indiana :$cWiley,$d2015. 210 4$dİ2015 215 $a1 online resource (432 p.) 300 $aIncludes index. 311 $a1-119-18357-X 311 $a1-118-96177-3 327 $aCover; 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 Map 327 $aWhich 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 Solution 327 $aConsidering 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 Data 327 $aImporting 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 Layer 327 $aData 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 Reporting 327 $aUnderstanding Power Pivot Model Basics 330 $aLeverage 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 606 $aBusiness intelligence$xComputer programs 606 $aBusiness planning 615 0$aBusiness intelligence$xComputer programs. 615 0$aBusiness planning. 676 $a658.47028 700 $aLeblanc$b Patrick$01701576 702 $aLeblanc$b Patrick 801 0$bMiAaPQ 801 1$bMiAaPQ 801 2$bMiAaPQ 906 $aBOOK 912 $a9910821915403321 996 $aApplied microsoft business intelligence$94085425 997 $aUNINA