3 Ways to use Power BI (PBI Desktop, PIB Service, PBI
Mobile pp)

Roles in Data (Business Analyst, Data Analyst, Data
Engineer, Data Scientist, Data Admin)

Role of Data Analyst

• • Introduction & importance of Business Intelligence
  • Tools & Technologies in Business Intelligence area
  • Power BI vs Tableau

• • Power BI Architecture
  • Power BI introduction and its components
  • Power BI over Excel

• • Power BI Flow – Most Important
  • Download PBI Desktop & Interface tour
  • Understanding Key backstage options (file Tab)
  • Understanding Case Study 1 and Role Play
  • Power BI Practice Files

• Get Data from Flat Files (CSV, Text & Excel files)
• Get Data from Odata Feed
• Connect to Local folder

• Power Query & Power Query Editor Introduction
• Difference Between Transform and load
• Merge, Add & remove columns
• Sorting in Power Query
• Merge & Append Queries
• Transform table tools: grouping, transpose, reverse rows,
count rows, use as header
• Transform column tools Splitting, replace values,
extracting, merging, formatting and parsing columns
• Number column tools: Statistical, standard, rounding and
information
• Building a complete Calendar Table
• Conditional, Custom, Invoke Custom, Index & Duplicate
Column
• Flash fill in Power Query (Columns from example)
• Understanding different view options
• Connect to multiple files in a folder
• Is Power Query smart enough?

• • How to build relationship and relationship cardinality
  • Understanding filter flow & Cross Filter direction
  • Building entire Model
  • Snowflake & Star Schema
  • Add related Tables

• • Difference between calculated columns and measures

• Understanding DAX & its Types
  • Difference between calculated columns and measures

• • Logical DAX
  • Another example of conditional column
  • Understanding SWITCH function
  • Understanding Year & Today function
  • Playing with Text functions (Left & Search)

• • Bringing Data from any Related table using Related
  function
  • Opposite of related function – RELATABLE FUNCTION

• Filter & Row Context – A must watch for any Power BI user

• Understanding Measures Practically
• Creating Measures Table
• Counting Values using count function

• • Condition Based Calculation – Calculate Function
  • Building Calculated Table using Filter
  • Understanding Variable with Calculate Filter & Same
  period Last Year Function

• • Iterator Function
  • Iterator Function -MAXX

• Crossfilter (Activate filter direction virtually)
• Ignoring filter context by using all Function
• Nesting of Filter and Calculate Function

• Month, QTR, YEAR to Date calculation
• Previous Day, Month, QTR, Year Calculation
• Periodic Calculation

• Understanding Report view and creating a new report
• Page display settings in a Power BI Report
• Setting color theme aligned to project/company color
theme & Theme Gallery

• Adding non visualization project
• Inserting Basic Charts and understanding format tab
• Creating comparison visuals (Doughnut chart)
• Creating Bar Charts for top 5 customers
• Plotting Values on a Map Visual
• Understanding Matrix visual along with Conditional
Formatting
• Comparing Actual VS Target using Gauge chart
• Using Slicers and understanding its impact on the report

• Showing monthly trend with line chart
• Setting up forecasted revenue in line chart
• Presenting data in area chart with Awesome tooltip
feature
• Building amazing KPI’s
• Drillthrough Report Page
• Custom visual (third party visual)
• Story telling through Bookmarks
• Ask questions from PBI and get visuals (NLQ)
• Sync Slicer
• Key Influencer P1
• Key Influencer P2
• Decomposition Tree
• Function based visual titles

• What if Parameter
• Setting RLS (Row Level Security)
• Tooltip Page
• Different types of filters in report view
• Change how visuals interact in a report

• Publish the report to Power BI Sevice

• Understanding Power BI Service
• Creating New PBI Service Account
• PBI Interface tour

• Understanding various option in Report interface
• 3 ways of creating a Dashboard
• Understanding various options in Dashboard interface

• Understanding Gateways & its types
• Enabling Scheduled refresh through Personal gateway
• Incremental Refresh (Theory & Practical)

• Assigning user roles and giving permissions
• Sharing through publishing apps
• Implementing RLS

• Real Time data streaming connection
• Real Time data download

• Start Page
• Show ME
• Connecting Excel Files
• Connecting Text Files
• Connecting to Microsoft SQL Server
• Connecting to Microsoft Analysis Services
• Creating & Removing Hierarchies
• Bins
• Joining Tables
• Data Blending

• Parameters
• Grouping Examples
• Edit Groups
• Set
• Combined Sets
• Creating a first report
• Data Labels
• Create folders
• Sorting data
• Add totals, sub total and gran totals to report

• Area Chart
• Bar Chart
• Box Plot
• Bubble Chart
• Bump Chart
• Bullet chart
• Circle views
• Dual Combination Chart
• Dual Lines chart
• Funnel Chart
• Traditional Funnel Charts
• Gannt charts
• Groupped Bar or Side by sude Bars chart
• Heatmap
• Highlight Table
• Histogram
• Cumulative Histogram
• Line chart
• Lollipop Chart
• Pareto Chart
• Pie chart
• Scatter Plot
• Stacked Bar Chart
• Text Label
• Tree Map
• Word cloud
• Waterfall chart
• Geographic map
• Filled map
• Crosstab
• Combines axis
• Motion chart
• Reference lines

• Convert to custom SQL

• Dual Axis Reports
• Blended Axis
• Individual Axis
• Add reference lines
• Reference bands
• Reference distributions
• Basic maps
• Symbol map
• Use google maps
• Mapbox maps as background map
• WMS server maps as background map

• Calculated Fields
• Basic Approach to calculate rank
• Advanced approach to calculate rank
• Calculating running total
• Filter’s introduction
• Quick filters
• Filters on dimensions
• Conditional filters
• Top & bottom filters
• Filters on measures
• Context Filters
• Slicing filters
• Data source filters
• Extract filters

• Create a Dashboard
• Format Dashboard layout
• Create a device Preview of a dashboard
• Dashboard Objects
• Create a story

• Physical architecture overview
• User access
• Component functions & processes
• Tableau Server on-premises
• Tableau reader
• Tableau online v tableau server

• Tableau server user interface
• Users
• Site roles
• Groups
• Schedules
• Tasks
• Tableau Server menu
• Content display options