Benjamin Johnston

As a trained architect, Johnston has a keen eye for the classic design principles of balance and proportion. His application of clean lines and tailored details demonstrate his timeless sensibility, but he imbues every space with something unexpected to make it feel modern. The homes he creates are both classic and cool, curated with a contemporary eye, a distinctive fusion of styles, time periods, and cultures to create interiors that defy the cliche. In an opening section of his principles, Johnston discusses Intention, Theatre, Architecture, Juxtaposition, Imperfection, Art, Scale, Texture, and Color. The book then segues into seven homes embodying modern elegance, many of which have never been seen before. The rooms reflect a unique blend of creativity, functionality, and a deep understanding of aesthetics. Johnston explores each home in detail, and provides a comprehensive look into his design philosophy, methodologies, and his most important dos and don ts when it comes to creating a home. Whether discussing the role of scale, daytime vs nighttime rooms, creating drama in hospitality spaces, or why every room needs a bit of black, Johnston will guide readers through every part of the design process, making this book a source of inspiration and learning not only to those in the design community, but to anyone looking for ideas and lessons on designing a home.

Level up from basic SQL to advanced, analytics-grade data analysis and use real PostgreSQL datasets, modern features, and practical business scenarios to turn raw data into clear, actionable insights. Key Features Solve real business problems with advanced SQL techniques Work with time-series, geospatial, and text data using PostgreSQL Build job-ready data analysis skills with hands-on SQL projects Purchase of the print or Kindle book includes a free PDF eBook Book DescriptionSQL remains one of the most essential tools for modern data analysis and mastering it can set you apart in a competitive data landscape. This book helps you go beyond basic query writing to develop a deep, practical understanding of how SQL powers real-world decision-making. SQL for Data Analytics, Fourth Edition, is for anyone who wants to go beyond basic SQL syntax and confidently analyze real-world data. Whether you're trying to make sense of production data for the first time or upgrading your analytics toolkit, this book gives you the skills to turn data into actionable outcomes. You'll start by creating and managing structured databases before advancing to data retrieval, transformation, and summarization. From there, you’ll take on more complex tasks such as window functions, statistical operations, and analyzing geospatial, time-series, and text data. With hands-on exercises, case studies, and detailed guidance throughout, this book prepares you to apply SQL in everyday business contexts, whether you're cleaning data, building dashboards, or presenting findings to stakeholders. By the end, you'll have a powerful SQL toolkit that translates directly to the work analysts do every day. What you will learn Write SQL Queries to explore and analyze structured data. Use JOINs, subqueries, views, and CTEs to build analytics-ready datasets Apply window functions to identify trends, patterns, and cohort behavior Perform statistical analysis and hypothesis testing directly in SQL Analyze JSON, arrays, text, geospatial, and time-series data Improve SQL performance with indexing strategies and query plan optimization Load data with Python and automate analytics workflows Complete a full case study simulating a real-world data analysis project Who this book is forThis book is for aspiring and early-career data analysts, data engineers, backend developers, business analysts, and students who want to apply SQL to real-world data analytics. You should have basic SQL familiarity and college-level math knowledge, along with the desire to advance toward analytics-grade SQL, data transformation, pattern discovery, and business insight generation.

Take your first steps to becoming a fully qualified data analyst by learning how to explore complex datasetsKey FeaturesMaster each concept through practical exercises and activitiesDiscover various statistical techniques to analyze your dataImplement everything you've learned on a real-world case study to uncover valuable insightsBook DescriptionEvery day, businesses operate around the clock, and a huge amount of data is generated at a rapid pace. This book helps you analyze this data and identify key patterns and behaviors that can help you and your business understand your customers at a deep, fundamental level. SQL for Data Analytics, Third Edition is a great way to get started with data analysis, showing how to effectively sort and process information from raw data, even without any prior experience. You will begin by learning how to form hypotheses and generate descriptive statistics that can provide key insights into your existing data. As you progress, you will learn how to write SQL queries to aggregate, calculate, and combine SQL data from sources outside of your current dataset. You will also discover how to work with advanced data types, like JSON. By exploring advanced techniques, such as geospatial analysis and text analysis, you will be able to understand your business at a deeper level. Finally, the book lets you in on the secret to getting information faster and more effectively by using advanced techniques like profiling and automation. By the end of this book, you will be proficient in the efficient application of SQL techniques in everyday business scenarios and looking at data with the critical eye of?analytics professional.What you will learnUse SQL to clean, prepare, and combine different datasetsAggregate basic statistics using GROUP BY clausesPerform advanced statistical calculations using a WINDOW functionImport data into a database to combine with other tablesExport SQL query results into various sourcesAnalyze special data types in SQL, including geospatial, date/time, and JSON dataOptimize queries and automate tasksThink about data problems and find answers using SQLWho this book is forIf you're a database engineer looking to transition into analytics or a backend engineer who wants to develop a deeper understanding of production data and gain practical SQL knowledge, 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.Basic familiarity with SQL (such as basic SELECT, WHERE, and GROUP BY clauses) as well as a good understanding of linear algebra, statistics, and PostgreSQL 14 are necessary to make the most of this SQL data analytics book.

Learning how to apply unsupervised algorithms on unlabeled datasets from scratch can be easier than you thought with this beginner's workshop, featuring interesting examples and activitiesKey FeaturesGet familiar with the ecosystem of unsupervised algorithmsLearn interesting methods to simplify large amounts of unorganized dataTackle real-world challenges, such as estimating the population density of a geographical areaBook DescriptionDo you find it difficult to understand how popular companies like WhatsApp and Amazon find valuable insights from large amounts of unorganized data? The Unsupervised Learning Workshop will give you the confidence to deal with cluttered and unlabeled datasets, using unsupervised algorithms in an easy and interactive manner.The book starts by introducing the most popular clustering algorithms of unsupervised learning. You'll find out how hierarchical clustering differs from k-means, along with understanding how to apply DBSCAN to highly complex and noisy data. Moving ahead, you'll use autoencoders for efficient data encoding.As you progress, you'll use t-SNE models to extract high-dimensional information into a lower dimension for better visualization, in addition to working with topic modeling for implementing natural language processing (NLP). In later chapters, you'll find key relationships between customers and businesses using Market Basket Analysis, before going on to use Hotspot Analysis for estimating the population density of an area.By the end of this book, you'll be equipped with the skills you need to apply unsupervised algorithms on cluttered datasets to find useful patterns and insights.What you will learnDistinguish between hierarchical clustering and the k-means algorithmUnderstand the process of finding clusters in dataGrasp interesting techniques to reduce the size of dataUse autoencoders to decode dataExtract text from a large collection of documents using topic modelingCreate a bag-of-words model using the CountVectorizerWho this book is forIf you are a data scientist who is just getting started and want to learn how to implement machine learning algorithms to build predictive models, then this book is for you. To expedite the learning process, a solid understanding of the Python programming language is recommended, as you'll be editing classes and functions instead of creating them from scratch.

Cut through the noise and get real results with a step-by-step approach to understanding supervised learning algorithmsKey FeaturesIdeal for those getting started with machine learning for the first timeA step-by-step machine learning tutorial with exercises and activities that help build key skillsStructured to let you progress at your own pace, on your own termsUse your physical print copy to redeem free access to the online interactive editionBook DescriptionYou already know you want to understand supervised learning, and a smarter way to do that is to learn by doing. The Supervised Learning Workshop focuses on building up your practical skills so that you can deploy and build solutions that leverage key supervised learning algorithms. You'll learn from real examples that lead to real results.Throughout The Supervised Learning Workshop, you'll take an engaging step-by-step approach to understand supervised learning. You won't have to sit through any unnecessary theory. If you're short on time you can jump into a single exercise each day or spend an entire weekend learning how to predict future values with auto regressors. It's your choice. Learning on your terms, you'll build up and reinforce key skills in a way that feels rewarding.Every physical print copy of The Supervised Learning Workshop unlocks access to the interactive edition. With videos detailing all exercises and activities, you'll always have a guided solution. You can also benchmark yourself against assessments, track progress, and receive content updates. You'll even earn a secure credential that you can share and verify online upon completion. It's a premium learning experience that's included with your printed copy. To redeem, follow the instructions located at the start of your book.Fast-paced and direct, The Supervised Learning Workshop is the ideal companion for those with some Python background who are getting started with machine learning. You'll learn how to apply key algorithms like a data scientist, learning along the way. This process means that you'll find that your new skills stick, embedded as best practice. A solid foundation for the years ahead.What you will learnGet to grips with the fundamental of supervised learning algorithmsDiscover how to use Python libraries for supervised learningLearn how to load a dataset in pandas for testingUse different types of plots to visually represent the dataDistinguish between regression and classification problemsLearn how to perform classification using K-NN and decision treesWho this book is forOur goal at Packt is to help you be successful, in whatever it is you choose to do. The Supervised Learning Workshop is ideal for those with a Python background, who are just starting out with machine learning. Pick up a Workshop today, and let Packt help you develop skills that stick with you for life.

Take a step-by-step approach to learning SQL data analysis in this interactive workshop that uses fun exercises and activities to make learning data analytics for beginners easy and approachable.Key FeaturesExplore ways to use SQL for data analytics and gain key insights from your dataStudy advanced analytics, such as geospatial and text analyticsDiscover ways to integrate your SQL pipelines with other analytics technologiesBook DescriptionEvery day, businesses operate around the clock and a huge amount of data is generated at a rapid pace. Hidden in this data are key patterns and behaviors that can help you and your business understand your customers at a deep, fundamental level. Are you ready to enter the exciting world of data analytics and unlock these useful insights?Written by a team of expert data scientists who have used their data analytics skills to transform businesses of all shapes and sizes, The Applied SQL Data Analytics Workshop is a great way to get started with data analysis, showing you how to effectively sieve and process information from raw data, even without any prior experience.The book begins by showing you how to form hypotheses and generate descriptive statistics that can provide key insights into your existing data. As you progress, you'll learn how to write SQL queries to aggregate, calculate and combine SQL data from sources outside of your current dataset. You'll also discover how to work with different data types, like JSON. By exploring advanced techniques, such as geospatial analysis and text analysis, you'll finally be able to understand your business at a deeper level. Finally, the book lets you in on the secret to getting information faster and more effectively by using advanced techniques like profiling and automation.By the end of The Applied SQL Data Analytics Workshop, you'll have the skills you need to start identifying patterns and unlocking insights in your own data. You will be capable of looking and assessing data with the critical eye of a skilled data analyst.What you will learnUnderstand what data analytics is and why it is importantExperiment with data analytics using basic and advanced queriesInterpret data through descriptive statistics and aggregate functionsExport data from external sources using powerful SQL queriesWork with and manipulate data using SQL joins and constraintsSpeed up your data analysis workflow by automating tasks and optimizing queriesWho this book is forIf you are a database engineer who is looking to transition into analytics or someone who knows SQL basics but doesn't know how to use it to create business insights, then this book is for you.

Take your first steps to become a fully qualified data analyst by learning how to explore large relational datasetsKey FeaturesExplore a variety of statistical techniques to analyze your dataIntegrate your SQL pipelines with other analytics technologiesPerform advanced analytics such as geospatial and text analysisBook DescriptionUnderstanding 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 learnPerform advanced statistical calculations using the WINDOW functionUse SQL queries and subqueries to prepare data for analysisImport and export data using a text file and psqlApply special SQL clauses and functions to generate descriptive statisticsAnalyze special data types in SQL, including geospatial data and time dataOptimize queries to improve their performance for faster resultsDebug queries that won’t runUse SQL to summarize and identify patterns in dataWho this book is forIf 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.

Design clever algorithms that can uncover interesting structures and hidden relationships in unstructured, unlabeled dataKey FeaturesLearn how to select the most suitable Python library to solve your problemCompare k-Nearest Neighbor (k-NN) and non-parametric methods and decide when to use themDelve into the applications of neural networks using real-world datasetsBook DescriptionUnsupervised learning is a useful and practical solution in situations where labeled data is not available. Applied Unsupervised Learning with Python guides you on the best practices for using unsupervised learning techniques in tandem with Python libraries and extracting meaningful information from unstructured data. The course begins by explaining how basic clustering works to find similar data points in a set. Once you are well versed with the k-means algorithm and how it operates, you’ll learn what dimensionality reduction is and where to apply it. As you progress, you’ll learn various neural network techniques and how they can improve your model. While studying the applications of unsupervised learning, you will also understand how to mine topics that are trending on Twitter and Facebook and build a news recommendation engine for users. You will complete the course by challenging yourself through various interesting activities such as performing a Market Basket Analysis and identifying relationships between different merchandises. By the end of this course, you will have the skills you need to confidently build your own models using Python.What you will learnUnderstand the basics and importance of clusteringBuild k-means, hierarchical, and DBSCAN clustering algorithms from scratch with built-in packagesExplore dimensionality reduction and its applicationsUse scikit-learn (sklearn) to implement and analyse principal component analysis (PCA)on the Iris datasetEmploy Keras to build autoencoder models for the CIFAR-10 datasetApply the Apriori algorithm with machine learning extensions (Mlxtend) to study transaction dataWho this book is forThis course is designed for developers, data scientists, and machine learning enthusiasts who are interested in unsupervised learning. Some familiarity with Python programming along with basic knowledge of mathematical concepts including exponents, square roots, means, and medians will be beneficial.

Explore the exciting world of machine learning with the fastest growing technology in the worldKey FeaturesUnderstand various machine learning concepts with real-world examplesImplement a supervised machine learning pipeline from data ingestion to validationGain insights into how you can use machine learning in everyday lifeBook DescriptionMachine learning—the ability of a machine to give right answers based on input data—has revolutionized the way we do business. Applied Supervised Learning with Python provides a rich understanding of how you can apply machine learning techniques in your data science projects using Python. You'll explore Jupyter Notebooks, the technology used commonly in academic and commercial circles with in-line code running support.With the help of fun examples, you'll gain experience working on the Python machine learning toolkit—from performing basic data cleaning and processing to working with a range of regression and classification algorithms. Once you’ve grasped the basics, you'll learn how to build and train your own models using advanced techniques such as decision trees, ensemble modeling, validation, and error metrics. You'll also learn data visualization techniques using powerful Python libraries such as Matplotlib and Seaborn. This book also covers ensemble modeling and random forest classifiers along with other methods for combining results from multiple models, and concludes by delving into cross-validation to test your algorithm and check how well the model works on unseen data.By the end of this book, you'll be equipped to not only work with machine learning algorithms, but also be able to create some of your own!What you will learnUnderstand the concept of supervised learning and its applicationsImplement common supervised learning algorithms using machine learning Python librariesValidate models using the k-fold techniqueBuild your models with decision trees to get results effortlesslyUse ensemble modeling techniques to improve the performance of your modelApply a variety of metrics to compare machine learning modelsWho this book is forApplied Supervised Learning with Python is for you if you want to gain a solid understanding of machine learning using Python. It'll help if you to have some experience in any functional or object-oriented language and a basic understanding of Python libraries and expressions, such as arrays and dictionaries.