Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Power BI for Beginner
2 students

Power BI for Beginner

Power BI Desktop: Report Development, Power BI Analysis, Data Visualization, Power BI Modelling
Created bySachin Agrawal
Last updated 5/2025
English
English [Auto],

What you'll learn

  • Basic Report Design: Power BI Desktop Installation,Architecture of Power BI,Data sources and Visual Types,Canvas, Visualization and fields
  • Format Button and data labels,Legend, Category and Grid,Visual Interaction, Data Points,Edit Interaction, Format Options,PBIX and PBIT File Formats
  • Spotlight and Focus Mode,Tooltip
  • Visual Sync, Grouping,Slicer Visual: Real-Time Usage,Orientation, Selection Properties,Single and Multi-Select, Ctrl Options
  • Slicer: Number, Text and Date Data,Slicer List and Slicer Drop Down,Visual sync,Disabling Slicer, Clear selection Limitation with slicers
  • Hierarchies, Filters:Creating Hierarchies in Power BI,Independent Drill-Down Options,Dependent Drill-Down Options
  • Conditional Drilldowns, Data Points,Drill Up Buttons and Operations,Expand & Show Next Level Options
  • Dynamic Data Drills Limitations,Show Data and See Records,Filters : Types and Usage in Real-time
  • Visual Filter, Page Filter, Report Filter,Basic, Advanced and TOP N Filters,Category and Summary Level Filters,Drill Thru Filters, Drill Thru Reports
  • Drill-thru Filters, Page Navigations,Bookmarks: Real-time Usage,Bookmarks for Visual Filters, Bookmarks for Page Navigation
  • Selection Pane with Bookmarks Buttons, Images with Actions Buttons, Actions and Text URLs, Bookmarks View & Selection Pane
  • Table & Column Transformations,Text & Number Transformations,Date, Time and Structured Data
  • List, Record and Table Structures, let, source, in statements M Lang,Power Query Functions, Parameters,Invoke Functions, Execution Results
  • Get Data, Table Creations and Edit,Merge and Append Transformations,Join Kinds, Advanced Editor, Apply ETL Operations with Power Query
  • Power Query Level 2,Query Duplicate, Query Reference, Group By and Advanced Options,Aggregations with Power Query
  • Transpose, Header Row Promotion ,Reverse Rows and Row Count, Data Type Changes & Detection,Replace Columns: Text, NonText
  • Replace Nulls: Fill Up, Fill Down,PIVOT, UNPIVOT Transformations,Move Column and Split Column Extract, Format and Numbers
  • Date & Time Transformations,Deriving Year, Quarter, Month, Day, Add Column : Query Expressions,Query Step Inserts and Step Edits
  • Creating Parameters in Power Query,Parameter Data Types, Default Lists,Static/Dynamic Lists For Parameters,Removing Columns and Duplicates
  • Convert Tables to List Queries,Linking Parameters to Queries,Testing Parameters and PBI Canvas,Multi-Valued Parameter Lists
  • Creating Lists in Power Query,Converting Lists to Table Data,Advanced Edits and Parameters,Data Type Conversions, Expressions
  • Columns From Examples, Indexes, Conditional Columns, Expressions

Course content

1 section • 26 lectures • 4h 3m total length

  • Power BI Installation14:15
  • Report Hands On25:18

    Load Excel data, build the data model, and craft Power BI visuals—bar and donut charts, tables, and formatted labels—within a completed report.

  • Visual Properties-Sorting,spotlight,export,focus mode3:29

    Explore how to view a Power BI visual in large format, use focus mode and spotlight, and export data or view it as a table with sorting options.

  • Filter Types 1- Visual, Page, Report, DrillThrough7:10

    Explore Power BI filter types—visual, page, and report filters—with hands-on demonstrations of applying, restricting, and navigating filters across pages to tailor data views.

  • Filter Types 2 - Basic, Advanced, TopN4:38

    Learn to use Power BI filter types—basic, advanced, and topN—to refine reports, select single values, hide options, and tailor visuals for specific regions or criteria.

  • Edit Interaction, Sync Slicer6:21

    Learn to edit interaction and sync slicer in Power BI for beginners, controlling how slicer selections affect visuals across summary and detail pages.

  • BookMark-Switch Visuals11:37

    Create and switch between multiple visuals in Power BI using bookmarks and buttons to display profit and quantity, then test and publish the report.

  • BookMark-On-Off4:59

    Build a month-by-year Power BI visualization and learn to toggle between views using bookmark-driven on/off buttons, add and align images, and refine bottom-of-visual interactions for end users.

  • Tooltip2:23

    Learn to customize tooltips in Power BI by configuring the tooltip settings, including vertical alignment, background, and transparency. Apply colors and category labels to hover interactions.

  • DrillDown7:26

    In drill down, learn to build a Power BI metrics report by adding rows, columns, and measures, exploring data from state to city levels and formatting for profit insights.

  • Conditional Formatting5:04

    Learn how to apply conditional formatting in Power BI for beginners, using background colors, font color rules, and icon sets to visualize profit margins and quantity thresholds.

  • Hierarchy2:53

    demonstrates building a hierarchy in Power BI using city and state fields, arranging columns for drill-down, and adapting drag-and-drop steps to create multi-state reports.

  • Ribbon-121:50

    Power BI for beginner teaches file management, data import, transformation, refreshing, and publishing reports using templates and source connections.

  • Ribbon-213:14

    Explore how the Power BI team option affects colors, filters, and organization-wide reports. Learn to add data, create visuals, and customize themes for effective dashboards.

  • TransformData- Home Tab12:33

    Explore the transform data window in the home tab, learning to remove columns, apply changes, manage sources, and use duplicate versus reference to protect source data.

  • TransformData- Home Tab26:49

    Explore how to transform data with the Power BI home tab, including grouping by fields, adding columns, duplicating queries, and performing unions, joins, and date handling.

  • TransformData- Home Tab9:16

    Explore transforming data in Power BI using the home tab and option management. Learn to apply filters, create new queries, and generate distinct values from a list of values.

  • TransformData-Transform Tab28:57

    Learn to use the transform tab in Power BI to clean and reshape data with fill down and up, rename, replace values, concatenate, split, and case transformations.

  • TransformData- Add Column Tab6:27

    Learn to transform data in Power BI using the add column tab, creating custom and conditional columns, applying case changes, indexing serial numbers, and duplicating columns for reporting.

  • Relationship and Connection0:49

    Learn about one-to-one, one-to-many, and many-to-many relationships in Power BI, and how to connect tables effectively for beginner analysis.

  • Relationship and Connection9:32

    Explore Power BI relationships and data modeling by mapping one-to-one, one-to-many, many-to-one, and many-to-many connections between tables, and build robust reports.

  • Relationship and Connection4:44

    Learn how to model relationships in Power BI, manage many-to-many connections, and create a new table to resolve data misalignment across tables.

  • Relationship and Connection3:39

    Create and manage relationships in Power BI data models, define table relations, and resolve multiple relationships to ensure accurate reporting.

  • Relationship and Connection4:02

    Connect Power BI to a database using Windows authentication, choose import mode, load tables, and establish relationships and connections to enable analysis.

  • Relationship and Connection1:08

    Learn how to connect to an external data site, load the data into Power BI, and analyze basic percentages and gender distribution in a population.

  • Custom Visual4:41

    Learn how to import custom visuals in Power BI, choose marketplace visuals (including Microsoft certified ones), add them to the report canvas, and analyze profitability with interactive tooltips.

Requirements

  • Laptop with good configuration, Power BI Desktop software

Description

  1. Introduction to Power BI: Students will gain a basic understanding of what Power BI is and its role in business intelligence. They will learn about the different components of Power BI, including Power BI Desktop, Power BI Service, and Power BI Mobile.

  2. Data Sources and Data Transformation: Students will learn how to connect to various data sources, such as databases, Excel files, SharePoint, and online services. They will understand how to import and transform data using Power Query Editor to clean and shape the data for analysis.

  3. Data Modeling: Students will learn about data modeling concepts in Power BI. They will understand how to create relationships between different tables, define measures and calculated columns using DAX (Data Analysis Expressions), and create hierarchies for organizing data.

  4. Data Visualization: Students will gain skills in creating visually appealing and interactive reports and dashboards in Power BI. They will learn how to use different types of visualizations (such as charts, tables, maps, and slicers) to present data effectively. They will also explore formatting options and best practices for designing engaging visualizations.

  5. Power Query: Students will learn advanced techniques in Power Query for data transformation and manipulation. They will understand how to use functions, conditional statements, and other data shaping techniques to clean and prepare data for analysis.

  6. DAX (Data Analysis Expressions): Students will gain proficiency in using DAX formulas to create calculations, measures, and calculated columns in Power BI. They will learn how to write DAX expressions for aggregating, filtering, and manipulating data to derive meaningful insights.

  7. Interactive Reports and Dashboards: Students will learn how to create interactive reports and dashboards in Power BI. They will understand how to add interactivity through slicers, filters, and drill-through actions to enable users to explore data and gain insights.

  8. Data Refresh and Sharing: Students will learn how to refresh data in Power BI and schedule automatic data refreshes. They will understand how to publish and share reports and dashboards with others, both within the organization and externally.

  9. Power BI Service: Students will gain an understanding of the Power BI Service, which is the cloud-based platform for sharing and collaborating on Power BI content. They will learn how to publish reports, create workspaces, manage access and permissions, and utilize collaboration features.

  10. Advanced Analytics and Custom Visualizations: Depending on the course, students may also learn about advanced analytics features in Power BI, such as forecasting, clustering, and sentiment analysis. They may also explore custom visualizations, where they can import and use third-party visualizations to extend the capabilities of Power BI.

By completing a Power BI course, students will develop the skills and knowledge required to analyze and visualize data effectively, create interactive reports and dashboards, and share insights with stakeholders. These skills are valuable in various roles, including data analysis, business intelligence, reporting, and decision-making.

Who this course is for:

  • Power BI Developer
  • Fresher
  • Any one who are interested to learn reporting Tool

Report abuse