Data Warehousing Fundamentals

Cutting-edge content and guidance from a data warehousing expert—now expanded to reflect field trends Data warehousing has revolutionized the way businesses in a wide variety of industries perform analysis and make strategic decisions. Since the first edition of Data Warehousing Fundamentals, numerous enterprises have implemented data warehouse systems and reaped enormous benefits. Many more are in the process of doing so. Now, this new, revised edition covers the essential fundamentals of data warehousing and business intelligence as well as significant recent trends in the field. The author provides an enhanced, comprehensive overview of data warehousing together with in-depth explanations of critical issues in planning, design, deployment, and ongoing maintenance. IT professionals eager to get into the field will gain a clear understanding of techniques for data extraction from source systems, data cleansing, data transformations, data warehouse architecture and infrastructure, and the various methods for information delivery. This practical Second Edition highlights the areas of data warehousing and business intelligence where high-impact technological progress has been made. Discussions on developments include data marts, real-time information delivery, data visualization, requirements gathering methods, multi-tier architecture, OLAP applications, Web clickstream analysis, data warehouse appliances, and data mining techniques. The book also contains review questions and exercises for each chapter, appropriate for self-study or classroom work, industry examples of real-world situations, and several appendices with valuable information. Specifically written for professionals responsible for designing, implementing, or maintaining data warehousing systems, Data Warehousing Fundamentals presents agile, thorough, and systematic development principles for the IT professional and anyone working or researching in information management.

The purpose of this book is to provide a practical approach for IT professionals to acquire the necessary knowledge and expertise in data modeling to function effectively. It begins with an overview of basic data modeling concepts, introduces the methods and techniques, provides a comprehensive case study to present the details of the data model components, covers the implementation of the data model with emphasis on quality components, and concludes with a presentation of a realistic approach to data modeling. It clearly describes how a generic data model is created to represent truly the enterprise information requirements.

What every electrical engineering student and technical professional needs to know about data exchange across networks While most electrical engineering students learn how the individual components that make up data communication technologies work, they rarely learn how the parts work together in complete data communication networks. In part, this is due to the fact that until now there have been no texts on data communication networking written for undergraduate electrical engineering students. Based on the author’s years of classroom experience, Fundamentals of Data Communication Networks fills that gap in the pedagogical literature, providing readers with a much-needed overview of all relevant aspects of data communication networking, addressed from the perspective of the various technologies involved. The demand for information exchange in networks continues to grow at a staggering rate, and that demand will continue to mount exponentially as the number of interconnected IoT-enabled devices grows to an expected twenty-six billion by the year 2020. Never has it been more urgent for engineering students to understand the fundamental science and technology behind data communication, and this book, the first of its kind, gives them that understanding. To achieve this goal, the book: Combines signal theory, data protocols, and wireless networking concepts into one text Explores the full range of issues that affect common processes such as media downloads and online games Addresses services for the network layer, the transport layer, and the application layer Investigates multiple access schemes and local area networks with coverage of services for the physical layer and the data link layer Describes mobile communication networks and critical issues in network security Includes problem sets in each chapter to test and fine-tune readers’ understanding Fundamentals of Data Communication Networks is a must-read for advanced undergraduates and graduate students in electrical and computer engineering. It is also a valuable working resource for researchers, electrical engineers, and technical professionals.

This book explains the concept of spatial data quality, a key theory for minimizing the risks of data misuse in a specific decision-making context. Drawing together chapters written by authors who are specialists in their particular field, it provides both the data producer and the data user perspectives on how to evaluate the quality of vector or raster data which are both produced and used. It also covers the key concepts in this field, such as: how to describe the quality of vector or raster data; how to enhance this quality; how to evaluate and document it, using methods such as metadata; how to communicate it to users; and how to relate it with the decision-making process. Also included is a Foreword written by Professor Michael F. Goodchild.

Fundamentals of Big Data Network Analysis for Research and Industry Hyunjoung Lee, Institute of Green Technology, Yonsei University, Republic of Korea Il Sohn, Material Science and Engineering, Yonsei University, Republic of Korea Presents the methodology of big data analysis using examples from research and industry There are large amounts of data everywhere, and the ability to pick out crucial information is increasingly important. Contrary to popular belief, not all information is useful; big data network analysis assumes that data is not only large, but also meaningful, and this book focuses on the fundamental techniques required to extract essential information from vast datasets. Featuring case studies drawn largely from the iron and steel industries, this book offers practical guidance which will enable readers to easily understand big data network analysis. Particular attention is paid to the methodology of network analysis, offering information on the method of data collection, on research design and analysis, and on the interpretation of results. A variety of programs including UCINET, NetMiner, R, NodeXL, and Gephi for network analysis are covered in detail. Fundamentals of Big Data Network Analysis for Research and Industry looks at big data from a fresh perspective, and provides a new approach to data analysis. This book: Explains the basic concepts in understanding big data and filtering meaningful data Presents big data analysis within the networking perspective Features methodology applicable to research and industry Describes in detail the social relationship between big data and its implications Provides insight into identifying patterns and relationships between seemingly unrelated big data Fundamentals of Big Data Network Analysis for Research and Industry will prove a valuable resource for analysts, research engineers, industrial engineers, marketing professionals, and any individuals dealing with accumulated large data whose interest is to analyze and identify potential relationships among data sets.

A comprehensive understanding of the potential dangers inherent in warehousing chemicals is the first step in managing the associated risks. Written by industry professionals for warehouse operators, designers, and all who are concerned with the safe warehousing of chemicals, this book offers a performance-based approach to such hazards as health effects, environmental pollution, fire, and explosion, and presents practical means to minimize the risk of these hazards to employees, the surrounding population, the environment, property, and business operations. These basic precepts can be used to evaluate the risks in initial or existing designs for warehousing facilities on a manufacturing site, for freestanding offsite buildings, and for strictly chemical or mixed-use storage. Each of the book’s ten chapters has a list of references and suggestions for further reading. The numerous topics covered make this book invaluable for warehousing designers and operators.

The absolute beginner's guide to learning basic computer skills Computing Fundamentals, Introduction to Computers gets you up to speed on basic computing skills, showing you everything you need to know to conquer entry-level computing courses. Written by a Microsoft Office Master Instructor, this useful guide walks you step-by-step through the most important concepts and skills you need to be proficient on the computer, using nontechnical, easy-to-understand language. You'll start at the very beginning, getting acquainted with the actual, physical machine, then progress through the most common software at your own pace. You'll learn how to navigate Windows 8.1, how to access and get around on the Internet, and how to stay connected with email. Clear instruction guides you through Microsoft Office 2013, helping you create documents in Word, spreadsheets in Excel, and presentations in PowerPoint. You'll even learn how to keep your information secure with special guidance on security and privacy. Maybe you're preparing for a compulsory computing course, brushing up for a new job, or just curious about how a computer can make your life easier. If you're an absolute beginner, this is your complete guide to learning the essential skills you need: Understand the basics of how your computer works Learn your way around Windows 8.1 Create documents, spreadsheets, and presentations Send email, surf the Web, and keep your data secure With clear explanations and step-by-step instruction, Computing Fundamentals, Introduction to Computers will have you up and running in no time.

Queueing analysis is a vital tool used in the evaluation of system performance. Applications of queueing analysis cover a wide spectrum from bank automated teller machines to transportation and communications data networks. Fully revised, this second edition of a popular book contains the significant addition of a new chapter on Flow & Congestion Control and a section on Network Calculus among other new sections that have been added to remaining chapters. An introductory text, Queueing Modelling Fundamentals focuses on queueing modelling techniques and applications of data networks, examining the underlying principles of isolated queueing systems. This book introduces the complex queueing theory in simple language/proofs to enable the reader to quickly pick up an overview to queueing theory without utilizing the diverse necessary mathematical tools. It incorporates a rich set of worked examples on its applications to communication networks. Features include: Fully revised and updated edition with significant new chapter on Flow and Congestion Control as-well-as a new section on Network Calculus A comprehensive text which highlights both the theoretical models and their applications through a rich set of worked examples, examples of applications to data networks and performance curves Provides an insight into the underlying queuing principles and features step-by-step derivation of queueing results Written by experienced Professors in the field Queueing Modelling Fundamentals is an introductory text for undergraduate or entry-level post-graduate students who are taking courses on network performance analysis as well as those practicing network administrators who want to understand the essentials of network operations. The detailed step-by-step derivation of queueing results also makes it an excellent text for professional engineers.

Kick start your journey into computing and prepare for your IC3 certification With this essential course book you'll be sending e-mails, surfing the web and understanding the basics of computing in no time. Written by Faithe Wempen, a Microsoft Office Master Instructor and author of more than 120 books, this complete guide to the basics has been tailored to provide comprehensive instruction on the full range of entry-level computing skills. It is a must for students looking to move into almost any profession, as entry-level computing courses have become a compulsory requirement in the modern world. This great resource brings readers up to speed on computing basics, and helps them achieve competency on a computer quickly and easily. The book covers everything from computer hardware and software to the underlying functionality of a computer, and helps readers gain the skills and knowledge they need to move forward in their careers, or to successfully prepare for the IC3 Exam. Learn about computer hardware, software and other basic functions Get a full introduction to Windows and Microsoft Office Create polished documents and presentations in Microsoft Excel, PowerPoint and Word 2010 Gain an understanding of web basics, connectivity, security and privacy Written especially for students and those interested in learning more about computing, the book includes bonus questions, PowerPoint slides and bonus tasks to help put new skills into practice immediately.

The Second Edition of this critically-acclaimed text continues the standard of excellence set in the first edition by providing a thorough introduction to the fundamentals of telecommunication networks without bogging you down in complex technical jargon or math. Although focusing on the basics, the book has been thoroughly updated with the latest advances in the field, including a new chapter on metropolitan area networks (MANs) and new sections on Mobile Fi, ZigBee and ultrawideband. You’ll learn which choices are now available to an organization, how to evaluate them and how to develop strategies that achieve the best balance among cost, security and performance factors for voice, data, and image communication. An Instructor's Manual presenting detailed solutions to all the problems in the book is available from the Wiley editorial department.