Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Power BI Desktop: Report Development
Rating: 5.0 out of 5(3 ratings)
11 students

Power BI Desktop: Report Development

Master Power BI Desktop,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,Tooltips
  • 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
  • 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 • 28 lectures • 4h 10m total length

  • 1-Power BI Installation14:15
  • 2-Report Hands On25:18

    Learn to build a Power BI desktop report by loading data from an Excel workbook, modeling two tables with city relationships, and creating formatted visuals with slicers.

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

    Explore visual properties in Power BI desktop, including focus mode to enlarge a visual, export data, show as table, and spotlight to highlight a visual, with sorting options.

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

    Explore how Power BI filters work across visuals, pages, and reports, and practice applying visual filters, page filters, report filters, and drillthrough to control data visibility.

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

    Master how to use filter types in Power BI Desktop, including basic filtering, advanced filtering, and TopN, to refine data by region, dates, or other fields.

  • Edit Interaction, Sync Slicer6:21

    Explore how to edit interactions and sync slicers in Power BI Desktop, and learn to apply slicer settings across pages for a consistent report.

  • 1-BookMark-Switch Visuals11:37

    Learn to create and use bookmarks in Power BI Desktop to switch between visuals with buttons, configure bookmark actions, and navigate between reports for interactive storytelling.

  • 2-BookMark-ClearFilter2:42

    Explore how to use bookmarks to clear filters and reset selections in Power BI reports, name bookmarks, and adjust color and size of visuals for consistent reporting.

  • 3-BookMark-ON_OFF_Button3:57

    Demonstrate creating on/off button controls and bookmark interactions, manage image visibility, and explore how real-time data can be displayed in a Power BI report.

  • 4-BookMark-Slicer Panel5:19

    Discover how to use the bookmark and slicer panel in power bi desktop to manage visuals, columns, and image selections for ship-related data, including toggling visibility and grouping items.

  • 7-Tooltip2:23

    Explore configuring tooltips in Power BI Desktop by adjusting information options, vertical alignment, background transparency, and color, then preview how tooltips display when you hover over report visuals.

  • 8-DrillDown7:26

    Learn to build a drill-down Power BI Desktop report by configuring rows, columns, and measures such as quantity and profit, and view data from state to city.

  • 9-Conditional Formatting, Hierarchy5:04

    Learn to apply conditional formatting in Power BI Desktop, using background colors, font color rules, and icons to highlight profit margins based on quantity and percentage ranges.

  • 9-Conditional Formatting, Hierarchy2:53

    Explore managing hierarchy and columns in Power BI Desktop to organize data across multiple pages, control column order, and refine report navigation.

  • 10-Ribbon21:50

    Explore the Power BI desktop 10-ribbon, including creating, opening, saving, importing data, and publishing reports. Learn to refresh and transform data and manage data sources with new features.

  • 10-Ribbon13:14

    Learn to use the teams option, apply organizational settings, and customize Power BI reports with data, colors, and visuals. Apply filters, bookmarks, and performance analyses to create interactive reports.

  • TransformData- Home Tab12:33

    Explore the transform data workflow in the Power BI Desktop home tab, including applying changes, removing columns, and managing data sources with sort, split, and search options.

  • TransformData-Home Tab26:49

    Explore transforming data in Power BI Desktop using the home tab, including grouping by fields, adding columns, duplicating queries, replacing values, and combining queries with append and merge.

  • TransformData-Home Tab9:16

    Explore how to create and manage parameters in Power BI Desktop's transform data home tab, define value lists, set defaults, apply filters, and remove duplicates for dynamic reports.

  • TransformData-Transform Tab28:57

    Explore Power BI Desktop's transform tab to cleanse and reshape data: convert formats, fill missing values, rename columns, and create new columns with lowercase, uppercase, and concatenation techniques.

  • TransformData- Add Column Tab6:27

    Explore adding and transforming columns in Power BI Desktop's transform data add column tab, using custom and conditional columns, filtering data, indexing serial numbers, and basic calculations.

  • Relationship and Connection0:49

    Explore one-to-one and one-to-many table relationships in Power BI Desktop, and see how connections between tables drive report development. Apply these concepts to the album scenario and table connections.

  • Relationship and Connection9:32

    Explore one-to-one, one-to-many, and many-to-many relationships in Power BI Desktop, modeling tables like students and courses to build accurate reports.

  • Relationship and Connection4:44

    Explore how to build and manage relationships in Power BI Desktop for report development, including data modeling, connecting product names and dates with budget data, and handling many-to-many scenarios.

  • Relationship and Connection3:39

    Develop effective relationships in Power BI Desktop by understanding one-to-many relationships, modeling adjustments, and aligning date and product name fields with budget data for accurate reporting.

  • Relationship and Connection4:02

    Connect to data sources in Power BI Desktop, import data with import mode, and define relationships and connections across extensive databases to build health facilities and travel spending reports.

  • Relationship and Connection1:08

    Learn to establish relationships by importing data from OpenSecrets.org, selecting fields, and comparing percentages of male and female control to build a simple Power BI report.

  • Custom Visual4:41

    Discover how to add and configure a custom visual in Power BI Desktop, import visuals available for use, and place them on the report canvas to explore profit and efficiencies.

Requirements

  • Laptop with good configuration, Power BI Desktop software, Internet

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