Data Analyst

Microsoft Certified: Azure Data Engineer Associate
  • Exam DP-203

As a candidate for this certification, you should have subject matter expertise in integrating, transforming, and consolidating data from various structured, unstructured, and streaming data systems into a suitable schema for building analytics solutions. As an Azure data engineer, you help stakeholders understand the data through exploration, and build and maintain secure and compliant data processing pipelines by using different tools and techniques. You use various Azure data services and frameworks to store and produce cleansed and enhanced datasets for analysis. This data store can be designed with different architecture patterns based on business requirements, including: Modern data warehouse (MDW) Big data Lakehouse architecture As an Azure data engineer, you also help to ensure that the operationalization of data pipelines and data stores are high-performing, efficient, organized, and reliable, given a set of business requirements and constraints. You help to identify and troubleshoot operational and data quality issues. You also design, implement, monitor, and optimize data platforms to meet the data pipelines. As a candidate for this certification, you must have solid knowledge of data processing languages, including: SQL Python Scala You need to understand parallel processing and data architecture patterns. You should be proficient in using the following to create data processing solutions: Azure Data Factory Azure Synapse Analytics Azure Stream Analytics Azure Event Hubs Azure Data Lake Storage Azure Databricks Important The English language version of this certification was updated on November 2, 2023. Review the study guide linked on the Exam DP-203 page for details about recent changes.

Microsoft Certified: Azure Data Fundamentals
  • Exam DP-900

This certification offers the foundation you need to build your technical skills to start working with data in the cloud. Mastering the basics can help you jump-start your career and prepare you to dive deeper into other technical opportunities Azure offers. The Microsoft Certified: Azure Data Fundamentals certification could be a great fit for you if you’d like to: Validate your foundational knowledge of core data concepts and how they’re implemented using Azure data services. Reinforce your basics for other Azure role-based certifications, like Azure Database Administrator Associate, Azure Data Engineer Associate, Power BI Data Analyst Associate, or Azure Developer Associate, but it’s not a prerequisite for any of them. If you’re new to the cloud or just starting out with Azure, first choose Azure fundamentals training and certification. If you’re beginning to work with data in the cloud, this certification is for you. It is recommended to have familiarity with: The concepts of relational and nonrelational data. Different types of data workloads, such as transactional or analytical. To prepare for the exam, we recommend that you: Fully understand the skills measured. Study the relevant self-paced content on Microsoft Learn, attend a Microsoft Azure Virtual Training Day: Data Fundamentals, or sign up for an instructor-led training event with a Training Services Partner. Take the free Practice Assessment to validate your knowledge and understanding of the exam experience. Get a trial subscription and give it a try. Check out Master the basics with the Azure Data Fundamentals certification to learn more about this certification and how to get ready. What's next? Register for your exam! After you pass the exam and earn your certification, celebrate your certification badge and skills on social platforms such as LinkedIn. To find out more, visit use and share certification badges. Depending on your goals and your profession, you may choose to: Master the basics with the Azure AI Fundamentals certification. Level up with the Azure Database Administrator Associate, Azure Data Engineer Associate, Power BI Data Analyst Associate, or Azure Developer Associate certifications. Find the right Microsoft Azure certification for you. Important The English language version of this certification was updated on February 1, 2024. Review the study guide linked on the Exam DP-900 page for details about recent changes.

Microsoft Certified: Azure Database Administrator Associate
  • Exam DP-300

As a candidate for this certification, you should have subject matter expertise in building database solutions that are designed to support multiple workloads built with: SQL Server on-premises Azure SQL services You’re a database administrator who manages on-premises and cloud databases built with SQL Server and Azure SQL services. As the Azure database administrator, you implement and manage the operational aspects of cloud-native and hybrid data platform solutions built on SQL Server and Azure SQL services. You use a variety of methods and tools to perform and automate day-to-day operations, including applying knowledge of using Transact-SQL (T-SQL) and other tools for administrative management purposes. You’re responsible for the following concerning database solutions: Management Availability Security Performance monitoring and optimization You evaluate and implement migration strategies for moving databases between Azure and on-premises. Plus, you work with Azure data engineers, Azure solution architects, Azure developers, data scientists, and other professionals to manage operational aspects of data platform solutions. As a candidate for this certification, you should have knowledge of and experience with: Azure SQL Database Azure SQL Managed Instance SQL Server on Azure Virtual Machines (Windows and Linux) Important The English language version of this certification was updated on February 7, 2024. Review the study guide linked on the Exam DP-300 page for details about recent changes.

Microsoft Certified: Azure Enterprise Data Analyst Associate
  • Exam DP-500

Warning This certification will retire on April 30, 2024. You will no longer be able to earn this certification after this date. Certification renewal will be available for at least six months after the certification retires. Read the blog post. As a candidate for the Azure Enterprise Data Analyst Associate certification, you should have subject matter expertise in designing, creating, and deploying enterprise-scale data analytics solutions. Your responsibilities for this role include performing advanced data analytics at scale, such as: Cleaning and transforming data. Designing and building enterprise data models. Incorporating advanced analytics capabilities. Integrating with IT infrastructure. Applying development lifecycle practices. As a professional in this role, you: Help collect enterprise-level requirements for data analytics solutions that include Azure and Power BI. Advise on data governance and configuration settings for Power BI administration. Monitor data usage. Optimize performance of the data analytics solutions. As an Azure enterprise data analyst, you collaborate with other roles, such as: Solution architects Data engineers Data scientists AI engineers Database administrators Power BI data analysts As a candidate for this certification, you should have advanced Power BI skills, including managing data repositories and data processing in the cloud and on-premises, along with using Power Query and Data Analysis Expressions (DAX). You should also be proficient in consuming data from Azure Synapse Analytics and should have experience querying relational databases, analyzing data by using Transact-SQL (T-SQL), and visualizing data. Important The English language version of this certification was updated on January 30, 2024. Review the study guide linked on the Exam PL-200 page for details about recent changes.

Microsoft Certified: Azure Solutions Architect Expert
  • Exam AZ-305

As a Microsoft Azure solutions architect, you have subject matter expertise in designing cloud and hybrid solutions that run on Azure, including: Compute Network Storage Monitoring Security Your responsibilities for this role include advising stakeholders and translating business requirements into designs for Azure solutions that align with the Azure Well-Architected Framework and Cloud Adoption Framework for Azure. In this role, you implement solutions on Azure by partnering with various other job roles, including: Developers Administrators Security engineers Data engineers As a candidate for this certification, you should have advanced experience and knowledge of IT operations, including networking, virtualization, identity, security, business continuity, disaster recovery, data platforms, and governance. You should manage how decisions in each area affect an overall solution. In addition, you should have experience with: Azure administration Azure development DevOps processes Important The English language version of this certification was updated on January 22, 2024. Review the study guide linked on the Exam AZ-305 page for details about recent changes.

Microsoft Certified: Dynamics 365 Customer Insights (Data) Specialty
  • Exam MB-260

As a candidate for this certification, you implement solutions that provide insights into customer profiles and that track engagement activities to help: Improve customer experiences. Increase customer retention. You should have firsthand experience with: Dynamics 365 Customer Insights - Data and one or more additional Dynamics 365 apps Microsoft Power Query Microsoft Dataverse Common Data Model Microsoft Power Platform You should also have direct experience with practices related to: Privacy Compliance Consent Security Responsible AI Data retention policy As a candidate for this exam, you need experience with processes related to key performance indicators (KPIs), data retention, validation, visualization, preparation, matching, fragmentation, segmentation, and enhancement. You should have a general understanding of: Azure Machine Learning Azure Synapse Analytics Azure Data Factory If you need more experience before you try to earn this certification, here are some suggestions: Work as a Microsoft Dynamics 365 consultant on Customer Insights projects. Join the Dynamics 365 community. You don't have to be a certificate holder. Take available learning paths on Microsoft Learn and complete more hands-on practice. Sign up for an instructor-led training course. Read the Discover your career path blog for more information. Important The English language version of this certification was updated on October 19, 2023. Review the study guide linked on the Exam MB-260 page for details about latest changes.

Microsoft Certified: Dynamics 365: Finance and Operations Apps Solution Architect Expert
  • Exam MB-700

Are you a solution architect, functional or technical consultant, IT professional, or information worker who is familiar with Microsoft Dynamics 365 apps and Microsoft Power Platform? Do you have a deep understanding of Dynamics 365 finance and operations apps? Are you a trusted advisor who understands recommended business practices and software capabilities? If so, earning this expert certification can open doors that could take your career to the next level. As a candidate for this certification, you’re a Dynamics 365 professional who advises stakeholders and translates business requirements into secure, scalable, and reliable solutions. You design cohesive solutions for your customers because you know how to work with the essential architectural components of Dynamics 365 finance and operations apps. You have extensive domain knowledge in one or more industry verticals. Plus, you understand how decisions in each area affect the overall solution. In addition, you’re familiar with platforms, tools, and functional areas, such as finance and supply chain management. The Dynamics 365: Finance and Operations Apps Solution Architect Expert certification is a good fit for you if: You have significant experience as a Dynamics 365 finance and operations apps functional consultant or technical consultant. You aspire to be a solution architect or recently started that career journey. You’re responsible for the successful design, implementation, deployment, and adoption of an overall technology solution in your organization. You have experience consulting with organizations and implementation team members to refine business needs into well-defined and cost-effective solutions. If you need more experience before you try to earn this certification, here are some suggestions: Shadow a solution architect or work as one on a few projects. Volunteer to design and implement a finance and operations app solution. Attend solution architecture workshops with other solution architects. Important The English language version of this certification will be updated on March 18, 2024. Review the study guide linked on the Exam MB-700 page for details about upcoming changes.

Microsoft Certified: Fabric Analytics Engineer Associate
  • Exam DP-600

As a candidate for this certification, you should have subject matter expertise in designing, creating, and deploying enterprise-scale data analytics solutions. Your responsibilities for this role include transforming data into reusable analytics assets by using Microsoft Fabric components, such as: Lakehouses Data warehouses Notebooks Dataflows Data pipelines Semantic models Reports You implement analytics best practices in Fabric, including version control and deployment. To implement solutions as a Fabric analytics engineer, you partner with other roles, such as: Solution architects Data engineers Data scientists AI engineers Database administrators Power BI data analysts In addition to in-depth work with the Fabric platform, you need experience with: Data modeling Data transformation Git-based source control Exploratory analytics Languages, including Structured Query Language (SQL), Data Analysis Expressions (DAX), and PySpark

Microsoft Certified: Power BI Data Analyst Associate
  • Exam PL-300

As a candidate for this certification, you should deliver actionable insights by working with available data and applying domain expertise. You should: Provide meaningful business value through easy-to-comprehend data visualizations. Enable others to perform self-service analytics. Deploy and configure solutions for consumption. As a Power BI data analyst, you work closely with business stakeholders to identify business requirements. You collaborate with enterprise data analysts and data engineers to identify and acquire data. You also use Power BI to: Transform the data. Create data models. Visualize data. Share assets. You should be proficient at using Power Query and writing expressions by using Data Analysis Expressions (DAX). You know how to assess data quality. Plus, you understand data security, including row-level security and data sensitivity. If you need more experience before you try to earn this certification, you could: Work on a Power BI data analysis and visualization project. Shadow a data analyst who works with Power BI. Complete additional training on Microsoft Learn. Take available learning paths on Microsoft Learn. Find training options at the Power BI Learning catalog. Sign up for an instructor-led training course. Important The English language version of this certification was updated on February 6, 2024. Review the study guide linked on the Exam PL-300 page for details about recent changes.

Microsoft Certified: Power Platform App Maker Associate
  • Exam PL-100

If you’re a business professional with deep expertise in your solution domain and you want to use your passion for building Microsoft Power Platform solutions to simplify, automate, and transform tasks and processes for your team, this certification is designed for you. You understand: The data that you work with. The issues that you need to resolve. The required processes and app experiences. As a candidate for this certification, you may not have formal IT training but are comfortable using technology to solve business problems. You're self-directed and focus on solving problems by using Microsoft Power Platform as part of your primary job role. You may connect to and use features of apps including: Microsoft Teams Microsoft 365 apps and services Third-party solutions You have a desire to understand the capabilities and limitations of available tools and how to apply them. To learn more, read our post Are you a Power Platform App Maker? Now’s the time to get certified. If you need more experience before you try for this certification, you could: Volunteer on a project to get real-life experience with data modeling, basic UX design, requirements analysis, or process analysis. Take learning paths on Microsoft Learn. Sign up for an instructor-led training course. Important The English language version of this certification was updated on January 19, 2024. Review the study guide linked on the Exam PL-100 page for details about recent changes.

Microsoft Certified: Power Platform Solution Architect Expert
  • Exam PL-600

If you’re looking to prove your expertise as a Microsoft Power Platform or Microsoft Dynamics 365 solution architect, or if you’re a developer or a senior consultant ready to take the next step to become a solution architect, this expert certification can help you move forward in your career. As a candidate for the Power Platform Solution Architect Expert certification, you’re a solution architect who: Leads successful implementations. Focuses on how solutions address the broader business and technical needs of organizations. This role requires you to have the ability to identify opportunities to solve business problems. You should have functional and technical knowledge of: Microsoft Power Platform Dynamics 365 customer engagement apps Related Microsoft cloud solutions Other third-party technologies You apply knowledge and experience throughout an engagement. You perform proactive and preventative work to: Increase the value of the customer’s investment. Promote organizational health. If you need additional experience before you try for this certification, here are some suggestions: Work as (or shadow) a solution architect on Power Platform projects. Sign up for an instructor-led training course. Explore available learning paths on Microsoft Learn. Important The English language version of this certification was updated on September 26, 2023. Review the study guide linked on the Exam PL-600 page for details about recent changes.