Fundamentals of Business Intelligence by
This book presents a comprehensive and systematic introduction to transforming process-oriented data into information about the underlying business process, which is essential for all kinds of decision-making. To that end, the authors develop step-by-step models and analytical tools for obtaining high-quality data structured in such a way that complex analytical tools can be applied. The main emphasis is on process mining and data mining techniques and the combination of these methods for process-oriented data. After a general introduction to the business intelligence (BI) process and its constituent tasks in chapter 1, chapter 2 discusses different approaches to modeling in BI applications. Chapter 3 is an overview and provides details of data provisioning, including a section on big data. Chapter 4 tackles data description, visualization, and reporting. Chapter 5 introduces data mining techniques for cross-sectional data. Different techniques for the analysis of temporal data are then detailed in Chapter 6. Subsequently, chapter 7 explains techniques for the analysis of process data, followed by the introduction of analysis techniques for multiple BI perspectives in chapter 8. The book closes with a summary and discussion in chapter 9. Throughout the book, (mostly open source) tools are recommended, described and applied; a more detailed survey on tools can be found in the appendix, and a detailed code for the solutions together with instructions on how to install the software used can be found on the accompanying website. Also, all concepts presented are illustrated and selected examples and exercises are provided. The book is suitable for graduate students in computer science, and the dedicated website with examples and solutions makes the book ideal as a textbook for a first course in business intelligence in computer science or business information systems. Additionally, practitioners and industrial developers who are interested in the concepts behind business intelligence will benefit from the clear explanations and many examples.
Fundamentals of Database Management System by
Designed to provide an insight into the database concepts Key Features Book contains real-time executed commands along with screenshot Parallel execution and explanation of Oracle and MySQL Database commands A Single comprehensive guide for Students, Teachers and Professionals Practical oriented book Description Book teaches the essentials of DBMS to anyone who wants to become an effective and independent DBMS Master. It covers all the DBMS fundamentals without forgetting few vital advanced topics such as from installation, configuration and monitoring, up to the backup and migration of database covering few database client tools. What Will You Learn Relational Database, Keys Normalization of database SQL, SQL Queries, SQL joins Aggregate Functions, Oracle and Mysql tools Who This Book Is For Students of Polytechnic Diploma Classes- Computer Science/ Information Technology Graduate Students- Computer Science/ CSE / IT/ Computer Applications Master Class Students-Msc (CS/IT)/ MCA/ M.Phil, M.Tech, M.S. Industry Professionals- Preparing for Certifications Table of Contents Fundamentals of data and Database management system Database Architecture and Models Relational Database and normalization Open source technology & SQL Database queries SQL operators Introduction to database joins Aggregate functions, subqueries and users Backup & Recovery Database installation Oracle and MYSQL tools Exercise About the Author Dr. Mukesh Negi is an Oracle, IBM, ITIL & Prince2 Certified Engineer with more than sixteen years of experience in multiple Advance and Emerging IT Technologies such as DBMS & Big Data, Cloud Computing, Virtualization, Internet of Things, Artificial Intelligence, Machine Learning, Business Intelligence & Analytics, IT Security etc. In the Education field, He is serving as an Editorial Board Member of many international journals. He has conducted several Faculty Development Programs and serving as a Guest & Visiting Faculty in many reputed University and Colleges in India.
Fundamentals of Data Visualization by
Effective visualization is the best way to communicate information from the increasingly large and complex datasets in the natural and social sciences. But with the increasing power of visualization software today, scientists, engineers, and business analysts often have to navigate a bewildering array of visualization choices and options. This practical book takes you through many commonly encountered visualization problems, and it provides guidelines on how to turn large datasets into clear and compelling figures. What visualization type is best for the story you want to tell? How do you make informative figures that are visually pleasing? Author Claus O. Wilke teaches you the elements most critical to successful data visualization. Explore the basic concepts of color as a tool to highlight, distinguish, or represent a value Understand the importance of redundant coding to ensure you provide key information in multiple ways Use the book's visualizations directory, a graphical guide to commonly used types of data visualizations Get extensive examples of good and bad figures Learn how to use figures in a document or report and how employ them effectively to tell a compelling story
SQL for Data Analytics by
Take your first steps to become a fully qualified data analyst by learning how to explore large relational datasets Key Features Explore a variety of statistical techniques to analyze your data Integrate your SQL pipelines with other analytics technologies Perform advanced analytics such as geospatial and text analysis Book Description Understanding and finding patterns in data has become one of the most important ways to improve business decisions. If you know the basics of SQL, but don't know how to use it to gain the most effective business insights from data, this book is for you. SQL for Data Analytics helps you build the skills to move beyond basic SQL and instead learn to spot patterns and explain the logic hidden in data. You'll discover how to explore and understand data by identifying trends and unlocking deeper insights. You'll also gain experience working with different types of data in SQL, including time-series, geospatial, and text data. Finally, you'll learn how to increase your productivity with the help of profiling and automation. By the end of this book, you'll be able to use SQL in everyday business scenarios efficiently and look at data with the critical eye of an analytics professional. Please note: if you are having difficulty loading the sample datasets, there are new instructions uploaded to the GitHub repository. The link to the GitHub repository can be found in the book's preface. What you will learn Perform advanced statistical calculations using the WINDOW function Use SQL queries and subqueries to prepare data for analysis Import and export data using a text file and psql Apply special SQL clauses and functions to generate descriptive statistics Analyze special data types in SQL, including geospatial data and time data Optimize queries to improve their performance for faster results Debug queries that won't run Use SQL to summarize and identify patterns in data Who this book is for If you're a database engineer looking to transition into analytics, or a backend engineer who wants to develop a deeper understanding of production data, 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. Knowledge of basic SQL and database concepts will aid in understanding the concepts covered in this book.
UX for XR by
Extending traditional digital platforms to the new frontier of extended reality (XR) requires taking into account what best practices, new concepts, and conventions have been established and what learnings can be brought forward from case studies involving industry leaders. By looking at practical examples from the field of handheld AR breakthroughs, virtual reality (VR) success stories and experimental interaction concept of pioneering XR platforms, you'll see how it's possible to map out a framework of user experience (UX) guidelines to close in on opportunities and challenges that lay ahead. This book defines, identifies, and analyzes UX practices for XR environments and reviews the techniques and tools for prototyping and designing XR user interactions. You'll approach the design for experiential state and spatial cognition, using established UX key performance indicators, while taking into account the social dynamics, emotional framework and wider industry context. UX design and strategy for the XR space is a new frontier, so UX for XR focuses on case studies and industry research to illustrate the relationship between UX design and the growth of immersive technologies. Practical examples will demonstrate how you should apply UX design principles using designing interactions in XR by identifying the importance of spaces, senses and storyboarding. What You'll Learn Explore the challenges and opportunities of designing for XR See how spatial interaction is revolutionizing human computer interaction Examine sensory input and interaction beyond the screen Work with 3D Interaction Design and build a strong 3D UX Understand VR and augmented reality essentials for emotion-rich user experiences Apply UX research techniques for the XR space Who This Book Is For This book is primarily for UX designers, consultants, and strategists; XR developers; and media professionals
