Bazy danych
Soheil Bakhshi, Christian Wade
This book is a comprehensive guide to understanding the ins and outs of data modeling and how to create full-fledged data models using Power BI confidently.In this new, fully updated edition, you'll learn how to connect data from multiple sources, understand data, define and manage relationships between data, and shape data models to gain deep and detailed insights about your organization. As you advance through the chapters, the book will demonstrate how to prepare efficient data models in the Power Query Editor and use simpler DAX code with new data modeling features. You'll explore how to use the various data modeling and navigation techniques and perform custom calculations using the modeling features with the help of real-world examples. Finally, you'll learn how to use some new and advanced modeling features to enhance your data models to carry out a wide variety of complex tasks. Additionally, you'll learn valuable best practices and explore common data modeling complications and the solutions to supercharge the process of creating a data model in Power BI and build better-performing data models.By the end of this Power BI book, you'll have gained the skills you need to structure data coming from multiple sources in different ways to create optimized data models that support high-performing reports and data analytics.
Extreme DAX. Take your Power BI and Fabric analytics skills to the next level - Second Edition
Michiel Rozema, Madzy Stikkelorum, Henk Vlootman, Jeroen...
This book helps experienced analysts unlock the full potential of DAX in Power BI and Microsoft Fabric to build scalable, production-ready analytics solutions.You’ll begin by strengthening your understanding of semantic models, data modeling, and evaluation context—the foundation of reliable analytics. Instead of isolated examples, the book uses real-world scenarios such as inventory analysis, benchmarking, and data security to show how advanced DAX calculations are applied in practice.As you progress, you’ll master advanced techniques including context transition, table functions, calculation groups, field parameters, and custom calendars. You’ll also explore analytical methods such as regression and goal-seeking to generate deeper insights from your data.With step-by-step guidance and practical PBIX examples, you’ll learn how to design efficient models, avoid common pitfalls, and implement reusable calculations. By the end, you’ll be able to create advanced DAX measures and high-performance Power BI solutions for complex analytical requirements.
F# 4.0 Design Patterns. Solve complex problems with functional thinking
Gene Belitski
Following design patterns is a well-known approach to writing better programs that captures and reuses high-level abstractions that are common in many applications. This book will encourage you to develop an idiomatic F# coding skillset by fully embracing the functional-first F# paradigm. It will also help you harness this powerful instrument to write succinct, bug-free, and cross-platform code.F# 4.0 Design Patterns will start off by helping you develop a functional way of thinking. We will show you how beneficial the functional-first paradigm is and how to use it to get the optimum results. The book will help you acquire the practical knowledge of the main functional design patterns, the relationship of which with the traditional Gang of Four set is not straightforward.We will take you through pattern matching, immutable data types, and sequences in F#. We will also uncover advanced functional patterns, look at polymorphic functions, typical data crunching techniques, adjusting code through augmentation, and generalization. Lastly, we will take a look at the advanced techniques to equip you with everything you need to write flawless code.
Raúl Estrada
SMACK is an open source full stack for big data architecture. It is a combination of Spark, Mesos, Akka, Cassandra, and Kafka. This stack is the newest technique developers have begun to use to tackle critical real-time analytics for big data. This highly practical guide will teach you how to integrate these technologies to create a highly efficient data analysis system for fast data processing.We’ll start off with an introduction to SMACK and show you when to use it. First you’ll get to grips with functional thinking and problem solving using Scala. Next you’ll come to understand the Akka architecture. Then you’ll get to know how to improve the data structure architecture and optimize resources using Apache Spark. Moving forward, you’ll learn how to perform linear scalability in databases with Apache Cassandra. You’ll grasp the high throughput distributed messaging systems using Apache Kafka. We’ll show you how to build a cheap but effective cluster infrastructure with Apache Mesos. Finally, you will deep dive into the different aspect of SMACK using a few case studies. By the end of the book, you will be able to integrate all the components of the SMACK stack and use them together to achieve highly effective and fast data processing.
Feature Store for Machine Learning. Curate, discover, share and serve ML features at scale
Jayanth Kumar M J
Feature store is one of the storage layers in machine learning (ML) operations, where data scientists and ML engineers can store transformed and curated features for ML models. This makes them available for model training, inference (batch and online), and reuse in other ML pipelines. Knowing how to utilize feature stores to their fullest potential can save you a lot of time and effort, and this book will teach you everything you need to know to get started.Feature Store for Machine Learning is for data scientists who want to learn how to use feature stores to share and reuse each other's work and expertise. You’ll be able to implement practices that help in eliminating reprocessing of data, providing model-reproducible capabilities, and reducing duplication of work, thus improving the time to production of the ML model. While this ML book offers some theoretical groundwork for developers who are just getting to grips with feature stores, there's plenty of practical know-how for those ready to put their knowledge to work. With a hands-on approach to implementation and associated methodologies, you'll get up and running in no time.By the end of this book, you’ll have understood why feature stores are essential and how to use them in your ML projects, both on your local system and on the cloud.
Greg Rafferty
Forecasting Time Series Data with Prophet will help you to implement Prophet's cutting-edge forecasting techniques to model future data with high accuracy using only a few lines of code. This second edition has been fully revised with every update to the Prophet package since the first edition was published two years ago. An entirely new chapter is also included, diving into the mathematical equations behind Prophet's models. Additionally, the book contains new sections on forecasting during shocks such as COVID, creating custom trend modes from scratch, and a discussion of recent developments in the open-source forecasting community.You'll cover advanced features such as visualizing forecasts, adding holidays and trend changepoints, and handling outliers. You'll use the Fourier series to model seasonality, learn how to choose between an additive and multiplicative model, and understand when to modify each model parameter. Later, you'll see how to optimize more complicated models with hyperparameter tuning and by adding additional regressors to the model. Finally, you'll learn how to run diagnostics to evaluate the performance of your models in production.By the end of this book, you'll be able to take a raw time series dataset and build advanced and accurate forecasting models with concise, understandable, and repeatable code.
Sebastien Drouyer
This book is for intermediary to seasoned web developers who want to learn how to use the FuelPHP framework and build complex projects using it. You should be familiar with PHP, HTML, CSS, and JavaScript, but no prior knowledge about MVC frameworks is required.
Funkcje okna w języku T-SQL dla SQL Server 2019
Itzik Ben-Gan
Wykorzystaj funkcje okna do tworzenia prostszych, lepszych i wydajniejszych zapytań Większość programistów T-SQL docenia wartość funkcji okna w analizowaniu danych. Potrafią one jednak znacznie więcej, a ostatnie optymalizacje sprawiają, że stały się jeszcze skuteczniejsze. Uznany ekspert T-SQL Itzik Ben-Gan wprowadza przełomowe techniki wykorzystania funkcji okna do realizowania wielu typowych zadań z nieznaną wcześniej elegancją i siłą. Przy użyciu bogatych przykładów kodu prowadzi Czytelnika poprzez funkcje agregujące, rankingowe, statystyczne, przesunięć i zbiorów uporządkowanych. Znajdziemy tu szczegółowy rozdział o optymalizacji oraz kolekcję rozwiązań biznesowych w tym nowatorskie techniki, które nie są dostępne w żadnej innej książce. MVP Itzik Ben-Gan pokazuje, jak: Używać funkcji okna do usprawnienia kwerend, które wcześniej budowalismy za pomocą predykatów Opanować kluczowe koncepcje okien SQL i wydajnie projektować funkcje okna Skutecznie wykorzystywać partycjonowanie, porządkowanie i ramy Zdobyć praktyczne, pogłębione zrozumienie agregujących, rankingowych i statystycznych funkcji okna Zrozumieć, jak standard SQL obsługuje funkcje zbiorów uporządkowanych i znaleźć działające rozwiązania dla funkcji, które nie są jeszcze dostępne w konkretnym dialekcie Pozna zaawansowane techniki analizy danych oparte na rozwiązywaniu wzorców wierszy Optymalizować funkcje okna w SQL Server i Azure SQL Database, maksymalnie wykorzystując indeksowanie, równoległość i nie tylko Odkryć pełną bibliotekę rozwiązań opartych na funkcjach okna dla typowych problemów biznesowych O tej książce Dla programistów, administratorów baz danych, analityków, profesjonalistów BI i zaawansowanych użytkowników korzystających z kwerend T-SQL Dotyczy dowolnego wydania silnika bazy danych SQL Server 2019 i późniejszego, a także Azure SQL Database O autorze Itzik Ben-Gan, MVP firmy Microsoft w dziedzinie platform danych od roku 1999, jest mentorem i współzałożycielem firmy SolidQ oraz podstawą jej działalności w dziedzinie T-SQL. Prowadził liczne wykłady w dziedzinie zapytań w języku T-SQL, dostrajania zapytań i programowania na całym świecie, Jest autorem licznych książek, w tym Podstawy T-SQL i Zapytania w języku T-SQL, a także programów nauczania Advanced T-SQL Querying, Programming, and Tuning oraz T-SQL Fundamentals prowadzonych przez SolidQ. Pisuje również w witrynach sqlperformance.com, ITProToday and SolidQ. Występował w licznych konferencjach, w tym PASS Summit i SQLBits. Przykłady kodu dostępne są pod adresem: MicrosoftPressStore.com/TSQLWindowFunctions/downloads