Library Hours
Monday to Friday: 9 a.m. to 9 p.m.
Saturday: 9 a.m. to 5 p.m.
Sunday: 1 p.m. to 9 p.m.
Naper Blvd. 1 p.m. to 5 p.m.
LEADER 00000cam a2200625Ia 4500
001 825821728
003 OCoLC
005 20240129213017.0
006 m o d
007 cr unu||||||||
008 130129s2012 xx ac o 001 0 eng d
019 966397993|a969781109|a985041383|a1005750246
020 9781430234883
020 1430234881
020 9781430234890
020 143023489X
029 1 AU@|b000050591368
029 1 AU@|b000053294097
029 1 DEBBG|bBV041120568
029 1 DEBSZ|b396754678
035 (OCoLC)825821728|z(OCoLC)966397993|z(OCoLC)969781109
|z(OCoLC)985041383|z(OCoLC)1005750246
037 CL0500000188|bSafari Books Online
040 UMI|beng|epn|cUMI|dCOO|dDEBSZ|dOCLCQ|dCAUOI|dYDXCP|dOCLCQ
|dTXI|dOCLCQ|dVT2|dLIV|dOCLCQ|dOCLCO|dOCLCF|dCEF|dINT
|dOCLCQ|dOCLCO|dWYU|dUWO|dDEHBZ|dTKN|dOCLCQ|dUAB|dUKAHL
|dOCLCQ|dOCLCO|dBRF|dOCLCO|dOCLCQ|dOCLCO
049 INap
082 04 004.36
082 04 004.36|222
099 eBook O’Reilly for Public Libraries
100 1 Root, Randal.
245 10 Pro SQL Server 2012 BI solutions /|cRandal Root, Caryn
Mason.|h[O'Reilly electronic resource]
246 3 Pro SQL Server 2012 Business intelligence solutions
260 [Place of publication not identified] :|bApress,|c2012
|e(New York, NY :|fDistributed to the Book trade worldwide
by Springer Science+Business Media New York)
300 1 online resource (1 volume) :|billustrations, portraits
336 text|btxt|2rdacontent
337 computer|bc|2rdamedia
338 online resource|bcr|2rdacarrier
490 1 The expert's voice in SQL server
505 00 |gMachine generated contents note:|gch. 1|tBusiness
Intelligence Solutions --|tWho Should Read This Book? --
|tWhat Is a Business Intelligence Solution? --|gStep 1
|tInterview and Identify Data --|gStep 2|tPlan the BI
Solution --|gStep 3|tCreate a Data Warehouse --|gStep 4
|tCreate an ETL Process --|gStep 5|tCreate Cubes --|gStep
6|tCreate Reports --|gStep 7|tTest and Tune the Solution -
-|gStep 8|tApprove, Release and Prepare --|tPractice
Exercises and More --|tDownloadable Content --|tOur
Example Scenarios --|tSetup Instructions --|tThink Small,
Win Big --|tRapid Application Development for BI Solutions
--|tMoving On --|tWhat's Next? --|gch. 2|tBig-Picture
Overview --|t10,000-Foot View --|tInterviewing and
Isolating Data --|tPlan the Solution --|tCreating Planning
Documents --|tAdding Documents to Visual Studio --
|tCreating the Data Warehouse --|tExample Data Warehouse -
-|tUsing SQL Code to Create a Data Warehouse --|tRunning
SQL Code from Visual Studio --|tCreate the ETL Process --
|tETL with an SSIS Project --|tCreating an SSIS Package --
|tOutlining the Control Flow Tasks --|tSSIS Connections --
|tConfiguring an Execute SQL Task --|tConfiguring Data
Flow Tasks --|tConfiguring Additional Data Flows --
|tConfiguring a Data Source --|tExecuting an SSIS Task --
|tCompleting the Package Execution --|tCreating a Cube --
|tMaking a Connection to the Data Warehouse --|tCreating a
Data Source View --|tCreating Dimensions --|tCreating
Cubes --|tDeploying and Processing --|tCreating Reports --
|tUsing the SSRS Wizard --|tManually Creating SSRS Reports
--|tTesting the Solution --|tApprove, Release, and Prepare
--|tMoving On --|tWhat's Next? --|gch. 3|tPlanning
Solutions --|tOutline the Steps in the Process --
|tInterviewing --|tWhy Do We Need It? --|tWhat Are We
Building? --|tHow Long Will It Take to Build? --|tHow Will
We Build It? --|tWho Will We Get to Build It? --|tWhen
Will We Need It? --|tHow Will We Finish It? --|t"Hey,
Wait! I'm a Developer, Not a Manager" --|tDocumenting the
Requirements --|tLocating Data --|tDefining the Roles --
|tDefining the Team --|tDetermining the Schedule --|tIT,
Security and Licensing Requirements --|tEstimating the
Cost --|tDocumenting the Solution Plan --|tImplementation
--|tMoving On --|tWhat's Next? --|gch. 4|tDesigning a Data
Warehouse --|tWhat Is a Data Warehouse? --|tWhat Is a Data
Mart? --|tCompeting Definitions --|tStarting with an OLTP
Design --|tTypical OLTP Database Design --|tNormalized
Tables --|tTable Relationships --|tMany-to-Many Tables --
|tOne-to-Many Tables --|tParent -- Child One-to-Many
Tables --|tTypical Data Warehouse Database Design --
|tMeasures --|tFact Table --|tDimensions --|tStars and
Snowflakes --|tPerformance Considerations --|tComparing
Designs --|tForeign Keys --|tMissing Features --
|tDimensional Patterns --|tStandard Dimensions --|tFact or
Degenerate Dimensions --|tTime Dimensions --|tRole-Playing
Dimensions --|tParent -- Child Dimensions --|tJunk
Dimensions --|tMany-to-Many Dimensions --|tConformed
Dimensions --|tAdding Surrogate Keys --|tSlowly Changing
Dimensions --|tType I --|tType II --|tType III --|tMoving
On --|tWhat's Next? --|gch. 5|tCreating a Data Warehouse -
-|tSQL Server Management Studio --|tConnecting to Servers
--|tConfiguration Manager --|tManagement Studio Windows --
|tObject Explorer --|tQuery Window --|tChanging the Query
Window Focus --|tExecuting a Query --|tCreating Data
Warehouse Database --|tSetting the Database Owner --
|tSetting the Database Size --|tSetting the Recovery Model
--|tKeeping Data Warehouse Backups --|tUsing the
Filegroups Option --|tCreating Tables --|tUsing the Table
Designer --|tUsing the Diagramming Tool --|tUsing the
Query Window --|tCreating a Date Dimension Table --
|tGetting Organized --|tBacking Up the Data Warehouse --
|tScripting the Database --|tOrganizing Your Files with
Visual Studio --|tMoving On --|tWhat's Next? --|gch. 6
|tETL Processing with SQL --|tPerforming the ETL
Programming --|tDeciding on Full or Incremental Loading --
|tIsolating the Data to Be Extracted --|tFormatting Your
Code --|tIdentifying the Transformation Logic --
|tProgramming Your Transformation Logic --|tReducing the
Data --|tUsing Column Aliases --|tConverting the Data
Types --|tLooking Up Surrogate Key Values --|tProvide
Conformity --|tGenerate Date Data --|tDealing with Nulls -
-|tSQL Query Designer --|tUpdating Your BI Documentation -
-|tBuilding an ETL Script --|tWorking in the Abstract --
|tViews --|tStored Procedures --|tUser-Defined Functions -
-|tMoving On --|tWhat's Next? --|gch. 7|tBeginning the ETL
Process with SSIS --|tStarting Your SSIS Project --
|tAdding a Project to an Existing Solution --|tRenaming
Your SSIS Package --|tAnatomy of an SSIS Package --
|tControl Flow Tab --|tData Flow Tab --|tUsing Sequence
Containers --|tUsing Precedence Constraint Arrows --|tSSIS
Variables --|tOutlining Your ETL Process --|tData
Connections --|tFile Connection Manager --|tOLE DB
Connection Manager --|tADO.NET Connection Manager --
|tConfiguring a Connection --|tExecute SQL Tasks --
|tEditing Your Execute SQL Task --|tExecuting Your Execute
SQL Tasks --|tProgress/Execution Results Tabs --
|tResetting Your Destination Database --|tMoving On --
|tWhat's Next? --|gch. 8|tConcluding the ETL Process with
SSIS --|tData Flows --|tOutlining a Data Flow Task --
|tConfiguring the Data Source --|tOLE DB Source Editor --
|tConnection Manager Page --|tColumns Manager Page --
|tError Output Page --|tData Flow Paths --|tError Outputs
Paths --|tConfiguring the Data Destination --|tConnection
Manager Page --|tMappings Page --|tError Output Page --
|tExecuting the Entire Package --|tMoving On --|tWhat's
Next? --|gch. 9|tBeginning the SSAS Project --|tSQL Server
vs. Analysis Server Databases --|tOLAP Cubes vs. Reporting
Tables --|tSQL Server vs. Analysis Server Applications --
|tSSAS Projects --|tData Sources --|tDefine a Connection -
-|tImpersonation Information --|tData Source Views --
|tData Source View Wizard --|tData Source View Designer --
|tDimensions --|tDimension Wizard --|tMoving On --|tWhat's
Next? --|gch. 10|tConfiguring Dimensions with SSAS --
|tDimension Designer --|tDimension Structure Tab --
|tAttribute Relationships Tab --|tTesting Your Progress --
|tTranslations Tab --|tBrowser Tab --|tBuild, Deploy, and
Process --|tBuilding --|tDeploying --|tProcessing --
|tBrowsing the Dimension --|tMoving On --|tWhat's Next? --
|gch. 11|tCreating and Configuring SSAS Cubes --|tCreating
Cubes --|tProcessing the Cube --|tConfiguring Cubes --
|tBrowser Tab --|tValidate the Measures --|tReview the
Dimensions --|tValidating the Results --|tCube Structure
Tab --|tCommon Measure Properties --|tMeasure Group
Properties --|tDimension Usage Tab --|tConfiguring a
Relationship --|tCalculations Tab --|tAdding a Calculated
Member --|tConfiguring a Calculated Member --|tCalculated
Members vs. Derived Members --|tMaking a Test Copy of a
Cube --|tKPIs --|tMoving On --|tWhat's Next? --|gch. 12
|tAdditional Cube and Dimension Configurations --
|tAdditional Cube Configurations --|tActions --
|tPartitions --|tAggregations --|tPerspectives --
|tTranslations --|tBrowser --|tAdditional Dimension
Configurations --|tParent-Child Dimensions --|tRole-
Playing Dimensions --|tReference Dimensions --|tManaging
Your Cubes and Dimensions --|tSQL Server Management Studio
--|tVisual Studio (Live) --|tMoving On --|tWhat's Next? --
|gch. 13|tCreating Reports with SQL Queries --
|tIdentifying the Data --|tJoining Table Data --|tOrdering
Results --|tFormatting Results Using SQL Functions --
|tFiltering Results --|tAdding Dynamic Filters with
Parameters --|tAdding Aggregations --|tUsing Subqueries --
|tCreating KPI Queries --|tAdding Abstraction Layers --
|tUsing Views --|tUsing Stored Procedures --|tUsing Your
Code in Reporting Applications --|tMoving On --|tWhat's
Next? --|gch.
505 00 |t14|tReporting with MDX Queries --|tKey Concepts and
Terms --|tProgramming with MDX --|tComments --|tBasic and
Raw Syntax --|tRunning Your MDX Code --|tOptional Syntax -
-|tDefault Members --|tUsing Key vs. Name Identifiers --
|tUsing the Axis 0 and 1 Instead of Column and Row --
|tCells and Tuples --|tCalculated Members --|tMember
Properties --|tMembers and Levels --|tNonEmpty Function --
|tNon Empty Clause --|tMember and Level Paths --|tCommon
Functions --|tPrevMember and NextMember Functions --
|tUsing Your Code in Reporting Applications --|tMoving On
--|tWhat Next? --|gch. 15|tReporting with Microsoft Excel
--|tMicrosoft's BI Reporting --|tExcel Reports from the
Data Warehouse --|tCreating a Connection --|tCreating a
Report --|tConfiguring a Report --|tChanging Connection
Properties --|tReconfiguring a Connection --|tUsing Stored
Procedures --|tWorking with Excel Reports from a Cube --
|tConnecting to Your Cube --|tTesting Your Reports --
|tCreating Charts --|tAdding a Header --|tSaving to PDF --
|tMoving On --|tWhat's Next? --|gch. 16|tCreating Reports
with SSRS --|tSSRS Architecture --|tDeveloper Tools --
|tAdministrative Services --|tSSRS Services --|tSSRS
Databases --|tSSRS Configuration Manager --|tCreating SSRS
Objects --|tData Sources --|tDatasets --|tReports --
|tManaging the Report --|tMoving On --|tWhat's Next? --
|gch. 17|tConfiguring Reports with SSRS --|tCreating a
Report Template --|tAdding a Header and Footer --|tSetting
Report Properties --|tPage Size and Report Margins --
|tDesigning the Header --|tRectangles --|tTextboxes --
|tImages --|tLines --|tRenaming Report Items --|tUsing
Expressions --|tCategory and Item Panes --|tExpression
Editing Pane --|tPlaceholders --|tVariables --|tCompleting
the Header --|tConfiguring the Footer --|tSaving the
Report Template.
505 00 |gNote continued:|tUsing Network Templates 721 --|tUsing
Local Templates --|tMoving On --|tWhat's Next --|gch. 18
|tTesting and Timing BI Solutions --|tTesting the BI
Solution --|tValidation --|tImprovement Identification --
|tTuning the BI Solution --|tETL Performance --
|tProcessing Performance --|tReporting Performance --
|tCommon Design Strategies --|tPerformance Measurements --
|tAbsolute Performance --|tRelative Performance
Measurements --|tMeasuring Performance with SQL Profiler -
-|tExample Scenario --|tCreating a Metadata Database --
|tMoving On --|tWhat's Next --|gch. 19|tApprove, Release,
and Prepare --|tEnd of the Cycle --|tFinal Approval
Process --|tSign-Off Document --|tAnnouncing the Release -
-|tPress Release Title --|tPress Release Body --|tPress
Release Boilerplate --|tReleasing the Solution --
|tCollecting the Solution Artifacts --|tDeploying the
Files --|tRelease Documentation --|tSDKs --|tDeveloper
Specifications --|tUser Documentation --|tStyle Guides --
|tUser Manuals --|tHelp Files --|tUser Training --|tSay
Thank You --|tMoving On --|tWhat's Next?
520 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.
588 0 Print version record.
590 O'Reilly|bO'Reilly Online Learning: Academic/Public
Library Edition
630 00 SQL server.
630 07 SQL server.|2blmlsh
630 07 SQL server|2fast
650 0 Client/server computing.
650 0 Business intelligence|xComputer programs.
650 6 Architecture client-serveur (Informatique)
650 7 Client/server computing|2fast
700 1 Mason, Caryn.
776 08 |iPrint version:|aRoot, Randal.|tPro SQL Server 2012 BI
solutions.|d[New York] : Apress ; Distributed to the book
trade worldwide by Springer Science+Business Media New
York, ©2012|z9781430234883|w(OCoLC)748329680
830 0 Expert's voice in SQL server.
856 40 |uhttps://ezproxy.naperville-lib.org/login?url=https://
learning.oreilly.com/library/view/~/9781430234883/?ar
|zAvilable on O'Reilly for Public Libraries
938 Askews and Holts Library Services|bASKH|nAH28323469
938 YBP Library Services|bYANK|n9907084
994 92|bJFN