An introduction to learning how to protect ourselves and organise against Big Data

EPDF and EPUB available Open Access under CC-BY-NC-ND licence Drawing on the study of different cities in the Global South, this book explores how data have become a generative force in shaping what cities are, how they are governed and inhabited, especially during times of crisis, such as the COVID-19 pandemic.

Data Ethics of Power takes a reflective and fresh look at the ethical implications of transforming everyday life and the world through the effortless, costless, and seamless accumulation of extra layers of data. By shedding light on the constant tensions that exist between ethical principles and the interests invested in this socio-technical transformation, the book bridges the theory and practice divide in the study of the power dynamics that underpin these processes of the digitalization of the world.

Renowned DAX experts Alberto Ferrari and Marco Russo teach you how to design data models for maximum efficiency and effectiveness. How can you use Excel and Power BI to gain real insights into your information? As you examine your data, how do you write a formula that provides the numbers you need? The answers to both of these questions lie with the data model. This book introduces the basic techniques for shaping data models in Excel and Power BI. It’s meant for readers who are new to data modeling as well as for experienced data modelers looking for tips from the experts. If you want to use Power BI or Excel to analyze data, the many real-world examples in this book will help you look at your reports in a different way–like experienced data modelers do. As you’ll soon see, with the right data model, the correct answer is always a simple one! By reading this book, you will: • Gain an understanding of the basics of data modeling, including tables, relationships, and keys • Familiarize yourself with star schemas, snowflakes, and common modeling techniques • Learn the importance of granularity • Discover how to use multiple fact tables, like sales and purchases, in a complex data model • Manage calendar-related calculations by using date tables • Track historical attributes, like previous addresses of customers or manager assignments • Use snapshots to compute quantity on hand • Work with multiple currencies in the most efficient way • Analyze events that have durations, including overlapping durations • Learn what data model you need to answer your specific business questions About This Book • For Excel and Power BI users who want to exploit the full power of their favorite tools • For BI professionals seeking new ideas for modeling data

Power Query is one component of the Power BI (Business Intelligence) product from Microsoft, and "M" is the name of the programming language created by it. As more business intelligence pros begin using Power Pivot, they find that they do not have the Excel skills to clean the data in Excel; Power Query solves this problem. This book shows how to use the Power Query tool to get difficult data sets into both Excel and Power Pivot, and is solely devoted to Power Query dashboarding and reporting.

Machine Learning and Data Science in the Power Generation Industry explores current best practices and quantifies the value-add in developing data-oriented computational programs in the power industry, with a particular focus on thoughtfully chosen real-world case studies. It provides a set of realistic pathways for organizations seeking to develop machine learning methods, with a discussion on data selection and curation as well as organizational implementation in terms of staffing and continuing operationalization. It articulates a body of case study–driven best practices, including renewable energy sources, the smart grid, and the finances around spot markets, and forecasting. Provides best practices on how to design and set up ML projects in power systems, including all nontechnological aspects necessary to be successful Explores implementation pathways, explaining key ML algorithms and approaches as well as the choices that must be made, how to make them, what outcomes may be expected, and how the data must be prepared for them Determines the specific data needs for the collection, processing, and operationalization of data within machine learning algorithms for power systems Accompanied by numerous supporting real-world case studies, providing practical evidence of both best practices and potential pitfalls