Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Power BI : All In One
Rating: 5.0 out of 5(1 rating)
11 students

Power BI : All In One

Power BI : All In One
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,F
  • 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
  • Import & Direct Query with Power BI,SQL Queries and Enter Data, Data Modelling : Currency, Relations, Summary, Format, Synonyms, Web View & Mobile View
  • Power Query Level 1,Power Query M Language Purpose, Power Query Architecture and ETL, Data Types, Literals and Values, Power Query Transformation
  • Table & Column Transformations, Text & Number Transformations, Date, Time and Structured Data List, Record and Table Structures let, source, in statements M La
  • 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
  • Power BI Cloud - 1,Power BI Service Architecture, Power BI Cloud Components, Use App Workspace, Report Publish, Reports & Related Data
  • Creating New Reports in Cloud, Report Publish and Report Uploads, Dashboards Creation and Usage, Adding Tiles to Dashboards
  • Pining Visuals and Report Pages, Visual Pin Actions in Dashboards, LIVE Page Interaction in Dashboard, Dashboards Actions, Report Actions
  • Dataset Actions: Create Report, Share, Metrics and Exports, Mobile View & Dashboard Themes & A, and Pin Visuals, Export, Subscribe
  • Favourite, Insights, Embed Code, Featured Dashboards and Refresh, Gateways Configuration, PBI Service Gateway Types, Cloud Connections, Gateway
  • Data Refresh : Manual, Automatic, Power Query Expressions, Import and Upload Options in Excel, Excel Workbooks and Dashboards
  • Datasets in Excel and Dashboards, Using Excel Analyser in Power BI,Using Excel Publisher in PBI Cloud, Excel Workbooks, PINS in Power BI
  • Excel ODC Connections, Power Pivot, Row Level Security (RLS) with DAX,Need for RLS in Power BI Cloud, Data Modelling in Power BI Desktop
  • DAX Roles Creation and Testing, Adding Power BI Users to Roles, Custom Visualizations in Cloud, Create Report on PBI Services, View Usage Metrics
  • DAX Functions, Tips and Real Time Scenario

Course content

1 section • 65 lectures • 7h 11m total length

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

    Power BI all in one: learn to load data from Excel and other sources, relate city and sales tables, and create visuals with slicers, titles, and formatting.

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

    Explore Power BI visual properties by using focus mode, spotlight, export data to csv, and sorting by sales territory or profit, with table view and simple removal controls.

  • Filter Types7:10

    Explore Power BI filter types, including visual, page, and report level, plus layer and base filters, and see how slicers control data from summary to detail pages.

  • Filter Types-24:38

    Explore filter types in the Power BI filter pane, including basic filtering, single selection, search, advanced filtering, and top/bottom N filters based on value, with lock and hide options.

  • Edit Interaction, Sync Slicer6:21

    Learn how to use edit interaction to lock visuals on a slicer, control cross-page filters, and sync slicer selections between summary and detail pages.

  • BookMark-Switch Visuals11:37

    Learn to build bookmark visuals in Power BI by using buttons to switch between profit and quantity, managing bookmarks and the selection pane, and navigating to the sales report.

  • BookMark-Toggling4:59

    Explore bookmark toggling in Power BI by using on and off buttons to switch between quantity and profit visuals, and build interactive data stories with image buttons and bookmark actions.

  • Tooltip2:23

    Enable tooltip in Power BI, adjust the canvas stage, set a blue background with transparency, style the visual in white, and link a tooltip page to hover.

  • DrillDown7:26
  • Conditional Formatting5:04

    Apply conditional formatting in Power BI on a sample table. Use background color and font color rules, data bars, and icon sets to highlight profit and quantity insights.

  • Hierarchy2:53

    Learn how to create and use hierarchies in Power BI to combine multiple columns (state, city, etc.) into a single header, enabling reusable, multi-column views across pages.

  • Ribbon 121:50

    Navigate file options to create, open, save, export, and import reports, and apply templates to publish Power BI dashboards. Set up row-level security with roles and publish securely.

  • Ribbon 213:14

    Learn to apply a theme from the team gallery, customize colors and fonts, load data, and produce consistent, ready-to-deliver Power BI reports.

  • TransformData- Add Column Tab6:27

    Power BI all in one: use the add column tab to format text (caps or lowercase), apply date formats, create custom and conditional columns, and index or duplicate columns.

  • TransformData-Home Tab12:33

    Explore the transform data workflow from the home tab and apply steps like removing columns and refreshing. Note memory-based changes, sources, parameters, and mashup language ideas like splits and delimiters.

  • TransformData-Home Tab26:49

    Power BI all in one teaches how to group data with aggregates, use advanced options to multi-column group, and append or merge queries with various joins for unified reports.

  • TransformData-Home Tab9:16

    Create and manage Power BI parameters to drive city filters, transform data with a sales territory list of distinct values, and remove duplicates for dynamic analysis.

  • TransformData-Transform Tab28:57

    Experiment with power query editor to transform data by renaming, filling, unpivoting, merging columns, and shaping data types, dates, and text formats for a clean Power BI dataset.

  • PBI Services0- Email Creation3:22

    Learn how to create and verify a cloud services account, explore a free trial, and set up user profiles and domains, including otp verification and secure sign-up steps.

  • PBI Services0- Email Creation4:00

    Add users and manage licenses in Power BI services, then set up Power Cloud services and login through the main site to start the free license and observe real-time setup.

  • PBI Services1- Publish Report, Workspace, Dashboard9:26

    Learn how to publish Power BI reports, create workspaces, and build dashboards, with guidance on licenses, pro vs premium capacity, and sharing with end users.

  • PBI Services2 - Create Report,dataset,Download,Export,QR Code,Search,View10:08

    Create reports and datasets in Power BI services, then download, export, and analyze in Excel, and view results via QR code, search, and a workspace.

  • PBI Services3- Metrics,Quick Insight,Subscription,Sharing,RLS15:07

    Explore Power BI services features including metrics and quick insights, set up subscriptions and sharing, and implement row-level security (RLS) with workspace access and export options.

  • PBI Services3- Metrics,Quick Insight,Subscription,Sharing,RLS3:35

    Explore Power BI service quick insights to automatically create visuals from your data, manage row-level security in desktop before publishing to a workspace, and leverage insights for detailed analytics.

  • PBI Services4 - Delete,Uses of Shared with me, AppCreation8:10

    Explore delete options for reports, datasets, and workspaces; use shared with me to access reports; then create and publish apps from a workspace to share reports with end users.

  • PBI Services5-ScheduleRefresh,Gateway Installation15:28

    Learn to install and configure the on-premises data gateway for Power BI, connect data sources at the organizational level with standard/enterprise gateway, and automate scheduled refresh.

  • 1.DAX-Date and Time Functions11:33

    Discover DAX date and time functions in Power BI, creating calculated columns and measures, calculating date differences with today and now, and formatting dates with the format function.

  • 2.DAX-Text Functions4:44

    Explore DAX text functions in Power BI, including upper, lower, left, right, mid, and concatenate, with practical examples of formatting names and employee IDs.

  • 3.DAX-Logical Functions9:53

    Explore DAX logical functions in Power BI, including IF, AND, OR, SWITCH, and IN; learn to create a new column like salary status and use conditions for reporting.

  • 4.DAX-Information Functions1:38

    Learn how to use DAX information functions to test data types by creating a calculated column that checks if a value is text or number, returning true or false.

  • 5.DAX-Math _ Statistical Functions3:11

    Learn to use DAX math and statistical functions in Power BI by creating measures for sum, count, mean, min, and max on the salary column.

  • 6.DAX-Time Intelligence Functions10:04

    Explore time intelligence functions in Power BI using calculate and date add to derive previous year, month, and quarter data, and build running totals and YTD, QTD, and MTD.

  • 7.DAX-Table Functions12:46

    Explore DAX table functions union, intersect, and except to merge tables in Power BI, then learn summarize and all except for grouping data and pruning columns.

  • 0-Relationship Overview0:49

    Explore one-to-one, one-to-many, many-to-one, and many-to-many relationships in Power BI, learn how to manage relationships, and apply the most recommended patterns for accurate data modeling.

  • 1-Relationship Explanation,1 to 1,1 to M9:32

    Explore one-to-many, many-to-one, many-to-many, and one-to-one relationships in Power BI, and learn how to model tables such as student and course to ensure correct data relationships.

  • 2-M to M4:44

    Learn to manage many to many relationships in Power BI, identify cross-table issues on the modeling tab, and implement a bridge table to fix data accuracy.

  • 3-M to M 23:39

    In this lecture, learn how to manage many-to-many relationships in Power BI by creating a distinct product name table, setting active relationships, and using modeling to resolve data inconsistencies.

  • SQL Connection4:02

    Connect to SQL Server in Power BI, choose direct query or import, load data with Windows authentication, and build charts: stack volume and donut pie with filters for Oscar-winning movies.

  • Web Connection1:08

    Connect Power BI to web data by using get data, selecting web, and entering the website URL to load live demographic data such as male and female counts.

  • Visual Align1:07

    Select all visuals, open the format options, and use align to set top or left alignment, then distribute horizontally for a neat, organized report.

  • Custom Visual4:41

    Learn to add and configure custom visuals in Power BI, including licensing and importing visuals, then place them on the report canvas and use measures like profit.

  • Smart Narrative1:05

    Learn how the smart narrative feature in Power BI automatically generates text from visual data, providing written insights without manual drafting, accessible from the visualization or insert tab.

  • Sorting1:19

    Learn to sort a Power BI table by adding a field, using the three-dot menu, and choosing ascending or descending order, including sorting by other fields.

  • Page Navigation0:57

    Learn to create page navigation in Power BI via the insert tab and button options, selecting stage names to link to pages and jump to a chosen page.

  • Easy Page Movement0:49

    Move a page, such as page 16, to the first position by selecting the page and pressing the move button, and repeat for multiple pages as needed in Power BI.

  • Move to next visual by TAB0:31

    Learn to move to the next visual in Power BI using the TAB keyboard shortcut, enabling quick navigation between visuals.

  • Move Objects0:54

    Learn to move objects by adjusting offsets in Power BI using the up and down arrow buttons and shift plus arrow shortcuts to increase motion.

  • Lock Objects0:46

    Learn to lock visuals after completing a report and publishing, preventing later relocation, and use the local option available in the U.S.

  • Hide and View,Expand and Collapse2:14

    expand and collapse the table, view and hide columns using the three-dots menu, and use the hide all or describe condition options to manage table visibility in Power BI.

  • Q & A1:46

    Discover the Power BI Q&A feature, a natural language query tool in the visualization section that generates visuals automatically by simply typing questions about your data.

  • Decomposition Tree1:52

    Explore the new visual decomposition tree in Power BI, resize the chart, drag columns, and use the plus icon to expand and drill down by high or low values.

  • Dollar sign,Percentage2:49

    Learn to add currency symbols and percentages in Power BI by using the column tool to apply dollar (English United States) format and convert profit values to percent.

  • Stepped Layout1:49

    Convert data to a step layout in Power BI by using a matrix, adjusting font size with a global property, and exploring front versus below step layout options.

  • Sequence Changes0:50

    Learn to change the sequence of columns in Power BI by clicking a column to place it in the first position, with a simple demonstration of reordering on the table.

  • Gradient Colour on Visual1:40

    Apply gradient color to Power BI visuals by editing a column chart, enabling data levels, and using the gradient option in the format settings via the effects to visualize territory.

  • 1. Blank to Zero4:24

    Convert blank values to zero in power bi by creating a calculated column with a conditional formula, then apply it alongside a slicer.

  • 2. Conditional Formatting with Images4:09

    Apply conditional formatting with images in Power BI by using salary thresholds, background color rules, and a DAX image formula that swaps visuals based on value.

  • 3. Default State -Drill Through4:06

    Create a default state bookmark to preserve all data across drill-through pages, reset filters, and view complete data with a single action.

  • 4. Dynamic Column Selection5:16

    Learn dynamic column selection in Power BI by duplicating columns, building relationships, and configuring cross-filter interactions with a slicer to view data by product name or salesperson.

  • 5. Dynamic Text Changes2:20

    learn to implement dynamic text changes in Power BI by using a textbox title with a conditional formula that shows a value when selected and a default message when empty.

  • 6. Dynamic Title Changes3:10

    Enable dynamic title changes in Power BI by binding the chart title to slice selections and displaying salary by date. Create a new column to support this dynamic title behavior.

  • 7. Month Sequence5:15

    In this lecture, arrange monthly data in Power BI by adding a month number in Edit Query and sorting by it to display January, February, March.

  • 8. Dynamic RLS - Userprincipalname()5:57

    Demonstrates dynamic role level security in Power BI by linking contributors, countries, and sales data, applying userprincipalname to filter each user’s France or Germany data.

  • 9. CY Vs PY, Running Total10:04

    Master time intelligence in Power BI by computing running totals and year-to-date measures using date add, and comparing previous year, quarter, or month.

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.

    Power BI Service Overview: Students will gain an understanding of Power BI Service, which is the cloud-based platform for sharing, collaborating, and publishing Power BI reports and dashboards. They will learn how to navigate the Power BI Service interface, manage workpaces, and utilize collaboration features.


  11. Sharing and Collaboration: Students will learn how to share Power BI reports and dashboards with colleagues, teams, and stakeholders. They will understand different sharing options, set access permissions, and manage content collaboration within Power BI Service.

  12. Data Refresh and Scheduling: Students will learn how to schedule and manage data refresh in Power BI Service. They will understand how to configure automatic data refresh for reports and datasets, ensuring that the data is up to date and accurate.

  13. Power BI Mobile: Students will explore Power BI Mobile, the mobile app for accessing and interacting with Power BI reports and dashboards on smartphones and tablets. They will learn how to navigate the app, view reports offline, and utilize mobile-specific features for enhanced user experience.

  14. DAX Formulas and Functions: Students will dive deeper into DAX formulas, which are used for calculations and data modeling in Power BI. They will learn advanced DAX functions and techniques for creating complex calculations, time intelligence, filtering, and conditional logic.

  15. Calculated Columns and Measures: Students will understand the difference between calculated columns and measures in Power BI and when to use each. They will learn how to create and use calculated columns and measures effectively for data analysis and visualization.

  16. Advanced Data Modeling: Students will learn advanced data modeling techniques using DAX in Power BI. They will explore concepts such as hierarchies, calculated tables, and many-to-many relationships. They will understand how to optimize data models for performance and efficiency.

  17. Advanced Visualization Techniques: Students will gain skills in creating advanced visualizations using DAX expressions. They will learn how to use DAX to customize and enhance visualizations, create dynamic visuals, and implement advanced charting techniques.

  18. Advanced Analytics with DAX: Students will explore advanced analytics capabilities in Power BI using DAX. They will learn how to perform statistical analysis, implement advanced calculations, and create complex data models to support advanced analytics scenarios.

  19. Performance Optimization: Students will understand techniques for optimizing the performance of Power BI reports and dashboards. They will learn how to improve query performance, optimize data models, and manage large datasets efficiently.

Who this course is for:

  • This course will cover all aspects which developer need in organization to develop nice report and also take care of data by using Admin part. Also, you will get good exposure on Dax function and Data Model too. Also, I had attached one power BI Report where you can take your reporting skill to the next level. We are also using different types of connectivity in this module like SQL, Web, Excel, etc.. • Export , show as table, Remove, spotlight, Sorting,• Hide and show column and table.• Filter Types (Visual, Page, Report)• Drill Through• Basic Filters• Advanced Filter• TOP N• Sync Slicer ,Edit Interaction, Book Mark Pane ,Page Navigation, Selection Pane,Tooltip ,Drill Down, Hierarchy, Conditional Formatting(Bar, Background, Text, icons, Web URL) , Home Ribbon, Transform Ribbon, Add Column Ribbon Publishing Report on PBI Services• Creating Workspace• Create Dashboard/Pin to live page/Pinning• Create Report on PBI Services• Create Datasets • Download and Print the Report• Analyze in Excel• Export report in various format• QR Code>> Microsoft power bi• Search Option • View Related •View Usage Metrics Get Quick Insight •Subscription •Sharing Report • Row Level Security -Applied on PBI Desktop • Security at Dataset Level/Assigning Role •Uses of Shared with me •Delete•App creation•Download Data Gateway•Schedule Refresh . DAX Functions, Tips, Real Time Scenario.

Report abuse