Power BI Detail Syllabus

    SQL :
  • Installation of Microsoft SQL server
    • Basic command
    • Select
    • Insert
    • Update
    • Create
    • Alter
    • Delete
    • Drop
    • Truncate
    • Rename
    • Merge
    • Commit
    • Rollback
    • Constraints
    • Not Null
    • Default
    • Unique
    • Check
    • Primary key
    • Foreign Key
  • Operators-All
    • Clause
    • Where clause with AND and OR operator
    • Where clause with IN and Not IN operator
    • Where clause with Like operator
    • Where clause with Between operator
    • Having Clause
  • Distinct Operator
  • Order by Function-ASC/DESC
    • Aggregate Function
    • AVG
    • SUM
    • MAX
    • MIN
    • COUNT
  • Wildcards
  • Joins
    • Inner join
    • Left outer join
    • Right outer join
    • Full outer join
  • Union/Union All
    Power BI:
  • Power BI Desktop Installation
    • Power BI Architecture
    • Power BI Desktop Overview & Example
    • Visualization and its properties
    • Table
    • Slicer
    • Stacked Bar Chart
    • Stacked Column Chart
    • Clustered Bar Chart
    • Clustered Column Chart
    • 100% Stacked Bar Chart
    • 100% Stacked Column Chart
    • Line Chart
    • Scatter Chart
    • Pie Chart
    • Donut Chart
    • TreeMap
    • Map
    • Filled Map
    • Funnel
  • Export , show as table, Remove, spotlight, Sorting Filter Types (Visual, Page, Report)
  • Drill Through Basic Filters Advanced Filter TOP N
  • Conditional Formatting(Bar, Background, Text, icons, Web URL) Manage Relationship
  • Publishing Report on Cloud Creating Workspace
  • Create Dashboard/Pin to live page/Pinning Create Report on PBI Services
  • Create Dataset
  • Copy report from one workspace to other
  • Report
    • Sharing Report
    • Row Level Security -Applied on PBI Desktop
    • Security at Dataset Level/Assigning Role
    • Export report in various format
    • Uses of Shared with me
    • View Related
    • View Usage Metrics
    • Delete
    • Add Tile
    • Schedule Refresh
Call to Enroll