• What is OLTP?
  • What is Data Warehouse?
  • What is E-R MODELING?
  • What is Start Schema and snowflake schema?
  • What are dimensions and Facts?
  • What is ETL?
  • What is Architecture of DWH?
  • Introduction to Power BI Desktop
  • Different data sources (excel, csv, SQL server, SSAS, web, Azure)
  • Data types and Categories
  • Direct Query and Import and Live connection
  • Parameters in power BI
  • Calculate Column Vs Calculated Measures
  • All Transformation Options in EDIT Query Window
  • How to create Customer Function
  • How to Invoke Custom Function
  • Templates in power BI
  • Synonyms in Power BI
  • Hierarchies in Power BI
  • Import Excel workbook content
  • Modeling and Filters in Power BI
  • MERGING AND APPENDING QURIES
  • Data Modeling in Power BI
  • Cross filter direction in modeling
  • Bins and list in Grouping
  • Different Kind of Theams in Powerbi
  • How to import and use Custom visuals
  • Different kind of filters in Power BI Desktop
  • Report Level
  • Page Level
  • Visual Level
  • Drill through
  • Scatter chart by using play axis option
  • Word cloud
  • Slicer
  • ArcGIS maps enablement in power bi Desktop and service
  • Power BI publisher for Excel
  • Quick measures
  • Publish reports to Power BI Online
  • Introduction to Power BI Service
  • Different kind of licenses Free Pro and Premium
  • How to create workspace
  • How to create Dashboards
  • Delivery Methods of Dashboard
  • How to create powerBI Apps
  • What is Content Packs?
  • Data Gateways and schedule refresh
  • Row Level Security
  • Row Level Security in PowerBI Desktop
  • Row level security in Power BI Service
  • Row level security in powerBI dynamic
  • Power BI Reporting Services
  • Q&A Natural Language Processing option in PowerBI
  • Quick Insights
  • Dashboards and Pins - Real-time Usage
  • Dynamic Data Sources and Encryptions
  • Personal and Organizational Content Packs
  • Gateways, Subscriptions, Mobile Reports
  • How to Schedule Data Refresh
  • Cloud and On-Premise Data Sources
  • Relation between Dashboards to Reports
  • Relation between Datasets to Reports
  • Relation between Datasets to Dashboards
  • Page to Report - Mapping Options
  • Purpose of Data Analysis Expressions (DAX)
  • Calculated Columns and Calculated Measures with DAX
  • Scope of Usage with DAX. Usability Options
  • DAX Context: Row Context and Filter Context
  • DAX Entities: Calculated Columns and Measures
  • DAX Data Types: Numeric, Boolean, Variant, Currency
  • DAX Operators & Symbols. Usage. Operator Priority
  • Parenthesis, Comparison, Arithmetic, Text, Logic
  • DAX Functions and Types: Table Valued Functions
  • Filter, Aggregation and Time Intelligence Functions
  • Information Functions, Logical, Parent-Child Functions
  • Statistical and Text Functions. Formulas and Queries
  • Syntax Requirements with DAX. Differences with Excel
  • Naming Conventions and DAX Format Representation
  • YTD, QTD, MTD Calculations with DAX
  • DAX Calculations and Measures
  • Using TOPN, RANKX
  • Computations using STDEV & VAR
  • SAMPLE Function, COUNTALL, ISERROR
  • ISTEXT, DATEFORMAT, TIMEFORMAT
  • Time Intelligence Functions with DAX
  • Data Analysis Expressions and Functions
  • DATESYTD, DATESQTD, DATESMTD
  • ENDOFYEAR, ENDOFQUARTER, ENDOFMONTH
  • FIRSTDATE, LASTDATE, DATESBETWEEN
  • Slicing and Dicing Options with Columns, Measures
  • DAX for Query Extraction, Data Mashup Operations
  • Installation and configuration of Report Server
  • Deploy Power BI Reports into Report Server
  • Paginated Reports in Report Server
  • Report Builder in Report server
  • Mobile Reports in Report Server
  • Create KPI in Report server
  • How to schedule reports in Report Server
  • Security in Report Server
  • Duration 35 Hours
  • Students 21
  • Days 40 Days
  • Resume Preparation Yes
  • Interview Guidance Yes