Books & Videos

Table of Contents

    1. Chapter 1 SharePoint, Apps, and Business Intelligence

      1. So What Does All This Have to Do with Business Intelligence?
    2. Chapter 2 Choosing the Right Tools for the Job

      1. Technology Selection Goals
      2. Solution Components
      3. Visual Studio LightSwitch
      4. SharePoint Server 2010-2013
      5. SharePoint Development: Past, Present, and Future
      6. SQL Server 2012 for Business Intelligence
      7. Summary
    3. Chapter 3 Basic Concepts of Relational Database Design

      1. Normalization
      2. Many-to-Many Relationships
      3. Summary
    1. Chapter 4 Why You Need LightSwitch

      1. Traditional SharePoint Development Is Difficult
      2. Custom Development Is Tedious
      3. Build Custom Apps, Coding Optional
    2. Chapter 5 Start with Data

      1. Defining Basic Fields and Data Types
      2. Using the Properties Window
      3. Enhancing a String with a Choice List
      4. Setting Default Values
      5. Adding Relationships
      6. Business Types
      7. Defining Uniqueness
      8. Practicing What We Just Learned
      9. Calculated Computed Properties
      10. Advanced Relationships
      11. Summary
    3. Chapter 6 Screens: The LightSwitch User Interface

      1. Creating Screens
      2. Creating a Modal Window
      3. Summary
    4. Chapter 7 Adding Business Logic

      1. Change Tracking in LightSwitch
      2. Factoring Out Repeated Logic
      3. Customizing the Add and Edit Buttons
      4. Designing Running Screens
      5. Creating a Custom Details Page
      6. Custom Validation
      7. Summary
    5. Chapter 8 Application Security, Access Control, and Personalizing Your Application

      1. Enabling Authentication: Windows or Forms
      2. Adding a Welcome Message Using Our ViewModel
      3. Summary
    6. Chapter 9 Running and Debugging Our Application

      1. The LightSwitch Runtime Experience
      2. The LightSwitch Grid Control
      3. Search
      4. Running as a Web Application
      5. Summary
    7. Chapter 10 LightSwitch with SharePoint Data

      1. Logical SharePoint Architecture
      2. Adding a SharePoint Data Source
      3. Populating the Knowledge Base
      4. Summary
    8. Chapter 11 Deploying Your LightSwitch Application

      1. The Application Designer
      2. The Publishing Wizard
      3. Deploying Your Packages to the Server
      4. Summary
    1. Chapter 12 Introduction to Business Intelligence

      1. What Is Business Intelligence?
      2. Applications of Business Intelligence
      3. Microsoft’s Tools for Business Intelligence
      4. Summary
    2. Chapter 13 Business Intelligence Semantic Model (BISM)

      1. Why Business Intelligence Semantic Model?
      2. BISM Design Goals
      3. Business Intelligence Semantic Model Architecture
      4. Consuming Data from OData Sources
      5. How Do Existing Analysis Services Applications Translate to the New Semantic Model?
      6. Pros and Cons of the New BI Tabular Data Model
      7. How Do the Data Access Methodologies Stack Up?
      8. Business Logic
      9. DAX Syntax
      10. Getting Started with DAX
    3. Chapter 14 Populating Sample Data into Our Database

      1. Downloading Adventure Works Data from Microsoft
      2. Attaching the Database
      3. Importing People from Adventure Works
      4. Synthesizing Help Desk Queues from Adventure Works
      5. Importing Tickets from Adventure Works
      6. Review the Results
    4. Chapter 15 Building the Help Desk Tabular Cube

      1. Importing SQL Server Data into PowerPivot
      2. Connecting Excel to the PowerPivot Model
      3. Importing Data from the Windows Azure Marketplace DataMarket
      4. Summary
    5. Chapter 16 Enriching the Cube: Relationships and DAX

      1. Relationships in PowerPivot
      2. Manually Adding Relationships
      3. Traversing Relationships with DAX
      4. Hiding Columns and Tables from Client Tools
      5. Using DAX to Aggregate Rows in a Related Table
      6. Calculating Earliest and Latest Related Dates with DAX
      7. Parsing Strings with DAX
      8. Counting and Aggregating Related Rows with DAX
      9. Count of Distinct Values with DAX
      10. Calculating the Difference Between Dates with DAX
      11. Adding a Measure from the Excel Side
      12. Counting Rows Across an Inactive Relationship
      13. Creating a Hierarchy for Dates
      14. Looking Up Related Data Without an Active Relationship
      15. Summary
    6. Chapter 17 Deploying to SharePoint

      1. Sharing with Your Team
      2. Summary
    7. Chapter 18 SQL Server Analysis Services (SSAS)

      1. Scalability
      2. Manageability
      3. Security
      4. Development Tools
      5. Direct Feature Comparison
      6. Upgrading a PowerPivot Workbook to a Tabular Model
      7. Validating the Deployment
      8. Automating Processing Your Cube
      9. Summary
    1. Chapter 19 PivotTable Basics

      1. Meaning from Data
      2. The Universal Business Intelligence ToolComment [RR1]: Should the first ...pages be a chapter on Excel 2012 or maybe even an Appendix...it seems like a bunch of great but individual things you can do with you data...no flow...Comment [DMF2]: This is the chapter you broke from one huge chapter into many. I think the chapter just needs to be renamed as its really just pivot table basics. Excel continues for several chapters and excel services isn’t in this chapter anymoreComment [GM3]: I renamed it Pivot Table Basics.
      3. PivotTables
      4. Ranking Largest to Smallest
      5. Percentage of Parent Row
      6. Filtering and Sorting PivotTable Dimensions
      7. Visual Totals
      8. Values on Rows
      9. PivotCharts
      10. Summary
    2. Chapter 20 Slicers

      1. Inserting an Additional PivotTable
      2. Connecting Additional PivotTables to Slicers
      3. Summary
    3. Chapter 21 Formatting

      1. Custom Slicer Formatting
      2. Disabling Gridlines and Headings
      3. Formatting PivotTables and PivotCharts
      4. Summary
    4. Chapter 22 PivotTable Named Sets

      1. Scenario: Last Four Years of Ticket Counts and Total Average Time to Closure
      2. Reusing a Named Set for Another Chart
      3. Summary
    5. Chapter 23 Sparklines and Data Bars

      1. Sparklines: Intense, Simple, Word-Sized Graphics
      2. Adding a Data Bar
      3. Summary
    6. Chapter 24 Configuring a Gallery for Reporting Services, Power View, and Excel Services

      1. Enabling Required Features
      2. Creating the PowerPivot Gallery
      3. Enabling Business Intelligence Content Types
      4. Setting Up Your Default View
      5. Summary
    7. Chapter 25 Reporting Services Basics

      1. What Is Reporting Services?
      2. Report Architecture
      3. Creating a Reporting Services Data Source
      4. Launching Report Builder 3.0
      5. Creating Datasets
      6. Creating a Reporting Services Report
      7. Adding a Chart
      8. Consuming an OData Feed from Reporting Services
      9. Summary
    8. Chapter 26 Advanced Reporting Services Charting

      1. Create a Drill-Down Report
      2. Two Approaches to Drill-Down Reporting
      3. Basic Drill-Down Reports
      4. Advanced Pop-Up Window Drill-Down Report
      5. Summary
    9. Chapter 27 Subscriptions and Data Alerts

      1. Report Subscriptions and Delivery
      2. How Does It Work?
      3. Setting Up a Report
      4. Common Scenarios for Subscriptions
      5. Data Alerts
      6. Summary
    10. Chapter 28 Excel Services and Power View

      1. What Is Excel Services?
      2. What Is Power View?
      3. Why Are We Talking About Excel Services and Power View Together?
      4. Publishing a PowerPivot Model to Excel Services
      5. Using Excel Services 2013 as an OData Feed
      6. Using Power View on a PowerPivot Model
      7. Saving Your Power View
      8. Exporting to PowerPoint
      9. Connecting to Tabular CubesComment [GM4]: AU: This section needs some fleshing out. Can you review it?Comment [GM5]: PROD: The author fleshed out this section. I made some grammatical corrections; can you reapply styles (body text and num list)?
      10. Summary
    11. Chapter 29 What’s Next for Excel and Power View 2013

      1. Quick Explore
      2. PowerPivot and Power View Are Built into Excel 2013
      3. Power View Maps
      4. Power View Hierarchies and Drill DownComment [GM3]: AU: Please add content between the two headings, or combine the headings into one.Comment [DMF4]: Removed the 2nd
      5. Power View Pie Charts, Slices, and Drill Down
      6. Enabling Tabular Drill Down with the Matrix
      7. Key Performance Indicators
      8. SummaryComment [GM10]:
    1. Chapter 30 Architecture to Support SharePoint BI

      1. SharePoint Architecture with SQL 2012 BI
      2. SharePoint 2013 Changes
      3. Summary
    2. Chapter 31 The Infrastructure

      1. The Environment
      2. Microsoft SharePoint 2010
      3. Visual Studio LightSwitch 2011
      4. SQL Server
      5. SQL Server Licensing
      6. Summary
    3. Chapter 32 Your Environment

      1. Server Requirements
      2. Logical Requirements
      3. Recommended Specs
      4. Summary
    4. Chapter 33 Active Directory

      1. Before Setting Up Active Directory
      2. Creating the Active Directory
      3. Managing Service Accounts
      4. Security in Active Directory
      5. Summary
    5. Chapter 34 Visual Studio LightSwitch

      1. Visual Studio LightSwitch Client-Side Installation
      2. Visual Studio LightSwitch Server-Side Implementation
      3. Summary
    6. Chapter 35 Installing the BI Components for SharePoint

      1. SQL 2012 for PowerPivot on the App Tier
      2. Summary
    7. Chapter 36 PowerPivot Instance Configuration

      1. Initial PowerPivot Instance Configuration
      2. Summary
    8. Chapter 37 PowerPivot Service Application Configuration

      1. PowerPivot Management Dashboard Setup
      2. Request Allocation
      3. Using the PowerPivot Management Dashboard
      4. Summary
    9. Chapter 38 Excel Services ConfigurationComment [GM1]: PROD: Global - move figures to appear after their references in text.

      1. Excel Services and the Secure Store
      2. Allow Cross-Domain Access
      3. Summary
    10. Chapter 39 Office Client Configuration of PowerPivot and Power View

      1. Getting Started
      2. The Light-Up Story for PowerPivot and Power View in Office 2013
      3. Power View Light Up on SharePoint
      4. Summary
    11. Chapter 40 SQL Server Reporting Services Configuration

      1. Provisioning Subscriptions and Alerts
      2. Email Configuration
      3. Key Management
      4. Leveraging EffectiveUserName
      5. Summary
  1. Colophon