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
Requirements
Laptop with good configuration, Power BI Desktop software
Description
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.
Overview
Section 1: Introduction
Lecture 1 Power BI Installation
Lecture 2 Power BI Installation-2
Lecture 3 Report Hands On
Lecture 4 Visual Properties-Sorting,spotlight,export,focus mode
Lecture 5 Filter Types
Lecture 6 Filter Types-2
Lecture 7 Edit Interaction, Sync Slicer
Lecture 8 BookMark-Switch Visuals
Lecture 9 BookMark-Toggling
Lecture 10 Tooltip
Lecture 11 DrillDown
Lecture 12 Conditional Formatting
Lecture 13 Hierarchy
Lecture 14 Ribbon 1
Lecture 15 Ribbon 2
Lecture 16 TransformData- Add Column Tab
Lecture 17 TransformData-Home Tab
Lecture 18 TransformData-Home Tab
Lecture 19 TransformData-Home Tab
Lecture 20 TransformData-Transform Tab
Lecture 21 PBI Services0- Email Creation
Lecture 22 PBI Services0- Email Creation
Lecture 23 PBI Services1- Publish Report, Workspace, Dashboard
Lecture 24 PBI Services2 - Create Report,dataset,Download,Export,QR Code,Search,View
Lecture 25 PBI Services3- Metrics,Quick Insight,Subscription,Sharing,RLS
Lecture 26 PBI Services3- Metrics,Quick Insight,Subscription,Sharing,RLS
Lecture 27 PBI Services4 - Delete,Uses of Shared with me, AppCreation
Lecture 28 PBI Services5-ScheduleRefresh,Gateway Installation
Lecture 29 1.DAX-Date and Time Functions
Lecture 30 2.DAX-Text Functions
Lecture 31 3.DAX-Logical Functions
Lecture 32 4.DAX-Information Functions
Lecture 33 5.DAX-Math _ Statistical Functions
Lecture 34 6.DAX-Time Intelligence Functions
Lecture 35 7.DAX-Table Functions
Lecture 36 0-Relationship Overview
Lecture 37 1-Relationship Explanation,1 to 1,1 to M
Lecture 38 2-M to M
Lecture 39 3-M to M 2
Lecture 40 SQL Connection
Lecture 41 Web Connection
Lecture 42 Visual Align
Lecture 43 Custom Visual
Lecture 44 Smart Narrative
Lecture 45 Sorting
Lecture 46 Page Navigation
Lecture 47 Easy Page Movement
Lecture 48 Move to next visual by TAB
Lecture 49 Move Objects
Lecture 50 Lock Objects
Lecture 51 Hide and View,Expand and Collapse
Lecture 52 Q & A
Lecture 53 Decomposition Tree
Lecture 54 Dollar sign,Percentage
Lecture 55 Stepped Layout
Lecture 56 Sequence Changes
Lecture 57 Gradient Colour on Visual
Lecture 58 1. Blank to Zero
Lecture 59 2. Conditional Formatting with Images
Lecture 60 3. Default State -Drill Through
Lecture 61 4. Dynamic Column Selection
Lecture 62 5. Dynamic Text Changes
Lecture 63 6. Dynamic Title Changes
Lecture 64 7. Month Sequence
Lecture 65 8. Dynamic RLS - Userprincipalname()
Lecture 66 9. CY Vs PY, Running Total
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.

Homepage

https://www.udemy.com/course/power-bi-all-in-one/