Pro SQL Server 2012 BI solutions
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 creat...
| Autor principal: | |
|---|---|
| Otros Autores: | |
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Berkeley, CA :
Apress : Imprint: Apress
2012.
|
| Edición: | 1st ed. 2012. |
| Colección: | The expert's voice in SQL server Pro SQL Server 2012 BI solutions
|
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009628710706719 |
Tabla de Contenidos:
- Title Page; Copyright Page; Contents at a Glance; Table of Contents; Foreword; About the Authors; About the Technical Reviewers; Acknowledgments; CHAPTER 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 InstructionsThink Small, Win Big; Rapid Application Development for BI Solutions; Moving On; What's Next?; CHAPTER 2 A Big-Picture Overview; The 10,000-Foot View; Interviewing and Isolating Data; Plan the Solution; Creating Planning Documents; Adding Documents to Visual Studio; Creating Visual Studio Solutions and Projects; Using Visual Studio; Creating a Blank Solution; Working with the Blank Solution; Creating the Data Warehouse; An Example Data Warehouse; Using SQL Code to Create a Data Warehouse; Create the Database; Create the Tables; Using the Identity Option
- Adding Primary Key ConstraintsAdding Foreign Key Constraints; 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 a Flat File Connection; Configuring a SQL Server Connection; 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 CubesDeploying and Processing; Creating Reports; Using the SSRS Wizard; Manually Creating SSRS Reports; Testing the Solution; Approve, Release, and Prepare; Moving On; What's Next?; CHAPTER 3 Planning Solutions; Outline the Steps in the Process; Interviewing; Why Do We Need It?; What Are We Building?; Additional Considerations for Determining What You Will Build; Determining Your Ability to Complete the Solution; 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; The IT, Security and Licensing Requirements; Estimating the Cost; Documenting the Solution Plan; Implementation; Moving On; What's Next?; CHAPTER 4 Designing a Data Warehouse; What Is a Data Warehouse?; What Is a Data Mart?; Competing Definitions; Starting with an OLTP Design; A Typical OLTP Database Design; Normalized Tables; Table Relationships; Many-to-Many Tables; One-to-Many Tables; Parent-Child One-to-Many Tables
- A Typical Data Warehouse Database Design
