Title Pro SQL Server 2012 BI solutions / Randal Root, Caryn Mason

Published [Place of publication not identified] : Apress, 2012 (New York, NY : Distributed to the Book trade worldwide by Springer Science+Business Media New York)

Click on the following:
O'Reilly

Copies

Description 1 online resource (1 volume) : illustrations, portraits Series The expert's voice in SQL server Expert's voice in SQL server. Contents Machine generated contents note: ch. 1 Business Intelligence Solutions -- Who Should Read This Book? -- What Is a Business Intelligence Solution? -- Step 1 Interview and Identify Data -- Step 2 Plan the BI Solution -- Step 3 Create a Data Warehouse -- Step 4 Create an ETL Process -- Step 5 Create Cubes -- Step 6 Create Reports -- Step 7 Test and Tune the Solution -- Step 8 Approve, Release and Prepare -- Practice Exercises and More -- Downloadable Content -- Our Example Scenarios -- Setup Instructions -- Think Small, Win Big -- Rapid Application Development for BI Solutions -- Moving On -- What's Next? -- ch. 2 Big-Picture Overview -- 10,000-Foot View -- Interviewing and Isolating Data -- Plan the Solution -- Creating Planning Documents -- Adding Documents to Visual Studio -- Creating the Data Warehouse -- Example Data Warehouse -- Using SQL Code to Create a Data Warehouse -- Running SQL Code from Visual Studio -- Create the ETL Process -- ETL with an SSIS Project -- Creating an SSIS Package -- Outlining the Control Flow Tasks -- SSIS Connections -- Configuring an Execute SQL Task -- Configuring Data Flow Tasks -- Configuring Additional Data Flows -- Configuring a Data Source -- Executing an SSIS Task -- Completing the Package Execution -- Creating a Cube -- Making a Connection to the Data Warehouse -- Creating a Data Source View -- Creating Dimensions -- Creating Cubes -- Deploying and Processing -- Creating Reports -- Using the SSRS Wizard -- Manually Creating SSRS Reports -- Testing the Solution -- Approve, Release, and Prepare -- Moving On -- What's Next? -- ch. 3 Planning Solutions -- Outline the Steps in the Process -- Interviewing -- Why Do We Need It? -- What Are We Building? -- How Long Will It Take to Build? -- How Will We Build It? -- Who Will We Get to Build It? -- When Will We Need It? -- How Will We Finish It? -- "Hey, Wait! I'm a Developer, Not a Manager" -- Documenting the Requirements -- Locating Data -- Defining the Roles -- Defining the Team -- Determining the Schedule -- IT, Security and Licensing Requirements -- Estimating the Cost -- Documenting the Solution Plan -- Implementation -- Moving On -- What's Next? -- ch. 4 Designing a Data Warehouse -- What Is a Data Warehouse? -- What Is a Data Mart? -- Competing Definitions -- Starting with an OLTP Design -- Typical OLTP Database Design -- Normalized Tables -- Table Relationships -- Many-to-Many Tables -- One-to-Many Tables -- Parent -- Child One-to-Many Tables -- Typical Data Warehouse Database Design -- Measures -- Fact Table -- Dimensions -- Stars and Snowflakes -- Performance Considerations -- Comparing Designs -- Foreign Keys -- Missing Features -- Dimensional Patterns -- Standard Dimensions -- Fact or Degenerate Dimensions -- Time Dimensions -- Role-Playing Dimensions -- Parent -- Child Dimensions -- Junk Dimensions -- Many-to-Many Dimensions -- Conformed Dimensions -- Adding Surrogate Keys -- Slowly Changing Dimensions -- Type I -- Type II -- Type III -- Moving On -- What's Next? -- ch. 5 Creating a Data Warehouse -- SQL Server Management Studio -- Connecting to Servers -- Configuration Manager -- Management Studio Windows -- Object Explorer -- Query Window -- Changing the Query Window Focus -- Executing a Query -- Creating Data Warehouse Database -- Setting the Database Owner -- Setting the Database Size -- Setting the Recovery Model -- Keeping Data Warehouse Backups -- Using the Filegroups Option -- Creating Tables -- Using the Table Designer -- Using the Diagramming Tool -- Using the Query Window -- Creating a Date Dimension Table -- Getting Organized -- Backing Up the Data Warehouse -- Scripting the Database -- Organizing Your Files with Visual Studio -- Moving On -- What's Next? -- ch. 6 ETL Processing with SQL -- Performing the ETL Programming -- Deciding on Full or Incremental Loading -- Isolating the Data to Be Extracted -- Formatting Your Code -- Identifying the Transformation Logic -- Programming Your Transformation Logic -- Reducing the Data -- Using Column Aliases -- Converting the Data Types -- Looking Up Surrogate Key Values -- Provide Conformity -- Generate Date Data -- Dealing with Nulls -- SQL Query Designer -- Updating Your BI Documentation -- Building an ETL Script -- Working in the Abstract -- Views -- Stored Procedures -- User-Defined Functions -- Moving On -- What's Next? -- ch. 7 Beginning the ETL Process with SSIS -- Starting Your SSIS Project -- Adding a Project to an Existing Solution -- Renaming Your SSIS Package -- Anatomy of an SSIS Package -- Control Flow Tab -- Data Flow Tab -- Using Sequence Containers -- Using Precedence Constraint Arrows -- SSIS Variables -- Outlining Your ETL Process -- Data Connections -- File Connection Manager -- OLE DB Connection Manager -- ADO.NET Connection Manager -- Configuring a Connection -- Execute SQL Tasks -- Editing Your Execute SQL Task -- Executing Your Execute SQL Tasks -- Progress/Execution Results Tabs -- Resetting Your Destination Database -- Moving On -- What's Next? -- ch. 8 Concluding the ETL Process with SSIS -- Data Flows -- Outlining a Data Flow Task -- Configuring the Data Source -- OLE DB Source Editor -- Connection Manager Page -- Columns Manager Page -- Error Output Page -- Data Flow Paths -- Error Outputs Paths -- Configuring the Data Destination -- Connection Manager Page -- Mappings Page -- Error Output Page -- Executing the Entire Package -- Moving On -- What's Next? -- ch. 9 Beginning the SSAS Project -- SQL Server vs. Analysis Server Databases -- OLAP Cubes vs. Reporting Tables -- SQL Server vs. Analysis Server Applications -- SSAS Projects -- Data Sources -- Define a Connection -- Impersonation Information -- Data Source Views -- Data Source View Wizard -- Data Source View Designer -- Dimensions -- Dimension Wizard -- Moving On -- What's Next? -- ch. 10 Configuring Dimensions with SSAS -- Dimension Designer -- Dimension Structure Tab -- Attribute Relationships Tab -- Testing Your Progress -- Translations Tab -- Browser Tab -- Build, Deploy, and Process -- Building -- Deploying -- Processing -- Browsing the Dimension -- Moving On -- What's Next? -- ch. 11 Creating and Configuring SSAS Cubes -- Creating Cubes -- Processing the Cube -- Configuring Cubes -- Browser Tab -- Validate the Measures -- Review the Dimensions -- Validating the Results -- Cube Structure Tab -- Common Measure Properties -- Measure Group Properties -- Dimension Usage Tab -- Configuring a Relationship -- Calculations Tab -- Adding a Calculated Member -- Configuring a Calculated Member -- Calculated Members vs. Derived Members -- Making a Test Copy of a Cube -- KPIs -- Moving On -- What's Next? -- ch. 12 Additional Cube and Dimension Configurations -- Additional Cube Configurations -- Actions -- Partitions -- Aggregations -- Perspectives -- Translations -- Browser -- Additional Dimension Configurations -- Parent-Child Dimensions -- Role-Playing Dimensions -- Reference Dimensions -- Managing Your Cubes and Dimensions -- SQL Server Management Studio -- Visual Studio (Live) -- Moving On -- What's Next? -- ch. 13 Creating Reports with SQL Queries -- Identifying the Data -- Joining Table Data -- Ordering Results -- Formatting Results Using SQL Functions -- Filtering Results -- Adding Dynamic Filters with Parameters -- Adding Aggregations -- Using Subqueries -- Creating KPI Queries -- Adding Abstraction Layers -- Using Views -- Using Stored Procedures -- Using Your Code in Reporting Applications -- Moving On -- What's Next? -- ch 14 Reporting with MDX Queries -- Key Concepts and Terms -- Programming with MDX -- Comments -- Basic and Raw Syntax -- Running Your MDX Code -- Optional Syntax -- Default Members -- Using Key vs. Name Identifiers -- Using the Axis 0 and 1 Instead of Column and Row -- Cells and Tuples -- Calculated Members -- Member Properties -- Members and Levels -- NonEmpty Function -- Non Empty Clause -- Member and Level Paths -- Common Functions -- PrevMember and NextMember Functions -- Using Your Code in Reporting Applications -- Moving On -- What Next? -- ch. 15 Reporting with Microsoft Excel -- Microsoft's BI Reporting -- Excel Reports from the Data Warehouse -- Creating a Connection -- Creating a Report -- Configuring a Report -- Changing Connection Properties -- Reconfiguring a Connection -- Using Stored Procedures -- Working with Excel Reports from a Cube -- Connecting to Your Cube -- Testing Your Reports -- Creating Charts -- Adding a Header -- Saving to PDF -- Moving On -- What's Next? -- ch. 16 Creating Reports with SSRS -- SSRS Architecture -- Developer Tools -- Administrative Services -- SSRS Services -- SSRS Databases -- SSRS Configuration Manager -- Creating SSRS Objects -- Data Sources -- Datasets -- Reports -- Managing the Report -- Moving On -- What's Next? -- ch. 17 Configuring Reports with SSRS -- Creating a Report Template -- Adding a Header and Footer -- Setting Report Properties -- Page Size and Report Margins -- Designing the Header -- Rectangles -- Textboxes -- Images -- Lines -- Renaming Report Items -- Using Expressions -- Category and Item Panes -- Expression Editing Pane -- Placeholders -- Variables -- Completing the Header -- Configuring the Footer -- Saving the Report Template Note continued: Using Network Templates 721 -- Using Local Templates -- Moving On -- What's Next -- ch. 18 Testing and Timing BI Solutions -- Testing the BI Solution -- Validation -- Improvement Identification -- Tuning the BI Solution -- ETL Performance -- Processing Performance -- Reporting Performance -- Common Design Strategies -- Performance Measurements -- Absolute Performance -- Relative Performance Measurements -- Measuring Performance with SQL Profiler -- Example Scenario -- Creating a Metadata Database -- Moving On -- What's Next -- ch. 19 Approve, Release, and Prepare -- End of the Cycle -- Final Approval Process -- Sign-Off Document -- Announcing the Release -- Press Release Title -- Press Release Body -- Press Release Boilerplate -- Releasing the Solution -- Collecting the Solution Artifacts -- Deploying the Files -- Release Documentation -- SDKs -- Developer Specifications -- User Documentation -- Style Guides -- User Manuals -- Help Files -- User Training -- Say Thank You -- Moving On -- What's Next? Summary Business intelligence projects do not need to cost multi-millions of dollars or take months or even years to complete! Using rapid application development (RAD) techniques along with Microsoft SQL Server 2012, this book guides database administrators, SQL programmers, and report specialists in creating practical, cost-effective business intelligence solutions for their companies and departments. Pro SQL Server 2012 BI Solutions provides practical examples of cost-effective business intelligence projects. Readers will be guided through several complete projects that build a foundation for real-world solutions. Even with limited experience using Microsoft's SQL Server, Integration Server, Analysis Server, and Reporting Server, you can leverage your existing knowledge of SQL programming and database design to provide users with the business intelligence reports they need. Provides recipes for multiple business intelligence scenarios Progresses from simple to advanced projects using several examples Shows Microsoft SQL Server technology used to complete real-world business intelligence projects Notes Print version record SUBJECT SQL server. http://id.loc.gov/authorities/names/n90684343 SQL server. blmlsh SQL server fast Subject Client/server computing. Business intelligence -- Computer programs Client/server computing Form Electronic book Author Mason, Caryn ISBN 9781430234883 1430234881 9781430234890 143023489X

Other Titles Pro SQL Server 2012 Business intelligence solutions

  Permalink