Power BI for Beginner

Power BI Desktop: Report Development, Power BI Analysis, Data Visualization, Power BI Modelling

(0 ratings)

1 student

Created by Sachin Agrawal

Last updated 4/2022

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

Requirements

Laptop with good configuration, Power BI Desktop software

Description

From this course you can create professional reports for your client also you will get good exposure on each property which we are going to take in this session:

• 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,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,Tool tips,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,, 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.

Will connect to different types of data sources and then transform it in a data model.

Who this course is for:

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

Sachin Agrawal

Technical Lead-Business Intelligence

4.4 Instructor Rating
5 Reviews
16 Students
6 Courses

I am a Microsoft Certified Power BI, SQL, MSBI freelance Trainer with International training exposure. I had Provided 10+ corporate level training. Also I have trained 2000+ participants till 2022. Training provided to all age groups (22 to 60+ Yrs.).Having good exposure into BI Tools like SQL, SSIS, SSRS, SSAS, Power BI.

I had received 98% positive feedback on my practical training.

I have total 15 Years of experience in IT industry.