PL-300: Microsoft Certified Power BI Data Analyst
Power BI is the world’s most powerful self-service business intelligence platform, and an essential tool for data professionals and beginners alike. With Power BI you can connect to hundreds of data sources, build complex relational models using simple and intuitive tools, and design stunning, interactive dashboards from scratch. The Power BI data analyst works closely with business stakeholders to identify business requirements. They also transform the data, create data models, visualize data, and share assets by using Power BI.
PL-300: Microsoft Certified Power BI Data Analyst
Power BI is the world’s most powerful self-service business intelligence platform, and an essential tool for data professionals and beginners alike. With Power BI you can connect to hundreds of data sources, build complex relational models using simple and intuitive tools, and design stunning, interactive dashboards from scratch. The Power BI data analyst works closely with business stakeholders to identify business requirements. They also transform the data, create data models, visualize data, and share assets by using Power BI.
Course Introduction
Power BI is the world’s most powerful self-service business intelligence platform, and an essential tool for data professionals and beginners alike. With Power BI you can connect to hundreds of data sources, build complex relational models using simple and intuitive tools, and design stunning, interactive dashboards from scratch. The Power BI data analyst works closely with business stakeholders to identify business requirements. They also transform the data, create data models, visualize data, and share assets by using Power BI.
This 60-hours instructor led course at RSTForum or online is customized to provide candidates with extensive knowledge to accomplish their day-to-day jobs. The key to success is based on the program’s objectives as follows:
- Course contents are based on course outlines defined by Microsoft
- Dedicated Monitoring to evaluate and report candidate’s progress
- Extensive hands-on lab exercises
- Industry acclaimed, experienced, and certified instructors
Course Highlights
- Project manager can be assigned to track candidates performance
- Curriculum based on course outlines defined by Microsoft.
- This Instructor-led classroom course is designed with an aim to build theoretical knowledge supplemented by ample hands-on lab exercises
- Facility of Lab on cloud available (based on booking)
- Courseware includes reference material to maximize learning.
- Assignments and test to ensure concept absorption.
- Courseware includes reference material to maximize learning.
- Assignments and test to ensure concept absorption.
- Repeating of lectures allowed (based on seat availability)
Course Objectives
- Build professional-quality business intelligence reports from the ground up
- Blend and transform raw data into beautiful interactive dashboards
- Design and implement the same B.I. tools used by professional analysts and data scientists
- Showcase your skills with many course-projects
- Understand the business intelligence workflow from end-to-end
Course Topics
Through this Microsoft Certified: Power BI Data Analyst training, participants will learn about creating actionable insights by leveraging various data sets and then building data models using the Power BI tool. The Power BI data analyst works closely with business stakeholders to identify business requirements. They collaborate with enterprise data analysts and data engineers to identify and acquire data. They also transform the data, create data models, visualize data, and share assets by using Power BI.
OBJECTIVE 1: Connect & Transform the Raw Data
- Intro to the Power BI Query Editor
- Types of Power BI Data Connectors
- Basic Table Transformations
- Text, Number & Date Tools
- Index & Conditional Columns
- Grouping & Aggregating Data
- Pivoting & Unpivoting
- Modifying, Merging & Appending Queries
- Connecting to Folders
- Defining Hierarchies & Categories
- Query Editing & Power BI Best Practices
OBJECTIVE 2: Build a Relational Data Model
- Intro to Database Normalization
- Data (“Fact”) Tables vs. Lookup (“Dimension”) Tables
- Creating Power BI Table Relationships
- “Star” vs. “Snowflake” Schemas
- Active vs. Inactive Relationships
- Relationship Cardinality
- Connecting Multiple Data Tables
- Filtering & Cross-Filtering
- Hiding Fields from the Power BI Report View
- Data Modeling & Power BI best Practices
OBJECTIVE 3: Add Calculated Fields with DAX
- Intro to Data Analysis Expressions (DAX)
- Calculated Columns vs. Measures
- Row Context vs. Filter Context in Power BI
- DAX Syntax & Operators
- Common Power BI Functions
- Basic Date & Time Formulas
- Logical & Conditional Statements
- Text, Math & Stats Functions
- Joining Data with RELATED
- CALCULATE, ALL & FILTER Functions
- DAX Iterators
- Time Intelligence Formulas
- DAX & Power BI Best Practices
OBJECTIVE 4 : Design Interactive Power BI Reports
- Intro to the Power BI Report View
- Adding Basic Charts to Power BI Reports
- Formatting & Filtering Options
- Matrix Visuals
- Slicers & Timelines
- Cards & KPIs
- Power BI Map Visuals (Basic, Fill, ArcGIS)
- Tree-maps, Lines, Areas & Gauges
- Editing Report interactions
- Adding Drill through Filters
- Linking to Report Bookmarks
- Using “What-If” Parameters
- Managing & Viewing Roles
Lab Topics
Not Available
Virtual Classroom
- Instructor led online training is an ideal vehicle for delivering training to individuals anywhere in the world at any time.
- This innovative approach presents live content with instructor delivering the training online.
- Candidates will be performing labs remotely on our labs on cloud in presence of an online instructor.
- Rstforum uses microsoft lync engine to deliver instructor led online training.
- Advances in computer network technology, improvements in bandwidth, interactions, chat and conferencing, and realtime audio and video offers unparalleled training opportunities.
- Instructor led online training can helps today’s busy professionals to perform their jobs and upgrade knowledge by integrating self-paced instructor led online training in their daily routines.
Miscellaneous
- Minimum batch size required for batch is 10 participants in the this course.
- The RST Forum reserves the right to cancel/postpone the class.
- Course schedule will be provided before commencement of the course.
- Certificate of participation will be awarded to participants with a minimum 90% attendance.
- All attendees are to observe the Copyright Law on intellectual properties such as software and courseware from respective vendors.
- The RST Forum reserves the right to include external participants in the program either for the entire course or individual courses.
- The RST Forum reserves the right to change/alter the sequence of courses. RST FORUM published Book would be given at 50% discounted rate to the forum students.