• 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

• 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

• Power BI Mobile
  • View reports & Dashboards
  • View Apps & Notifications
  • View Share & Favorites
  • Scan QR Codes
• 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
• Power BI Gateways
• Power bi report builder
• Power bi report server
• Power apps
• Power automate
• Power virtual agent
• Power BI Embedded
• Power Rest API