1 POWER BI DESKTOP
Introduction to Power BI Desktop
ü Installing Power BI desktop
ü Import data from different sources
ü Creating Reports and Dashboards
ü Adding Charts and Visualizations
Creating reports
§ Adding pages
§ Renaming pages
§ Moving pages
§ Delete pages
ü Importing excel and power view items
Discovering and loading data with Power BI
Desktop
ü Data sources
§ File sources
§ Databases
§ SQL Server and other sources
ü Loading data
§ Web pages
§ CSV files
§ XML files
§ Excel
ü Relational databases
§ Loading related tables
§ Database options
Transforming datasets
ü Power BI desktop queries
§ Editing data after data load
§ Transforming data
ü Query editor and ribbons
ü Dataset shaping
ü Filtering data
Data cleansing
ü Changing data type
ü Replacing values
ü Transforming column contents
ü Grouping records
ü Pivot
ü Un pivot
ü Extending data
§ Duplicating columns
§ Splitting columns
§ Merging columns
§ Custom columns
§ Merging data
ü Appending data
§ Adding contents of one query to another
§ Pivoting and un pivoting tables
§ Transposing rows and columns
ü Managing queries
§ Grouping queries
§ Duplicating queries
Creating a data model
ü Data modeling in Power BI desktop environment
ü Data modeling ribbon
ü Manipulating tables and columns
ü Sorting data
ü Designing a data model
§ Creating relationships
§ Creating relationships manually/automatically
§ Deleting relationships
Text based visualizations
ü Switching to report view
Creating and modifications Charts in Power BI
Desktop
ü Column charts
ü Line charts
ü Pie charts
ü Donut charts
ü Funnel charts
ü Water fall charts
Other types of visuals
ü Maps
ü Filled maps
ü Tree maps
ü Gauges
ü Matrix table
Market place & From file visualizations
Advanced analytics visualizations
ü Bullet chart
ü Histogram
ü Time series decomposition
ü KPI Column
ü Box and whisker chart
ü Vitara charts – Micro chart
ü Ultimate variance
ü Narratives for power bi
ü Data insights
ü Dot plot
ü Editors picks visualizations
Info graphic designer
ü Drill down donut chart
ü Synoptic panel
ü Narratives for power bi
Filters visualizations
ü Table sorter
ü Attribute slicer
ü Text filter
ü Chiclet slicer
ü Zoom charts network chart
ü Smart filter
ü Time brush
ü Image timeline
ü Filter by list
ü Play axis
ü Acterys matrix light
ü Enlighten world flags
ü Enlighten slicer
ü Hierarchy slicer
Gauges visualizations
ü Dial gauge
ü Cylindrical gauge
ü Linear gauge
ü Tachometer
ü Tachometer
ü Circular gauge
Info graphics visualizations
ü Scatter chart
ü Enlighten data story
ü SW Org chart
ü Free ultimate decomposition tree
ü As T Accounts
ü As Timeline
ü KPI Chart
ü Bubble chart
ü Scroller
Kpis visualizations
ü PBI CV
ü Power KPI
ü Power KPI Matrix EB
ü Table heat map
ü Rotating tile
ü Data bar KPI
ü KPI Column
ü KPI Grid
ü KPI Ticker
ü Card with states
ü Advanced card
ü Bullet chart
ü KPI chart
ü KPI Indicator
Maps visualizations
ü Flow map
ü China heat map
ü Scatter map
ü Color map
ü Globe map
ü Icon map
Power bi certified visualizations
ü Bowtie chart
ü Pulse chart
ü Mekko chart
ü Tornado
ü Radar chart
ü Sankey
ü Ultimate waterfall
ü Word cloud
ü Brick chart
ü Grid by
ü Dot plot
ü Rotating chart
ü KPI Tickter
ü Cylindrical
ü Line dot chart
ü Funnel with source
ü Force-Directed graph
ü Chord
ü Sun burst
Time visualizations
ü Time line
ü Sparkline
ü Drilldown column chart for time based data
ü Gantt chart
ü Stream graph
ü Count down
ü Gantt
ü BCI Calendar
ü As Time line
ü Candlestick
ü Impact bubble chart
ü Custom calendar
Filtering data
ü Visual level filters
ü Page level filters
ü Drill through filters
ü Report level filters
Using slicers
ü Slicers
ü Sync slicer
ü Edit interactions
ü Selection pane
Enhancing dashboards
ü Text boxes
ü Modifying Page background
ü Images
ü Adding shapes
ü Organizing visuals on the page
ü Exporting data from a visualization
ü Creating Bins
ü Field formatting
ü Conditional formatting
ü Tool tips
ü Import custom visuals from market place
Row level security (RLS)
ü Creating Manage roles and View as roles
ü Static Row level security
ü Dynamic Row level security
ü Column level security
ü Page level security
ü Report level security
Creating reports and check data
ü Parameter report
ü Hierarchy report
ü Drill down report
ü Drill through report
ü See record
ü See data
Data analysis expressions (DAX)
ü New columns
ü New measures
ü New quick measures
2 POWER BI SERVICE/WEB/ONLINE/CLOUD
ü Get data
ü Import data to dataset
ü Upload data to workbook
ü Get app for developing reports and dashboards
ü My Workspace
ü APPs Workspace
ü Datasets
ü Reports
ü Dashboards
ü Workbook
ü Q&A
ü Insights
ü Pin Dashboards
ü Dashboards theme
ü Dashboards settings
ü Export to excel
ü Row level security
ü Embed codes
ü Alerts
ü Notifications
ü Subscriptions
ü Create reports
ü Add title and image
ü High contrast colors
ü Generate QR Code
ü Share
ü Favorites
ü Export to PPT
ü Analyze in excel
ü View related
ü Manage permissions
3 Power BI Mobile
ü View Apps & Notifications
ü View Share & Favorites
ü Scan QR Codes
4 Power BI Admin
ü Admin portal
ü Usage metrics
ü Users
ü Audit logs
ü Tenant settings
ü Capacity setting
ü Embedded code
ü Organization visuals
ü Data flow settings
ü Workspace
ü Custom branding
ü Protection metrics
ü Featured content
5 Power BI Gateways
6 Power bi report builder
7 Power bi report server
8 Power apps
9 Power automate
10 Power virtual agent
11 Power BI Embedded
12 Power Rest API
