Data Modeling with Microsoft Excel. Model and analyze data using Power Pivot, DAX, and Cube functions

Bernard Obeng Boateng, Michael Olafusi

Microsoft Excel's BI solutions have evolved, offering users more flexibility and control over analyzing data directly in Excel. Features like PivotTables, Data Model, Power Query, and Power Pivot empower Excel users to efficiently get, transform, model, aggregate, and visualize data.Data Modeling with Microsoft Excel offers a practical way to demystify the use and application of these tools using real-world examples and simple illustrations.This book will introduce you to the world of data modeling in Excel, as well as definitions and best practices in data structuring for both normalized and denormalized data. The next set of chapters will take you through the useful features of Data Model and Power Pivot, helping you get to grips with the types of schemas (snowflake and star) and create relationships within multiple tables. You’ll also understand how to create powerful and flexible measures using DAX and Cube functions.By the end of this book, you’ll be able to apply the acquired knowledge in real-world scenarios and build an interactive dashboard that will help you make important decisions.

Django 5 for the Impatient. Learn the core concepts of Django to develop Python web applications - Second Edition

Daniel Correa, Greg Lim

Learning Django can be a challenging and time-consuming activity without the right guidance. With hundreds of tutorials, loads of documentation, and unclear explanations out there, it’s easy to lose sight of what’s most important. This book stands out by teaching you how to use Django in just a few days with a focused approach. In this second edition, you’ll go on a fun, practical, and pragmatic journey to learning full-stack development with Django 5. You’ll start building your first Django app within minutes. As you progress, you’ll learn from concise explanations that will help you get to grips with some of the most important Django features, including URLs, views, templates, models, CSS inclusion, image storage, Django admin panel, and more. You’ll also understand how to design Django MVT (Model-View-Template) architectures and implement them. Additionally, you’ll use Django to develop a movie store application and deploy it to the internet.By the end of this book, you’ll be able to build and deploy your own Django web applications confidently.

Instant Apache Camel Message Routing. Route, transform, split, multicast messages, and do much more with Camel

Bilgin Ibryam, Bilgin Ismet Ibryam

With new APIs and technologies emerging every day, the need for integrating applications is greater than ever before. With the right tools, integrating applications is not hard. Apache Camel is the leading open source integration and message orchestration framework. Apache Camel, which has a variety of connectors and features numerous well-known integration patterns, has an enormous advantage over home grown integration solutions.Instant Apache Camel Message Routing helps you to get started using the Camel routing engine and Enterprise Integration Patterns. This book will show you how to create integration applications using Apache Camel. You will learn how Camel works and how to leverage the Enterprise Integration Patterns for message routing.Instant Apache Camel Message Routing is a practical and step-by-step guide to Apache Camel and integration patterns. This book will show you how Apache Camel works and how it integrates disparate systems using Enterprise Integration Patterns. The book starts with a high level overview of the Camel architecture before diving into message routing principles. Then, it introduces a number of patterns, complete with diagrams, common use cases, and examples about how to use them with Camel. The book also shows you how to test and monitor Camel applications and cope with failure scenarios.

Oracle User Productivity Kit 3.5. Build high-quality training simulations using Oracle UPK 3.5 using this book and

Dirk Manuel

As the complexity of software applications increases and the length of the implementation life cycles decreases, companies are looking for effective ways of training users in new applications, and the new releases of existing applications. Oracle's User Productivity Kit solves these problems by enabling the rapid creation of software application simulations, which are used for training purposes or to generate business documents. Although UPK provides such advanced features, nothing has been written about this application yet.This book provides a guided approach to building high-quality, re-functional simulations of tasks performed in software applications. With this book in hand, it is easy for organizations that are implementing or upgrading software to meet their full training and documentation requirements. This book explains how to harness all of the functionality provided by Oracle's User Productivity Kit, formerly known as OnDemand, to develop better quality training. It also covers the advanced topics of customizing UPK's built-in delivery formats, and defining new ones to extend the capabilities of UPK.This book explains how to make the most of Oracle User Productivity Kit's available functionality to create high-quality simulations. These simulations can be used during instructor-led training, self-directed learning, or refresher training. By following the approach described in this book, you will create world-class training material that your trainees will find useful, engaging, and informative. As a result, they will remember more of what they are taught, and will be better equipped to use the application on which you are training them. In turn, they will become more productive sooner, make fewer mistakes, and require less support. To ensure effective knowledge transfer through training simulations, it is necessary to add a business context to recordings, and to provide additional explanations. This book will teach you more than simple mouse-clicks and keystrokes.

Mastering Web Application Development with Express. A comprehensive guide to developing production-ready web applications with Express

Alexandru Vladutu

Caffe2 Quick Start Guide. Modular and scalable deep learning made easy

Ashwin Nanjappa

Caffe2 is a popular deep learning library used for fast and scalable training, and inference of deep learning models on different platforms. This book introduces you to the Caffe2 framework and demonstrates how you can leverage its power to build, train, and deploy efficient neural network models at scale.The Caffe 2 Quick Start Guide will help you in installing Caffe2, composing networks using its operators, training models, and deploying models to different architectures. The book will also guide you on how to import models from Caffe and other frameworks using the ONNX interchange format. You will then cover deep learning accelerators such as CPU and GPU and learn how to deploy Caffe2 models for inference on accelerators using inference engines. Finally, you'll understand how to deploy Caffe2 to a diverse set of hardware, using containers on the cloud and resource-constrained hardware such as Raspberry Pi.By the end of this book, you will not only be able to compose and train popular neural network models with Caffe2, but also deploy them on accelerators, to the cloud and on resource-constrained platforms such as mobile and embedded hardware.

PHP 7: Real World Application Development. Real World Application Development

Doug Bierer, Iltaf (Altaf) Hussain Gul, Branko Ajzele

PHP is a great language for developing web applications. It is essentially a server-side scripting language. PHP 7 is the latest version, providing major backward-compatibility breaks and focusing on improved performance and speed. This course follows a learning path which is divided into three modules. Each module is a mini course in its own right, taking your basic PHP programing skills to the next level by showing you intermediate to advanced PHP techniques with a focus on PHP 7. The first module of the book is a programming cookbook that consists over 80 recipes! Each recipe is designed to solve practical, real-world problems faced by PHP developers like yourself every day. This course also covers new ways of writing PHP code made possible only in version 7. The second module of the course is designed to improve the performance and productivity of your application. You’ll be introduced to the concepts of Object-Oriented Programming (OOP) in PHP 7 and then shed some light on how to improve the performance of your PHP 7 applications and database. With all important concepts of PHP covered up you will move on to third module. In this module you will gain a deep insight into the modular programming paradigm and how to achieve modularity in your PHP code. Modular design techniques help you build readable, manageable, reusable, and more efficient codes. By the end of this module you will have a good understanding of modular application development using PHP 7.This Learning Path combines some of the best that Packt has to offer in one complete, curated package. It includes content from the following Packt products:• PHP 7 Programming Cookbook, Doug Bierer• Learning PHP 7 High Performance, Altaf Hussain• Modular Programming with PHP 7, Branko Ajzele

Draw and Paint Better with Krita. Discover pro-level techniques and practices to create spectacular digital illustrations with Krita

Wesley Gardner

Krita is a free, open-source digital painting program with industry-leading functionality and a creative suite of tools able to bring any visual idea to life. It allows for a fast, clean approach to creating digital art, without the hassle of pay-to-play or subscription license fees, but just like all other art software, it takes time and effort to learn it.This book provides a comprehensive look into functional tools, visual problem-solving, and leading painting techniques using Krita to unleash your inner artist. You’ll learn the functionality and tools of Krita for creating digital and print-quality work as well as explore manipulation toolsets, custom brush creation, overviews of color spaces, and layer management. As you progress, you’ll get to grips with ‘key styles’ needed to make professional-grade digital art, through techniques such as photobashing, 3D paint-overs, and more traditional painting methods, along with covering how Krita handles these workflows. Next, you’ll work through a few step-by-step art pieces using the skills and tools learned throughout the book.By the end of this Krita book, you’ll have a solid understanding of the Krita work environment and be able to bring your artistic visions to life with a myriad of leading industry-standard techniques.

Android NDK Game Development Cookbook. For C++ developers, this is the book that can swiftly propel you into the potentially profitable world of Android games. The 70+ step-by-step recipes using Android NDK will give you the wide-ranging knowledge you need

Sergey Kosarevsky, Viktor Latypov

Android NDK is used for multimedia applications which require direct access to a system's resources. Android NDK is also the key for portability, which in turn provides a reasonably comfortable development and debugging process using familiar tools such as GCC and Clang toolchains. If your wish to build Android games using this amazing framework, then this book is a must-have.This book provides you with a number of clear step-by-step recipes which will help you to start developing mobile games with Android NDK and boost your productivity debugging them on your computer. This book will also provide you with new ways of working as well as some useful tips and tricks that will demonstrably increase your development speed and efficiency.This book will take you through a number of easy-to-follow recipes that will help you to take advantage of the Android NDK as well as some popular C++ libraries. It presents Android application development in C++ and shows you how to create a complete gaming application. You will learn how to write portable multithreaded C++ code, use HTTP networking, play audio files, use OpenGL ES, to render high-quality text, and how to recognize user gestures on multi-touch devices. If you want to leverage your C++ skills in mobile development and add performance to your Android applications, then this is the book for you.

AI Strategies for Web Development. Build next-gen, intelligent websites by unleashing AI's power in design, personalization, and ethics

Anderson Soares Furtado Oliveira, Elijah Low, Marcelo Augusto Gonçalves Bardi

If you’re a web developer looking to leverage the power of AI in your projects, then this book is for you. Written by an AI and ML expert with more than 15 years of experience, AI Strategies for Web Development takes you on a transformative journey through the dynamic intersection of AI and web development, offering a hands-on learning experience.The first part of the book focuses on uncovering the profound impact of AI on web projects, exploring fundamental concepts, and navigating popular frameworks and tools. As you progress, you’ll learn how to build smart AI applications with design intelligence, personalized user journeys, and coding assistants. Later, you’ll explore how to future-proof your web development projects using advanced AI strategies and understand AI’s impact on jobs. Toward the end, you’ll immerse yourself in AI-augmented development, crafting intelligent web applications and navigating the ethical landscape.Packed with insights into next-gen development environments, AI-augmented practices, emerging realities, interfaces, and security governance, this web development book acts as your roadmap to staying ahead in the AI and web development domain.

Professional Azure SQL Managed Database Administration. Efficiently manage and modernize data in the cloud using Azure SQL - Third Edition

Ahmad Osama, Shashikant Shakya

Despite being the cloud version of SQL Server, Azure SQL Database and Azure SQL Managed Instance stands out in various aspects when it comes to management, maintenance, and administration. Updated with the latest Azure features, Professional Azure SQL Managed Database Administration continues to be a comprehensive guide for becoming proficient in data management. The book begins by introducing you to the Azure SQL managed databases (Azure SQL Database and Azure SQL Managed Instance), explaining their architecture, and how they differ from an on-premises SQL server. You will then learn how to perform common tasks, such as migrating, backing up, and restoring a SQL Server database to an Azure database. As you progress, you will study how you can save costs and manage and scale multiple SQL databases using elastic pools. You will also implement a disaster recovery solution using standard and active geo-replication. Finally, you will explore the monitoring and tuning of databases, the key features of databases, and the phenomenon of app modernization. By the end of this book, you will have mastered the key aspects of an Azure SQL database and Azure SQL managed instance, including migration, backup restorations, performance optimization, high availability, and disaster recovery.

Mastering QlikView Data Visualization. Take your QlikView skills to the next level and master the art of creating visual data analysis for real business needs

Karl Pover

Just because you know how to swing a hammer doesn't mean you know how to build a house. Now that you've learned how to use QlikView, it's time to learn how to develop meaningful QlikView applications that deliver what your business users need.You will explore the requirements and the data from several business departments in order to deliver the most amazing analysis and data visualizations. In doing so, you will practice using advanced QlikView functions, chart object property options, and extensions to solve real-worldchallenges.

Windows Server 2019 Administration Fundamentals. A beginner's guide to managing and administering Windows Server environments - Second Edition

Bekim Dauti

Windows Server 2019 is the server operating system introduced by Microsoft as part of the Windows NT family of operating systems, developed concurrently with Windows 10. This book will not only get you started with Windows Server 2019, but will also help you prepare for the MTA 98-365 exam. With step-by-step instructions and easy-to-understand graphics, you will become well-versed with the roles, features, and functions of Windows Server 2019.Starting with the installation process, upgrades, and basic configuration, you will move on to explore roles and features such as Active Directory, Hyper-V, remote access, storage, and printers. The book then takes you through maintenance and troubleshooting tasks to guide you in efficiently managing Windows Server 2019. In addition, it covers Windows Server 2019 best practices using real-world examples. Complete with questionnaires, and detailed answers at the end of the book, you can test your understanding of the concepts covered in each chapter.By the end of this book, you will be equipped with the knowledge you need to troubleshoot, update, and maintain servers so as to ensure business continuity.

Mastering OpenCV with Practical Computer Vision Projects. This is the definitive advanced tutorial for OpenCV, designed for those with basic C++ skills. The computer vision projects are divided into easily assimilated chapters with an emphasis on practical involvement for an easier learning curve

Mora Saragih, Eugene Khvedchenia, Daniel L?É?íÂ!(C)lis Baggio, Shervin Emami, ...

Computer Vision is fast becoming an important technology and is used in Mars robots, national security systems, automated factories, driver-less cars, and medical image analysis to new forms of human-computer interaction. OpenCV is the most common library for computer vision, providing hundreds of complex and fast algorithms. But it has a steep learning curve and limited in-depth tutorials.Mastering OpenCV with Practical Computer Vision Projects is the perfect book for developers with just basic OpenCV skills who want to try practical computer vision projects, as well as the seasoned OpenCV experts who want to add more Computer Vision topics to their skill set or gain more experience with OpenCV's new C++ interface before migrating from the C API to the C++ API.Each chapter is a separate project including the necessary background knowledge, so try them all one-by-one or jump straight to the projects you're most interested in.Create working prototypes from this book including real-time mobile apps, Augmented Reality, 3D shape from video, or track faces & eyes, fluid wall using Kinect, number plate recognition and so on.Mastering OpenCV with Practical Computer Vision Projects gives you rapid training in nine computer vision areas with useful projects.

Oracle Database 11gR2 Performance Tuning Cookbook. Shifting your Oracle Database into top gear takes a lot of know-how and fine-tuning ability. The 80+ recipes in this Cookbook will give you those skills along with the ability to troubleshoot if things starts running slowly

Ciro Fiorillo

Oracle's Database offers great performance, scalability, and many features for DBAs and developers. Due to a wide choice of technologies, successful applications are good candidates to run into performance issues and when a problem arises it's very difficult to identify the cause and the right solution to the problem.The Oracle Database 11g R2 Performance Tuning Cookbook helps DBAs and developers to understand every aspect of Oracle Database that can affect performance. You will be guided through implementing the correct solution in a proactive way before problems arise, and how to diagnose issues on your Oracle database-based solutions.This fast-paced book offers solutions starting from application design and development, through the implementation of well-performing applications, to the details of deployment and delivering best-performance databases.With this book you will quickly learn to apply the right methodology to tune the performance of an Oracle Database, and to optimize application design and SQL and PL/SQL code. By following the real-world examples you will see how to store your data in correct structures and access and manipulate them at a lightning speed. You will learn to speed up sort operations, hack the optimizer and the data loading process, and diagnose and tune memory, I/O, and contention issues.The purpose of this cookbook is to provide concise recipes, which will help you to build and maintain a very high-speed Oracle Database environment.

Advanced C++ Programming Cookbook. Become an expert C++ programmer by mastering concepts like templates, concurrency, and type deduction

Dr. Rian Quinn

If you think you've mastered C++ and know everything it takes to write robust applications, you'll be in for a surprise. With this book, you'll gain comprehensive insights into C++, covering exclusive tips and interesting techniques to enhance your app development process.You'll kick off with the basic principles of library design and development, which will help you understand how to write reusable and maintainable code. You'll then discover the importance of exception safety, and how you can avoid unexpected errors or bugs in your code. The book will take you through the modern elements of C++, such as move semantics, type deductions, and coroutines. As you advance, you'll delve into template programming - the standard tool for most library developers looking to achieve high code reusability. You'll explore the STL and learn how to avoid common pitfalls while implementing templates. Later, you'll learn about the problems of multithreaded programming such as data races, deadlocks, and thread starvation. You'll also learn high-performance programming by using benchmarking tools and libraries. Finally, you'll discover advanced techniques for debugging and testing to ensure code reliability.By the end of this book, you'll have become an expert at C++ programming and will have gained the skills to solve complex development problems with ease.