Acquire In-Demand Skills with PowerBI & Oracle Training

• 3 Ways to use Power BI (PBI Desktop, PBI Service, PBI Mobile app)
• 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

• 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 Service

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

• Understanding various options 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

Accordion Content (not detailed)

• 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 side 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 vs Tableau server

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