Complete Practical and Real-time Training on Power BI Embedded. Power BI Embedded simplifies Power BI capabilities by helping you to quickly add stunning visuals, reports, and dashboards to your apps. Similar to the way apps built on Microsoft Azure use services like Machine Learning and IoT. By enabling easy-to-navigate data exploration in their apps, ISVs allow their customers to make quick, informed decisions in context.
PLAN A | PLAN B | PLAN C | |
---|---|---|---|
Power BI Embedded |
Power BI, PowerBI Embedded |
Azure BI | |
Total Duration | 1 Week | 5 Weeks | 18 Weeks |
Practical Training | ✔ | ✔ | ✔ |
Power BI Embedded Dashboards | ✔ | ✔ | ✔ |
Power BI Embedded API's | ✔ | ✔ | ✔ |
Power B: Report Design, Visuals | ❌ | ✔ | ✔ |
Power BI: M Lang, DX for ETL | ❌ | ✔ | ✔ |
Power BI: Report Server, Admin | ❌ | ✔ | ✔ |
Azure BI: MSBI - IS | ❌ | ❌ | ✔ |
Azure BI: MSBI - AS | ❌ | ❌ | ✔ |
Azure BI: MSBI - RS | ❌ | ❌ | ✔ |
Azure BI: ADF & Synapse | ❌ | ❌ | ✔ |
Azure BI: Cosmos DB | ❌ | ❌ | ✔ |
Azure BI: Azure Databricks | ❌ | ❌ | ✔ |
Azure BI: Azure Storage | ❌ | ❌ | ✔ |
Azure BI: Azure SSIS | ❌ | ❌ | ✔ |
Azure BI: Azure SSAS | ❌ | ❌ | ✔ |
Total Course Fee * |
INR 7000 USD 95 |
INR 15000 USD 203 |
INR 59000 USD 798 |
If above schedule does not work, opt for Power BI Training Videos
Power BI Embedded Training Highlights :
✔ Azure Fundamentals, Cloud Implementations | |
✔ SaaS, IaaS & PaaS Implementation Concepts | |
✔ Azure Kubernetes Services (AKS) Concepts | |
✔ Azure Active Directory and Security Concepts | |
✔ Public Cloud and Private Cloud Concepts | |
✔ Azure Governance Methodologies | |
✔✔ End to End Real-time Project @ Resume |
All Session Are Completely Practical & Real Time
SQL Server Integration Services (SSIS) |
SQL Server Analysis Services (SSAS) |
SQL Server Reporting Services (SSRS) |
Ch 1: SSIS INTRO, INSTALLATION
|
Ch 1: SSAS INTRO, CONFIGURATION
|
Ch 1: SSRS INTRO, INSTALLATION
|
Ch 2: SSIS ETL PACKAGES: BASICS
|
Ch 2: CUBE DESIGN WITH SSAS, EXCEL
|
Ch 2: BASIC REPORT DESIGN
|
Ch 3: MERGE & FUZZY LOOKUP
|
Ch 3: HIERARCHIES, MDX - LEVEL 1
|
Ch 3: GROUPING, REPORT PARAMETERS
|
Ch 4: SSIS CHECKPOINT & PIVOT
|
Ch 4: CALCULATIONS, MDX - LEVEL 2
|
Ch 4: CHARTS, DASHBOARDS, FITLERS
|
Ch 5: EVENTS, LOOPS, EXPRESSIONS
|
Ch 5: PARTITIONS & AGGREGATIONS
|
Ch 5: EXPRESSIONS, SHARED DATASETS
|
Ch 6: SSIS with ETL, Warehouse (DWH)
|
Ch 6: KPIs, OLAP CUBE DEPLOYMENTS
|
Ch 6: REPORT BUILDER, GAUGES
|
Ch 7: Checksum & DWH Design
|
Ch 7: TABULAR CUBE DESIGN
|
Ch 7: REPORT BUILDER, MAP REPORTS
|
Ch 8: CDC Transformations for DWH
|
Ch 8: TABULAR MODE CUBES, DAX - 1
|
Ch 8: REPORT MANAGEMENT
|
Ch 9: Fact Table Design, DWH Loads
|
Ch 9: TABULAR MODE - DAX LEVEL 2
|
Ch 9: MOBILE, KPI, CUBE REPORTS
|
Ch 10: DWH MIGRATIONS, SCRIPT Task
|
Ch 10: OLAP DATABASE MANAGEMENT
|
Ch 10: PROJECT WORK in SSRS
|
Ch 11: SSIS DEPLOYMENTS, UPGRADES
|
Ch 11: Real-time Project for SSAS
|
End to End Implementation (Real-time)
|
Ch 12: Realtime Project for SSIS & DWH
|
Ch 12: Integration with Power BI [Plan C]
|
MSBI Resume Guidance, Interview FAQs
|
Part 1: Power BI Report Design |
Part 2: ETL, Data Modeling, DAX |
Part 3: Power BI Cloud, Admin |
Ch 1 : POWER BI BASICS
|
Ch 7 : POWER QUERY LEVEL 1
|
Ch 13 : POWER BI CLOUD - 1
|
Ch 2: BASIC REPORT DESIGN
|
Ch 8 : POWER QUERY LEVEL 2
|
Ch 14 : POWER BI CLOUD - 2
|
Ch 3 : Visual Sync, Grouping
|
Ch 9 : POWER QUERY LEVEL 3
|
Ch 15 : EXCEL & RLS
|
Ch 4 : Hierarchies, Filters
|
Ch 10 : DAX Functions - Level 1
|
Ch 16 : Report Server, RDL
|
Ch 5 : Bookmarks, Azure, Modeling
|
Ch 11 : DAX Functions - Level 2
|
Ch 17: MSBI Integrations
|
Ch 6 : Visualization Properties
|
Ch 12 : DAX FUNCTIONS Level 3
|
Ch 18 : REAL-TIME PROJECT
|
1. Azure Fundamentals: What is Cloud? Advantages of Azure Cloud? IaaS, SaaS & PaaS. Azure Data Engineer Technologies, Job Roles. DP 200, 201 Exams Azure Account Registration and Free Trail Activation; Understanding Azure Resources and Resource Types; Creating Resource Groups in Azure Portal; | ||
2. Azure SQL Server: Azure Resources; Resource Groups; Azure SQL Server [Logical Server] Creation; Server Name Format and Firewall Rules; Azure Services Access with Firewall; Test Connections with SSMS Tool and Azure Data Studio Tool; Creating Azure SQL Databases in Portal, T-SQL; Tables, Data Inserts; | ||
3. Azure SQL DB Migrations: Azure SQL DB Migrations from OnPremise; Using Data Migration Assistant Tool; Migration Assessments; Deploy Schema & Migrate Data Options; Onpremise Versus Azure SQL DB Differences; Generating bacpac Files From SSMS Tool; Azure SQL DB Exports & Imports; |
Mod 1: Azure Data Factory, Azure Synapse, Azure Data Share, Azure Key Vaults |
Mod 2: Azure Storage, Azure Data Lake Storage, Azure Data Lake Analytics, U-SQL |
Mod 3: Azure Databricks, Azure Cosmos DB, Azure Stream Analytics, NoSQL |
Ch 1: Azure Data Factory, Synapse Intro
|
Ch 11: Azure Storage Concepts
|
Ch 21: Azure Databricks Configurations
|
Ch 2: Azure Synapse Architecture
|
Ch 12: Azure Tables & Azure BLOB
|
Ch 22: Databricks Notebooks, Spark Jobs
|
Ch 3: Azure Data Factory Architecture
|
Ch 13: Azure Files, Queues & Security
|
Ch 23: Python Notebooks & Operations
|
Ch 4: Azure Data Lake with ADF
|
Ch 14: Azure Monitor, KQL, Power Shell
|
Ch 24: Scala Notebooks, SQL Notebooks
|
Ch 5: On-Premise Data to Azure
|
Ch 15: Azure Stream Analytics, Event Hubs
|
Ch 25: Databricks Jobs & Power BI
|
Ch 6: Incremental Loads with ADF - 1
|
Ch 16: Azure Data Lake Storage (ADLS)
|
Ch 26: Azure Cosmos DB - Architecture
|
Ch 7: Incremental Loads with ADF - 2
|
Ch 17: ADLS Monitoring, Alerts
|
Ch 27: Azure Cosmos DB Queries Level 1
|
Ch 8: Mapping Data Flow in ADF
|
Ch 18: Azure Key Vaults & ADL Analytics
|
Ch 28: Azure Cosmos DB Queries Level 2
|
Ch 9: Wrangling Data Flow in ADF
|
Ch 19: Data Lake Analytics, U-SQL 1
|
Ch 29: Azure Notebooks, Azure Functions
|
Ch 10: ADF : End to End Implementation
|
Ch 20: Data Lake Analytics, U-SQL 2
|
Ch 30: Azure Cosmos Admin, Power BI
|
Real-time Project @ Ecommerce Domain: Includes On-Premise Migrations with bac Files, Azure Storage Compoments, Azure Data Ingestions using Azure Data Factory; Big Data Storage with Azure Synapse and Azure Cosmos Database; Big Data Analytics using Azure Databricks and Azure Stream Analytics. This Real-time Project also includes End User Reporting with Power BI. Additionally includes Resume Support and DP 200, DP 201 Certification Guidance. |
Chapter 1: SSIS Migrations to Azure Data Factory Provision Azure SQL Server Integration Services; SSIS DB Creation and Configuration Recommendations; Node Size, Node Number and Edition / License Options; Count, Parallel Execution Settings and DIUs; Edition Settings, logical SQL Server Configurations; SSIS DB Access from SSMS, SKU & Edition Checks; SSIS Package Validations with Connection Parameters; Generation of ISPAC Files in On-Premise, Validations; SSIS Catalog Database, Catalog Folders Creation; SSIS Deployments with ISPAC to Azure SSIS Catalog DB; Package Verifications and Acess from ADF Portal; SSIS Package Execution from ADF Portal, SSIS Store; |
Chapter 2: Azure SSIS from Visual Studio (SSDT) Accessing Azure Data Factory Resource from SSDT; Storage Account and BLOB Container Configurations; Azure SQL Server Deployment for SSIS Catalog DB; Configuring Azure Data Factory, Azure SSIS IR; Using Azure Enabled Integration Services Project in SSDT; Enabling, Linking ADF Account to SSIS Project; Using Azure BLOB Upload Task in SSIS - SSDT Tool; Storage Account, Access Key & Authentication Tests; SSIS Import and Export Operations with Azure; Excel Sheet to Azure SQL Database Tables in SSIS; Connection Settings and Package Executions in Azure; PIVOT Operations in SSIS, Data Uploads to Azure; |
Chapter 3: SSIS Packages with Azure Feature Pack Azure Feature Pack Installations and Real-time Usage; Using Azure BLOB Destination with ETL in SSIS; Using Azure SQL Server Databases with ETL in SSIS; SSIS Package Design with Azure Connections, Parameters; Azure SSIS Runtime Configurations, SSIS DB usage; Azure SSIS Package Executions with T-SQL Scripts; Real-time Considerations with Azure SSIS Migrations; Security Options - Data Security at Rest, TDE Options; Tools - Azure SSIS IR Customizations and Precautions; Pricing - Azure Hybrid Benefit (AHB), DIU and DTU Costs; 3rd Party Tools - Azure SSIS Feature Pack, IR Customization; Networking - Odata Sources, WAN & VNET Considerations; |
Chapter 4: Elastic Jobs with Azure SSIS DB Working with Azure SSIS DB - Standard Edition; Elastic Job Agent Service and Job Databases; Creating Master Keys and Database Credentials; Job Database Configurations with T-SQL Scripts; Testing Elastic Jobs from Azure Portal, T-SQL; Setting Retention Window in Azure SSIS DB with T-SQL; Start, Stop & Schedule Azure SSIS IR; Working with Web Activity in Azure Data Factory; Web Activity : PUSH / PULL Settings, Messages; Azure Management URLs, Azure SSIS IR Start & Stop; MSBI Authentication with Web Activity, Security; Execute SSIS Package Activity with ADF Pipeline; ADF Trigger Schedules and Tumbling Window; |
Chapter 5: Azure SSIS Projects : Versioning, ADF Jobs Azure SSIS Projects : Deployments and Exports; Azure SSIS Projects : Improts to SSDT Environment; Enabling ADF for Existing SSIS Projects, Parameters; SSIS Package Deployments. Deployment Rollbacks, LSN; Creating ADF Jobs from SSMS - using SSIS Schedules; Trigger Edits and Configuration Settings with ADF Jobs; Azure SSIS - Security Management; Creating Logins and Users in Azure SQL Server; User Mapping with SSIS Catalog Database, Scripts; Folder Level and Project Level Permissions in SSSDB; Read, Modify and Manage Permissions in SSIS DB; Principal IDs and Permission Types, Object Types; IAM : ADF Security @ Azure Active Directory Users, Groups; |
Chapter 1: Azure Analysis Services OperationsAzure Analysis Services : Architecture and Purpose; PaaS Implementation of SSAS in Azure Cloud; Azure Analysis Services : Advantages over MSBI SSAS; Deployment, Integration and Low Cost of Ownership; Server Side Encryption (SSE) with Azure BLOB Data; SSAS Data Models with Azure Analysis Services; Deployment Options and Workflow Operations; Azure Analysis Services: Query Processing Unit (QPU); Service Tiers (Plans): Developer, Basic and Standard; Data Source Types and In-Memory Options in AS; Creating and Connecting to Azure Analysis Services; Sample Models: Creation, Connection and Analytics; |
Chapter 2: Data Models with Azure Analysis ServicesCreating Data Models in SQL Server Data Tools; Tabular Mode Data Models with Azure SQL Database; Working with In-Memory Xvelocity Vertipaq Database; Multi Factor Authentication (MFA) with SSMS Tool; Creating Analysis Services Tabular Mode Projects; Compatibility Levels and Integrated Workspace; Navigators, In-Memory Data Processing & Cubes; Data Model Deployments with Azure Analysis Server; Dimension & Attribute Identification in Data Models; Aggregated Measures, KPIs and Excel Data Analytics; Creating Hierarchies and Attribute Relations; Azure Active Directory Authentication For Azure AS; |
Chapter 3: Azure Data Sources and DAX CalculationsAzure Synapse (Data Warehouse) Data Sources; Azure Storage Tables and Azure Files (BLOB) Data; Azure Cosmos Databases for Azure Analysis Services; Using SMK: Service Managed Key for Data Models; Using Azure Active Directory (AAD) Users and Groups; Using Azure Service Principals and Tenants for Azure AS; Using Service Vaults for Authentication Options; Direct Query and Import Options with Azure Sources; DAX Implementations with Azure Data Sources; DAX Measures and DAX Calculations for Attributes; Formatting Date and Time Calculations with DAX; YoY, YTD, MoM, QTD, YTD, MTD DAX Calculations; |
Chapter 4: Azure AS with On-Premise Data SourcesAccessing On-Premise Data Sources For Azure AS; OnPremise Versus Azure Analysis Services; MSMDSRV.EXE Versus Azure PaaS Components; Azure Storage Account For Azure AS OLAP DB Store; In-Memory Vertipaq Database Concepts with OLAP; MCE : Maximum Core Entitlement with Azure OLAP; On-Premise OLAP Cube Deployments (Tabular); Migrating On-Premise to Azure Analysis Services; Creating abf Files with On-Premise OLAP Database; Creating and Using Azure Storage Containers; Restoring abf Files in Azure Analysis Services (PaaS); Testing OLAP DB Migrations with Excel Analyzer; |
Chapter 5: Azure AS Data Model ManagementStart & Stop Options. Scale Up & Scale Down Options; Azure Analysis Services: Monitoring, Activity Logs; Event Severity, Quick Insights and Usage Metrics; Diagnostic Events, Errors and Alerts in Azure AS; Configure OLAP Database Replica, Backups & Restores; Detach and Attach OLAP Databases, Migrations; IAM : Identity and Access Management with Azure AS; Analytical Role, Monitor Role in Azure AS Data Models; Owner Role, Contributor Role & Reader Role; AD User Permissions, Firewall, Alerts and Metrics; Firewalls, Data Security and Row Level Security; Common Errors and Solutions with Azure Analysis; |
Chapter 6: End to End Implementation with Azure ASCreating Azure Data Sources and Azure Synapse; Creating Azure Analysis Services Resources, Models; Creating Data Models with Azure Synapse Databases; Tabular Mode Data Models : Design and Compatibility; Data Imports, Data Preview, Processing & Deployment; DAX For Aggregated Measures, Aggregated Columns; RLS: Row Level Security Implementation with DAX; OLAP Deployment Options and OLAP Server Settings; OLAP Database Builds and Deployment Target Files; XMLA Scripts, OLAP DB Scripting & Cloning Options; Power BI for Azure Analysis Services Data Models; Interactive Reports Design with Azure OLAP Databases; |
Power BI EmbeddedNeed for Power BI Embedded and Azure Platform; Independent Software Vendors (ISV); PaaS Solution for Power BI in Azure, Configuration; SaaS Solution for Power BI with Premium Account; Pay as you Go versus Monthly Subscriptions; Using Azure Portal and Power BI Desktop UI; Creating Power BI Embedded Capacities; Azure Configuraton, Access Options. Visualizations; Capacity Administrators and Pricing Tiers Power BI Embedded in Azure and Office; Azure Active Directory Tenant Setup, Power BI Pro; Embedded Development Analysitcs Environment; Azure Active Directory (AAD) : App Registration; Native Apps and Server Side Web Applications; Workspace Creation and Realt-time Usage; Server Principal and Security Settings, URL Access; Create & Publish Reports in Power BI Embedded; Power BI Embeeding within Applications (.NET) Microsoft Rest Token Credentials and Use; Creating Dedicated Capacities and Nodes; Development Testing Options with Embedded; Workspace Assisgnment to Capacities; Organizational Embeds and Secure Tenants; End to End Implementation with Power BI; Firewall Settings, Power BI Access; Metrics : Memory & CPU Usage Reports; Azure Security Management Options; Owner, Contributor, RBAC in Azure AD |