| What is bi-directional cross filtering. |
| What is Power BI? |
| What is Power BI Desktop |
| What is Power Pivot? |
| What is Power Query? |
| What is self-service BI, anyway? |
| What is DAX? |
| What are Filters in Power BI? |
| What is Manual filters |
| What is Auto filters |
| What is Include/Exclude filters |
| What is Drill-down filters |
| What is Cross Drill filters |
| What is Drillthrough filters |
| What is URL filters? |
| What is Pass-Through filters |
| What are Custom Visuals in Power BI? |
| What is GetData in Power BI? |
| What are some differences in data modeling between Power BI Desktop and Power Pivot for Excel? |
| What is SQL Server Import |
| What is Direct Query |
| What is Live Connection |
| What are the various types of refresh options provided in Power BI? |
| What is Package refresh |
| What is Model or data refresh |
| What is Tile refresh |
| What is Visual container refresh |
| What is a dashboard in Power BI? |
| What is the CALCULATE function in DAX? |
| What is Azure SQL Database |
| What is Azure Blob Storage |
| What is row-level security? |
| What are the different views available in Power BI Desktop? |
| What is Report View |
| What is Data View |
| What is Model View |
| What are the various versions of Power BI? |
| What is Power BI Desktop |
| What is Power BI service |
| What is Visualizations |
| What is Datasets |
| What is Reports |
| What is Dashboards |
| What is Tiles |
| What are the critical components of the Power BI toolkit? |
| What is Power Query |
| What is Power Pivot |
| What is Power View |
| What is Power Map |
| What is Power Q&A |
| What do you mean by the content pack? |
| What are some familiar sources for data in the Get Data menu in Power BI? |
| What is What are the categories of data types? |
| What do you mean by grouping? |
| What is query folding in Power BI? |
| What is "M language." |
| What are the major differences between visual-level, page-level, and report-level filters in Power BI? |
| What information is needed to create a map in Power Map? |
| What is OLP Engine |
| What is Data Drilling |
| What is Slicers |
| What is Pivot Tables |
| What are the three fundamental concepts of DAX? |
| What is Functions |
| What is Context |
| What are the different stages in the working of Power BI? |
| What is Data Processing |
| What is Data Presentation |
| What is Data Integration |
| What is the advanced editor? |
| What gateways does Power BI have and why should you use them? |
| What is Personal Gateway |
| What is On-Premises Gateway: This is an advanced form of the Personal Gateway, supporting Direct Query and usable by multiple users to refresh data. |
| What are KPIs in Power BI? |
| What is a Slicer? |
| Name the different connectivity modes available in Power BI? |
| Name the data sources can Power BI can connect to? |
| Name some commonly used tasks in the Query Editor. |
| Name the variety of Power BI Formats. |
| Explain how relationships are defined in Power BI Desktop? |
| Explain the building blocks of Microsoft Power BI. |
| Explain responsive slicers in Power BI. |
| Explain Power BI Designer. |
| Why should we use Power BI? |
| Why should you apply general formatting to Power BI data? |
| Why and how would you use a custom visual file? |
| Which in-memory analytics engine does Power Pivot use? |
| Which professionals use Power BI the most? |
| How is the Schedule Refresh feature designed to work? |
| How do you reshape data in Power BI? |
| Where is data stored in Power BI? |
| Who is Business Analysts |
| Who is Business Owners |
| Who is Business Developers |
| Who is Business Analysts |
| Difference between Power BI and Tableau |
| Difference between Power Query and Power Pivot |
| Can you have more than one functional relationship between two tables in a Power Pivot data model? |
| Can you have a table in the model which does not have any relationship with other tables? |
| can you depict a story in Power BI? |
| Describe the components of Microsoft?s self-service BI solution. |
| List out some drawbacks/limitations of using Power BI. |
| List the most common techniques for data shaping. |
| Mention some advantages of Power BI. |
| Mention important components of SSAS |
| Mention some applications of Power BI |
- SQL SERVER INTRODUCTION
- Data, Databases and RDBMS Software
- Database Types: OLTP, DWH, OLAP
- Microsoft SQL Server Advantages, Use
- Versions and Editions of SQL Server
- SQL: Purpose, Real-time Usage Options
- SQL versus Microsoft T-SQL [MSSQL]
- Microsoft SQL Server - Career Options
- SQL Server Components and Usage
- Database Engine Component and OLTP
- BI Components, Data Science Components
- ETL, MSBI and Power BI Components
- Course Plan, Concepts, Resume, Project
- 24 x 7 Online Labs for Remote DB Access
- Software Installation Pre-Requisites
- Introduction to Power BI (Free Demo Class)
- Power BI Job Roles in Real-time
- Power BI Data Analyst Job Roles
- Business Analyst - Job Roles
- Power BI Developer - Job Roles
- Power BI for Data Scientists
- Comparing MSBI and Power BI
- Comparing Tableau and Power BI
- MCSA 70-778, MCSA 70-779 Exam
- Types of Reports in Real-World
- Interactive & Paginated Reports
- Analytical & Mobile Reports
- Data Sources Types in Power BI
- Power BI Licensing Plans - Types
- Power BI Training : Lab Plan
- Power BI Dev & Prod Environments
- Understanding the Power BI Tools
- Installing Power BI & Connecting to Data
- The "Locale" used in the curriculum
- Working with the query Editor
- Working with the data model and creating a visualization
- Basic Report Design
- Power BI Desktop Installation
- Data Sources & Visual Types
- Canvas, Visualizations and Fields
- Get Data and Memory Tables
- In-Memory xvelocity Database
- Table and Tree Map Visuals
- Format Button and Data Labels
- Legend, Category and Grid
- PBIX and PBIT File Formats
- Visual Interaction, Data Points
- Disabling Visual Interactions
- Edit Interactions - Format Options
- SPOTLIGHT & FOCUSMODE
- CSV and PDF Exports. Tooltips
- Power BI EcoSystem, Architecture
- Visual Sync, Grouping
- Slicer Visual : Real-time Usage
- Orientation, Selection Properties
- Single & Multi Select, CTRL Options
- Slicer : Number, Text and Date Data
- Slicer List and Slicer Dropdowns
- Visual Sync Limitations with Slicer
- Disabling Slicers,Clear Selections
- Grouping : Real-time Use, Examples
- List Grouping and Binning Options
- Grouping Static / Fixed Data Values
- Grouping Dynamic / Changing Data
- Bin Size and Bin Limits (Max, Min)
- Bin Count and Grouping Options
- Grouping Binned Data, Classification
- Hierarchies, Filters
- Creating Hierarchies in Power BI
- Independent Drill-Down Options
- Dependant Drill-Down Options
- Conditional Drilldowns, Data Points
- Drill Up Buttons and Operations
- Expand & Show Next Level Options
- Dynamic Data Drills Limitations
- Show Data and See Records
- Filters : Types and Usage in Real-time
- Visual Filter, Page Filter, Report Filter
- Basic, Advanced and TOP N Filters
- Category and Summary Level Filters
- DrillThru Filters, Drill Thru Reports
- Keep All Filters" Options in DrillThru
- CrossReport Filters, Include, Exclude
- Bookmarks, Azure, Modeling
- Drill-thru Filters, Page Navigations
- Bookmarks: Real-time Usage
- Bookmarks for Visual Filters
- Bookmarks for Page Navigations
- Selection Pane with Bookmarks
- Buttons, Images with Actions
- Buttons, Actions and Text URLs
- Bookmarks View & Selection Pane
- OLTP Databases, Big Data Sources
- Azure Database Access, Reports
- Import & Direct Query with Power BI
- SQL Queries and Enter Data
- Data Modeling : Currency, Relations
- Summary, Format, Synonyms
- Web View & Mobile View in PBI
- Visualization Properties
- Stacked Charts and Clustered Charts
- Line Charts, Area Charts, Bar Charts
- 100% Stacked Bar & Column Charts
- Map Visuals: Tree, Filled, Bubble
- Cards, Funnel, Table, Matrix
- Scatter Chart : Play Axis, Labels
- Series Clusters & Selections
- Waterfall Chart and ArcGIS Maps
- Info graphics, Icons and Labels
- Color Saturation, Sentiment Colors
- Column Series, Column Axis in Lines
- Join Types : Round, Bevel, Miter
- Shapes, Markers, Axis, Plot Area
- Display Units, Data Colors, Shapes
- Series, Custom Series and Legends
- Power Query Level 1
- Power Query M Language Purpose
- Power Query Architecture and ETL
- Data Types, Literals and Values
- Power Query Transformation Types
- Table & Column Transformations
- Text & Number Transformations
- Date, Time and Structured Data
- List, Record and Table Structures
- let, source, in statements @ M Lang
- Power Query Functions, Parameters
- Invoke Functions, Execution Results
- Get Data, Table Creations and Edit
- Merge and Append Transformations
- Join Kinds, Advanced Editor, Apply
- ETL Operations with Power Query
- Power Query Level 2
- Query Duplicate, Query Reference
- Group By and Advanced Options
- Aggregations with Power Query
- Transpose, Header Row Promotion
- Reverse Rows and Row Count
- Data Type Changes & Detection
- Replace Columns: Text, NonText
- Replace Nulls: Fill Up, Fill Down
- PIVOT, UNPIVOT Transformations
- Move Column and Split Column
- Extract, Format and Numbers
- Date & Time Transformations
- Deriving Year, Quarter, Month, Day
- Add Column : Query Expressions
- Query Step Inserts and Step Edits
- Power Query Level 3
- Creating Parameters in Power Query
- Parameter Data Types, Default Lists
- Static/Dynamic Lists For Parameters
- Removing Columns and Duplicates
- Convert Tables to List Queries
- Linking Parameters to Queries
- Testing Parameters and PBI Canvas
- Multi-Valued Parameter Lists
- Creating Lists in Power Query
- Converting Lists to Table Data
- Advanced Edits and Parameters
- Data Type Conversions, Expressions
- Columns From Examples, Indexes
- Conditional Columns, Expressions
- DAX Functions - Level 1
- DAX : Importance in Real-time
- Real-world usage of Excel, DAX
- DAX Architecture, Entity Sets
- DAX Data Types, Syntax Rules
- DAX Measures and Calculations
- ROW Context and Filter Context
- DAX Operators, Special Characters
- DAX Functions, Types in Real-time
- Vertipaq Engine, DAX Cheat Sheet
- Creating, Using Measures with DAX
- Creating, Using Columns with DAX
- Quick Measures and Summaries
- Validation Errors, Runtime Errors
- SUM, AVERAGEX, KEEPFILTERS
- Dynamic Expressions, IF in DAX
- DAX Functions - Level 2
- Data Modeling Options in DAX
- Detecting Relations for DAX
- Using Calculated Columns in DAX
- Using Aggregated Measures in DAX
- Working with Facts & Measures
- Modeling : Missing Relations
- Modeling : Relation Management
- CALCULATE Function Conditions
- CALCULATE & ALL Member Scope
- RELATED & COUNTROWS in DAX
- Entity Sets and Slicing in DAX
- Dynamic Expressions, RETURN
- Date, Time and Text Functions
- Logical, Mathematical Functions
- Running Total & EARLIER Function
- DAX Functions - Level 3
- Connection with CSV, MS Access
- AVERAGEX and AVERAGE in DAX
- KEEPFILTERS and CALCUALTE
- COUNTROWS, RELATED, DIVIDE
- PARALLELPERIOD, DATEDADD
- CALCULATE & PREVIOUSMONTH
- USERELATIONSHIP, DAX Variables
- TOTALYTD , TOTALQTD
- DIVIDE, CALCULATE, Conditions
- IF..ELSE..THEN Statement
- SELECTEDVALUE, FORMAT
- SUM, DATEDIFF Examples in DAX
- TODAY, DATE, DAY with DAX
- Time Intelligence Functions - DAX
- Power BI Cloud - 1
- Power BI Service Architecture
- Power BI Cloud Components, Use
- App Workspaces, Report Publish
- Reports & Related Datasets Cloud
- Creating New Reports in Cloud
- Report Publish and Report Uploads
- Dashboards Creation and Usage
- Adding Tiles to Dashboards
- Pining Visuals and Report Pages
- Visual Pin Actions in Dashboards
- LIVE Page Interaction in Dashboard
- Adding Media: Images, Custom Links
- Adding Chs and Embed Links
- API Data Sources, Streaming Data
- Streaming Dataset Tiles (REST API)
- Power BI Cloud - 2
- Dashboards Actions, Report Actions
- DataSet Actions: Create Report
- Share, Metrics and Exports
- Mobile View & Dashboard Themes
- Q & A [Cortana] and Pin Visuals
- Export, Subscribe, Subscribe
- Favorite, Insights, Embed Code
- Featured Dashboards and Refresh
- Gateways Configuration, PBI Service
- Gateway Types, Cloud Connections
- Gateway Clusters, Add Data Sources
- Data Refresh : Manual, Automatic
- PBIEngw Service, ODG Logs, Audits
- DataFlows, Power Query Expressions
- Adding Entities and JSON Files
- Excel & RLS
- Import and Upload Options in Excel
- Excel Workbooks and Dashboards
- Datasets in Excel and Dashboards
- Using Excel Analyzer in Power BI
- Using Excel Publisher in PBI Cloud
- Excel Workbooks, PINS in Power BI
- Excel ODC Connections, Power Pivot
- Row Level Security (RLS) with DAX
- Need for RLS in Power BI Cloud
- Data Modeling in Power BI Desktop
- DAX Roles Creation and Testing
- Adding Power BI Users to Roles
- Custom Visualizations in Cloud
- Histogram, Gantt Chart, Infographics
- Report Server, RDL
- Need for Report Server in PROD
- Install, Configure Report Server
- Report Server DB, Temp Database
- Web service URL, Webportal URL
- Creating Hybrid Cloud with Power BI
- Using Power BI DesktopRS
- Uploading Interactive Reports
- Report Builder For Report Server
- Report Builder For Power BI Cloud
- Designing Paginated Reports (RDL)
- Deploy to Power BI Report Server
- Data Source Connections, Report
- Power BI Report Server to Cloud
- Tenant IDs Generation and Use
- Mobile Report Publisher, Usage
- PowerApp
- Overview
- Basic Power App Concept
- Canvas Apps | Navigation | Customization
- Contents (Galleries, Data Cards, Forms, Triggers, Functions & Formulas, Edit Forms, Text Boxes)
- Power BI Service & Power BI Mobile
- Why Power Bi Service?
- Comparison Power BI Free & Premium
- Logging into Power Bi Service
- Interface overview
- Importing data from Desktop to Service
- Dataset menu
- Working on reports
- Dashboard overview
- Workspace & Gateways
- Installing Gateways - Personal & On-premise
- Working alone or collaborating with colleagues
- Collaborating in App Workspace
- Sharing the results
- Publishing the app
- Content packs from online services
- Power Bi Mobile Overview
- Excluding dataset from sharing
- Power BI and Excel Together
- Options for Publishing from Excel
- Pin Excel Elements to Power BI
- Analyze in Excel (Power BI Pro or Premium)
- Excel Publish: Upload and Export to Power BI
- Sharing Published Excel Dashboards (Power BI Pro or Premium)
No comments:
Post a Comment