DAT 350 - Microsoft Power BI Data Analyst
Connect to and visualize any data using Power BI, the unified, scalable platform for self-service and enterprise business intelligence (BI). Power BI is easy to use and helps you gain deeper insight into your data.
Students will examine the methods and best practices that align with business and technical requirements for modeling, visualizing, and analyzing data with Power BI. You will learn how to access and process data from various sources, including relational and non-relational data. Implement proper security standards and policies across the Power BI spectrum, including datasets and groups. Manage and deploy reports and dashboards for sharing and content distribution, and enable advanced analytic capabilities that provide meaningful business value.
This course covers the objectives for Microsoft Exam PL-300: Microsoft Power BI Data Analyst. This exam is required to fulfil the requirements of the Microsoft Certified: Power BI Data Analyst Associate professional certification.
Students enrolled in this course will be eligible to purchase the Microsoft exam voucher at a discounted rate.
By the completion of this course, successful students will be able to:
- Ingest, clean, and transform data
- Model data for performance and scalability
- Design and create reports for data analysis
- Apply and perform advanced report analytics
- Manage and share report assets
Module 1: Get Started with Microsoft Data Analytics
Explore the different roles in the data space, the important roles and responsibilities of a Data Analysts, and then explore the landscape of the Power BI portfolio.
Module 2: Getting Data in Power BI
This module explores the identification and retrieval of data from various data sources. Learn the options for connectivity and data storage and understand the difference and performance implications of connecting directly to data vs. importing it.
Module 3: Cleaning, Transforming, and Loading Data in Power BI
This module teaches you the process of profiling and understanding the condition of data. Learn how to identify anomalies, look at the size and shape of data, and perform the proper data cleaning and transforming steps to prepare data for loading into the model.
Module 4: Design a Data Model in Power BI
Module four teaches the fundamental concepts of designing and developing a data model for proper performance and scalability. Understand and tackle many of the common data modeling issues, including relationships, security, and performance.
Module 5: Create Model Calculations using DAX in Power BI
This module introduces you to the world of the Data Analysis Expressions (DAX) programming language. Students will be exposed to enhancing a model and its true power. Learn about aggregations and the concepts of Measures, calculated columns and tables, and Time Intelligence functions to solve calculation and data analysis problems.
Module 6: Optimize Model Performance in Power BI
Students are introduced to steps, processes, concepts, and data modeling best practices necessary to optimize a data model for enterprise-level performance.
Module 7: Create Reports in Power BI
Module seven introduces you to the fundamental concepts and principles of designing and building a report, including selecting the correct visuals, creating a page layout, and applying basic but critical functionality. The vital topic of designing for accessibility is also covered.
Module 8: Create Dashboards in Power BI
Learn how to tell a compelling story using dashboards and the different navigation tools available to provide navigation. You will be introduced to features and functionality and how to enhance dashboards for usability and insights.
Module 9: Identify Patterns and Trends in Power BI
Apply additional features to enhance the report for analytical insights within the data, equipping you with the steps to use the report for actual data analysis. Perform advanced analytics using AI visuals on the report for even deeper and more meaningful data insights.
Module 10: Create and Manage Workspaces in Power BI
This module will introduce you to Workspaces, including how to create and manage them. Discover how to share content, including reports and dashboards, and then learn how to distribute an App.
Module 11: Manage Files and Datasets in Power BI
This module will introduce you to parameters and datasets. Learn how to manage datasets and parameters, build dynamic reports with parameters, and set dataset refresh options.
Module 12: Row-level Security in Power BI
In Module twelve, students will understand how to implement row-level security using the Static and Dynamic methods.
Who is this course for?
The audience for this course is those individuals who develop reports that visualize data from the data platform technologies that exist both in the cloud and on-premises.
This course is designed for learners who wish to pursue future careers like:
- Data Analyst
- Business Analyst
- Reporting Analyst
- Power BI Analyst
This course includes extensive hands-on activities designed to help you learn by working with Azure. To complete the labs in this course, you will need:
- A modern web browser such as Microsoft Edge
- Microsoft Azure Lab Access (will be provided at no additional cost)
There are no mandatory pre-requisites for this course. However, you are required to perform a self-assessment to ensure you meet the requirements to enroll.
Self-assessment for enrolment
- Fundamental understanding of 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.
Applies Towards the Following Program(s)
- Certificate in Business Intelligence and Analytics : Optional Courses
- Enterprise Data Analytics using Microsoft Azure and Microsoft Power BI : Required