PL 300 Power BI Data Analyst
Course Duration
3 Days
Training Mode
Online
Accredited By
Microsoft
Course Overview
The Power BI Data Analyst certification course teaches professionals to create data visualizations and dashboards using Microsoft Power BI. It covers accessing and processing data from relational and non-relational sources, implementing security standards, managing and deploying reports and dashboards, and building paginated reports within Power BI.
Corporate Benefits
Upskilling your employees in this certification offers several advantages, including:
- Increasing the productivity and efficiency of the company’s data analysis and reporting
- Improving decision-making in the company through accurate and insightful data analysis
- Improving business data visualisation and storytelling skills to effectively communicate insights
- Lowering organisational costs by reducing reliance on outside consultants or vendors
- Increasing a company’s competitive advantage by rapidly adapting to changing business needs and trends
Course ratings
Why Choose Us ?
- Reputable training facility with over 20 years of experience.
- Experienced and knowledgeable instructors
- High-quality, relevant, and up-to-date training materials
- Convenient training that fits your hectic schedule
- Good value for money that is worth the investment
Course Objectives
- 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
- Create paginated reports in Power BI
Who Should Get Certified
- Data Analysts
- Business Intelligence Developers
- Business Analysts
- IT Professionals
- Project Managers
- Anyone interested in a career in data analytics or business intelligence
Prerequisites
- Have a good understanding of data analysis concepts and proficient in using Microsoft Excel
- Have experience working with data from a variety of sources and familiar with database concepts
- Have a basic understanding of SQL and data modeling concepts
- Familiar with Power BI Desktop and have access to a Power BI tenant to complete the labs and exercises
Course Curriculum
Module 1: Get Started with Microsoft Data Analytics
- Data analytics and Microsoft
- Getting started with Power BI
- Lab: getting started in Power BI desktop
- Getting started
Module 2: Prepare Data in Power BI
- Get data from various data sources
- Lab: preparing data in Power BI desktop
- Prepare Data
Module 3: Clean, Transform, and Load Data in Power BI
- Data shaping
- Enhance the data structure
- Data profiling
- Lab: transforming and loading data in Power BI desktop
- Loading data
Module 4: Design a Data Model in Power BI
- Introduction to data modelling
- Working with tables
- Dimensions and hierarchies
- Lab: data modeling in Power BI desktop
- Create model relationships
- Configure tables
- Review the model interface
- Create quick measures
- Lab: advanced data modeling in Power BI desktop
- Configure many-to-many relationships
- Enforce row-level security
Module 5: Create Model Calculations using DAX in Power BI
- Introduction to DAX
- DAX context
- Advanced DAX
- Lab: advanced DAX in Power BI desktop
- Use the CALCULATE() function to manipulate filter context
- Use Time Intelligence functions
- Lab: introduction to DAX in Power BI Desktop
- Create calculated tables
- Create calculated columns
- Create measures
Module 6: Optimize Model Performance in Power BI
- Optimize the model for performance
- Optimize Direct Query models
- Create and manage aggregations
Module 7: Create Reports in Power BI
- Design a report
- Enhance the report
- Lab: designing a report in Power BI desktop
- Create a live connection in Power BI desktop
- Design a report
- Configure visual fields and format properties
- Lab: enhancing reports with interaction and formatting in Power BI
- desktop
- Create and configure Sync Slicers
- Create a drill through page
- Apply conditional formatting
- Create and use Bookmarks
Module 8: Create Dashboards in Power BI
- Create a dashboard
- Real-time dashboards
- Enhance a dashboard
- Lab: creating a dashboard in Power BI service
- Create a dashboard
- Pin visuals to a dashboard
- Configure a dashboard tile alert
- Use Q&A to create a dashboard tile
Module 9: Enhance Reports for Usability and Storytelling in Power BI
- Paginated report overview
- Create paginated reports
- Lab: creating a paginated report in Power BI desktop
- Use Power BI report builder
- Design a multi-page report layout
- Define a data course
- Define a dataset
- Create a report parameter
- Export a report to PDF
Module 10: Perform Advanced Analytics in Power BI
- Advanced analytics
- Data insights through AI visuals
- Lab: Data analysis in Power BI desktop
- Create animated scatter charts
- Use the visual to forecast values
- Work with Decomposition Tree visual
- Work with the Key Influencers visual
Module 11: Manage Datasets in Power BI
- Parameters
- Datasets
- Security in Power BI
Module 12: Create and Manage Workspaces in Power BI
- Creating Workspaces
- Sharing and managing assets
- Lab: publishing and sharing Power BI content
- Map security principals to dataset roles
- Share a dashboard
- Publish an App
Claim with HRD-Corp
We are an authorized training provider of HRD Corp (Human Resources Development Corporation). Our certification training programs are eligible for funding under SBL-Khas Scheme.
HRD Corp provides training and upskilling opportunities for Malaysian employees who are:
- Malaysian citizens or permanent residents
- Employed in a company that contributes to HRD Corp (employer with 10 or more Malaysian employees, or employers from specific sectors)
- Registered with the HRD Corp portal and have an activated account
- Have not attended the same training program within the last 12 months
- Meet the specific requirements for the training program, such as qualifications, skills, or job-specific criteria
Invest in your employees’ professional growth and development by claiming your training with HRD-Corp today!