Data Cleaning with Power BI. The definitive guide to transforming dirty data into actionable insights

Gus Frazer

Microsoft Power BI offers a range of powerful data cleaning and preparation options through tools such as DAX, Power Query, and the M language. However, despite its user-friendly interface, mastering it can be challenging. Whether you're a seasoned analyst or a novice exploring the potential of Power BI, this comprehensive guide equips you with techniques to transform raw data into a reliable foundation for insightful analysis and visualization.This book serves as a comprehensive guide to data cleaning, starting with data quality, common data challenges, and best practices for handling data. You’ll learn how to import and clean data with Query Editor and transform data using the M query language. As you advance, you’ll explore Power BI’s data modeling capabilities for efficient cleaning and establishing relationships. Later chapters cover best practices for using Power Automate for data cleaning and task automation. Finally, you’ll discover how OpenAI and ChatGPT can make data cleaning in Power BI easier.By the end of the book, you will have a comprehensive understanding of data cleaning concepts, techniques, and how to use Power BI and its tools for effective data preparation.

Cocos2d-x Cookbook. Over 50 hands-on recipes to help you efficiently administer and maintain your games with Cocos2d-x

Akihiro Matsuura

Modern C++ Programming Cookbook. Master C++ core language and standard library features, with over 100 recipes, updated to C++20 - Second Edition

Marius Bancila

C++ has come a long way to be one of the most widely used general-purpose languages that is fast, efficient, and high-performance at its core.The updated second edition of Modern C++ Programming Cookbook addresses the latest features of C++20, such as modules, concepts, coroutines, and the many additions to the standard library, including ranges and text formatting. The book is organized in the form of practical recipes covering a wide range of problems faced by modern developers.The book also delves into the details of all the core concepts in modern C++ programming, such as functions and classes, iterators and algorithms, streams and the file system, threading and concurrency, smart pointers and move semantics, and many others. It goes into the performance aspects of programming in depth, teaching developers how to write fast and lean code with the help of best practices.Furthermore, the book explores useful patterns and delves into the implementation of many idioms, including pimpl, named parameter, and attorney-client, teaching techniques such as avoiding repetition with the factory pattern. There is also a chapter dedicated to unit testing, where you are introduced to three of the most widely used libraries for C++: Boost.Test, Google Test, and Catch2.By the end of the book, you will be able to effectively leverage the features and techniques of C++11/14/17/20 programming to enhance the performance, scalability, and efficiency of your applications.

Microsoft Dynamics GP 2010 Implementation. If you feel intimidated by the thought of implementing Microsoft Dynamics GP, this book will quickly overcome any doubts. It’s the simplest, clearest guide available to getting this sophisticated ERP application up and running successfully

Victoria Yudin

Microsoft Dynamics GP 2010 is a sophisticated Enterprise Resource Planning application with a multitude of features and options. The implementation of Dynamics GP is usually considered to be complex, and can be very confusing for users and consultants. This step-by-step guide will show you how to effectively implement Dynamics GP 2010 with ease.This focused, step-by-step tutorial covers the basics of Microsoft Dynamics GP, from licensing, to design, before moving on to more complex topics such as implementation and setup. You will learn how to install and configure Microsoft Dynamics GP 2010 from start to finish.This book will enable you to master the implementation of Microsoft Dynamics 2010 effectively. This book starts with how to plan and complete a successful Microsoft Dynamics GP 2010 implementation. You will then move on to learning who should be on the implementation team, what important questions should be asked and how to plan your infrastructure for Dynamics GP 2010. Detailed descriptions of all the setup options for the core Dynamics GP modules as well as practical advice on setup will help guide you through the myriad of options available in this powerful application. As you reach the end of the book you will learn how to import your initial data with illustrations and practical examples.

ASP.NET 3.5 Social Networking. An expert guide to building enterprise-ready social networking and community applications with ASP.NET 3.5

Andrew Siemer

Windows Phone 7.5 Data Cookbook. Over 30 recipes for storing, managing, and manipulating data in Windows Phone 7.5 Mango applications

Ramesh Thalli

Windows Phone 7.5 Mango contains support for apps written in Silverlight or XNA. These apps can store data on the device, and also load and manipulate data from the cloud and other web services.This Windows Phone 7.5 Data Cookbook has a range of recipes to help you apply data handling concepts. You will be able to apply the knowledge gained from these recipes to build your own apps effectively. This Windows Phone 7.5 Data Cookbook starts with data binding concepts at the UI layer and then shows different ways of saving data locally and externally in databases. The book ends with a look at the popular MVVM software design pattern. The recipes contained in this book will make you an expert in the areas of data access and storage.

Mastering Git. Attain expert level proficiency with Git for enhanced productivity and efficient collaboration

Jakub Narębski, Jakub S Narebski

Git is one of the most popular types of Source Code Management (SCM) and Distributed Version Control System (DVCS). Despite the powerful and versatile nature of the tool enveloping strong support for nonlinear development and the ability to handle large projects efficiently, it is a complex tool and often regarded as “user-unfriendly”. Getting to know the ideas and concepts behind the architecture of Git will help you make full use of its power and understand its behavior. Learning the best practices and recommended workflows should help you to avoid problems and ensure trouble-free development.The book scope is meticulously designed to help you gain deeper insights into Git's architecture, its underlying concepts, behavior, and best practices. Mastering Git starts with a quick implementation example of using Git for a collaborative development of a sample project to establish the foundation knowledge of Git operational tasks and concepts. Furthermore, as you progress through the book, the tutorials provide detailed descriptions of various areas of usage: from archaeology, through managing your own work, to working with other developers. This book also helps augment your understanding to examine and explore project history, create and manage your contributions, set up repositories and branches for collaboration in centralized and distributed version control, integrate work from other developers, customize and extend Git, and recover from repository errors. By exploring advanced Git practices, you will attain a deeper understanding of Git’s behavior, allowing you to customize and extend existing recipes and write your own.

Unity 2018 By Example. Learn about game and virtual reality development by creating five engaging projects - Second Edition

Alan Thorn

Unity is the most exciting and popular engine used for developing games. With its 2018 release, Unity has become the primary source of both game development and virtual reality content.In Unity 2018 By Example, you’ll learn how to use Unity in order to make amazing games from popular genres - from action shooters to mind-bending puzzle games to adventure and Virtual Reality (VR) games. Even if you have no previous experience of using Unity, this book will help you understand the toolsets it provides in depth. In addition to this, you'll understand how to create time-critical collection games, twin-stick space shooters, platformers, and action-fest games with intelligent enemies. Finally, you'll get to grips with creating VR games with the new toolsets introduced by Unity to help you develop amazing VR experiences.To make things easier, you will be provided with step-by-step tutorials for making five great games in Unity 2018, along with a detailed explanation of all the fundamental concepts. By the end of this book, you’ll have established a strong foundation in making games with Unity 2018.

Tableau Desktop Certified Associate: Exam Guide. Develop your Tableau skills and prepare for Tableau certification with tips from industry experts

Dmitry Anoshin, JC Gillet, Fabian Peri, Radhika Biyani, ...

The Tableau Desktop Certified Associate exam measures your knowledge of Tableau Desktop and your ability to work with data and data visualization techniques. This book will help you to become well-versed in Tableau software and use its business intelligence (BI) features to solve BI and analytics challenges.With the help of this book, you'll explore the authors' success stories and their experience with Tableau. You'll start by understanding the importance of Tableau certification and the different certification exams, along with covering the exam format, Tableau basics, and best practices for preparing data for analysis and visualization. The book builds on your knowledge of advanced Tableau topics such as table calculations for solving problems. You'll learn to effectively visualize geographic data using vector maps. Later, you'll discover the analytics capabilities of Tableau by learning how to use features such as forecasting. Finally, you'll understand how to build and customize dashboards, while ensuring they convey information effectively. Every chapter has examples and tests to reinforce your learning, along with mock tests in the last section.By the end of this book, you'll be able to efficiently prepare for the certification exam with the help of mock tests, detailed explanations, and expert advice from the authors.

Data Literacy in Practice. A complete guide to data literacy and making smarter decisions with data through intelligent actions

Angelika Klidas, Kevin Hanegan

Data is more than a mere commodity in our digital world. It is the ebb and flow of our modern existence. Individuals, teams, and enterprises working with data can unlock a new realm of possibilities. And the resultant agility, growth, and inevitable success have one origin—data literacy.This comprehensive guide is written by two data literacy pioneers, each with a thorough footprint within the data and analytics commercial world and lectures at top universities in the US and the Netherlands. Complete with best practices, practical models, and real-world examples, Data Literacy in Practice will help you start making your data work for you by building your understanding of data literacy basics and accelerating your journey to independently uncovering insights.You’ll learn the four-pillar model that underpins all data and analytics and explore concepts such as measuring data quality, setting up a pragmatic data management environment, choosing the right graphs for your readers, and questioning your insights.By the end of the book, you'll be equipped with a combination of skills and mindset as well as with tools and frameworks that will allow you to find insights and meaning within your data for data-informed decision making.

Getting Started with Dynamics NAV 2013 Application Development. Using this tutorial will take you deeper into Dynamics NAV from a developer's viewpoint, and allow you to unlock its full potential. The book covers developing an application from start to finish in logical, illuminating steps

Alex Chow

So, your company has made the wise decision to use Dynamics NAV as its main business software for all its enterprise resource planning. Dive in and learn the ins and outs of the software from a development standpoint and unlock the software's full potential.The book will walk you through creating an application from start to finish. Once you know how to create a working application that users can access, you will have the knowledge and the resources needed to create other applications based on the tutorials covered in this guide.You will start by obtaining a free trial version of Dynamics NAV and then be introduced to the world of analyzing and deriving user problems into a requirements list. Finally, you will be shown how to use the software to knock out these requirements.You will learn everything you need in order to begin creating your own applications, from translating the user's requirements to creating and modifying your system applications. Use Dynamics NAV's capability to create an application and address the user's needs, while also learning best practices and simple solutions.Getting Started with Dynamics NAV 2013 Application Development will help you on your way to becoming a great developer!

iOS Forensics for Investigators. Take mobile forensics to the next level by analyzing, extracting, and reporting sensitive evidence

Gianluca Tiepolo

Professionals working in the mobile forensics industry will be able to put their knowledge to work with this practical guide to learning how to extract and analyze all available data from an iOS device.This audiobook is a comprehensive, how-to guide that leads investigators through the process of collecting mobile devices and preserving, extracting, and analyzing data, as well as building a report. Complete with step-by-step explanations of essential concepts, practical examples, and self-assessment questions, this book starts by covering the fundamentals of mobile forensics and how to overcome challenges in extracting data from iOS devices. Once you've walked through the basics of iOS, you’ll learn how to use commercial tools to extract and process data and manually search for artifacts stored in database files. Next, you'll find out the correct workflows for handling iOS devices and understand how to extract valuable information to track device usage. You’ll also get to grips with analyzing key artifacts, such as browser history, the pattern of life data, location data, and social network forensics.By the end of this audiobook, you'll be able to establish a proper workflow for handling iOS devices, extracting all available data, and analyzing it to gather precious insights that can be reported as prosecutable evidence.

Small Business Server 2008 - Installation, Migration, and Configuration. Set up and run Microsoft Small Business Server 2008 making it deliver a big business impact with this book and

David Overton

Small Businesses need to capitalize on the investments they make in IT to drive the business forward. SBS 2008 is uniquely positioned to deliver, but a poor implementation becomes a hindrance rather than a benefit to your business. Well implemented solutions enable your business to appear larger, yet more dynamic than many enterprises.It's easy to get Small Business Server 2008 up and running when you've got this book to hand. It helps you in a clear and friendly manner to understand how to implement SBS 2008 inside your business in a way that matches your business needs. The author's experience enables him to share a tried and tested path to deliver the business benefits without becoming bogged down in unnecessary details that are not relevant to small businesses.SBS 2008 is a fantastic investment for Small Businesses to make towards a well managed and highly functional IT solution in their business. This book is the culmination of many years advising small business owners and consultants on the recommend, tried and tested path to implement small business technology from Microsoft. Through this book you will gain an understanding of the features you can choose to use and then how to securely implement the server to deliver them. It will guide you through the installation and configuration process with the help of step-by-step instructions and plentiful screenshots. It will also explain how you can benefit from the collaboration tools based on SharePoint and how you can protect all your business data with a back-up process that covers anything from deleted files to a fire in the office.Imagine how great you'll feel when your Small Business Server 2008 is ready and working, and you can get back to surfing the Internet!

Windows Server 2019 Automation with PowerShell Cookbook. Powerful ways to automate and manage Windows administrative tasks - Third Edition

Thomas Lee

Windows Server 2019 is the latest version of Microsoft’s flagship server operating system. It also comes with PowerShell Version 5.1 and offers a number of additional features that IT professionals will find useful. This book is designed to help you learn how to use PowerShell and manage the core roles, features, and services of Windows Server 2019.You will begin by creating a PowerShell Administrative Environment that features updated versions of PowerShell, the Windows Management Framework, .NET Framework, and third-party modules. Next, you will learn to use PowerShell to set up and configure Windows Server 2019 networking and understand how to manage objects in the Active Directory (AD) environment. The book will also guide you in setting up a host to utilize containers and deploying containers. Further along, you will be able to implement different mechanisms to achieve Desired State Configuration. The book will then get you up to speed with Azure infrastructure, in addition to helping you get to grips with setting up virtual machines (VMs), websites, and file share on Azure. In the concluding chapters, you will be able to deploy some powerful tools to diagnose and resolve issues with Windows Server 2019.By the end of this book, you will be equipped with a number of useful tips and tricks to automate your Windows environment with PowerShell.

Mastering Flask Web and API Development. Build and deploy production-ready Flask apps seamlessly across web, APIs, and mobile platforms

Sherwin John C. Tragura

Flask is a popular Python framework known for its lightweight and modular design. Mastering Flask Web and API Development will take you on an exhaustive tour of the Flask environment and teach you how to build a production-ready application.You’ll start by installing Flask and grasping fundamental concepts, such as MVC and ORM database access. Next, you’ll master structuring applications for scalability through Flask blueprints. As you progress, you’ll explore both SQL and NoSQL databases while creating REST APIs and implementing JWT authentication, and improve your skills in role-based access security, utilizing LDAP, OAuth, OpenID, and databases. The new project structure, managed by context managers, as well as ASGI support, has revolutionized Flask, and you’ll get to grips with these crucial upgrades. You'll also explore out-of-the-box integrations with technologies, such as RabbitMQ, Celery, NoSQL databases, PostgreSQL, and various external modules. The concluding chapters discuss enterprise-related challenges where Flask proves its mettle as a core solution.By the end of this book, you’ll be well-versed with Flask, seeing it not only as a lightweight web and API framework, but also as a potent problem-solving tool in your daily work, addressing integration and enterprise issues alongside Django and FastAPI.

FL Studio Cookbook. Over 40 recipes to help you master the art of music production with FL Studio

Shaun Friedman