Daniil Maslyuk – författare

Transform your data analysis experience with Power Query, the ultimate tool for importing, reshaping, and cleansing data through a user-friendly interface. Whether you're using Power BI, Excel, or other Microsoft products, Power Query's capabilities are at your fingertips. Renowned Power Query experts Daniil Maslyuk and Gil Raviv guide you through mastering this indispensable tool, helping you eliminate tedious manual data preparation, tackle common issues, and avoid potential pitfalls. In this updated edition, you'll delve into comprehensive analytics challenges, seamlessly integrating your skills into a realistic, final project. By the end, you'll possess the expertise to handle any data and convert it into actionable insights.

You will learn how to:

Effortlessly prepare data by utilizing Power Query in Power BI and Excel to transform your data quickly and efficiently Overcome common data preparation problems with intuitive mouse clicks and straightforward formula edits Combine data from various sources, multiple queries, and mismatched tables with ease Reshape tables to suit your analysis needs Use the Power Query M formula language to create flexible data mashups and tailor transformations to your requirements Address and overcome collaboration challenges by using Power Query's powerful features Gain crucial insights from text feeds by enhancing your data analysis capabilities Profile data, diagnose queries, improve query performance, and more!

About This Book

For everyone who wants to get more done with Power Query in less time For business and financial professionals, developers, entrepreneurs, students, and others who need to efficiently manage and analyze data

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

Prepare for Microsoft Exam 70-778–and help demonstrate your real-world mastery of Power BI data analysis and visualization. Designed for experienced BI professionals and data analysts ready to advance their status, Exam Ref focuses on the critical thinking and decision-making acumen needed for success at the MCSA level. 

Focus on the expertise measured by these objectives: 

Consume and transform data by using Power BI Desktop  Model and visualize data  Configure dashboards, reports, and apps in the Power BI Service 

This Microsoft Exam Ref: 

Organizes its coverage by exam objectives  Features strategic, what-if scenarios to challenge you  Assumes you have experience consuming and transforming data, modeling and visualizing data, and configuring dashboards using Excel and Power BI 

Prepare for Microsoft Exam DP-600 and demonstrate your real-world mastery of Microsoft Fabric analytics solution development. Designed for working Fabric analytics engineers, this Exam Ref focuses on the critical thinking and decision-making acumen needed for success at the Microsoft Certified Solutions Associate level.

Focus on the expertise measured by these objectives:

Plan, implement, and manage a solution for data analytics Prepare and serve data Implement and manage semantic models Explore and analyze data

This Microsoft Exam Ref:

Organizes its coverage by exam objectives Features strategic, what-if scenarios to challenge you Assumes you want to validate your ability to design and build diverse Microsoft Fabric analytics solutions

About the Exam

Exam DP-600 focuses on knowledge needed to implement and plan a data analytics environment; manage an analytics development lifecycle; create objects in a lakehouse or warehouse; copy data, transform data, and optimize performance; implement, design, and build semantic models; optimize enterprise-scale semantic models; perform exploratory analytics; query data by using SQL.

About Microsoft Certification

Passing this exam fulfills your requirements for Microsoft Certified: Fabric Analytics Engineer Associate credential, demonstrating your readiness to design, build, test, and maintain Microsoft Fabric data analytics solutions, and partner with other professionals and clients to implement them.

See full details at: microsoft.com/learn

Exam Ref DA-100 Analysing Data with Microsoft Power BI offers professional-level preparation that helps candidates maximise their exam performance and sharpen their skills on the job. It focuses on specific areas of expertise modern IT professionals need to demonstrate real-world mastery of Power BI data analysis and visualisation. Coverage includes: Preparing data: acquiring, profiling, cleaning, transforming, and loading data Modeling data: designing and developing data models, creating measures with DAX, and optimising model performance Visualising data: creating reports and dashboards, and enriching reports for usability Analysing data: enhancing reports to expose insights, and performing advanced analysis Deploying and maintaining deliverables: managing datasets; creating and managing workspaces Microsoft Exam Ref publications stand apart from third-party study guides because they: Provide guidance from Microsoft, the creator of Microsoft certification exams Target IT professional-level exam candidates with content focused on their needs, not one-size-fits-all content Streamline study by organising material according to the exams objective domain (OD), covering one functional group and its objectives in each chapter Feature Thought Experiments to guide candidates through a set of what if? scenarios, and prepare them more effectively for Pro-level style exam questions Explore big picture thinking around the planning and design aspects of the IT pros job role

The full text downloaded to your computer

With eBooks you can:

search for key concepts, words and phrases make highlights and notes as you study share your notes with friends

eBooks are downloaded to your computer and accessible either offline through the Bookshelf (available as a free download), available online and also via the iPad and Android apps.

Upon purchase, you'll gain instant access to this eBook.

Time limit

The eBooks products do not have an expiry date. You will continue to access your digital ebook products whilst you have your Bookshelf installed.

Prepare for Microsoft Exam DA-100 and help demonstrate your real-world mastery of Power BI data analysis and visualization. Designed for experienced data analytics professionals ready to advance their status, Exam Ref focuses on the critical thinking and decision-making acumen needed for success at the Microsoft Certified Associate level.Focus on the expertise measured by these objectives:

Prepare the data Model the data Visualize the data Analyze the data Deploy and maintain deliverables This Microsoft Exam Ref: Organizes its coverage by exam objectives Features strategic, what-if scenarios to challenge you Assumes you are an experienced business intelligence professional or data analyst, or have a similar role Analyzing Data with Microsoft Power BI About the Exam Exam DA-100 focuses on skills and knowledge needed to acquire, profile, clean, transform, and load data; design and develop data models; create measures with DAX; optimize model performance; create reports and dashboards; enrich reports for usability; enhance reports to expose insights; perform advanced analysis; manage datasets, and create and manage workspaces. About Microsoft Certification Passing this exam earns your Microsoft Certified: Data Analyst Associate certification, demonstrating your ability to help businesses maximize the value of data assets by using Microsoft Power BI.

As subject matter experts, Data Analysts design and build scalable data models, clean and transform data, and enable advanced analytic capabilities that provide meaningful business value through easy-to-comprehend data visualizations.

See full details at: microsoft.com/learn

Prepare for Microsoft Exam DP-500 and demonstrate your real-world ability to design, create, and deploy enterprise-scale data analytics solutions. Designed for business intelligence developers, architects, data analysts, and other professionals, this Exam Ref focuses on the critical thinking and decision-making acumen needed for success at the Microsoft Certified: Azure Enterprise Data Analyst Associate level.

Focus on the expertise measured by these objectives:

Implement and manage a data analytics environment Query and transform data Implement and manage data models Explore and visualize data

This Microsoft Exam Ref:

Organizes its coverage by exam objectives Features strategic, what-if scenarios to challenge you Assumes you are a business intelligence developer, architect, data engineer, data architect, data analyst, or another professional with Power BI and Azure experience.

About the ExamExam DP-500 focuses on knowledge needed to govern and administer data analytics environments; integrate analytics platforms into existing IT infrastructure; manage the analytics development lifecycle; query data with Azure Synapse Analytics; ingest and transform data with Power BI; design and build tabular models; optimize enterprise-scale data models; explore data with Azure Synapse Analytics; and visualize data with Power BI.

About Microsoft CertificationPassing this exam fulfills your requirements for the Microsoft Certified: Azure Enterprise Data Analyst Associate certification, demonstrating your knowledge of designing, creating, and deploying enterprise-scale data analytics solutions. Responsibilities include performing advanced data analytics at scale, collecting enterprise-level requirements for data analytics solutions that include Azure and Microsoft Power BI, advising on data governance and configuration for Power BI administration, monitoring data usage, and optimizing solution performance.

See full details at: microsoft.com/learn