Database software Books

Book SynopsisTake your first steps to becoming a fully qualified data analyst by learning how to explore complex datasetsKey Features Master each concept through practical exercises and activities Discover various statistical techniques to analyze your data Implement everything you've learned on a real-world case study to uncover valuable insights Book DescriptionEvery day, businesses operate around the clock, and a huge amount of data is generated at a rapid pace. This book helps you analyze this data and identify key patterns and behaviors that can help you and your business understand your customers at a deep, fundamental level. SQL for Data Analytics, Third Edition is a great way to get started with data analysis, showing how to effectively sort and process information from raw data, even without any prior experience. You will begin by learning how to form hypotheses and generate descriptive statistics that can provide key insights into your existing data. As you progress, you will learn how to write SQL queries to aggregate, calculate, and combine SQL data from sources outside of your current dataset. You will also discover how to work with advanced data types, like JSON. By exploring advanced techniques, such as geospatial analysis and text analysis, you will be able to understand your business at a deeper level. Finally, the book lets you in on the secret to getting information faster and more effectively by using advanced techniques like profiling and automation. By the end of this book, you will be proficient in the efficient application of SQL techniques in everyday business scenarios and looking at data with the critical eye of�analytics professional.What you will learn Use SQL to clean, prepare, and combine different datasets Aggregate basic statistics using GROUP BY clauses Perform advanced statistical calculations using a WINDOW function Import data into a database to combine with other tables Export SQL query results into various sources Analyze special data types in SQL, including geospatial, date/time, and JSON data Optimize queries and automate tasks Think about data problems and find answers using SQL Who this book is forIf you're a database engineer looking to transition into analytics or a backend engineer who wants to develop a deeper understanding of production data and gain practical SQL knowledge, you will find this book useful. This book is also ideal for data scientists or business analysts who want to improve their data analytics skills using SQL.Basic familiarity with SQL (such as basic SELECT, WHERE, and GROUP BY clauses) as well as a good understanding of linear algebra, statistics, and PostgreSQL 14 are necessary to make the most of this SQL data analytics book.Table of ContentsTable of Contents Understanding and Describing Data The Basics of SQL for Analytics SQL for Data Preparation Aggregate Functions for Data Analysis Window Functions for Data Analysis Importing and Exporting Data Analytics Using Complex Data Types Performant SQL Using SQL to Uncover the Truth – a Case Study

Read more less

Book SynopsisMaster critical skills needed to deploy and use Databricks SQL and elevate your BI from the warehouse to the lakehouse with confidenceKey Features Learn about business intelligence on the lakehouse with features and functions of Databricks SQL Make the most of Databricks SQL by getting to grips with the enablers of its data warehousing capabilities A unique approach to teaching concepts and techniques with follow-along scenarios on real datasets Book DescriptionIn this new era of data platform system design, data lakes and data warehouses are giving way to the lakehouse – a new type of data platform system that aims to unify all data analytics into a single platform. Databricks, with its Databricks SQL product suite, is the hottest lakehouse platform out there, harnessing the power of Apache Spark™, Delta Lake, and other innovations to enable data warehousing capabilities on the lakehouse with data lake economics. This book is a comprehensive hands-on guide that helps you explore all the advanced features, use cases, and technology components of Databricks SQL. You'll start with the lakehouse architecture fundamentals and understand how Databricks SQL fits into it. The book then shows you how to use the platform, from exploring data, executing queries, building reports, and using dashboards through to learning the administrative aspects of the lakehouse – data security, governance, and management of the computational power of the lakehouse. You'll also delve into the core technology enablers of Databricks SQL – Delta Lake and Photon. Finally, you'll get hands-on with advanced SQL commands for ingesting data and maintaining the lakehouse. By the end of this book, you'll have mastered Databricks SQL and be able to deploy and deliver fast, scalable business intelligence on the lakehouse.What you will learn Understand how Databricks SQL fits into the Databricks Lakehouse Platform Perform everyday analytics with Databricks SQL Workbench and business intelligence tools Organize and catalog your data assets Program the data security model to protect and govern your data Tune SQL warehouses (computing clusters) for optimal query experience Tune the Delta Lake storage format for maximum query performance Deliver extreme performance with the Photon query execution engine Implement advanced data ingestion patterns with Databricks SQL Who this book is forThis book is for business intelligence practitioners, data warehouse administrators, and data engineers who are new to Databrick SQL and want to learn how to deliver high-quality insights unhindered by the scale of data or infrastructure. This book is also for anyone looking to study the advanced technologies that power Databricks SQL. Basic knowledge of data warehouses, SQL-based analytics, and ETL processes is recommended to effectively learn the concepts introduced in this book and appreciate the innovation behind the platform.Table of ContentsTable of Contents Introduction to Databricks The Databricks Product Suite – A Visual Tour The Data Catalog The Security Model The Workbench The SQL Warehouses Using Business Intelligence Tools with Databricks SQL The Delta Lake The Photon Engine Warehouse on the Lakehouse SQL Commands – Part 1 SQL Commands – Part 2 Playing with the TPC-DS Dataset Ask Me Anything

Read more less

Book SynopsisMaintaining the advanced technical focus found in Developing Essbase Applications, this second volume is another collaborative effort by some of the best and most experienced Essbase practitioners from around the world.Developing Essbase Applications: Hybrid Techniques and Practices reviews technology areas that are much-discussed but still very new, including Exalytics and Hybrid Essbase. Covering recent improvements to the Essbase engine, the book illustrates the impact of new reporting and analysis tools and also introduces advanced Essbase best practices across a variety of features, functions, and theories.Some of this book's chapters are in the same vein as the previous volume: hardware, engines, and languages. Others cover new ground with Oracle Business Intelligence Enterprise Edition, design philosophy, benchmarking concepts, and multiple client tools. As before, these subjects are covered from both the technical and best practice perspectives.Trade Review"I enjoyed the first book because it was a collection of best practices, tips, tricks, and mini-guides. ... Reading this book, I was happy to find a wider representation of topics: brand new, forward-looking features like Hybrid Aggregation Mode; popular product offerings such as Exalytics and Oracle Business Intelligence Enterprise Edition integrations; topics relevant to many existing implementations; and even a representation of partner products."—Gabby Rubin, Senior Director, Product Management, Oracle Business AnalyticsTable of ContentsIntroduction. Essbase on Exalytics and the "Secret Sauce". Hybrid Essbase: Evolution or Revolution? The Young Person’s Guide to Essbase Cube Design. Essbase Performance and Load Testing. Utilizing Structured Query Language to Enhance Your Essbase Experience. Copernicus Was Right: Integrating Oracle Business Intelligence and Essbase. Managing Spreadsheets (and Essbase) Through Dodeca. Smart View Your Way.

Read more less

Book SynopsisPrepare for Microsoft Exam 70-765–and help demonstrate your real-world mastery of provisioning SQL Server databases both on premise and in SQL Azure. Designed for experienced IT professionals ready to advance their status, Exam Ref focuses on the critical thinking and decision-making acumen needed for success at the MCSA level. Focus on the expertise measured by these objectives: • Implement SQL in Azure • Manage databases and instances • Manage storage This Microsoft Exam Ref: • Organizes its coverage by exam objectives • Features strategic, what-if scenarios to challenge you • Assumes you have working knowledge of SQL Server administration and maintenance, as well as Azure skills Provisioning SQL Databases About the Exam Exam 70-765 focuses on skills and knowledge for provisioning, upgrading, and configuring SQL Server; managing databases and files; and provisioning, migrating, and managing databases in the Microsoft Azure cloud. About Microsoft Certification Passing this exam as well as Exam 70-764: Administering a SQL Database Infrastructure earns you MCSA: SQL 2016 Database Administration certification, qualifying you for a position as a database administrator or infrastructure specialist. See full details at: microsoft.com/learning Table of ContentsIntroduction Chapter 1 Implement SQL in Azure Skill 1:1: Deploy a Microsoft Azure SQL Database Skill 1:2: Plan for SQL Server installation Skill 1:3: Deploy SQL Server instances Skill 1:4: Deploy SQL Server databases to Azure virtual machines Chapter 2 Manage databases and instances Skill 2.1: Configure secure access to Microsoft Azure SQL databases Skill 2.2: Configure SQL Server performance settings Skill 2.3: Manage SQL Server instances Chapter 3 Manage Storage Skill 3.1: Manage SQL Storage Skill 3.2: Perform database maintenance

Read more less

Book SynopsisTable of ContentsChapter 1 | K201 IntroductionMicrosoft AccessChapter 2 | Access IntroductionChapter 3 | Importing Data, Keys, and RelationshipsChapter 4 | Data Types and Basic Field SettingsChapter 5 | Data Entry, Lookup Fields, and Field PropertiesChapter 6 | Basic Select Query Design, Criteria, and Total RowChapter 7 | Concatenation, Calculated Fields, and Aggregate FunctionsChapter 8 | Parameter Query and Query on QueriesChapter 9 |Query Wizard, and Action QueriesChapter 10 | The IIF Function and Intro to FormsChapter 11 | Mulitple Page and Navigation FormsMicrosoft ExcelChapter 12 | The Power of ExcelChapter 13 | Cell Referencing and Named RangesChapter 14 | Conditional Aggregate and Date FunctionsChapter 15 | Financial AnalysisChapter 16 | Logical FunctionsChapter 17 | Compound Nested IFsChapter 18 | Data Retrieval: VLOOKUP, HLOOKUP, MATCHChapter 19 | Data Retrieval: INDEX and MATCHChapter 20 | Spreadsheet Models and Data TablesChapter 21 | Data ValidationChapter 22 | Working with Text DataChapter 23 | Tables and ChartsChapter 24 | PivotTable and Power View ReportsAppendixBox at IUQuery GuideReports in AccessAutomating Tasks with Macros

Read more less

Book SynopsisThis text provides information on creating effective Web applications with ColdFusion MX, a powerful tool for rapid Web site development. Beginning with the basics, it moves on to advanced topics, providing examples of common Web application tasks.Table of Contents1. Introducing ColdFusion What Is ColdFusion?ColdFusion Architecture Getting Started with ColdFusion 2. ColdFusion Basics Getting Started Datatypes Variables Expressions Writing Output Conditional Processing LoopingIncluding Other Templates 3. Passing Data Between Templates Passing Parameters Via URL Passing Data Using Forms Dealing with Nonexistent Parameters 4. Database Basics Configuring Data Sources Introducing cfquery A Quick SQL Primer Retrieving and Displaying Data Sorting Query Results Grouping Output Looping Over a Query Result Set Formatting Techniques 5. Maintaining Database Records Inserting RecordsUpdating Existing Records Deleting Records 6. Complex Datatypes Lists Arrays Structures Query Objects 7. Maintaining State Setting Up the Web Application Framework Using Shared Scope Variables Br owser Redirection Portal Example 8. Security Security Basics Implementing Security from Scratch Taking Advantage of ColdFusion MX's New Security Framework 9. Error and Exception Handling Basic Exception Handling Custom Exception Handling Rethrowing Exceptions Error Handling Within the Web-Application Framework Server-Wide Error Handling 10. Dynamic Form Controls Combining HTML and CFML Form Controls Basic Input Controls Textual Input A Selection Control SlidersGrids Trees Preserving Input Custom Controls 11. Advanced Database Techniques Display TechniquesDrilldown Queries Query Caching Advanced SQL Query of Queries Calling Stored Procedures Transaction Processing 12. Manipulating Files and Directories Working with Directories Dealing with Files Performing FTP Operations Executing Command-Line Programs 13. Working with Email Sending Email Dealing with Undeliverable Email Retrieving MessagesBuilding a Web-Based Email Client 14. Interacting with Other Web Servers Using HTTP Retrieving Information Parsing Data Generating Static HTML Pages Posting Information cfhttp Considerations 15. Interfacing with LDAP-Enabled Directories LDAP Basics Querying an LDAP Directory Modifying LDAP Entries Modifying the Distinguished Name 16. Working with the Verity Search Interface Creating Collections Populating Collections Searching Collections The Verity Search Language Updating Collections Maintaining Collections Advanced Techniques 17. Graphing and Charting Creating a Simple Graph Working with Dates Charting Dynamic Data Charting Multiple Data Series Drilling Down on Graph Data Saving Charts to a Variable Working with the Chart Cache 18. Regular Expressions in ColdFusion Regular-Expre ssion Syntax Finding Strings Replacing Strings Back references Useful Regular Expressions Regular Expression Tester 19. Scripting Scripting Syntax Writing Output Flow Control and Looping Error and Exception Handling 20. User-Defined Functions UDF Basics Calling User-Defined Functions Advanced Topics Function Libraries Script-Based UDFs 21. Creating Custom Tags Getting Started Calling Custom Tags (Part Contents).

Read more less

Book Synopsis

Read more less

Book SynopsisGet up to speed on the extensive changes to the newest release of Microsoft SQL Server The 2012 release of Microsoft SQL Server changes how you develop applications for SQL Server.Table of ContentsINTRODUCTION xxv CHAPTER 1: RDBMS BASICS: WHAT MAKES UP A SQL SERVER DATABASE? 1 An Overview of Database Objects 2 SQL Server Data Types 13 SQL Server Identifiers for Objects 19 Summary 21 CHAPTER 2: LEARNING THE TOOLS OF THE TRADE 23 Getting Help with Books Online 24 SQL Server Configuration Manager 25 SQL Server Management Studio 31 SQL Server Data Tools (formerly BIDS) 43 SQL Server Integration Services (SSIS) 44 SQL Server Reporting Services (SSRS) 45 SQL Server Analysis Services (SSAS) 45 Bulk Copy Program (BCP) 46 SQL Server Profiler 46 sqlcmd 46 PowerShell 47 Summary 47 CHAPTER 3: THE FOUNDATION STATEMENTS OF T-SQL 49 Getting Started with a Basic SELECT Statement 50 Adding Data with the INSERT Statement 76 Changing What You’ve Got with the UPDATE Statement 84 The DELETE Statement 87 Summary 88 CHAPTER 4: JOINS 91 Combining Table Data with JOINs 92 Selecting Matching Rows with INNER JOIN 93 Retrieving More Data with OUTER JOIN 102 Seeing Both Sides with FULL JOINs 115 Understanding CROSS JOINs 117 Exploring Alternative Syntax for Joins 118 Stacking Results with UNION 121 Summary 125 CHAPTER 5: CREATING AND ALTERING TABLES 129 Object Names in SQL Server 130 The CREATE Statement 134 The ALTER Statement 155 The DROP Statement 164 Using the GUI Tool 165 Summary 171 CHAPTER 6: KEYS AND CONSTRAINTS 175 Types of Constraints 176 Constraint Naming 178 Key Constraints 179 CHECK Constraints 197 DEFAULT Constraints 199 Disabling Constraints 201 Rules and Defaults — Cousins of Constraints 206 Triggers for Data Integrity 210 Choosing What to Use 210 Summary 211 CHAPTER 7: ADDING MORE TO YOUR QUERIES 213 What Is a Subquery? 214 Building Correlated Subqueries 218 Derived Tables 225 Using Common Table Expressions (CTEs) 228 Using the EXISTS Operator 232 Mixing Data Types: CAST and CONVERT 236 Synchronizing Data with the MERGE Command 239 Gathering Affected Rows with the OUTPUT Clause 243 Through the Looking Glass: Windowing Functions 246 One Chunk at a Time: Ad Hoc Query Paging 251 Performance Considerations 252 CHAPTER 8: BEING NORMAL: NORMALIZATION AND OTHER BASIC DESIGN ISSUES 257 Understanding Tables 258 Keeping Your Data “Normal” 258 Understanding Relationships 270 Diagramming Databases 279 Denormalization 291 Beyond Normalization 291 Drawing Up a Quick Example 293 Summary 302 CHAPTER 9: SQL SERVER STORAGE AND INDEX STRUCTURES 305 SQL Server Storage 306 Understanding Indexes 308 Creating, Altering, and Dropping Indexes 323 Choosing Wisely: Deciding Which Index Goes Where and When 331 Maintaining Your Indexes 345 Summary 350 CHAPTER 10: VIEWS 353 Creating Simple Views 354 Editing Views with T-SQL 367 Dropping Views 367 Creating and Editing Views in the Management Studio 367 Auditing: Displaying Existing Code 371 Protecting Code: Encrypting Views 373 About Schema Binding 374 Making Your View Look like a Table with VIEW_METADATA 375 Indexed (Materialized) Views 375 Indexing an Aggregate View 378 Summary 381 CHAPTER 11: WRITING SCRIPTS AND BATCHES 383 Understanding Script Basics 384 Grouping Statements into Batches 399 Running from the Command Prompt: sqlcmd 405 Dynamic SQL: Using the EXEC Command 409 Using Control-of-Flow Statements 415 Summary 431 CHAPTER 12: STORED PROCEDURES 435 Creating the Sproc: Basic Syntax 436 Changing Stored Procedures with ALTER 438 Dropping Sprocs 438 Parameterizing Sprocs 438 More on Dealing with Errors 448 What a Sproc Offers 468 Extended Stored Procedures (XPs) 472 A Brief Look at Recursion 472 Debugging 475 Understanding .NET Assemblies 484 When to Use Stored Procedures 485 Summary 486 CHAPTER 13: USER-DEFINED FUNCTIONS 489 What a UDF Is 489 UDFs Returning a Scalar Value 491 UDFs That Return a Table 496 Debugging User-Defined Functions 506 Using .NET in a Database World 507 Summary 507 CHAPTER 14: TRANSACTIONS AND LOCKS 509 Understanding Transactions 509 How the SQL Server Log Works 514 Understanding Locks and Concurrency 518 Setting the Isolation Level 527 Dealing with Deadlocks (aka “a 1205”) 531 Summary 534 CHAPTER 15: TRIGGERS 537 What Is a Trigger? 538 ON 540 WITH ENCRYPTION 540 FOR|AFTER 540 The FOR|AFTER versus the INSTEAD OF Clause 541 NOT FOR REPLICATION 543 AS 543 Using Triggers for Data Integrity Rules 543 Dealing with Requirements Sourced from Other Tables 544 Using Triggers to Check the Delta of an Update 545 Using Triggers for Custom Error Messages 547 Other Common Uses for Triggers 548 Other Trigger Issues 548 Triggers Can Be Nested 548 Triggers Can Be Recursive 549 Triggers Don’t Prevent Architectural Changes 549 Triggers Can Be Turned Off without Being Removed 550 Trigger Firing Order 550 INSTEAD OF Triggers 552 Performance Considerations 552 Triggers Are Reactive Rather Than Proactive 552 Triggers Don’t Have Concurrency Issues with the Process That Fires Them 553 Using IF UPDATE() and COLUMNS_UPDATED 553 Keep It Short and Sweet 556 Don’t Forget Triggers When Choosing Indexes 556 Try Not to Roll Back within Triggers 556 Dropping Triggers 556 Debugging Triggers 557 Summary 558 CHAPTER 16: A BRIEF XML PRIMER 561 XML Basics 562 What SQL Server Brings to the Party 577 A Brief Word on XSLT 610 Summary 613 CHAPTER 17: BUSINESS INTELLIGENCE FUNDAMENTALS 615 What Is Business Intelligence? 616 Those Who Forget History: The Data Warehouse 619 Dimensional Modeling: Why Be Normal? 624 ETLs 637 Making Your Data Actionable: BI Reporting Techniques 642 Summary 647 CHAPTER 18: BI STORAGE AND REPORTING RESOURCES 649 SQL Server Analysis Services, or How I Learned to Stop Worrying and Love the Cube 661 Building Your First Cube 663 Self-Service BI: User Tools 675 Summary 678 CHAPTER 19: REPORTING FOR DUTY, SIR! A LOOK AT REPORTING SERVICES 681 Reporting Services 101 682 Understanding the SSRS Report Lifecycle 683 Understanding the Reporting Services Architecture 684 Building Simple Report Models 686 Report Server Projects 711 Summary 717 CHAPTER 20: GETTING INTEGRATED WITH INTEGRATION SERVICES 719 Understanding the Problem 720 Using the Import/Export Wizard to Generate Basic Packages 720 Examining Package Basics 727 Executing Packages 738 A Final Word on Packages 745 Summary 745 CHAPTER 21: PLAYING ADMINISTRATOR 747 Scheduling Jobs 748 Logins and Users 760 Backup and Recovery 764 Index Maintenance 770 Policy Based Management 774 Automating Administration Tasks with PowerShell 775 Summary 779 APPENDIX: ANSWERS TO EXERCISES 783 INDEX 807 ONLINE APPENDICES BONUS APPENDIX 1: SYSTEM FUNCTIONS 1 BONUS APPENDIX 2: VERY SIMPLE CONNECTIVITY EXAMPLES 69

Read more less

Book SynopsisOptimize reporting and BI with Microsoft SQL Server 2016 Professional Microsoft SQL Server 2016 Reporting Services and Mobile Reports provides a comprehensive lesson in business intelligence (BI), operational reporting and Reporting Services architecture using a clear, concise tutorial approach.Table of ContentsINTRODUCTION xxix PART I: GETTING STARTED CHAPTER 1: INTRODUCING REPORTING SERVICES 3 Who Uses Reporting Services? 4 Information Workers and Data Analysts 5 Information Consumers 6 Business Managers and Leaders 6 Software Developers 6 System Administrators 7 Dashboards, Reports, and Applications 7 Application Integration 7 Business Intelligence and Analytics Solutions 10 Mobile Reports and KPIs 11 Report Tool Choices 14 Simple Report Design 15 IT-Designed Reports 16 User-Designed Reports 16 Server-Based Reports 17 Report Data Sources 18 Enterprise Scale 19 Optimizing Performance 19 Performance 20 Summary 20 CHAPTER 2: WHAT’S NEW IN SQL SERVER 2016 REPORTING SERVICES? 23 Report Builder and Designer Enhancements 25 Modern Browser Rendering 26 Parameter Layout Control 26 Updated RDL Specifi cation 27 Mobile Reports 28 KPIs 30 Native Printing Control 31 PowerPoint Rendering 31 Integrated and Improved Web Portal 31 New Charts and Visual Enhancements 32 Standardized, Modern Browser Rendering 33 Power BI Dashboard Pinning 33 Summary 36 CHAPTER 3: REPORTING SERVICES INSTALLATION AND ARCHITECTURE 39 What’s Changed in SQL Server 2016? 41 The Basic Installation 41 Installing Reporting Services 42 Installing the Reporting Services Samples, Exercises, and SQL Server Databases 56 The Enterprise Deployment 57 SQL Server Editions 58 Default and Named Instances 58 Topology 60 Modes 61 Installation Options 61 The Reporting Life Cycle 63 Authoring 63 Management 63 Delivery 64 Reporting Services Tools 64 Report Builder 64 Web Portal 64 SharePoint Libraries and Web Parts 64 Reporting Services Confi guration Manager 65 SQL Server Management Applications 65 Command-Line Utilities 65 HTML Viewer 66 Report Viewer Control 66 Reporting Services Web Service 67 Reporting Services Windows Service 68 HTTP.SYS and the HTTP Listener 69 The Security Sublayer 69 Web Portal and the Web Service 70 Core Processing 71 Service Management 71 WMI and the RPC Interface 72 Reporting Services Processors and Extensions 73 The Report Processor 74 Data Processing Extensions 75 Report Items 76 Rendering Extensions 77 The Scheduling and Delivery Processor 80 Delivery Extensions 80 Reporting Services Application Databases 80 ReportServer 80 ReportServerTempDB 82 Summary 82 PART II: BASIC REPORT DESIGN CHAPTER 4: REPORT LAYOUT AND FORMATTING 87 Using Report Design Tools 88 Understanding Report Data Building Blocks 89 Data Sources 89 Datasets 90 Data Regions 90 Report Items 93 Samples and Exercises 93 Preparing the Report Data 96 Designing the Report Layout 100 Reviewing the Report 104 Setting Formatting Properties 105 Validating Report Design and Grouping Data 108 Summary 112 CHAPTER 5: DATA ACCESS AND QUERY BASICS 113 Database Essentials 114 Relational Database Concepts 114 What’s a Sequel? 114 Data Source Management 115 Embedded and Shared Data Sources 115 Datasets and Fields 119 Embedded and Shared Datasets 120 Exercises 120 Authoring a Query with SQL Server Management Studio 120 Add the Query to the Report Dataset 124 Design the Report Body 128 Enhance the Parameter 131 Using Multiple Parameter Values 134 Summary 138 CHAPTER 6: GROUPING AND TOTALS 139 SQL Server Data Tools 140 Getting Started 140 Getting Started with Sample Reports Projects 144 Report Groups 150 Adding Totals to a Table or Matrix Report 153 Expression Basics 154 Introducing Aggregate Functions and Totals 155 Sorting 155 Exercise 158 Design the Dataset Query 158 Design and Lay Out a Table Report 160 Add Summary Totals and Drill-Down 163 Aggregate Detail Row Summaries 167 Create Parameter List 168 Summary 171 PART III: ADVANCED AND ANALYTIC REPORTING CHAPTER 7: ADVANCED REPORT DESIGN 175 Pagination and Flow Control 176 Headers and Footers 178 Tablix Headers and Detail Cells 182 Designing the Page Headers 182 Composite Reports and Embedded Content 187 Unlocking the Textbox 187 Padding and Indenting 188 Embedded Formatting 189 Designing Master/Detail Reports 195 Repeating Data Regions: Table, Matrix, and List 196 Groups and Dataset Scope 200 More Aggregate Functions and Totals 200 Designing Subreports 203 Federating Data with a Subreport 205 Navigating Reports 208 Creating a Document Map 209 Exercises 210 Exercise 1: Create a Report Template 210 Exercise 2: Create a Report from the Template with Dynamic Expressions 215 Summary 219 CHAPTER 8: GRAPHICAL REPORT DESIGN 221 Visual Design Principles 222 Keep Charts Simple 222 Properties, Oh My! 223 The Fashion of Visualization 223 Visual Storytelling 224 Perspective and Skewing 224 Chart Types 225 Chart Type Summary 225 Column and Stacked Charts 228 Area and Line Charts 229 Pie and Doughnut Charts 229 Bubble and Stock Charts 233 New Chart Types 233 The Anatomy of a Chart 235 Multiple Series, Axes, and Areas 237 Exercises 240 Exercise 1: Creating and Styling a Simple Chart 240 Exercise 2: Creating a Multi-series Chart 245 Useful Properties and Settings 248 Summary 249 CHAPTER 9: ADVANCED QUERIES AND PARAMETERS 251 T-SQL Queries and Parameters 252 Parameter Lists and Multi-select 252 Cascading Parameters 257 Arranging Parameters in the Parameter Bar 259 Managing Long Parameter Lists 259 All Value Selection 261 Handling Conditional Logic 264 MDX Queries and Parameters 266 Single-Valued Parameter 270 Multi-Valued Parameter 270 Date Value Ranges 271 Summary 275 CHAPTER 10: REPORTING WITH ANALYSIS SERVICES 277 Analysis Services for Reporting 278 Using Reporting Services with Analysis Services Data 279 Working with Multidimensional Expression Language 280 MDX: Simple or Complex? 280 Building Queries with the MDX Query Designer 281 Modifying an MDX Query 293 Adding Nonadditive Measures 302 When to Use the Aggregate Function 304 MDX Properties and Cube Formatting 305 Drill-Through Reports 307 Parameter Safety Precautions 308 Best Practices and Provisions 308 Summary 309 CHAPTER 11: SSAS REPORTING ADVANCED TECHNIQUES 311 Building a Dynamic Cube Browser with SSRS 312 Cube Dynamic Rows 312 Cube Dynamic Rows Anatomy 313 Cube Dynamic Rows Summary 322 Cube Dynamic Rows Expanded 324 MDX Query Modifi cations 324 Design Surface Modifi cations 325 Cube Restricting Rows 326 Designing the Report 326 Cube Metadata 332 Designing the Report 332 Adding Other Cube Metadata 336 Cube Browser 342 Anatomy of the Reports 342 Behind the Scenes 346 Final Thoughts 362 Summary 364 CHAPTER 12: EXPRESSIONS AND ACTIONS 365 Basic Expressions Recap 365 Using the Expression Builder 367 Calculated Fields 369 Conditional Expressions 371 The IIF() Function 372 Using Custom Code 375 Using Custom Code in a Report 376 Links and Drill-Through Reports 378 Reporting on Recursive Relationships 381 Actions and Report Navigation 385 Summary 392 PART IV: SOLUTION PATTERNS CHAPTER 13: REPORT PROJECTS AND CONSOLIDATION 397 SSDT Solutions and Projects 398 Project Structure and Development Phases 399 Shared Datasets and Data Sources 401 Key Success Factors 402 Report Specifi cations 403 Report Template 406 Version Control 407 Setting Up Version Control 408 Getting the Latest Version 408 Viewing a Report’s History 409 Restoring a Previous Version of a Report 409 Setting Check-out and Check-in Policies 409 Applying Labels 409 Synchronizing Content 409 Deploying an Individual Report 410 Deploying a Suite of Reports 410 Checking for Build Errors 410 Excluding a Report from a Deployment 410 Managing Server Content 410 Checking the Deployment Location 411 Managing Content in Native Mode 412 Managing Content in SharePoint 413 Report Builder and Self-Service Reporting Strategies 414 Report Builder and Semantic Model History 415 Planning a Self-Service Reporting Environment 416 You Need a Plan 416 Design Approaches and Usage Scenarios 416 Defi ne Ownership 417 Data Governance 418 Data Source Access and Security 419 User Education 419 Data Source and Query Options 421 User Report Migration Strategies 425 Review 425 Consolidate 426 Design 426 Test 426 Maintain 426 Summary 427 CHAPTER 14: REPORT SOLUTIONS, PATTERNS, AND RECIPES 429 Super Reports 430 Working with the Strengths and Limitations of the Reporting Services Architecture 431 Seeking the Excel Export Holy Grail 431 Report Recipes: Building on Basic Skills 435 Dashboard Solution Data Sources and Datasets 436 KPI Scorecard 437 Gauges 441 Interactive Sparkline and Chart 443 Thumbnail Map with Drill-Through Navigation 450 Summary 456 PART V: REPORTING SERVICES CUSTOM PROGRAMMING CHAPTER 15: INTEGRATING REPORTS INTO CUSTOM APPLICATIONS 461 URL Access 462 URL Syntax 463 Accessing Reporting Services Objects 463 Reporting Services URL Parameters 469 Passing Report Information Through the URL 474 Programmatic Rendering 477 Common Scenarios 478 Rendering Through Windows 479 Rendering to the Web 502 Using the ReportViewer Control 509 Embedding a Server-Side Report in a Windows Application 512 Summary 519 CHAPTER 16: EXTENDING REPORTING SERVICES 521 Extension Through Interfaces 524 What Is an Interface? 524 Interface Language Differences 524 A Detailed Look at Data Processing Extensions 527 Creating a Custom Data Processing Extension 529 The Scenario 530 Creating and Setting Up the Project 530 Creating the DataSetConnection Object 533 Creating the DataSetParameter Class 542 Implementing IDataParameter 543 Creating the DataSetParameterCollection Class 545 Creating the DataSetCommand Class 547 Creating the DataSetDataReader Object 562 Installing the DataSetDataProcessing Extension 566 Testing DataSetDataExtension 569 Summary 572 PART VI: MOBILE REPORT SOLUTIONS CHAPTER 17: INTRODUCING REPORTING SERVICES MOBILE REPORTS 575 The Mobile Report Experience and Business Case 576 Report Drill-Through Navigation 579 When to Use Mobile Reports 579 Connection and Dataset Design Basics 581 Introducing Mobile Report Publisher 581 Layout View 582 Data View 582 Dashboard Settings 583 Preview 583 Visual Control Categories 584 Navigators 585 Summary 592 CHAPTER 18: IMPLEMENTING A MOBILE REPORT WITH DESIGN-FIRST DEVELOPMENT 593 Design-First Mobile Report Development Exercise 593 Add Visual Controls 598 Preview the Mobile Report 601 Add Data to the Report 602 Apply Mobile Layouts and Color Styling 613 Test the Completed Mobile Report from the Server 616 Summary 620 CHAPTER 19: MOBILE REPORT DESIGN PATTERNS 623 Key Performance Indicators 623 The Thing About KPIs 630 You Need Goals 630 Time-Series Calculations and Time Grain 631 Creating a Time-Series Mobile Report 632 Lay Out the Report Using Design-First Report Development 633 Add Data and Set Control Data Properties 635 Set Color Palette and Mobile Device Layouts 642 Server Access and Live Mobile Connectivity 647 Summary 650 CHAPTER 20: ADVANCED MOBILE REPORT SOLUTIONS 653 Designing a Chart Data Grid Mobile Report 653 Exercise: Chart Data Grid 654 Exercise: Adding a Drill-Through Mobile Report 662 Exercise: Adding a Drill-Through Paginated Report 666 Getting Serious with Maps 671 Summary 676 PART VII: ADMINISTERING REPORTING SERVICES CHAPTER 21: CONTENT MANAGEMENT 679 Using Web Portal 680 Content Management Activities 683 Folders 684 Shared Data Sources 685 Reports 688 Report Resources 694 Shared Schedules 695 Site and Content Security 696 Site Security 697 Item-Level Security 697 Site Branding 707 Content Management Automation 710 The RS Utility 710 Reporting Services Scripts 713 Summary 714 CHAPTER 22: SERVER ADMINISTRATION 715 Security 716 Account Management 717 System-Level Roles 721 Surface Area Management 723 Backup and Recovery 724 Application Databases 725 Encryption Keys 727 Confi guration Files 730 Other Items 730 Monitoring 731 Setup Logs 731 Windows Application Event Logs 731 Trace Logs 732 Execution Logs 735 Performance Counters 736 Server Management Reports 741 Confi guration 742 Memory Management 742 URL Reservations 743 E-mail Delivery 745 Rendering Extensions 747 My Reports 749 Summary 751 INDEX 753

Read more less

Book SynopsisOracle Database Programming with Visual Basic.NET Discover a detailed treatment of the practical considerations and applications of Oracle database programming with Visual Basic 2019 Oracle Database Programming with Visual Basic.NET: Concepts, Designs, and Implementations delivers a comprehensive exploration of the foundations of Oracle database programming using Visual Basic.NET. Using Visual Basic.NET 2019, Visual Studio.NET 2019, and Oracle 18c XE, the book introduces the Oracle database development system, Oracle SQL Developer and Modeler, and teaches readers how to implement a sample database solution. The distinguished author also demonstrates the use of dotConnect for Oracle to show readers how to create an effective connection to an Oracle 18c XE database. The current versions of the .NET framework, ASP.NET, and ASP.NET 4.7 are also explored and used to offer readers the most up to date web database programming techniques available today. The book provides practical example p

Read more less

Book SynopsisFileMaker Pro 12: The Missing Manual is the clear, thorough, and accessible guide to the latest version of this popular desktop database program. This book shows you how use FileMaker to make information work for you -- print a catalog, plan your retirement, or run a small business.

Read more less

Book SynopsisServer bottlenecks and failures are a fact of life in any database deployment, but they don't have to bring everything to a halt. This practical book explains replication, cluster, and monitoring features that can help protect your MySQL system from outages, whether it's running on hardware, virtual machines, or in the cloud.

Read more less

Book SynopsisUnlock the secrets of Access 2013 and discover how to use your data in creative ways. With this book's easy step-by-step instructions, you'll learn how to build and maintain a full-featured database and even turn it into a web app.

Read more less

Book SynopsisAccess is the most complex and intimidating application in Microsoft Office. This book helps you learn how to design complete databases, maintain them, search for valuable nuggets of information, and build attractive forms for quick-and-easy data entry. It lets you discover the pre-built databases which can be customized to fit your needs.

Read more less

Book SynopsisMake information work for you with the FileMaker Pro 11 desktop database and FileMaker Pro 11: The Missing Manual. This book helps you get started, build your database, and produce results, whether you're running a business, pursuing a hobby, or planning your retirement.

Read more less

Book SynopsisThe best practices in this practical guide help you design database schemas that not only interoperate with other Hadoop components, and are convenient for administers to manage and monitor, but also accommodate future expansion in data size and evolution of software capabilities.

Read more less

a huge range and FREE tracked UK delivery on ALL orders.

Read more less

a huge range and FREE tracked UK delivery on ALL orders.

Read more less

Book SynopsisMary Anne Poatsy, Series Editor Mary Anne is a senior faculty member at Montgomery County Community College, teaching various computer application and concepts courses in face-to-face and online environments. She holds a B.A. in Psychology and Education from Mount Holyoke College and an M.B.A. in Finance from Northwestern University's Kellogg Graduate School of Management. Mary Anne has more than 12 years of educational experience. She is currently adjunct faculty at Gwynedd-Mercy College and Montgomery County Community College. She has also taught at Bucks County Community College and Muhlenberg College, as well as conducted personal training. Before teaching, she was Vice President at Shearson Lehman in the Municipal Bond Investment Banking Department. Eric Cameron Eric Cameron is a tenured Associate Professor at Passaic County Community College, where he has taught in the Computer and Information Sciences department since 2001. He holds an M.S. in Computer Science and a B.S. degree in Computer Science with minors in Mathematics and Physics, both from Montclair State University. He currently co-chairs the College's General Education committee and served as a member of the College's Academic Assessment, College Writing, and Educational Technology committees at various points. Eric has also developed degrees in Graphic Design and Medical Informatics for the College. Eric previously worked as a software engineer both as a full-time employee and contractor, most recently for ITT/Exelis (now part of Harris Corporation). This is Eric's fourth publication for Pearson, after authoring Web 2.0 and Windows 8 books in the Your Office series and co-authoring the Exploring Access 2013 text.   Jerri Williams Jerri Williams is a Senior Instructor at Montgomery County Community College in Pennsylvania. Jerri also works as an independent corporate trainer, technical editor, and content developer. She is interested in travel, cooking, movies, and tending to her colonial farmhouse. Jerri is married, and is the mother of two daughters, Holly (an Accounting graduate and full-time mother to an adorable son, Meir) and Gwyneth (a corporate defense attorney). Jerri and Gareth live in the suburbs of Philadelphia. They enjoy their home and garden, and spending time with family and good friends. Amy Rutledge Amy Rutledge is a Special Instructor of Management Information Systems at Oakland University in Rochester, Michigan. She coordinates academic programs in Microsoft Office applications and introductory management information systems courses for the School of Business Administration. Before joining Oakland University as an instructor, Amy spent several years working for a music distribution company and automotive manufacturer in various corporate roles including IT project management. She holds a B.S. in Business Administration specializing in Management Information Systems, and a B.A. in French Modern Language and Literature. She holds an M.B.A from Oakland University. She resides in Michigan with her husband, Dan and daughters Emma and Jane.   Dr. Robert T. Grauer, Creator of the Exploring Series Bob Grauer is Professor Emeritus in the Department of Computer Information Systems at the University of Miami, where he is a multiple winner of the Outstanding Teaching Award in the School of Business, most recently in 2009. He has written numerous COBOL texts and is the vision behind the Exploring Office series, with more than three million books in print. His work has been translated into three foreign languages and is used in all aspects of higher education at both national and international levels. Bob Grauer has consulted for several major corporations including IBM and American Express. He received his Ph.D. in Operations Research in 1972 from the Polytechnic Institute of Brooklyn.  Table of Contents Office 2016 Common Features Access Chapter 1 Introduction to Access Chapter 2 T ables and Queries in Relational Databases Chapter 3 Using Queries to Make Decisions Chapter 4 Creating and Using Professional Forms and Reports Chapter 5 Data Validation and Data Analysis Chapter 6 Action and Specialized Queries Chapter 7 Advanced Forms and Reports Chapter 8 Get Connected Chapter 9 Fine-Tuning the Database Chapter 10 Using Macros and SQL in Access Access Introductory Capstone Exercise (Chs. 1—4) Access Comprehensive Capstone Exercise (Chs. 5—10) MICROSOFT OFFICE 2016 SPECIALIST ACCESS Glossary Index Application Capstone Exercises

Read more less

Book SynopsisAbout our authors Mary Anne Poatsy, Series Editor, Windows 10 Author, is a senior faculty member at Montgomery County Community College, teaching various computer applications and concepts courses in face-to-face and online environments. She holds a BA in psychology and education from Mount Holyoke College and an MBA in finance from Northwestern University's Kellogg Graduate School of Management. Mary Anne has over 20 years of educational experience. She has taught at Montgomery County Community College and Muhlenberg College. She also engages in corporate training. Before teaching, she was Vice President at Shearson Lehman in the Municipal Bond Investment Banking Department. Amy Rutledge, Access Author, is a special Instructor of MIS (management information systems) at Oakland University in Rochester, Michigan. She coordinates academic programs in Microsoft Office applications and introductory management informatioTable of ContentsBrief Contents OFFICE Office 365 Common Features ACCESS Introduction to Access Tables and Queries in Relational Databases Query Calculations and Expressions Basic Forms and Reports Data Validation and Data Analysis Action and Specialized Queries Advanced Forms and Reports Get Connected Fine-Tuning the Database Enhanced Database Techniques APPLICATION CAPSTONE EXERCISE Access Application Capstone Exercise

Read more less

Book SynopsisThe Benchmark Series is designed to develop a mastery skill level in Microsoft Word, Excel, Access, and PowerPoint. Its graduated, three-level instructional approach moves students to analyse, synthesise, and evaluate information. Multi-part, projects-based exercises build skill mastery with activities that require independent problem solving.

Read more less

Book SynopsisA must-have guide for the latest updates to the new release of Reporting Services SQL Server Reporting Services allows you to create reports and business intelligence (BI) solutions.Table of ContentsFOREWORD xxxv INTRODUCTION xxxvii PART I: GETTING STARTED CHAPTER 1: INTRODUCING REPORTING SERVICES 3 CHAPTER 2: REPORTING SERVICES INSTALLATION AND ARCHITECTURE 23 CHAPTER 3: CONFIGURING SHAREPOINT INTEGRATION 69 PART II: REPORT DESIGN CHAPTER 4: BASIC REPORT DESIGN 95 CHAPTER 5: REPORT LAYOUT AND FORMATTING 123 CHAPTER 6: DESIGNING DATA ACCESS 143 CHAPTER 7: ADVANCED REPORT DESIGN 189 CHAPTER 8: CHART REPORTS 229 PART III: BUSINESS INTELLIGENCE REPORTING CHAPTER 9: BI SEMANTIC MODELS 251 CHAPTER 10: REPORTING WITH ANALYSIS SERVICES 263 CHAPTER 11: OLAP REPORTING ADVANCED TECHNIQUES 295 PART IV: ENABLING USER REPORTING CHAPTER 12: TABULAR MODELS 349 CHAPTER 13: VISUAL ANALYTICS WITH POWER VIEW 373 CHAPTER 14: REPORT BUILDER SOLUTION STRATEGIES 445 PART V: SOLUTION PATTERNS CHAPTER 15: MANAGING REPORT PROJECTS 463 CHAPTER 16: REPORT SOLUTIONS, PATTERNS, AND RECIPES 483 PART VI: ADMINISTERING REPORTING SERVICES CHAPTER 17: CONTENT MANAGEMENT 525 CHAPTER 18: INTEGRATING REPORTS WITH SHAREPOINT 559 CHAPTER 19: NATIVE MODE SERVER ADMINISTRATION 581 PART VII: REPORTING SERVICES CUSTOM PROGRAMMING CHAPTER 20: INTEGRATING REPORTS INTO CUSTOM APPLICATIONS 619 CHAPTER 21: USING EMBEDDED AND REFERENCED CODE 681 CHAPTER 22: EXTENDING REPORTING SERVICES 697 PART VIII: APPENDIXES APPENDIX A: T-SQL COMMAND SYNTAX REFERENCE 758 APPENDIX B: T-SQL SYSTEM VARIABLES AND FUNCTIONS 779 APPENDIX C: MDX REFERENCE 803 INDEX 829

Read more less

Book SynopsisWrite optimized queries. This book helps you write queries that perform fast and deliver results on time. You will learn that query optimization is not a dark art practiced by a small, secretive cabal of sorcerers. Any motivated professional can learn to write efficient queries from the get-go and capably optimize existing queries. You will learn to look at the process of writing a query from the database engine’s point of view, and know how to think like the database optimizer. The book begins with a discussion of what a performant system is and progresses to measuring performance and setting performance goals. It introduces different classes of queries and optimization techniques suitable to each, such as the use of indexes and specific join algorithms. You will learn to read and understand query execution plans along with techniques for influencing those plans for better performance. The book also covers advanced topics such as the use of functions and procedures, dynamic SQL, and generated queries. All of these techniques are then used together to produce performant applications, avoiding the pitfalls of object-relational mappers.This second edition includes new examples using Postgres 15 and the newest version of the PostgresAir database. It includes additional details and clarifications about advanced topics, and covers configuration parameters in greater depth. Finally, it makes use of advancements in NORM, using automatically generated functions. What You Will Learn Identify optimization goals in OLTP and OLAP systems Read and understand PostgreSQL execution plans Distinguish between short queries and long queries Choose the right optimization technique for each query type Identify indexes that will improve query performance Optimize full table scans Avoid the pitfalls of object-relational mapping systems Optimize the entire application rather than just database queries Who This Book Is ForIT professionals working in PostgreSQL who want to develop performant and scalable applications, anyone whose job title contains the words “database developer” or “database administrator" or who is a backend developer charged with programming database calls, and system architects involved in the overall design of application systems running against a PostgreSQL databaseTable of Contents1. Why Optimize?2. Theory - Yes, We Need It!3. Even More Theory Algorithms4. Understanding Execution Plans5. Short Queries and Indexes6. Long Queries and Full Scans7. Long Queries: Additional Techniques8. Optimizing Data Modification9. Design Matters10. Application Development and Performance11. Functions12. Dynamic SQL13. Avoiding the Pitfalls of Object-Relational Mapping14. More Complex Filtering and Search15. Ultimate Optimization Algorithm16. Conclusion

Read more less