Applied Microsoft Business Intelligence by Patric Leblanc, Jessica M. Moss, Dejan Sarka

1 BOOKS FOUND ON YOUR SEARCH.

Applied Microsoft Business Intelligence

by Patric Leblanc, Jessica M. Moss, Dejan Sarka

Qty :

Price : $ ~~9.98~~
Your Price : $ 8.98
You Save : $ 1.00 (10%)
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. Table of 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 Which Development Tools Do You Need? Using SQL Server Data Tools Using SQL Management Studio Using Dashboard Designer Using Report Builder 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 Considering Performance Considering Availability 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 Part II: Business Intelligence for Analysis Chapter 4 - Searching and Combining Data with Power Query Downloading and Installing Power Query Importing Data Importing 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 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 Data 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 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 Understanding Power Pivot Model Basics Adding All Necessary Relationships Adding Calculated Columns and DAX Measures Creating Hierarchies and Key Performance Indicators (KPIs) Sorting Your Data to Meet End-User Needs Implementing Role-Playing Dimensions Chapter 7 - Developing a Flexible and Scalable Tabular Model Why Use a Tabular Model? Understanding the Tabular Model Using the Tabular Model Comparing the Tabular and Multidimensional Models Understanding the Tabular Development Process How Do You Design the Model? Importing Data Designing Relationships Calculated Columns and Measures How Do You Enhance the Model? Adding Hierarchies Designing Perspectives Adding Partitions How Do You Tune the Model? Optimizing Processing Optimizing Querying Chapter 8 - Developing a Flexible and Scalable Multidimensional Model Why Use a Multidimensional Model? Understanding the Multidimensional Model Understanding the Multidimensional Model Process How Do You Design the Model? Creating Data Sources and the Data Source View Using the Cube Creation Wizard Adjusting Measures Completing Dimensions How Do You Enhance the Model? Adding Navigation with Hierarchies Using the Business Intelligence Wizard for Calculations Using Partitions and Aggregations How Do You Tune the Model? Resolving Processing Issues Querying Chapter 9 - Discovering Knowledge with Data Mining Understanding the Business Value of Data Mining Understanding Data Mining Techniques Common Business Use Cases Driving Decisions, Strategies and Processes Through Data Mining Getting the Basics Right Understanding the Data Training and Test Datasets Defining the Data Mining Structure The Data Mining Model Applying the Microsoft Data Mining Techniques with Best Practices Using Microsoft Association Rules Grouping Data with Microsoft Clustering Building Mining Models with Microsoft Na�ve Bayes Using the Microsoft Decision Trees Using Microsoft Neural Network and Microsoft Logistic Regression Using Microsoft Linear Regression and Microsoft Regression Trees Microsoft Sequence Clustering Forecasting with Microsoft Time Series Developing and Deploying a Scalable and Extensible Data Mining Solution Choosing Between a Relational or a Cube Source for Your Data Mining Structure Deploying Data Mining Models Using DMX to Query Data Mining Models Maintaining Data Mining Models Fine-Tuning the Data Mining Structure Keeping the Data Model Relevant Continuous Learning Cycle Integrating Data Mining with Your BI Solution Integrating Data Mining in Your DW and ETL Processes Integrating Data Mining with Reporting Services Data Mining in Excel Part III: Business Intelligence for Reporting Chapter 10 - Choosing the Right Business Intelligence Visualization Tool Why Do You Need to Choose? Identifying Users Selecting Tools What are the Selection Criteria? Business Capabilities Technical Capabilities How Do You Gather the Necessary Information? What are the Business Intelligence Visualization Options? Using SQL Server Reporting Services Using Power View Using Power Map How Do You Create and Complete the Evaluation Matrix? How Do You Verify and Complete the Process? Evaluation Matrix #1 Evaluation Matrix #2 Chapter 11 - Designing Operational Reports with Reporting Services What are Operational Reports and Reporting Services? Understanding Analytical versus Operational Reports Using Reporting Services What are Development Best Practices? Using Source and Version Control Using Shared Data Sources and Datasets Creating Templates What are Performance Best Practices? Investigating Performance Performance Tuning What are Functionality Best Practices? Using Visualizations Using Filters and Parameters Providing Drilldown and Drillthrough Chapter 12 - Visualizing Your Data Interactively with Power View Where Does Power View Fit with Your Reporting Solution? Power View System Requirements Creating Power View Data Source Connections Creating Data Sources Inside Excel Creating Data Sources Inside SharePoint Creating Power View Reports Using SharePoint to Create Power View Reports Using Multiple Views in Power View Creating Power View Visualizations Creating Tables Converting Visualizations Creating Matrices Creating Charts Creating Multiples Creating Cards Creating Maps Using Excel to Create Power View Reports Filtering Data with Power View Adding Filters Using Advanced Filters Adding Slicers Invoking Cross-Filters Adding Tiles Adding Filters to a Report URL Exporting Power View Reports Chapter 13 - Exploring Geographic and Temporal Data with Power Map How Power Map Fits into Reporting Solutions Understanding Power Map Features and Advantages Comparing Power Map to Other SQL Server Geospatial Reporting Tools Understanding Power Map Requirements Optimizing Your Data Model for Power Map Using Tours, Scenes and Layers in Power Map Defining Geography Fields in Your Data Model Defining Date and Time Fields in Your Data Model Working with Geospatial and Temporal Data Visualizing Data Aggregation Creating a Power Map Tour Visualizing Data Over Time with Rich Animations Deploying and Sharing Power Map Visualizations Sharing Power Map Tours Enhancing Power Map Deployment and Configurations in Office 365 Chapter 14 - Monitoring Your Business with PerformancePoint Services Where Does PerformancePoint Services Fit with Your Reporting Solution? Understanding PPS Features When is PPS the Right Choice? Implementing PPS Requirements for SharePoint Extending PPS Dashboards Adding PerformancePoint Time Intelligence Using Interactivity Features Adding Reporting Services Reports to PerformancePoint Extending Filters and KPIs Deployment Best Practices Following Best Practices for PerformancePoint Data Connections and Content Libraries Deploying Dashboards Across Dev, Test and Production Environments Customizing PerformancePoint SharePoint Web Parts Security and Configuration Best Practices Configuring the Unattended Service Account in SharePoint Optimizing PerformancePoint Services Application Settings Part IV: Deploying and Managing the Business Intelligence Solution Chapter 15 - Implementing a Self-Service Delivery Framework Planning a Self-Service Delivery Framework Creating a Data Governance Plan for Enterprise, Team and Personal BI Identifying Stakeholders, Subject Matter Experts and Data Stewards Understanding Industry Compliance Considerations Managing Data Quality and Master Data Identifying Target Audience and Roles Developing a Training Plan Inventorying Tools and Skillset Understanding Data Quality Services Understanding Master Data Services Managing Data Quality and Master Data in Excel Business Intelligence Features Across the Microsoft Data Platform Versions and Editions Defining Success Criteria Chapter 16 - Designing and Implementing a Deployment Plan What is a Deployment Plan? How Do You Deploy Business Intelligence Code? Using Analysis Services (Multidimensional or Tabular) Using Reporting Services How Do You Implement the Deployment Plan? Planning the Deployment Designing Scripts Documenting Steps Testing the Plan Training Your Staff Chapter 17 - Managing and Maintaining the Business Intelligence Environment Using SQL Server Reporting Services Configuring Memory Caching Data and Pre-Rendering Reports Using Execution Log Views Working with SQL Server Analysis Services Using Multidimensional Models Using Tabular Models Using SharePoint to Improve Performance Chapter 18 - Scaling the Business Intelligence Environment Why Would You Scale the Business Intelligence Environment? How Do You Scale Each Tool? Using Analysis Services (Multidimensional or Tabular) Reporting Services Using Power Pivot and Power View Summary Index ISBN - 9788126556656

Pages : 432

Untitled Document

Some More Books of Similar Interest

Standard Methods for the Examination of Water and Wastewater, 24th Edition by William C. Lipps, Ellen Burton Braun-Howland, Terry E. Baxter	Electronics (Hindi) by Vijay S. K.	Crystallography Applied to Solid State Physics by Verma, A.R.
Quantum Mechanics by Thankappan, V.K.	Laser Systems and Applications (All India) by Srivastava, S.K.	Laser Systems and Applications (AKTU) by Srivastava, S.K.

If you didn't find any required book(s),
Please mail us the details we will find it for you through our resources.
Kindly click here to send your requirement now.

OR

You may try advance search through below given search window.

Untitled Document

   Tips to get best Search results:
   1. Carefully check the spellings of words typed in the search box.
   2. Type one word in Search box to get better results.
   eg. for searching a book "Sikhism in India" just type sikhism in search box.
   3. Do not use Phrases to search a book like "Books on art of Himachal Pradesh".
   Just search for "art of Himachal Pradesh".
   4. To search a book on author, choose author in drop down menu given above
    search window before pressing Submit button.