talk-data.com talk-data.com

Event

O'Reilly Data Science Books

2013-08-09 – 2026-02-25 Oreilly Visit website ↗

Activities tracked

227

Collection of O'Reilly books on Data Science.

Filtering by: business-intelligence ×

Sessions & talks

Showing 51–75 of 227 · Newest first

Search within this event →
Pro Power BI Architecture: Development, Deployment, Sharing, and Security for Microsoft Power BI Solutions

This book provides detailed guidance around architecting and deploying Power BI reporting solutions, including help and best practices for sharing and security. You’ll find chapters on dataflows, shared datasets, composite model and DirectQuery connections to Power BI datasets, deployment pipelines, XMLA endpoints, and many other important features related to the overall Power BI architecture that are new since the first edition. You will gain an understanding of what functionality each of the Power BI components provide (such as Dataflow, Shared Dataset, Datamart, thin reports, and paginated reports), so that you can make an informed decision about what components to use in your solution. You will get to know the pros and cons of each component, and how they all work together within the larger Power BI architecture. Commonly encountered problems you will learn to handle include content unexpectedly changing while users are in the process of creating reports and building analyses, methods of sharing analyses that don’t cover all the requirements of your business or organization, and inconsistent security models. Detailed examples help you to understand and choose from among the different methods available for sharing and securing Power BI content so that only intended recipients can see it. The knowledge provided in this book will allow you to choose an architecture and deployment model that suits the needs of your organization. It will also help ensure that you do not spend your time maintaining your solution, but on using it for its intended purpose: gaining business value from mining and analyzing your organization’s data. What You Will Learn Architect Power BI solutions that are reliable and easy to maintain Create development templates and structures in support of reusability Set up and configure the Power BI gateway as a bridge between on-premises data sourcesand the Power BI cloud service Select a suitable connection type—Live Connection, DirectQuery, Scheduled Refresh, or Composite Model—for your use case Choose the right sharing method for how you are using Power BI in your organization Create and manage environments for development, testing, and production Secure your data using row-level and object-level security Save money by choosing the right licensing plan Who This Book Is For Data analysts and developers who are building reporting solutions around Power BI, as well as architects and managers who are responsible for the big picture of how Power BI meshes with an organization’s other systems, including database and data warehouse systems.

Intelligent Analytics for Industry 4.0 Applications

In Industry 4.0, intelligent analytics has a broader scope in terms of descriptive, predictive, and prescriptive sub-domains. To this end, the book will aim to review and highlight the challenges faced by Intelligent Analytics in Industry 4.0 and present the recent developments done to address those challenges.

Power BI Machine Learning and OpenAI

Microsoft Power BI Machine Learning and OpenAI offers a comprehensive exploration into advanced data analytics and artificial intelligence using Microsoft Power BI. Through hands-on, workshop-style examples, readers will discover the integration of machine learning models and OpenAI features to enhance business intelligence. This book provides practical examples, real-world scenarios, and step-by-step guidance. What this Book will help me do Learn to apply machine learning capabilities within Power BI to create predictive analytics Understand how to integrate OpenAI services to build enhanced analytics workflows Gain hands-on experience in using R and Python for advanced data visualization in Power BI Master the skills needed to build and deploy SaaS auto ML models within Power BI Leverage Power BI's AI visuals and features to elevate data storytelling Author(s) Greg Beaumont, an expert in data science and business intelligence, brings years of experience in Power BI and analytics to this book. With a focus on practical applications, Greg empowers readers to harness the power of AI and machine learning to elevate their data solutions. As a consultant and trainer, he shares his deep knowledge to help readers unlock the full potential of their tools. Who is it for? This book is ideal for data analysts, BI professionals, and data scientists who aim to integrate machine learning and OpenAI into their workflows. If you're familiar with Power BI's fundamentals and are eager to explore its advanced capabilities, this guide is tailored for you. Perfect for professionals looking to elevate their analytics to a new level, combining data science concepts with Power BI's features.

Embedded Analytics

Over the past 10 years, data analytics and data visualization have become essential components of an enterprise information strategy. And yet, the adoption of data analytics has remained remarkably static, reaching no more than 30% of potential users. This book explores the most important techniques for taking that adoption further: embedding analytics into the workflow of our everyday operations. Authors Donald Farmer and Jim Horbury show business users how to improve decision making without becoming analytics specialists. You'll explore different techniques for exchanging data, insights, and events between analytics platforms and hosting applications. You'll also examine issues including data governance and regulatory compliance and learn best practices for deploying and managing embedded analytics at scale. Learn how data analytics improves business decision making and performance Explore advantages and disadvantages of different embedded analytics platforms Develop a strategy for embedded analytics in an organization or product Define the architecture of an embedded solution Select vendors, platforms, and tools to implement your architecture Hire or train developers and architects to build the embedded solutions you need Understand how embedded analytics interacts with traditional analytics

Teach Yourself VISUALLY Power BI

A comprehensive and fully visual guide to Microsoft Power BI Teach Yourself VISUALLY Power BI collects all the resources you need to master the everyday use of Microsoft's powerful data visualization software and delivers them in a single, easy-to-use volume. Fully illustrated, step-by-step instructions are combined with crystal-clear screenshots that walk you through the basic and advanced functions of Microsoft Power BI. Teach Yourself VISUALLY Power BI offers the best visual learning techniques with complete source material about the interface and substance of Power BI, as well as: Stepwise guidance on working with, transforming, and processing data sources Instructions for customizing data visualizations to create informative and presentation-ready charts and graphs Full-color, two-page tutorials on the more advanced features of Power BI, including app integrations and data access with DAX The fastest, easiest way for visual learners to get a handle on Microsoft Power BI, Teach Yourself VISUALLY Power BI is a can't-miss resource, loaded with useful tips for newbies and experts alike.

Transitioning to Microsoft Power Platform: An Excel User Guide to Building Integrated Cloud Applications in Power BI, Power Apps, and Power Automate

Welcome to this step-by-step guide for Excel users, data analysts, and finance specialists. It is designed to take you through practical report and development scenarios, including both the approach and the technical challenges. This book will equip you with an understanding of the overall Power Platform use case for addressing common business challenges. While Power BI continues to be an excellent tool of choice in the BI space, Power Platform is the real game changer. Using an integrated architecture, a small team of citizen developers can build solutions for all kinds of business problems. For small businesses, Power Platform can be used to build bespoke CRM, Finance, and Warehouse management tools. For large businesses, it can be used to build an integration point for existing systems to simplify reporting, operation, and approval processes. The author has drawn on his15 years of hands-on analytics experience to help you pivot from the traditional Excel-based reporting environment. By using different business scenarios, this book provides you with clear reasons why a skill is important before you start to dive into the scenarios. You will use a fast prototyping approach to continue to build exciting reporting, automation, and application solutions and improve them while you acquire new skill sets. The book helps you get started quickly with Power BI. It covers data visualization, collaboration, and governance practices. You will learn about the most practical SQL challenges. And you will learn how to build applications in PowerApps and Power Automate. The book ends with an integrated solution framework that can be adapted to solve a wide range of complex business problems. What You Will Learn Develop reporting solutions and business applications Understand the Power Platform licensing and development environment Apply Data ETL and modeling in Power BI Use Data Storytelling and dashboard design to better visualize data Carry out data operations with SQL and SharePoint lists Develop useful applications using Power Apps Develop automated workflows using Power Automate Integrate solutions with Power BI, Power Apps, and Power Automate to build enterprise solutions Who This Book Is For Next-generation data specialists, including Excel-based users who want to learn Power BI and build internal apps; finance specialists who want to take a different approach to traditional accounting reports; and anyone who wants to enhance their skill set for the future job market.

Exam Ref PL-900 Microsoft Power Platform Fundamentals, 2nd Edition

Prepare for Microsoft Exam PL-900. Demonstrate your real-world knowledge of the fundamentals of Microsoft Power Platform, including its business value, core components, and the capabilities and advantages of Power BI, Power Apps, Power Automate, and Power Virtual Agents. Designed for business users, functional consultants, and other professionals, this Exam Ref focuses on the critical thinking and decision-making acumen needed for success at the Microsoft Certified: Power Platform Fundamentals level. Focus on the expertise measured by these objectives: Describe the business value of Power Platform Identify the Core Components of Power Platform Demonstrate the capabilities of Power BI Demonstrate the capabilities of Power Apps Demonstrate the capabilities of Power Automate Demonstrate the capabilities of Power Virtual Agents This Microsoft Exam Ref: Organizes its coverage by exam objectives Features strategic, what-if scenarios to challenge you Assumes you are a business user, functional consultant, or other professional who wants to improve productivity by automating business processes, analyzing data, creating simple app experiences, or developing business enhancements to Microsoft cloud solutions. About the Exam Exam PL-900 focuses on knowledge needed to describe the value of Power Platform services and of extending solutions; describe Power Platform administration and security; describe Common Data Service, Connectors, and AI Builder; identify common Power BI components; connect to and consume data; build basic dashboards with Power BI; identify common Power Apps components; build basic canvas and model-driven apps; describe Power Apps portals; identify common Power Automate components; build basic flows; describe Power Virtual Agents capabilities; and build and publish basic chatbots. About Microsoft Certification Passing this exam fulfills your requirements for the Microsoft Certified: Power Platform Fundamentals certification, demonstrating your understanding of Power Platforms core capabilitiesfrom business value and core product capabilities to building simple apps, connecting data sources, automating basic business processes, creating dashboards, and creating chatbots. With this certification, you can move on to earn specialist certifications covering more advanced aspects of Power Apps and Power BI, including Microsoft Certified: Power Platform App Maker Associate and Power Platform Data Analyst Associate. See full details at: microsoft.com/learn

Expert Data Modeling with Power BI - Second Edition

Expert Data Modeling with Power BI, Second Edition, serves as your comprehensive guide to mastering data modeling using Power BI. With clear explanations, actionable examples, and a focus on hands-on learning, this book takes you through the concepts and advanced techniques that will enable you to build high-performing data models tailored to real-world requirements. What this Book will help me do Master time intelligence and virtual tables in DAX to enhance your data models. Understand best practices for creating efficient Star Schemas and preparing data in Power Query. Deploy advanced modeling techniques such as calculation groups, aggregations, and incremental refresh. Manage complex data models and streamline them to improve performance. Leverage data marts and data flows within Power BI for modularity and scalability. Author(s) Soheil Bakhshi is a seasoned expert in data visualization and analytics with extensive experience in leveraging Power BI for business intelligence solutions. Passionate about educating others, he combines practical insights and technical knowledge to make learning accessible and effective. His approachable writing style reflects his commitment to helping readers succeed. Who is it for? This book is ideal for business intelligence professionals, data analysts, or report developers with basic knowledge of Power BI and experience with Star Schema concepts. Whether you're looking to refine your data modeling skills or expand your expertise in advanced features, this guide aims to help you achieve your goals efficiently.

Microsoft Power BI Data Analyst Certification Companion: Preparation for Exam PL-300

Use this book to study for the PL-300 Microsoft Power BI Data Analyst exam. The book follows the “Skills Measured” outline provided by Microsoft to help focus your study. Each topic area from the outline corresponds to an area covered by the exam, and the book helps you build a good base of knowledge in each area. Each topic is presented with a blend of practical explanations, theory, and best practices. Power BI is more than just the Power BI Desktop or the Power BI Service. It is two distinct applications and an online service that, together, enable business users to gather, shape, and analyze data to generate and present insights. This book clearly delineates the purpose of each component and explains the key concepts necessary to use each component effectively. Each chapter provides best practices and tips to help an inexperienced Power BI practitioner develop good habits that will support larger or more complex analyses. Manybusiness analysts come to Power BI with a wealth of experience in Excel and particularly with pivot tables. Some of this experience translates readily into Power BI concepts. This book leverages that overlap in skill sets to help seasoned Excel users overcome the initial learning curve in Power BI, but no prior knowledge of any kind is assumed, terminology is defined in non-technical language, and key concepts are explained using analogies and ideas from experiences common to any reader. After reading this book, you will have the background and capability to learn the skills and concepts necessary both to pass the PL-300 exam and become a confident Power BI practitioner. What You Will Learn Create user-friendly, responsive reports with drill-throughs, bookmarks, and tool tips Construct a star schema with relationships, ensuring that your analysis will be both accurate and responsive Publish reports and datasets to the Power BI Service, enabling the report (and the dataset) to be viewed and used by your colleagues Extract data from a variety of sources, enabling you to leverage the data that your organization has collected and stored in a variety of sources Schedule data refreshes for published datasets so your reports and dashboards stay up to date Develop dashboards with visuals from different reports and streaming content Who This Book Is For Power BI users who are planning to take the PL-300 exam, Power BI users who want help studying the topic areas listed in Microsoft’s outline for the PL-300 exam, and those who are not planning to take the exam but want to close any knowledge gaps they might have

API Analytics for Product Managers

In API Analytics for Product Managers, you will learn how to approach APIs as products to drive revenue and business growth. The book provides actionable insights on researching, strategizing, marketing, and evaluating the performance of APIs in SaaS contexts. What this Book will help me do Learn to develop long-term strategies for managing APIs as a product. Master the concepts of the API lifecycle and API maturity for better management. Understand and apply key metrics to measure activation, retention, and engagement of APIs. Design support models for APIs that ensure scalability and efficiency. Gain techniques for deriving actionable business insights from metrics analysis. Author(s) Deepa Goyal is an experienced product manager who specializes in API lifecycle management and analytics strategies. With years of industry experience, she has developed deep expertise in scaling and optimizing APIs to deliver business value. Her practical and results-oriented writing style makes complex topics accessible for professionals looking to enhance their API strategies. Who is it for? Ideal for product managers, engineers, and executives in SaaS companies looking to maximize the potential of APIs. This book is especially suited for individuals with foundational knowledge of APIs aiming to refine their analytical and strategic skills. Readers will gain actionable insights to track API performance effectively and implement metrics-driven decisions. It's a must-read for those focused on leveraging APIs for business growth.

Democratizing Application Development with Betty Blocks

"Democratizing Application Development with Betty Blocks" is a hands-on guide for learning the Betty Blocks no-code platform to develop impactful, dynamic business applications. This book introduces both basic and advanced concepts, empowering readers to create valuable IT solutions, from prototypes to complete applications. What this Book will help me do Understand the capabilities and low-code functionalities of Betty Blocks through engaging examples. Learn to create business applications using data models, workflows, and dynamic web components. Master rapid application development techniques to build prototypes and applications quickly. Discover how to use Betty Blocks' drag-and-drop interfaces for effective front-end design. Gain insight into collaborating as a citizen developer to deliver functional custom applications. Author(s) Reinier van Altena is an experienced professional in no-code application development, specializing in empowering users of varying technical skills to create business solutions. With practical insights derived from extensive use of platforms like Betty Blocks, Reinier shares approachable and actionable advice. His expertise bridges the gap between technology and innovation. Who is it for? This book is tailored for individuals interested in building business applications without prior coding knowledge. Ideal readers include citizen developers, business professionals, and anyone seeking to fulfill specific organizational IT needs through creativity and innovation. The book emphasizes learning fundamentals and advanced application-building strategies in an accessible manner.

Business Analysis For Dummies, 2nd Edition

Build a successful career in business analysis When it comes to doing good business, change is a very good thing. And effective business analysts are at the heart of identifying opportunities for growth and implementing the solutions that can transform an organization’s foundation—and ultimately increase its profitability. Whether you’re an aspiring business analysis professional or a seasoned analyst looking for the latest techniques and approaches, Business Analysis For Dummies helps you discover the newest tips and tricks for turning knowledge into the changes that have a real and meaningful impact on business and drive your organization towards value delivery. Identify areas for growth and create solutions Learn how to bring people together to collaborate effectively Discover ways to better understand and serve your customers See how business analysis works in the real world Learn the technology to make the job easier Find business solutions to improve your organization’s performance Understand how to dig deeply into your organization’s data, processes, and business rules Dummies makes the path to business success clear. Start here to turn your love of business analysis into the catalyst that makes a difference.

Microsoft Power Platform Enterprise Architecture - Second Edition

Microsoft Power Platform Enterprise Architecture is your essential guide to designing powerful, enterprise-grade solutions using Microsoft technology. This thoroughly structured book equips you with architectural insights, methodologies, and best practices necessary to optimize solutions using the Microsoft Power Platform and integrate them seamlessly with M365 and Azure. What this Book will help me do Design robust enterprise solutions leveraging Microsoft Power Platform and Dynamics 365. Integrate Power Platform tools with Microsoft 365 and Azure effectively for comprehensive solutions. Implement advanced security, extensibility, and lifecycle management methodologies. Migrate and manage data efficiently within the Power Platform ecosystem. Overcome architectural challenges in multi-system integration using proven techniques. Author(s) Robert Rybaric, the author of this book, is an experienced enterprise architect specializing in Microsoft technologies. With years of expertise in designing enterprise systems, Robert brings practical insights into crafting effective solutions using Microsoft Power Platform. His approach emphasizes clarity and practicality, ensuring concepts are both illustrative and applicable for readers. Who is it for? This book is ideal for enterprise architects and technical decision-makers aiming to design and deploy complex solutions using the Microsoft Power Platform. It is tailored for professionals with familiarity with Microsoft Power Platform and Azure services who wish to refine their skills in enterprise architecture to meet growing business demands efficiently.

Building Solutions with the Microsoft Power Platform

With the accelerating speed of business and the increasing dependence on technology, companies today are significantly changing the way they build in-house business solutions. Many now use low-code and no code technologies to help them deal with specific issues, but that's just the beginning. With this practical guide, power users and developers will discover ways to resolve everyday challenges by building end-to-end solutions with the Microsoft Power Platform. Author Jason Rivera, who specializes in SharePoint and the Microsoft 365 solution architecture, provides a comprehensive overview of how to use the Power Platform to build end-to-end solutions that address tactical business needs. By learning key components of the platform, including Power Apps, Power Automate, and Power BI, you'll be able to build low-code and no code applications, automate repeatable business processes, and create interactive reports from available data. Learn how the Power Platform apps work together Incorporate AI into the Power Platform without extensive ML or AI knowledge Create end-to-end solutions to solve tactical business needs, including data collection, process automation, and reporting Build AI-based solutions using Power Virtual Agents and AI Builder

Microsoft Power BI Quick Start Guide - Third Edition

Discover the power of transforming raw data into actionable insights with "Microsoft Power BI Quick Start Guide." This comprehensive guide introduces you to the core functionalities of Power BI, emphasizing practical demonstration on building data models, visualizations, and streamlining business intelligence processes. By following this book, you'll elevate your data analysis and storytelling skills. What this Book will help me do Connect and import data from various sources into Power BI. Master the usage of Power Query Editor for efficient data cleansing. Create effective and visually appealing Power BI dashboards. Understand and implement data security features, such as row-level and column-level security. Administer a Power BI environment effectively, including tenant management and cloud deployments. Author(s) Devin Knight, Erin Ostrowsky, Mitchell Pearson, and Bradley Schacht are seasoned experts in the field of data analysis and business intelligence. With years of practical experience, they bring a wealth of knowledge in Power BI and data visualization. Their passion for educating others is evident in their clear, approachable, and structured writing style. Who is it for? This book is designed for professionals seeking to delve into Microsoft Power BI's functionalities. Ideal readers include business analysts, data professionals, or enthusiasts aiming to transition from Excel-based solutions to BI platforms. Both beginners wanting to learn BI concepts and intermediate users looking to solidify their Power BI skills will benefit greatly.

Pro DAX and Data Modeling in Power BI: Creating the Perfect Semantic Layer to Drive Your Dashboard Analytics

Develop powerful data models that bind data from disparate sources into a coherent whole. Then extend your data models using DAX–the query language that underpins Power BI–to create reusable measures to deliver finely-crafted custom calculations in your dashboards. This book starts off teaching you how to define and enhance the core structures of your data model to make it a true semantic layer that transforms complex data into familiar business terms. You’ll learn how to create calculated columns to solve basic analytical challenges. Then you’ll move up to mastering DAX measures to finely slice and dice your data. The book also shows how to handle temporal analysis in Power BI using a Date dimension. You will see how DAX Time Intelligence functions can simplify your analysis of data over time. Finally, the book shows how to extend DAX to filter and calculate datasets and develop DAX table functions and variables to handle complex queries. What You Will Learn Create clear and efficient data models that support in-depth analytics Define core attributes such as data types and standardized formatting consistently throughout a data model Define cross-filtering settings to enhance the data model Make use of DAX to create calculated columns and custom tables Extend your data model with custom calculations and reusable measures using DAX Perform time-based analysis using a Date dimension and Time Intelligence functions Who This Book Is For Everyone from the CEO to the Business Intelligence developer and from BI and Data architects and analysts to power users and IT managers can use this book to outshine the competition and create the data framework that they need and interactive dashboards using Power BI

Creating Business Applications with Microsoft 365: Techniques in Power Apps, Power BI, SharePoint, and Power Automate

Learn how to automate processes, visualize your data, and improve productivity using Power Apps, Power Automate, Power BI, SharePoint, Forms, Teams, and more. This book will help you build complete solutions that often involve storing data in SharePoint, creating a front-end application in Power Apps or Forms, adding additional functionality with Power Automate, and effective reports and dashboards in Power BI. This new edition greatly expands the focus on Power Apps, Power BI, Power Automate, and Teams, along with SharePoint and Microsoft Forms. It starts with the basics of programming and shows how to build a simple email application in .NET, HTML/JavaScript, Power Apps on its own, and Power Apps and Power Automate in combination. It then covers how to connect Power Apps to SharePoint, create an approval process in Power Automate, visualize surveys in Power BI, and create your own survey solution with the combination of a number of Microsoft 365 tools. You’ll work with anextended example that shows how to use Power Apps and SharePoint together to create your own help ticketing system. This book offers a deep dive into Power BI, including working with JSON, XML, and Yes/No data, as well as visualizing learning data and using it to detect inconsistencies between Excel files. You’ll also see how to connect to Remedy and to the help system you will have created. Under author Jeffrey Rhodes’s guidance, you’ll delve into the Power Apps collection to learn how to avoid dreaded "delegation" issues with larger data sets. Back on applications, you will create a training class sign-up solution to only allow users to choose classes with available seats. Digging deeper into Teams, you’ll learn how to send chats, posts, and "adaptive cards" from Power Automate. Rounding things out, you’ll save Forms attachments to SharePoint with Power Automate, create your own "Employee Recognition" app with all of the Power Platform and Teams, add or edit weekly status reports, and learn how to create reservation and scoring applications. After reading the book, you will be able to build powerful applications using Power Apps, Power Automate, Power BI, SharePoint, Forms, and Teams. What You Will Learn Create productivity-enhancing applications with Power Apps, Power Automate, SharePoint, Forms, and/or Teams Transform and visualize data with Power BI to include custom columns, measures, and pivots Avoid delegation issues and tackle complicated Power Apps issues like complex columns, filtering, and ForAll loops Build scheduled or triggered Power Automate flows to schedule Teams Meetings, send emails, launch approvals, and much more Who This Book Is For Business and application developers.

Learning Microsoft Power BI

Microsoft Power BI is a data analytics and visualization tool powerful enough for the most demanding data scientists, but accessible enough for everyday use for anyone who needs to get more from data. The market has many books designed to train and equip professional data analysts to use Power BI, but few of them make this tool accessible to anyone who wants to get up to speed on their own. This streamlined intro to Power BI covers all the foundational aspects and features you need to go from "zero to hero" with data and visualizations. Whether you work with large, complex datasets or work in Microsoft Excel, author Jeremey Arnold shows you how to teach yourself Power BI and use it confidently as a regular data analysis and reporting tool. You'll learn how to: Import, manipulate, visualize, and investigate data in Power BI Approach solutions for both self-service and enterprise BI Use Power BI in your organization's business intelligence strategy Produce effective reports and dashboards Create environments for sharing reports and managing data access with your team Determine the right solution for using Power BI offerings based on size, security, and computational needs

Microsoft Power Apps Cookbook - Second Edition

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.

Pro Data Mashup for Power BI: Powering Up with Power Query and the M Language to Find, Load, and Transform Data

This book provides all you need to find data from external sources and load and transform that data into Power BI where you can mine it for business insights and a competitive edge. This ranges from connecting to corporate databases such as Azure SQL and SQL Server to file-based data sources, and cloud- and web-based data sources. The book also explains the use of Direct Query and Live Connect to establish instant connections to databases and data warehouses and avoid loading data. The book provides detailed guidance on techniques for transforming inbound data into normalized data sets that are easy to query and analyze. This covers data cleansing, data modification, and standardization as well as merging source data into robust data structures that can feed into your data model. You will learn how to pivot and transpose data and extrapolate missing values as well as harness external programs such as R and Python into a Power Query data flow. You also will see how to handle errors in source data and extend basic data ingestion to create robust and parameterized data load and transformation processes. Everything in this book is aimed at helping you deliver compelling and interactive insight with remarkable ease using Power BI’s built-in data load and transformation tools. What You Will Learn Connect Power BI to a range of external data sources Prepare data from external sources for easy analysis in Power BI Cleanse data from duplicates, outliers, and other bad values Make live connections from which to refresh data quickly and easily Apply advanced techniques to interpolate missing data Who This Book Is For All Power BI users from beginners to super users. Any user of the world’s leading dashboarding toolcan leverage the techniques explained in this book to turbo-charge their data preparation skills and learn how a wide range of external data sources can be harnessed and loaded into Power BI to drive their analytics. No previous knowledge of working with data, databases, or external data sources is required—merely the need to find, transform, and load data into Power BI..