In this episode, Bryce and Conor finish their interview with Kate Gregory and talk about the Carbon Programming Language. Link to Episode 95 on Website Twitter ADSP: The PodcastConor HoekstraBryce Adelstein LelbachAbout the Guest: Kate Gregory is an author, sought-after conference speaker, trainer, Microsoft Most Valuable Professional (MVP), and partner at Gregory Consulting. Kate has been using C++ since before Microsoft had a C++ compiler. She is an early adopter of many software technologies and tools, and a well-connected member of the software development community. Kate is one of the founders of #include whose goal is a more welcoming and inclusive C++ community. She also serves on the board of directors of Cpp Toronto, a non-profit organization that provides an open, inclusive, and collaborative place where software developers can meet and discuss topics related to C++ software development. Show Notes Date Recorded: 2022-08-15 Date Released: 2022-09-16 Carbon Language: An experimental successor to C++ - Chandler Carruth - CppNorth 2022Carbon Programming LanguageCppNorth ConferenceSwift Programming LanguageKotlin Programming LanguageRust Programming LanguageCurb CutsToronto Public Libraryfoonathon::blog() Carbon’s most exciting feature is its calling conventionKeynote: “Am I A Good Programmer?” - Kate Gregory - CppNorth 2022PluralSight Courses- Kate GregoryBeautiful C++: 30 Core Guidelines for Writing Clean, Safe, and Fast Code by Guy Davidson & Kate GregoryIntro Song Info Miss You by Sarah Jansen https://soundcloud.com/sarahjansenmusic  Creative Commons — Attribution 3.0 Unported — CC BY 3.0  Free Download / Stream: http://bit.ly/l-miss-you  Music promoted by Audio Library https://youtu.be/iYYxnasvfx8

In this episode, Bryce and Conor continue their interview with Kate Gregory and talk about the future of CppNorth and her most recent PluralSight courses. Link to Episode 94 on Website Twitter ADSP: The PodcastConor HoekstraBryce Adelstein LelbachAbout the Guest: Kate Gregory is an author, sought-after conference speaker, trainer, Microsoft Most Valuable Professional (MVP), and partner at Gregory Consulting. Kate has been using C++ since before Microsoft had a C++ compiler. She is an early adopter of many software technologies and tools, and a well-connected member of the software development community. Kate is one of the founders of #include whose goal is a more welcoming and inclusive C++ community. She also serves on the board of directors of Cpp Toronto, a non-profit organization that provides an open, inclusive, and collaborative place where software developers can meet and discuss topics related to C++ software development. Show Notes Date Recorded: 2022-08-15 Date Released: 2022-09-09 FULFIL Mint Protein BarElderberry FlowerCppNorth ConferenceCppCast CppNorth EpisodeKeynote: “Am I A Good Programmer?” - Kate Gregory - CppNorth 2022PluralSight Courses- Kate GregoryBeautiful C++: 30 Core Guidelines for Writing Clean, Safe, and Fast Code by Guy Davidson & Kate GregoryCarbon Programming LanguageIntro Song Info Miss You by Sarah Jansen https://soundcloud.com/sarahjansenmusic Creative Commons — Attribution 3.0 Unported — CC BY 3.0 Free Download / Stream: http://bit.ly/l-miss-you Music promoted by Audio Library https://youtu.be/iYYxnasvfx8

In this episode, Bryce and Conor continue their interview with Kate Gregory and talk about CppNorth and her keynote. Link to Episode 93 on Website Twitter ADSP: The PodcastConor HoekstraBryce Adelstein LelbachAbout the Guest: Kate Gregory is an author, sought-after conference speaker, trainer, Microsoft Most Valuable Professional (MVP), and partner at Gregory Consulting. Kate has been using C++ since before Microsoft had a C++ compiler. She is an early adopter of many software technologies and tools, and a well-connected member of the software development community. Kate is one of the founders of #include whose goal is a more welcoming and inclusive C++ community. She also serves on the board of directors of Cpp Toronto, a non-profit organization that provides an open, inclusive, and collaborative place where software developers can meet and discuss topics related to C++ software development. Show Notes Date Recorded: 2022-08-15 Date Released: 2022-09-02 Keynote: “Am I A Good Programmer?” - Kate Gregory - CppNorth 2022CppCon 2015: Kate Gregory “Stop Teaching C”KEYNOTE - Emotional Code - Kate Gregory [ACCU Conference 2019]PluralSight - Kate GregoryBeautiful C++: 30 Core Guidelines for Writing Clean, Safe, and Fast Code by Guy Davidson & Kate GregoryCppNorth ConferenceCarbon Programming LanguageIntro Song Info Miss You by Sarah Jansen https://soundcloud.com/sarahjansenmusic  Creative Commons — Attribution 3.0 Unported — CC BY 3.0  Free Download / Stream: http://bit.ly/l-miss-you  Music promoted by Audio Library https://youtu.be/iYYxnasvfx8

Microsoft Power Apps Cookbook, Second Edition, is your ultimate guide to unlocking the full potential of Microsoft's low-code platform for building custom business applications. From practical recipes that solve real-world challenges to advanced techniques, this book empowers you with tools to streamline processes and elevate your organization's productivity. What this Book will help me do Master the skills to design and implement canvas and model-driven apps to fit your business requirements. Utilize Microsoft Dataverse effectively as the data backbone for your applications. Automate business workflows dynamically using Power Automate and robotic process automation techniques. Expand your application's capabilities with AI Builder and mixed reality integrations for innovative solutions. Harness the Power Apps Component Framework to build powerful, customized extensions to meet enterprise-grade needs. Author(s) Eickhel Mendoza is a seasoned professional in low-code application development, specializing in the Microsoft Power Platform. With extensive experience in helping organizations implement effective solutions and improve productivity, Eickhel brings a pragmatic, hands-on approach to technical writing. His deep understanding of Power Apps and user-centric teaching style make this book an invaluable resource for developers and citizen creators alike. Who is it for? This book is designed for information workers, IT professionals, and citizen developers aiming to build custom applications tailored to their organizational needs. It is equally beneficial for traditional application developers interested in leveraging a rapid application development platform. A basic understanding of the Microsoft Power Platform ecosystem is recommended to make the most out of this book.

In this episode, Bryce and Conor interview Kate Gregory about her career history. Link to Episode 92 on Website Twitter ADSP: The PodcastConor HoekstraBryce Adelstein LelbachAbout the Guest: Kate Gregory is an author, sought-after conference speaker, trainer, Microsoft Most Valuable Professional (MVP), and partner at Gregory Consulting. Kate has been using C++ since before Microsoft had a C++ compiler. She is an early adopter of many software technologies and tools, and a well-connected member of the software development community. Kate is one of the founders of #include whose goal is a more welcoming and inclusive C++ community. She also serves on the board of directors of Cpp Toronto, a non-profit organization that provides an open, inclusive, and collaborative place where software developers can meet and discuss topics related to C++ software development. Show Notes Date Recorded: 2022-08-15 Date Released: 2022-08-26 Podcast Appearances CppCast Episode 30: Stop Teaching C (When Teaching C++)Episode 148: C++ SimplicityEpisode 238: Beautiful C++.NET Rocks! Episode 88: Kate Gregory on C+++, VB.NET, and VSTOOther .Net Rocks Episodes (search “Kate Gregory”)CoRecursive Episode 56: Memento Mori With Kate GregoryOther Links C++Now 2019: Conor Hoekstra “Algorithm Intuition”CppCon 2015: Kate Gregory “Stop Teaching C”Keynote: “Am I A Good Programmer?” - Kate Gregory - CppNorth 2022Beautiful C++: 30 Core Guidelines for Writing Clean, Safe, and Fast Code by Guy Davidson & Kate GregoryWATFOR — The University of Waterloo FORTRAN IV compilerWATFIVPluralSight - Kate GregoryNDC TechTown - Magazinet Kongsberg (29 Aug – 1 Sept)Intro Song Info Miss You by Sarah Jansen https://soundcloud.com/sarahjansenmusic Creative Commons — Attribution 3.0 Unported — CC BY 3.0 Free Download / Stream: http://bit.ly/l-miss-you Music promoted by Audio Library https://youtu.be/iYYxnasvfx8

Master the art of workflow automation with Microsoft Power Automate using this approachable, hands-on guide. By following practical examples and step-by-step tutorials, you'll learn how to streamline your business processes with minimal coding experience. Explore key features like connectors, actions, and triggers, and apply them to real-world applications to enhance productivity. What this Book will help me do Understand the fundamental principles of Microsoft Power Automate and its utility in business process optimization. Learn to create automation flows that seamlessly integrate with Microsoft 365 applications and popular third-party services. Gain practical experience working with Power Automate Desktop for robotic process automation. Acquire knowledge of using AI tools within Power Automate, such as sentiment analysis models. Develop skills to efficiently troubleshoot, monitor, and distribute automation flows. Author(s) Aaron Guilmette is an experienced technical author and Microsoft expert. With a deep understanding of Microsoft Power Automate and the Power Platform, Aaron brings a wealth of knowledge to his teaching. He specializes in helping users transition from basic to advanced automation concepts and is known for his clear, structured, and actionable writing style. Who is it for? This book is for professionals looking to streamline their workflows and embrace automation with the Microsoft 365 suite. No extensive technical knowledge is required, making it ideal for beginners who want to learn practical workflow automation. Experienced users can also benefit from exploring advanced features like AI integrations. If you're aiming to improve productivity and reduce manual tasks, this book is perfect for you.

Prepare for Microsoft Exam PL-300 and help demonstrate your real-world ability to deliver actionable insights with Power BI by leveraging available data and domain expertise; to provide meaningful business value through clear data visualizations; to enable others to perform self-service analytics, and to deploy and configure solutions for consumption. Designed for data analysts, business users, and other professionals, this Exam Ref focuses on the critical thinking and decision-making acumen needed for success at the Microsoft Certified: Power BI Data Analyst Associate level. Focus on the expertise measured by these objectives: Prepare the data Model the data Visualize and analyze the data Deploy and maintain assets This Microsoft Exam Ref: Organizes its coverage by exam objectives Features strategic, what-if scenarios to challenge you Assumes you are a data analyst, business intelligence professional, report creator, or other professional seeking to validate your skills and knowledge in analyzing data with Power BI About the Exam Exam PL-300 focuses on knowledge needed to get data from different data sources; clean, transform, and load data; design and develop data models; create model calculations with DAX; optimize model performance; create reports and dashboards; enhance reports for usability and storytelling; identify patterns and trends; and manage files, datasets, and workspaces. About Microsoft Certification Passing this exam fulfills your requirements for the Microsoft Certified: Power BI Data Analyst Associate certification, demonstrating your understanding of data repositories and data processes, and your skills in designing and building scalable data models, cleaning and transforming data, enabling advanced analytic capabilities to provide meaningful business value, and collaborating with key stakeholders to deliver relevant insights based on identified business requirements. See full details at: microsoft.com/learn ...

Migrate your existing, on-premises applications into the Microsoft Azure cloud platform. This book covers the best practices to plan, implement, and operationalize the migration of a database application from your organization’s data center to Microsoft’s Azure cloud platform. Data modernization and migration is a technologically complex endeavor that can also be taxing from a leadership and operational standpoint. This book covers not only the technology, but also the most important aspects of organization culture, communication, and politics that so frequently derail such projects. You will learn the most important steps to ensuring a successful migration and see battle-tested wisdom from industry veterans. From executive sponsorship, to executing the migration, to the important steps following migration, you will learn how to effectively conduct future migrations and ensure that your team and your database application delivers on the expected business value of the project. This book is unlike any other currently in the market. It takes you through the most critical business and technical considerations and workflows for moving your data and databases into the cloud, with special attention paid to those who are deploying to the Microsoft Data Platform in Azure, especially SQL Server. Although this book focuses on migrating on-premises SQL Server enterprises to hybrid or fully cloud-based Azure SQL Database and Azure SQL Managed Instances, it also cover topics involving migrating non-SQL Server database platforms such as Oracle, MySQL, and PostgreSQL applications to Microsoft Azure. What You Will Learn Plan a database migration that ensures smooth project progress, optimal performance, low operating cost, and minimal downtime Properly analyze and manage non-technical considerations, such as legal compliance, privacy, and team execution Perform athorough architectural analysis to select the best Azure services, performance tiers, and cost-containment features Avoid pitfalls and common reasons for failure relating to corporate culture, intra-office politics, and poor communications Secure the proper executive champions who can execute the business planning needed for success Apply proven criteria to determine your future-state architecture and your migration method Execute your migration using a process proven by the authors over years of successful projects Who This Book Is For IT leadership, strategic IT decision makers, project owners and managers, and enterprise and application architects. For anyone looking toward cloud migration projects as the next stage of growth in their careers. Also useful for enterprise DBAs and consultants who might be involved in such projects. Readers should have experience and be competent in designing, coding, implementing, and supporting database applications in an on-premises environment.

Microsoft Power Platform Solution Architect's Handbook is your definitive resource for mastering Enterprise-grade solution architecture using Microsoft Power Platform. By covering both practical examples and theoretical best practices, this book ensures you are well-prepared to tackle real-world challenges and excel in the PL-600 certification exam. What this Book will help me do Master the essential practices of solution architecture for optimal design. Develop secure integrations and data strategies for cutting-edge applications. Learn sophisticated lifecycle and compliance management using Azure DevOps. Build impactful, compliant, and flexible solutions using Power Platform. Prepare effectively for the PL-600 certification exam and excel in your field. Author(s) Hugo Herrera is a respected technology expert specializing in solution architecture and enterprise-grade IT solutions, particularly with Microsoft Power Platform. Drawing from years of experience, Hugo emphasizes practical, actionable strategies to elevate professionals. Through this book, Hugo shares his deep expertise and makes complex concepts accessible. Who is it for? This book is perfect for solution architects, enterprise architects, IT consultants, and analysts focused on Microsoft Power Platform and related technologies. It provides insight and tools for professionals looking to enhance their competencies, advance their careers, and prepare for the PL-600 exam. The reader should have a solid understanding of Power Platform fundamentals.

If you work with SQL Server, dbatools is a lifesaver. This book will show you how to use this free and open source PowerShell module to automate just about every SQL server task you can imagine—all in just one month! In Learn dbatools in a Month of Lunches you will learn how to: Perform instance-to-instance and customized migrations Automate security audits, tempdb configuration, alerting, and reporting Schedule and monitor PowerShell tasks in SQL Server Agent Bulk-import any type of data into SQL Server Install dbatools in secure environments Written by a group of expert authors including dbatools creator Chrissy LeMaire, Learn dbatools in a Month of Lunches teaches you techniques that will make you more effective—and efficient—than you ever thought possible. In twenty-eight lunchbreak lessons, you’ll learn the most important use cases of dbatools and the favorite functions of its core developers. Stabilize and standardize your SQL server environment, and simplify your tasks by building automation, alerting, and reporting with this powerful tool. About the Technology For SQL Server DBAs, automation is the key to efficiency. Using the open-source dbatools PowerShell module, you can easily execute tasks on thousands of database servers at once—all from the command line. dbatools gives you over 500 pre-built commands, with countless new options for managing SQL Server at scale. There’s nothing else like it. About the Book Learn dbatools in a Month of Lunches teaches you how to automate SQL Server using the dbatools PowerShell module. Each 30-minute lesson introduces a new automation that will make your daily duties easier. Following the expert advice of dbatools creator Chrissy LeMaire and other top community contributors, you’ll learn to script everything from backups to disaster recovery. What's Inside Performing instance-to-instance and customized migrations Automating security audits, best practices, and standardized configurations Administering SQL Server Agent including running PowerShell scripts effectively Bulk-importing many types of data into SQL Server Executing advanced tasks and increasing efficiency for everyday administration About the Reader For DBAs, accidental DBAs, and systems engineers who manage SQL Server. About the Authors Chrissy LeMaire is a GitHub Star and the creator of dbatools. Rob Sewell is a data engineer and a passionate automator. Jess Pomfret and Cláudio Silva are data platform architects. All are Microsoft MVPs. Quotes All SQL Server professionals should learn dbatools. With its combination of knowledge transfer, anecdotes, and hands-on labs, this book is the perfect way. - From the Foreword by Anna Hoffman, Databases Product Management, Microsoft Excellent guide for dbatools with lots of practical tips! Required reading for anyone interested in dbatools. - Ruben Vandeginste, PeopleWare A must-have for any SQL server developer. - Raushan Kumar Jha, Microsoft If you want to automate all vital aspects of SQL Server, wait no more! Learn dbatools in a month, with guidance from the best minds in the business. - Ranjit Sahai, RAM Consulting

With the world’s most distributed compute platform — from cloud to edge — Akamai makes it easy for businesses to develop and run applications, while keeping experiences closer to users and threats farther away. ​So when it was time to scale it’s legacy Hadoop-like infrastructure reaching its capacity limits, while keeping their global operations running uninterrupted, Akamai partnered with Microsoft and Databricks to migrate to Azure Databricks.

Connect with us: Website: https://databricks.com Facebook: https://www.facebook.com/databricksinc Twitter: https://twitter.com/databricks LinkedIn: https://www.linkedin.com/company/data... Instagram: https://www.instagram.com/databricksinc/

Data + AI Summit 2022 was a great opportunity to check-in on the partnership between Microsoft Azure and Databricks!

Business Intelligence (BI) tools such as Tableau and Microsoft Power BI are notoriously slow at extracting large query results from traditional data warehouses because they typically fetch the data in a single thread through a SQL endpoint that becomes a data transfer bottleneck. Data analysts can connect their BI tools to Databricks SQL endpoints to query data in tables through an ODBC/JDBC protocol integrated in our Simba drivers. With Cloud Fetch, which we released in Databricks Runtime 8.3 and Simba ODBC 2.6.17 driver, we introduce a new mechanism for fetching data in parallel via cloud storage such as AWS S3 and Azure Data Lake Storage to bring the data faster to BI tools. In our experiments using Cloud Fetch, we observed a 10x speed-up in extract performance due to parallelism.

Connect with us: Website: https://databricks.com Facebook: https://www.facebook.com/databricksinc Twitter: https://twitter.com/databricks LinkedIn: https://www.linkedin.com/company/data... Instagram: https://www.instagram.com/databricksinc/

Produce high-quality, visually attractive analysis quickly and effectively with Microsoft’s key BI tool. This book teaches analysts, managers, power users, and developers how to harness the power of Microsoft’s self-service business intelligence flagship product to deliver compelling and interactive insight with remarkable ease. It then shows you the essential techniques needed to go from source data to dashboards that seize your audience’s attention and provide them with clear and accurate information. As well as producing elegant and visually arresting output, you learn how to enhance the user experience through adding polished interactivity. This book shows you how to make interactive dashboards that allow you to guide users through the meaning of the data that they are exploring. Drill down features are also covered that allow you and your audience to dig deeper and uncover new insights by exploring anomalous and interesting data points. Reading this book builds your skills around creating meaningful and elegant dashboards using a range of compelling visuals. It shows you how to apply simple techniques to convert data into business insight. The book covers tablet and smartphone layouts for delivering business value in today’s highly mobile world. You’ll learn about formatting for effect to make your data tell its story, and you’ll be a master at creating visually arresting output on multiple devices that grabs attention, builds influence, and drives change. What You Will Learn Produce designer output that will astound your bosses and peers Make new insights as you chop and tweak your data as never before Create high-quality analyses in record time Create interdependent charts, maps, and tables Deliver visually stunning information Drill down through data to provide unique understandings Outshinecompeting products and enhance existing skills Adapt your dashboard delivery to mobile devices Who This Book Is For For any Power BI user who wants to strengthen their ability to deliver compelling analytics via Microsoft’s widely adopted analytics platform. For those new to Power BI who want to learn the full extent of what the platform is capable of. For power users such as BI analysts, data architects, IT managers, accountants, and C-suite members who want to drive change in their organizations.

Design and implement a modern data lakehouse on the Azure Data Platform using Delta Lake, Apache Spark, Azure Databricks, Azure Synapse Analytics, and Snowflake. This book teaches you the intricate details of the Data Lakehouse Paradigm and how to efficiently design a cloud-based data lakehouse using highly performant and cutting-edge Apache Spark capabilities using Azure Databricks, Azure Synapse Analytics, and Snowflake. You will learn to write efficient PySpark code for batch and streaming ELT jobs on Azure. And you will follow along with practical, scenario-based examples showing how to apply the capabilities of Delta Lake and Apache Spark to optimize performance, and secure, share, and manage a high volume, high velocity, and high variety of data in your lakehouse with ease. The patterns of success that you acquire from reading this book will help you hone your skills to build high-performing and scalable ACID-compliant lakehouses using flexible and cost-efficient decoupled storage and compute capabilities. Extensive coverage of Delta Lake ensures that you are aware of and can benefit from all that this new, open source storage layer can offer. In addition to the deep examples on Databricks in the book, there is coverage of alternative platforms such as Synapse Analytics and Snowflake so that you can make the right platform choice for your needs. After reading this book, you will be able to implement Delta Lake capabilities, including Schema Evolution, Change Feed, Live Tables, Sharing, and Clones to enable better business intelligence and advanced analytics on your data within the Azure Data Platform. What You Will Learn Implement the Data Lakehouse Paradigm on Microsoft’s Azure cloud platform Benefit from the new Delta Lake open-source storage layer for data lakehouses Take advantage of schema evolution, change feeds, live tables, and more Writefunctional PySpark code for data lakehouse ELT jobs Optimize Apache Spark performance through partitioning, indexing, and other tuning options Choose between alternatives such as Databricks, Synapse Analytics, and Snowflake Who This Book Is For Data, analytics, and AI professionals at all levels, including data architect and data engineer practitioners. Also for data professionals seeking patterns of success by which to remain relevant as they learn to build scalable data lakehouses for their organizations and customers who are migrating into the modern Azure Data Platform.

Dive deep into Microsoft Power BI with the second edition of 'Mastering Microsoft Power BI'. This comprehensive book equips you with the skills to transform business data into actionable insights using Power BI's latest features and techniques. From efficient data retrieval and transformation processes to creating interactive dashboards that tell impactful data stories, you will learn actionable knowledge every step of the way. What this Book will help me do Learn to master data collection and modeling using the Power Query M language Gain expertise in designing DirectQuery, import, and composite data models Understand how to create advanced analytics reports using DAX and Power BI visuals Learn to manage the Power BI environment as an administrator with Premium capacity Develop insightful, scalable, and visually impactful dashboards and reports Author(s) Greg Deckler, a seasoned Power BI expert and solution architect, and None Powell, an experienced BI consultant and data visualization specialist, bring their extensive practical knowledge to this book. Together, they share their real-world expertise and proven techniques applying Power BI's diverse capabilities. Who is it for? This book is ideal for business intelligence professionals and intermediate Power BI users. If you're looking to master data visualization, prepare insightful dashboards, and explore Power BI's full potential, this is for you. Basic understanding of BI concepts and familiarity with Power BI will ensure you get the most value.

THE GUIDE FOR ANYONE AFRAID TO LEARN STATISTICS & ANALYTICS UPDATED WITH NEW EXAMPLES & EXERCISES This book discusses statistics and analytics using plain language and avoiding mathematical jargon. If you thought you couldn't learn these data analysis subjects because they were too technical or too mathematical, this book is for you! This edition delivers more everyday examples and end-of-chapter exercises and contains updated instructions for using Microsoft Excel. You'll use downloadable data sets and spreadsheet solutions, template-based solutions you can put right to work. Using this book, you will understand the important concepts of statistics and analytics, including learning the basic vocabulary of these subjects. Create tabular and visual summaries and learn to avoid common charting errors Gain experience working with common descriptive statistics measures including the mean, median, and mode; and standard deviation and variance, among others Understand the probability concepts that underlie inferential statistics Learn how to apply hypothesis tests, using Z, t, chi-square, ANOVA, and other techniques Develop skills using regression analysis, the most commonly-used Inferential statistical method Explore results produced by predictive analytics software Choose the right statistical or analytic techniques for any data analysis task Optionally, read the Equation Blackboards, designed for readers who want to learn about the mathematical foundations of selected methods ...

Retired US Army Veteran Bill Clark of Microsoft discusses how simply showing interest can help you excel in this space.

This book is your ultimate companion to mastering Microsoft Power BI and becoming proficient in data analysis and visualization. With a focus on understanding and utilizing Power BI to its fullest extent, this guide also prepares you comprehensively for the PL-300 certification exam. You will go from the basics to advanced techniques enabling you to confidently analyze and present data. What this Book will help me do Understand and connect to various data sources using Power BI. Gain skills in transforming and preparing data for advanced analysis. Develop expertise in designing and optimizing data models. Learn to create insightful reports and dashboards to convey information clearly. Prepare for and succeed in the PL-300 certification exam with practice questions. Author(s) Authors None Edenfield and None Corcoran bring extensive experience in business intelligence and data analytics to this book. They have years of hands-on expertise with Power BI and a passion for teaching analytics in a practical and accessible way. Together, they aim to empower readers to master Power BI and achieve their certification goals. Who is it for? This book is perfect for data analysts, business intelligence professionals, and anyone aiming to deepen their knowledge of Microsoft Power BI. Beginners will find approachable content to quickly get started while experienced users will find detailed topics to refine their expertise. By covering exam preparation and practical applications, this guide benefits a wide range of learners who wish to get certified and excel in data-centric roles.

For programmers, analysts, and database administrators, this Nutshell guide is the essential reference for the SQL language used in today's most popular database products. This new fourth edition clearly documents SQL commands according to the latest ANSI/ISO standard and details how those commands are implemented in Microsoft SQL Server 2019 and Oracle 19c, as well as in the MySQL 8, MariaDB 10.5, and PostgreSQL 14 open source database products. You'll also get a concise overview of the relational database management system (RDBMS) model and a clear-cut explanation of foundational RDBMS concepts--all packed into a succinct, comprehensive, and easy-to-use format. Sections include: Background on the relational database model, including current and previous SQL standards Fundamental concepts necessary for understanding relational databases and SQL commands An alphabetical command reference to SQL statements, according to the SQL:2016 ANSI standard The implementation of each command by MySQL, Oracle, PostgreSQL, and SQL Server An alphabetical reference of the ANSI SQL:2016 functions and constructs as well as the vendor implementations Platform-specific functions unique to each implementation