Home > General > Applied Microsoft Business Intelligence
30%
Applied Microsoft Business Intelligence

Applied Microsoft Business Intelligence

          
5
4
3
2
1

Out of Stock


Premium quality
Premium quality
Bookswagon upholds the quality by delivering untarnished books. Quality, services and satisfaction are everything for us!
Easy Return
Easy return
Not satisfied with this product! Keep it in original condition and packaging to avail easy return policy.
Certified product
Certified product
First impression is the last impression! Address the book’s certification page, ISBN, publisher’s name, copyright page and print quality.
Secure Checkout
Secure checkout
Security at its finest! Login, browse, purchase and pay, every step is safe and secured.
Money back guarantee
Money-back guarantee:
It’s all about customers! For any kind of bad experience with the product, get your actual amount back after returning the product.
On time delivery
On-time delivery
At your doorstep on time! Get this book delivered without any delay.
Notify me when this book is in stock
Add to Wishlist

About the Book

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.

About the Author

Patrick LeBlanc is a Microsoft SQL Server and Business Intelligence Technical Solution Professional. 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.



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


Best Sellers



Product Details
  • ISBN-13: 9788126556656
  • Publisher: Wiley India Pvt Ltd
  • Language: English
  • ISBN-10: 812655665X
  • Publisher Date: 2015
  • No of Pages: 432

Related Categories

Similar Products

How would you rate your experience shopping for books on Bookswagon?

Add Photo
Add Photo

Customer Reviews

REVIEWS           
Click Here To Be The First to Review this Product
Applied Microsoft Business Intelligence
Wiley India Pvt Ltd -
Applied Microsoft Business Intelligence
Writing guidlines
We want to publish your review, so please:
  • keep your review on the product. Review's that defame author's character will be rejected.
  • Keep your review focused on the product.
  • Avoid writing about customer service. contact us instead if you have issue requiring immediate attention.
  • Refrain from mentioning competitors or the specific price you paid for the product.
  • Do not include any personally identifiable information, such as full names.

Applied Microsoft Business Intelligence

Required fields are marked with *

Review Title*
Review
    Add Photo Add up to 6 photos
    Would you recommend this product to a friend?
    Tag this Book
    Read more
    Does your review contain spoilers?
    What type of reader best describes you?
    I agree to the terms & conditions
    You may receive emails regarding this submission. Any emails will include the ability to opt-out of future communications.

    CUSTOMER RATINGS AND REVIEWS AND QUESTIONS AND ANSWERS TERMS OF USE

    These Terms of Use govern your conduct associated with the Customer Ratings and Reviews and/or Questions and Answers service offered by Bookswagon (the "CRR Service").


    By submitting any content to Bookswagon, you guarantee that:
    • You are the sole author and owner of the intellectual property rights in the content;
    • All "moral rights" that you may have in such content have been voluntarily waived by you;
    • All content that you post is accurate;
    • You are at least 13 years old;
    • Use of the content you supply does not violate these Terms of Use and will not cause injury to any person or entity.
    You further agree that you may not submit any content:
    • That is known by you to be false, inaccurate or misleading;
    • That infringes any third party's copyright, patent, trademark, trade secret or other proprietary rights or rights of publicity or privacy;
    • That violates any law, statute, ordinance or regulation (including, but not limited to, those governing, consumer protection, unfair competition, anti-discrimination or false advertising);
    • That is, or may reasonably be considered to be, defamatory, libelous, hateful, racially or religiously biased or offensive, unlawfully threatening or unlawfully harassing to any individual, partnership or corporation;
    • For which you were compensated or granted any consideration by any unapproved third party;
    • That includes any information that references other websites, addresses, email addresses, contact information or phone numbers;
    • That contains any computer viruses, worms or other potentially damaging computer programs or files.
    You agree to indemnify and hold Bookswagon (and its officers, directors, agents, subsidiaries, joint ventures, employees and third-party service providers, including but not limited to Bazaarvoice, Inc.), harmless from all claims, demands, and damages (actual and consequential) of every kind and nature, known and unknown including reasonable attorneys' fees, arising out of a breach of your representations and warranties set forth above, or your violation of any law or the rights of a third party.


    For any content that you submit, you grant Bookswagon a perpetual, irrevocable, royalty-free, transferable right and license to use, copy, modify, delete in its entirety, adapt, publish, translate, create derivative works from and/or sell, transfer, and/or distribute such content and/or incorporate such content into any form, medium or technology throughout the world without compensation to you. Additionally,  Bookswagon may transfer or share any personal information that you submit with its third-party service providers, including but not limited to Bazaarvoice, Inc. in accordance with  Privacy Policy


    All content that you submit may be used at Bookswagon's sole discretion. Bookswagon reserves the right to change, condense, withhold publication, remove or delete any content on Bookswagon's website that Bookswagon deems, in its sole discretion, to violate the content guidelines or any other provision of these Terms of Use.  Bookswagon does not guarantee that you will have any recourse through Bookswagon to edit or delete any content you have submitted. Ratings and written comments are generally posted within two to four business days. However, Bookswagon reserves the right to remove or to refuse to post any submission to the extent authorized by law. You acknowledge that you, not Bookswagon, are responsible for the contents of your submission. None of the content that you submit shall be subject to any obligation of confidence on the part of Bookswagon, its agents, subsidiaries, affiliates, partners or third party service providers (including but not limited to Bazaarvoice, Inc.)and their respective directors, officers and employees.

    Accept

    New Arrivals



    Inspired by your browsing history


    Your review has been submitted!

    You've already reviewed this product!