Malaysia-based online bookstore - 15 million titles - quick local delivery with tracking number
Learn how to use the Power Query M formula language and its functions effectively for better data modeling and impactful business intelligence reports.
Purchase of the print or Kindle book includes a free PDF eBook
Key FeaturesData transformation is a critical step in building data models and business intelligence reports. Power Query is an invaluable tool for anyone who wants to master data transformation, and this book will equip you with the knowledge and skills to make the most of it.
The Definitive Guide to Power Query (M) will help you build a solid foundation in the Power Query M language. As you progress through the chapters, you'll learn how to use that knowledge to implement advanced concepts and data transformations before going on a no-compromise 'deep dive' into the Power Query M language.
You'll also get to grips with optimizing performance, handling errors, and implementing efficient data processing techniques. As this is a hands-on guide, the practical examples in the chapters will help you gain the skills to apply Power Query to real-world problems and improve your data analysis capabilities.
By the end of this book, you will be able to leverage all of Power Query's remarkable capabilities for data transformation
What you will learnThis book is for business analysts, business intelligence professionals, and power business users working with data who want to add Power Query mastery to their resume. This book will be beneficial for anyone who wants to automate their process of data cleaning and save huge amount of time. Having some basic experience in Power Query is recommended.
Table of Contents
Plan, design, develop, and manage robust Power BI solutions to generate meaningful insights and make data-driven decisions.
Purchase of the print or Kindle book includes a free eBook in the PDF format.
Key FeaturesMastering Microsoft Power BI, Second Edition, provides an advanced understanding of Power BI to get the most out of your data and maximize business intelligence. This updated edition walks through each essential phase and component of Power BI, and explores the latest, most impactful Power BI features.
Using best practices and working code examples, you will connect to data sources, shape and enhance source data, and develop analytical data models. You will also learn how to apply custom visuals, implement new DAX commands and paginated SSRS-style reports, manage application workspaces and metadata, and understand how content can be staged and securely distributed via Power BI apps. Furthermore, you will explore top report and interactive dashboard design practices using features such as bookmarks and the Power KPI visual, alongside the latest capabilities of Power BI mobile applications and self-service BI techniques. Additionally, important management and administration topics are covered, including application lifecycle management via Power BI pipelines, the on-premises data gateway, and Power BI Premium capacity.
By the end of this Power BI book, you will be confident in creating sustainable and impactful charts, tables, reports, and dashboards with any kind of data using Microsoft Power BI.
What you will learnBusiness Intelligence professionals and intermediate Power BI users looking to master Power BI for all their data visualization and dashboarding needs will find this book useful. An understanding of basic BI concepts is required and some familiarity with Microsoft Power BI will be helpful to make the most out of this book.
Table of Contents
Now in color, this edition helps you unlock the full potential of Power BI with new recipes and comprehensive techniques on advanced data tools and AI
Key Features:
- Dive into Microsoft Data Fabric for deeper insights and robust data strategies
- Implement Hybrid tables, create comprehensive scorecards, and establish shared cloud connections effortlessly
- Uncover new and updated data visualization tools that turn complex data into clear, actionable charts and reports
Book Description:
Since its first edition the Power BI Cookbook has been a best-selling resource for BI developers and data analysts to produce impactful, quality BI solutions. This new and updated edition retains the rigorous details and concepts readers of prior editions have enjoyed while also demonstrating powerful new capabilities and updated guidance aligned to the current state of the platform.
In this book, with step-by-step instructions, you will learn to navigate the complexities of data integration and visualization in Power BI. From creating robust data models to implementing sophisticated reporting techniques, this Power BI book empowers you to make informed decisions based on actionable insights. It also introduces you to new capabilities such as Hybrid tables and scorecards, enhancing your ability to communicate and analyze business performance. It also expands and improvises on the core of the previous edition like parameterizing Power BI solutions, authoring reports, data intelligence, and integrating advanced analytics.
This edition not only updates you on the latest features but also prepares you for future innovations with a preview of upcoming AI enhancements in Power BI. Whether you're refining your skills or aspiring to become an expert, this book is an invaluable resource for leveraging Power BI to its fullest potential
What You Will Learn:
- Analyze and integrate business data using Microsoft Data Fabric
- Create impactful visualizations and manage Hybrid tables
- Develop shared cloud connections and advanced scorecards
- Enhance report accuracy and dynamics using real-time data processing
- Implement efficient data governance and security measures within Power BI
Who this book is for:
This book is designed for data analysts, business intelligence professionals, and anyone involved in data processing or analytics who seeks to enhance their skills with Power BI's latest features and prepare for future advancements in the field
Table of Contents
- Configuring and Licensing Power BI Tools
- Accessing and Retrieving Data
- Building a Power BI Data Model
- Authoring Power BI Reports
- Working in the Service
- Getting Serious with Date Intelligence
- Parameterizing Power BI Solutions
- Implementing Dynamic User-Based Visibility in Power BI
- Applying Advanced Analytics and Custom Visuals
- Administering and Monitoring Power BI
- Enhancing and Optimizing Existing Power BI Solutions
- Deploying and Distributing Power BI Content
- Integrating Power BI with Other Applications
- Self-Service SQL Databases via Datamarts
Learn how to use Power BI to deliver the insights needed to help your enterprise survive and thrive
Key Features
- Learn simple through to advanced Power BI features in a clear, concise way using real-world examples
- Develop powerful analytical models and reports that extract key business insights
- Publish, share and collaborate on impressive reports, dashboards, apps, and goals
Book Description
To succeed in today's transforming business world, organizations need business intelligence capabilities to make smarter decisions faster than ever before. This updated second edition of Learn Power BI takes you on a journey of data exploration and discovery, using Microsoft Power BI to ingest, cleanse, and organize data in order to unlock key business insights that can then be shared with others.
This newly revised and expanded edition of Learn Power BI covers all of the latest features and interface changes and takes you through the fundamentals of business intelligence projects, how to deploy, adopt, and govern Power BI within your organization, and how to leverage your knowledge in the marketplace and broader ecosystem that is Power BI. As you progress, you will learn how to ingest, cleanse, and transform your data into stunning visualizations, reports, and dashboards that speak to business decision-makers.
By the end of this Power BI book, you will be fully prepared to be the data analysis hero of your organization - or even start a new career as a business intelligence professional.
What you will learn
- Get up and running quickly with Power BI
- Understand and plan your business intelligence projects
- Connect to and transform data using Power Query
- Create data models optimized for analysis and reporting
- Perform simple and complex DAX calculations to enhance analysis
- Discover business insights and create professional reports
- Collaborate via Power BI dashboards, apps, goals, and scorecards
- Deploy and govern Power BI, including using deployment pipelines
Who this book is for
If you're an IT manager, data analyst, or BI user new to using Power BI for solving business intelligence problems, this book is for you. You'll also find this book helpful if you want to migrate from other BI tools to create powerful and interactive dashboards. No experience of working with Power BI is expected.
Table of Contents
- Understanding Business Intelligence and Power BI
- Planning Projects with Power BI
- Up and Running with Power BI Desktop
- Connecting to and Transforming Data
- Creating Data Models and Calculations
- Unlocking Insights
- Creating the Final Report
- Publishing and Sharing
- Using Reports in the Power BI Service
- Understanding Dashboards, Apps, Goals, and Security
- Refreshing Content
- Deploying, Governing, and Adopting Power BI
- Putting Your Knowledge to Use
Plan, design, develop, and manage robust Power BI solutions to generate meaningful insights and make data-driven decisions.
Purchase of the print or Kindle book includes a free eBook in the PDF format.
Key FeaturesMastering Microsoft Power BI, Second Edition, provides an advanced understanding of Power BI to get the most out of your data and maximize business intelligence. This updated edition walks through each essential phase and component of Power BI, and explores the latest, most impactful Power BI features.
Using best practices and working code examples, you will connect to data sources, shape and enhance source data, and develop analytical data models. You will also learn how to apply custom visuals, implement new DAX commands and paginated SSRS-style reports, manage application workspaces and metadata, and understand how content can be staged and securely distributed via Power BI apps. Furthermore, you will explore top report and interactive dashboard design practices using features such as bookmarks and the Power KPI visual, alongside the latest capabilities of Power BI mobile applications and self-service BI techniques. Additionally, important management and administration topics are covered, including application lifecycle management via Power BI pipelines, the on-premises data gateway, and Power BI Premium capacity.
By the end of this Power BI book, you will be confident in creating sustainable and impactful charts, tables, reports, and dashboards with any kind of data using Microsoft Power BI.
What you will learnBusiness Intelligence professionals and intermediate Power BI users looking to master Power BI for all their data visualization and dashboarding needs will find this book useful. An understanding of basic BI concepts is required and some familiarity with Microsoft Power BI will be helpful to make the most out of this book.
Table of Contents
Learn how to use the Power Query M formula language and its functions effectively for better data modeling and impactful business intelligence reports.
Purchase of the print or Kindle book includes a free PDF eBook
Key FeaturesData transformation is a critical step in building data models and business intelligence reports. Power Query is an invaluable tool for anyone who wants to master data transformation, and this book will equip you with the knowledge and skills to make the most of it.
The Definitive Guide to Power Query (M) will help you build a solid foundation in the Power Query M language. As you progress through the chapters, you'll learn how to use that knowledge to implement advanced concepts and data transformations before going on a no-compromise 'deep dive' into the Power Query M language.
You'll also get to grips with optimizing performance, handling errors, and implementing efficient data processing techniques. As this is a hands-on guide, the practical examples in the chapters will help you gain the skills to apply Power Query to real-world problems and improve your data analysis capabilities.
By the end of this book, you will be able to leverage all of Power Query's remarkable capabilities for data transformation
What you will learnThis book is for business analysts, business intelligence professionals, and power business users working with data who want to add Power Query mastery to their resume. This book will be beneficial for anyone who wants to automate their process of data cleaning and save huge amount of time. Having some basic experience in Power Query is recommended.
Table of Contents
Publisher's note: This edition from 2021 is outdated and does not cover the most recent Power BI updates. A new third edition, updated to the latest release is now available in color
Purchase of the print or Kindle book includes a free eBook in the PDF format.
Key Features:
- Update your knowledge with new recipes for query optimization, aggregation tables, Power BI API, and paginated reports
- Work with recipes across diverse Power BI platforms including the Power BI Service and Mobile Applications
- Implement custom solutions with M and DAX languages through actionable guidance and proven development techniques
Book Description:
The complete everyday reference guide to Power BI, written by an internationally recognized Power BI expert duo, is back with a new and updated edition.
Packed with revised practical recipes, Microsoft Power BI Cookbook, Second Edition, helps you navigate Power BI tools and advanced features. It also demonstrates the use of end-to-end solutions that integrate those features to get the most out of Power BI. With the help of the recipes in this book, you'll gain advanced design and development insight, practical tips, and guidance on enhancing existing Power BI projects.
The updated recipes will equip you with everything you need to know to implement evergreen frameworks that will stay relevant as Power BI updates. You'll familiarize yourself with Power BI development tools and services by going deep into the data connectivity, transformation, modeling, visualization, and analytical capabilities of Power BI. By the end of this book, you'll make the most of Power BI's functional programming languages of DAX and M and deliver powerful solutions to common business intelligence challenges.
What You Will Learn:
- Cleanse, stage, and integrate your data sources with Power Query (M)
- Remove data complexities and provide users with intuitive, self-service BI capabilities
- Build business logic and analysis into your solutions via the DAX programming language and dashboard-ready calculations
- Implement aggregation tables to accelerate query performance over large data sources
- Create and integrate paginated reports
- Understand the differences and implications of DirectQuery, live connections, Import, and Composite model datasets
- Integrate other Microsoft data tools into your Power BI solution
Who this book is for:
If you're a BI professional who wants to up their knowledge of Power BI and offer more value to their organization, then this book is for you. Those looking for quick solutions to common Power BI problems will also find this book an extremely useful resource. Please be aware that this is not a beginner's guide; you'll need a solid understanding of Power BI and experience working with datasets before you dive in.
Table of Contents
- Configuring Power BI Tools
- Accessing and Retrieving Data
- Building a Power BI Data Model
- Authoring Power BI Reports
- Working in the Service
- Getting Serious with Date Intelligence
- Parameterizing Power BI Solutions
- Implementing Dynamic User-Based Visibility in Power BI
- Applying Advanced Analytics and Custom Visuals
- Administering and Monitoring Power BI
- Enhancing and Optimizing Existing Power BI Solutions
- Deploying and Distributing Power BI Content
- Integrating Power BI with Other Applications