PL-300T00-A | Microsoft Power BI Data Analyst
This course covers the various methods and best practices that are in line with business and technical requirements for modeling, visualizing, and analyzing data with Power BI. The course will show how to access and process data from a range of data sources including both relational and non-relational sources. Finally, this course will also discuss how to manage and deploy reports and dashboards for sharing and content distribution.
The audience for this course are data professionals and business intelligence professionals who want to learn how to accurately perform data analysis using Power BI. This course is also targeted toward those individuals who develop reports that visualize data from the data platform technologies that exist on both in the cloud and on-premises.
Successful Data Analysts start this role with experience of working with data in the cloud.
- Understanding core data concepts.
- Knowledge of working with relational data in the cloud.
- Knowledge of working with non-relational data in the cloud.
- Knowledge of data analysis and visualization concepts.
You can gain the prerequisites and a better understanding of working with data in Azure by completing Microsoft Azure Data Fundamentals before taking this course.
Module 1: Get started with Microsoft data analytics
Businesses need data analysis more than ever. In this learning path, you will learn about the life and journey of a data analyst, the skills, tasks, and processes they go through in order to tell a story with data so trusted business decisions can be made. You will learn how the suite of Power BI tools and services are used by a data analyst to tell a compelling story through reports and dashboards, and the need for true BI in the enterprise.
- Discover data análisis
- Get started building with Power BI
Module 2: Prepare data for análisis
You will explore Power Query as you learn to extract data from different data sources and choose a storage mode and connectivity type. You will learn to profile, clean, and load data into Power BI in preparation for modeling your data.
- Get data in Power BI
- Clean, transform, and load data in Power BI
Module 3: Model data in Power BI
Success with Power BI begins with a great data model. In this module, you will learn how to design a data model that is intuitive, high-performing, and simple to maintain. You will learn about using DAX language to create measures. Those measures will help you create a wide variety of analytic solutions. Additionally, you’ll learn how to improve performance with your Power Query data retrieval tasks.
- Design a data model in Power BI
- Introduction to creating measures using DAX in Power BI
- Optimize a model for performance in Power BI
Module 4: Visualize data in Power BI
Power BI has extraordinary visuals that can be used on Power BI reports and dashboards. In this module, you will learn when to use which visual to solve which problem. You will also learn report design and report formatting. Additionally, you will learn how to use report navigation to tell a compelling, data-driven story in Power BI. Dashboards will help your users target report visuals to meet their specific needs. Paginated reports help you create pixel-perfect report artifacts like sales invoices, purchase orders, medical records, transaction statements, and much more.
- Work with Power BI visuals
- Create a data-driven story with Power BI reports
- Create dashboards in Power BI
- Create paginated reports
Module 5: Data analysis in Power BI
Report authors can use more features to enhance their reports for analytical insights in their data with features like Q&A and exporting. In this module, you will closely examine your data and Power BI reports and then extract value with deeper analysis. Additionally, you will learn how to sort data and how to present the report in a cohesive manner. You will learn how to get a statistical summary for your data and export data from Power BI. You will also apply and perform advanced analytics on the report for deeper and more meaningful data insights.
- Perform analytics in Power BI
- Work with AI visuals in Power BI
Module 6: Manage workspaces and datasets in Power BI
Once you have created your Power BI data sets and reports, it’s time to deploy them so the users can take advantage of all of your hard work. In this Learning Path, you will learn how to create workspaces in the Power BI service. You will deploy your Power BI artifacts here and share them to your users. You will also learn how to connect Power BI reports to on-premise data sources. Your users will appreciate seeing the latest data in your reports, so you will configure automatic refresh for your Power BI datasets. Row-level security allows you to create one report, but have users be restricted to see only the data that applies to them. This targets data to users, without having to create multiple reports.
- Create and manage workspaces in Power BI
- Manage datasets in Power BI
- Implement row-level security
Descargue el temario para conocer el detalle completo de los contenidos
Debido a las constantes actualizaciones de los contenidos de los cursos por parte del fabricante, el contenido de este temario puede variar con respecto al publicado en el sitio oficial, sin embargo, Netec siempre entregará la versión actualizada de éste