Best Microsoft Power BI Training
-
Home
- Best Microsoft Power BI Training
- 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
