Skip to content
thecertiedge.comthecertiedge.com
  • Category
    • Cloud Computing
    • Others
    • SAP
  • Home
  • All Courses
  • Contact us
  • Other
    • Gallery
    • About us
    • Terms and Conditions
    • Privacy policy
    • Blog
    • Certificate Authentication
  • Talent acquisition
thecertiedge.comthecertiedge.com
  • Home
  • All Courses
  • Contact us
  • Other
    • Gallery
    • About us
    • Terms and Conditions
    • Privacy policy
    • Blog
    • Certificate Authentication
  • Talent acquisition
  • Home
  • Course
  • Microsoft Power BI Data Analyst (PL-300)

Microsoft Power BI Data Analyst (PL-300)

  • By Certiedge official
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape

Course Duration: 32 Hours of Comprehensive Learning

Mode of Learning:

Choose the learning style that best fits your schedule and preferences:

  1. Online Instructor-Led Training – Learn in real time with live expert-led sessions.
  2. Online Self-Paced Learning – Study anytime, anywhere with flexible recorded modules.
  3. Onsite/Classroom Training – Experience in-person, hands-on learning guided by certified trainers.

What’s Included in the Training Program:

Our industry-leading Training Program is designed to provide a complete learning experience through a perfect blend of theory and practical exposure. Here’s what you’ll get:

  • Live, Instructor-Led Online Training Sessions
  • Hands-on Lab Exercises
  • Certified and Experienced Trainers
  • Post-Training Support & Mentorship
  • Comprehensive Learning Resources including eBooks, guides, and reference materials.
  • Real-World Case Studies & Application Scenarios
  • Networking Opportunities
  • Group Projects and Collaborative Learning Activities
  • Best Practices and Industry Insights.
  • Access to Recorded Sessions (available for online learners, based on client permissions).
  • Follow-up Review Sessions.
  • Tool Demonstrations and Guided Walkthroughs

This training helps you gain the knowledge and hands-on experience needed to advance your career in today’s competitive IT landscape.

 

Show More

Course Content

Introduction to Power BI

  • Introduction to Business Intelligence
  • Role of a Data Analyst
  • Overview of Microsoft Power BI Ecosystem
  • Power BI Desktop vs Power BI Service
  • End-to-End Flow: Connect, Transform, Model, Visualize

Get Data from Different Sources

  • Supported Data Sources in Power BI
  • Data Connection Modes: Import, DirectQuery, Live Connection
  • Connecting to Excel, SQL Server, Web, SharePoint, APIs
  • Using Parameters and Templates for Reusability
  • Performance Considerations for Data Loading

Data Preparation & Power Query Editor

  • Introduction to Power Query Editor
  • Data Cleaning: Removing Nulls, Errors, Duplicates
  • Shaping and Transforming Data
  • Using Advanced Editor and M Language
  • Merge vs Append Queries
  • Column Splits, Extracts, Replacements
  • Conditional Columns and Custom Columns

Data Modeling in Power BI

  • Understanding Tables and Fields
  • Relationships: Cardinality, Cross-filter Direction, Active vs Inactive
  • Normalization and Denormalization
  • Building a Star Schema
  • Creating Calculated Columns and Tables
  • Introduction to DAX: Syntax, Context, Functions
  • Role-Level Security (RLS) Implementation

Advanced Data Analysis using DAX

  • Introduction to Measures and Aggregation
  • Common DAX Functions: SUM, COUNT, AVERAGE, DISTINCT
  • Logical Functions: IF, SWITCH, AND, OR
  • Time Intelligence: YTD, MTD, SAMEPERIODLASTYEAR
  • Filter Context and Row Context
  • CALCULATE, FILTER, ALL Functions
  • Error Handling in DAX

Data Visualization and Reporting

  • Principles of Effective Data Visualization
  • Visual Types: Bar, Line, Pie, Card, Map, Matrix, Table, Gauge
  • Creating Interactive Dashboards
  • Using Bookmarks, Tooltips, and Drill-throughs
  • Slicers, Filters, Hierarchies and Tooltips
  • Custom Visuals from Marketplace
  • Design and Formatting Best Practices

Power BI Service: Sharing & Collaboration

  • Publishing Reports to Power BI Service
  • Workspaces, Apps and App Workspaces
  • Creating Dashboards from Reports
  • Data Refresh and Schedule Setup
  • Dataflows and Lineage View
  • Power BI Mobile App Overview

Excel & Power BI Integration

  • Analyzing Power BI Dataset in Excel
  • Export to Excel and CSV
  • Power Pivot and Power Query Integration
  • PivotTables from Power BI Datasets

Power BI Administration and Governance

  • Admin Roles and Power BI Tenant Settings
  • Deployment Pipelines
  • Usage Metrics and Audit Logs
  • Data Privacy Levels and Compliance
  • Sensitivity Labels and Data Classification

Capstone Project & Final Assessment

  • Business Scenario Provided: (e.g., Retail Sales Analysis or HR Attrition Dashboard)
  • Use end-to-end skills: Data prep, modeling, DAX, visuals, and deployment
  • Peer Review of Dashboards
  • Final Presentation to Stakeholders

Course Includes:

  • Price:
    ₹48,000.00 ₹51,000.00
  • Lessons:57
  • Level:Intermediate
₹48,000.00 ₹51,000.00
10ZUCU1h07wsB2i2AtWrsOOBCipoGRxlcLVnuH0OBSOebJFPcu325fCF7uAblhKs

No. 112, AKR Tech Park, B Block, 7th Mile, Hosur Road,
Bommanahalli, Bangalore – 560068, Karnataka

Company

  • Home
  • All Courses
  • Contact us
  • Other
  • Talent acquisition

Support

  • Home
  • About us
  • Contact us
  • Privacy policy
  • Terms and Conditions
  • Blog

Contacts

Call: (+91) 987-667-0964
Email: customersupport@thecertiedge.com

Icon-linkedin2 Icon-instagram X-twitter Icon-youtube
©2024-2025 Certiedge Solutions and Services. All Rights Reserved
thecertiedge.comthecertiedge.com
Hi, Welcome back!
Forgot Password?
Don't have an account?  Register Now