SØG - mellem flere end 8 millioner bøger:

Søg på: Titel, forfatter, forlag - gerne i kombination.
Eller blot på isbn, hvis du kender dette.

Viser: Applied Microsoft Business Intelligence

Applied Microsoft Business Intelligence, 1. udgave
Søgbar e-bog

Applied Microsoft Business Intelligence Vital Source e-bog

Patrick LeBlanc, Jessica M. Moss, Dejan Sarka og Dustin Ryan
John Wiley & Sons
396,00 kr.
Leveres umiddelbart efter køb
Applied Microsoft Business Intelligence, 1. udgave
Søgbar e-bog

Applied Microsoft Business Intelligence Vital Source e-bog

Patrick LeBlanc, Jessica M. Moss, Dejan Sarka og Dustin Ryan
(2015)
John Wiley & Sons
396,00 kr.
Leveres umiddelbart efter køb
Applied Microsoft Business Intelligence

Applied Microsoft Business Intelligence

Jessica M. Moss
(2015)
Sprog: Engelsk
John Wiley & Sons, Incorporated
393,00 kr.
ikke på lager, Bestil nu og få den leveret
om ca. 10 hverdage

Detaljer om varen

  • 1. Udgave
  • Vital Source searchable e-book (Fixed pages)
  • Udgiver: John Wiley & Sons
  • Forfattere: Patrick LeBlanc, Jessica M. Moss, Dejan Sarka og Dustin Ryan
  • ISBN: 9781118961797
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 toolsincluding Microsoft Office and SQL Serverto 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
Licens varighed:
Bookshelf online: 5 år fra købsdato.
Bookshelf appen: ubegrænset dage fra købsdato.

Udgiveren oplyser at følgende begrænsninger er gældende for dette produkt:
Print: 2 sider kan printes ad gangen
Copy: højest 10 sider i alt kan kopieres (copy/paste)

Detaljer om varen

  • 1. Udgave
  • Vital Source searchable e-book (Reflowable pages)
  • Udgiver: John Wiley & Sons (Maj 2015)
  • Forfattere: Patrick LeBlanc, Jessica M. Moss, Dejan Sarka og Dustin Ryan
  • ISBN: 9781118961780
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
Licens varighed:
Bookshelf online: 5 år fra købsdato.
Bookshelf appen: ubegrænset dage fra købsdato.

Udgiveren oplyser at følgende begrænsninger er gældende for dette produkt:
Print: 10 sider kan printes ad gangen
Copy: højest 2 sider i alt kan kopieres (copy/paste)

Detaljer om varen

  • Paperback: 432 sider
  • Udgiver: John Wiley & Sons, Incorporated (Maj 2015)
  • ISBN: 9781118961773

Leverage the power of SQL and Office to build a complete enterprise BI solution

The business intelligence world is changing. Hardware is getting more powerful, platforms are getting more capable, and decision timeframes are getting shorter. Microsoft's SQL Server and Office products provide powerful core BI technologies that allow decision makers who rely on Office for basic analytics to tap into a sophisticated BI toolset for both analysis and reporting. Applied Microsoft Business Intelligence reveals the best practices for building complete BI solutions using SQL Server, Reporting, and Analysis Services along with Excel and SharePoint for a more robust business intelligence framework.

This book shows you how to use the Microsoft business intelligence building blocks to construct synergetic and complete solutions to suit any organization. Organized chronologically by implementation order, it guides you through the data layer, data transformation and quality, the semantic layer, and the presentation layer, and ties it all together with comprehensive case studies. Focusing on best practices rather than specific tools keeps your skills relevant beyond the 2014 SQL release. Comprehensive explanations including architecture, strengths and weaknesses, and practical applications bring you fully up to speed quickly.

Applied Microsoft Business Intelligence shows you how to:

  • Design an effective BI architecture that best fits your organization
  • Develop flexible, scalable, tabular and multi-dimensional models
  • Create interactive visualizations with Power View
  • Explore geographic and temporal data with Power Map
  • Implement self-service delivery and an efficient deployment strategy
  • Manage, maintain, and scale the BI environment
Introduction xiii
Part I Overview of the Microsoft Business Intelligence Toolset 1
Chapter 1 Which Analysis and Reporting Tools Do You Need? 3 Selecting a SQL Server Database Engine 4 Building a Data Warehouse 4 Selecting an RDBMS 5 Selecting SQL Server Analysis Services 6 Working with SQL Server Reporting Services 7 Understanding Operational Reports 8 Understanding Ad Hoc Reporting 10 Working with SharePoint 11 Working with Performance Point 12 Using Excel for Business Intelligence 14 What Is Power Query? 14 What Is Power Pivot? 14 What Is Power View? 14 Power Map 15 Which Development Tools Do You Need? 16 Using SQL Server Data Tools 16 Using SQL Management Studio 17 Using Dashboard Designer 18 Using Report Builder 19 Summary 20
Chapter 2 Designing an Eff ective Business Intelligence Architecture 21 Identifying the Audience and Goal of the Business Intelligence Solution 21 Who''s the Audience? 22 What Is the Goal(s)? 23 What Are the Data Sources? 23 Using Internal Data Sources 23 Using External Data Sources 24 Using a Data Warehouse (or Not) 24 Implementing and Enforcing Data Governance 26 Planning an Analytical Model 28 Planning the Business Intelligence Delivery Solution 29 Considering Performance 30 Considering Availability 31 Summary 32
Chapter 3 Selecting the Data Architecture that Fits Your Organization 33 Why Is Data Architecture Selection Important? 34 Challenges 34 Benefits 35 How Do You Pick the Right Data Architecture? 36 Understanding Architecture Options 36 Understanding Research Selection Factors 42 Interviewing Key Stakeholders 44 Completing the Selection Form 45 Finalizing and Approving the Architecture 46 Summary 48
Part II Business Intelligence for Analysis 49
Chapter 4 Searching and Combining Data with Power Query 51 Downloading and Installing Power Query 52 Importing Data 56 Importing from a Database 57 Importing from the Web 59 Importing from a File 61 Transforming Data 62 Combining Data from Multiple Sources 62 Splitting Data 64 Aggregating Data 66 Introducing M Programming 70 A Glance at the M Language 70 Adding and Removing Columns Using M 72 Summary 72
Chapter 5 Choosing the Right Business Intelligence Semantic Model 73 Understanding the Business Intelligence Semantic Model Architecture 74 Understanding the Data Access Layer 75 Using Power Pivot 77 Using the Multidimensional Model 78 Using the Tabular Model 78 Implementing Query Languages and the Business Logic Layer 79 Data Analytics Expressions (DAX) 79 Multidimensional Expressions (MDX) 81 Direct Query and ROLAP 81 Data Model Layer 82 Comparing the Different Types of Models 83 Which Model Fits Your Organization? 84 Departmental 84 Team 86 Organizational 87 Summary 88
Chapter 6 Discovering and Analyzing Data with Power Pivot 89 Understanding Hardware and Software Requirements 90 Enabling Power Pivot 90 Designing an Optimal Power Pivot Model 92 Importing Only What You Need 92 Understanding Why Data Types Matter 99 Working with Columns or DAX Calculated Measures 103 Optimizing the Power Pivot Model for Reporting 104 Understanding Power Pivot Model Basics 104 Adding All Necessary Relationships 107 Adding Calculated Columns and DAX Measures 114 Creating Hierarchies and Key Performance Indicators (KPIs) 118 Sorting Your Data to Meet End-User Needs 121 Implementing Role-Playing Dimensions 122 Summary 125
Chapter 7 Developing a Flexible and Scalable Tabular Model 127 Why Use a Tabular Model? 127 Understanding the Tabular Model 128 Using the Tabular Model 128 Comparing the Tabular and Multidimensional Models 130 Understanding the Tabular Development Process 130 How Do You Design the Model? 131 Importing Data 131 Designing Relationships 134 Calculated Columns and Measures 135 How Do You Enhance the Model? 137 Adding Hierarchies 137 Designing Perspectives 140 Adding Partitions 141 How Do You Tune the Model? 144 Optimizing Processing 144 Optimizing Querying 147 Summary 149
Chapter 8 Developing a Flexible and Scalable Multidimensional Model 151 Why Use a Multidimensional Model? 151 Understanding the Multidimensional Model 152 Understanding the Multidimensional Model Process 153 How Do You Design the Model? 153 Creating Data Sources and the Data Source View 153 Using the Cube Creation Wizard 156 Adjusting Measures 159 Completing Dimensions 160 How Do You Enhance the Model? 162 Adding Navigation with Hierarchies 162 Using the Business Intelligence Wizard for Calculations 164 Using Partitions and Aggregations 166 How Do You Tune the Model? 169 Resolving Processing Issues 169 Querying 171 Summary 172
Chapter 9 Discovering Knowledge with Data Mining 173 Understanding the Business Value of Data Mining 174 Understanding Data Mining Techniques 174 Common Business Use Cases 175 Driving Decisions, Strategies, and Processes Through Data Mining 176 Getting the Basics Right 179 Understanding the Data 180 Training and Test Datasets 182 Defining the Data Mining Structure 184 The Data Mining Model 184 Applying the Microsoft Data Mining Techniques with Best Practices 185 Using Microsoft Association Rules 186 Grouping Data with Microsoft Clustering 190 Building Mining Models with Microsoft Naïve Bayes 192 Using the Microsoft Decision Trees 193 Using Microsoft Neural Network and Microsoft Logistic Regression 195 Using Microsoft Linear Regression and Microsoft Regression Trees 197 Microsoft Sequence Clustering 199 Forecasting with Microsoft Time Series 200 Developing and Deploying a Scalable and Extensible Data Mining Solution 201 Choosing Between a Relational or a Cube Source for Your Data Mining Structure 202 Deploying Data Mining Models 202 Using DMX to Query Data Mining Models 204 Maintaining Data Mining Models 205 Fine-Tuning the Data Mining Structure 205 Keeping the Data Model Relevant 205 Continuous Learning Cycle 205 Integrating Data Mining with Your BI Solution 206 Integrating Data Mining in Your DW and ETL Processes 206 Integrating Data Mining with Reporting Services 207 Data Mining in Excel 207 Summary 208
Part III Business Intelligence for Reporting 209
Chapter 10 Choosing the Right Business Intelligence Visualization Tool 211 Why Do You Need to Choose? 211 Identifying Users 212 Selecting Tools 213 What Are the Selection Criteria? 213 Business Capabilities 214 Technical Capabilities 214 How Do You Gather the Necessary Information? 215 What Are the Business Intelligence Visualization Options? 215 Using SQL Server Reporting Services 215 Using Power View 218 Using Power Map 219 How Do You Create and Complete the Evaluation Matrix? 221 How Do You Verify and Complete the Process? 223 Evaluation Matrix #1 224 Evaluation Matrix #2 224 Summary 225
Chapter 11 Designing Operational Reports with Reporting Services 227 What Are Operational Reports and Reporting Services? 227 Understanding Analytical versus Operational Reports 228 Using Reporting Services 228 What Are Development Best Practices? 230 Using Source and Version Control 231 Using Shared Data Sources and Datasets 234 Creating Templates 236 What Are Performance Best Practices? 237 Investigating Performance 237 Performance Tuning 238 What Are Functionality Best Practices? 239 Using Visualizations 239 Using Filters and Parameters 240 Providing Drilldown and Drillthrough 241 Summary 244
Chapter 12 Visualizing Your Data Interactively with Power View 245 Where Does Power View Fit with Your Reporting Solution? 246 Power View System Requirements 246 Creating Power View Data Source Connections 247 Creating Data Sources Inside Excel 247 Creating Data Sources Inside SharePoint 249 Creating Power View Reports 251 Using SharePoint to Create Power View Reports 251 Using Multiple Views in Power View 252 Creating Power View Visualizations 253 Creating Tables 253 Converting Visualizations 254 Creating Matrices 255 Creating Charts 256 Creating Multiples 261 Creating Cards 261 Creating Maps 262 Using Excel to Create Power View Reports 263 Filtering Data with Power View 264 Adding Filters 264 Using Advanced Filters 266 Adding Slicers 266 Invoking Cross-Filters 267 Adding Tiles 268 Adding Filters to a Report URL 270 Exporting Power View Reports 271 Summary 272
Chapter 13 Exploring Geographic and Temporal Data with Power Map 273 How Power Map Fits into Reporting Solutions 274 Understanding Power Map Features and Advantages 274 Comparing Power Map to Other SQL Server
De oplyste priser er inkl. moms

Polyteknisk Boghandel

har gennem mere end 50 år været studieboghandlen på DTU og en af Danmarks førende specialister i faglitteratur.

 

Vi lagerfører et bredt udvalg af bøger, ikke bare inden for videnskab og teknik, men også f.eks. ledelse, IT og meget andet.

Læs mere her


Trykt eller digital bog?

Ud over trykte bøger tilbyder vi tre forskellige typer af digitale bøger:

 

Vital Source Bookshelf: En velfungerende ebogsplatform, hvor bogen downloades til din computer og/eller mobile enhed.

 

Du skal bruge den gratis Bookshelf software til at læse læse bøgerne - der er indbygget gode værktøjer til f.eks. søgning, overstregning, notetagning mv. I langt de fleste tilfælde vil du samtidig have en sideløbende 1825 dages online adgang. Læs mere om Vital Source bøger

 

Levering: I forbindelse med købet opretter du et login. Når du har installeret Bookshelf softwaren, logger du blot ind og din bog downloades automatisk.

 

 

Adobe ebog: Dette er Adobe DRM ebøger som downloades til din lokale computer eller mobil enhed.

 

For at læse bøgerne kræves særlig software, som understøtter denne type. Softwaren er gratis, men du bør sikre at du har rettigheder til installere software på den maskine du påtænker at anvende den på. Læs mere om Adobe DRM bøger

 

Levering: Et download link sendes pr email umiddelbart efter købet.

 


Ibog: Dette er en online bog som kan læses på udgiverens website. 

Der kræves ikke særlig software, bogen læses i en almindelig browser.

 

Levering: Vores medarbejder sender dig en adgangsnøgle pr email.

 

Vi gør opmærksom på at der ikke er retur/fortrydelsesret på digitale varer.