Snowflake Training: 100% Real-time, Practical

Complete Practical and Real-time Snowflake Training with Basic to Advanced Cloud Concepts, ETL (Extract, Transform and Load), DWH (DataWarehouse), Big Data Storage, Big Data Analytics, Incremental Loads, External Stages, SnowPipes, Failsafe Concepts, Data Recovery, Security Management, ETL Management, Administration, Azure Integrations, Power BI Integrations, External Data Connections and more..

This Snowflake Training Classes also includes Concept wise FAQs, Real-time Project, Project Solution, Project FAQs for your Job Interviews, Snowflake Core Certification Guidance with Real-Life Scenarios.

Snowflake Training Plans

  PLAN A PLAN B PLAN C
  Snowflake SQL Server Basics,
Snowflake 		SQL Server Basics,
Power BI,
Snowflake
No of Weeks 4 Weeks 7 Weeks 11 Weeks
Snowflake: DWH and ETL ✔ ✔ ✔
Snowflake: Cloud Configurations ✔ ✔ ✔
Snowflake: DWH Architecture ✔ ✔ ✔
Snowflake: Database, Schemas ✔ ✔ ✔
Snowflake: Constraints, SP, Tasks ✔ ✔ ✔
Snowflake: Partitions & Tuning ✔ ✔ ✔
Snowflake: Security Management ✔ ✔ ✔
Snowflake: Automated Backups ✔ ✔ ✔
Snowflake: SnowSQL Concepts ✔ ✔ ✔
Snowflake: Variables & Tasks ✔ ✔ ✔
Snowflake: File Formats, Stages ✔ ✔ ✔
Snowflake: External Stages ✔ ✔ ✔
Snowflake: Azure Integration ✔ ✔ ✔
Snowflake: Snow Pipes & Upserts ✔ ✔ ✔
Snowflake: Power BI Analytics ✔ ✔ ✔
TSQL: Database Basics, T-SQL ❌ ✔ ✔
TSQL : Constraints, Joins, Queries ❌ ✔ ✔
TSQL: Views, Group By, Self Joins ❌ ✔ ✔
TSQL: SPs, Udf, Transaction Basics ❌ ✔ ✔
Power BI: Report Design, Visuals ❌ ❌ ✔
Power BI: M Lang, DAX for ETL ❌ ❌ ✔
Power BI: Cloud, Apps, Tenant ❌ ❌ ✔
Power BI: Azure, Report Server ❌ ❌ ✔
Total Course Fee* INR 15000
USD 200		 INR 20000
USD 300		 INR 32000
USD 450

Trainer: Mr. Sai Phanindra (18+ Yrs of Exp)

SQL Server & T-SQL Schedules
S No Time (IST, Mon - Fri) Start Date  
1 6 AM - 7 AM Dec 5th Register
2 8 AM - 9 AM Dec 13th Register
3 6 PM - 7 PM Jan 3rd Register
4 8 PM - 9 PM Jan 22nd Register
5 9 PM - 10 PM Dec 19th Register

Trainer: Mr.Guna Sekhar (15+ Yrs of Exp)

Snowflake Training Schedules
S No Time (IST, Mon - Fri) Start Date  
6 8:30 AM - 9:30 AM Dec 5th Register
7 6:30 AM - 8:30 AM (W) Dec 2nd Register

Snowflake Training Highlights :

  • DWH & Snowflake Introduction
  • Snowflake Architecture
  • Snowflake Service Form
  • Snowflake Objects
  • Using SnowSQL CLI, Snowflake Data
  • Sequence in Snowflake
  • Snowflake Stream & Tasks
  • SnowSQL Operators, SnowSQL Concepts
  • Data Loads & Validations
  • Staging Operations with Snowflake
  • Unloading Data from Snowflake
  • Virtual Warehouse in Snowflake
  • Replication and Business Continuity
  • Security Management with Snowflake
  • Snowflake with Azure Data Factory
  • Managing Governance in Snowflake
  • End to End Real-time Project @ Resume
 

If none of the above schedules work for you, please opt for Snowflake Video Training

 

Snowflake Training Course Contents:

Curriculum PDF-Image

Register Today

 

Ch 1: DATABASE INTRODUCTION

  • Databases Introduction & Purpose
  • Database Types : OLTP, DWH, OLAP
  • Microsoft SQL Server Advantages, Use
  • SQL Server Components and Usage
  • Microsoft SQL Server - Career Options
  • Developer, DBA, Data Engineer
  • Data Analyst, Data Scientist Careers
  • SQL : Purpose, Real-time Usage Options
  • SQL Versus Microsoft T-SQL [MSSQL]
  • Course Plan, Real-time Project, Resume
  • 24 x 7 Online Lab for Remote DB Access
  • Versions and Editions of SQL Server
  • SQL Server Pre-requisites : S/W, H/W
  • System Configuration Checker Tool

Ch 5: SQL Basics - 3, TSQL INTRO

  • Database Objects : Tables and Schemas
  • Schemas : Group Tables in Database
  • Schemas : Security Management Object
  • Creating Schemas & Batch Concept
  • Using Schemas for Table Creation
  • Data Storage in Tables with Schemas
  • Data Retrieval & Usage with Schemas
  • Table Migrations across Schemas
  • Import and Export Wizard in SSMS
  • Data Imports with Excel File Data
  • Performing Bulk Operations in SSMS
  • Temporary Tables : Real-time Use
  • Local and Global Temporary Tables
  • # and ## Prefix, Scope of Usage

Ch 9: Functions, Procedures Basics

  • Functions with SQL Server, TSQL
  • Scalar, Inline, Table Functions
  • Variables: Declare, Real-time Use
  • Creating, Executing Functions
  • Functions for Computations
  • Functions for Parameterized Joins
  • Procedures: Usage in Real-time
  • Using Parameters in SQL Server
  • Parameterized Joins in TSQL
  • Compilation with Stored Procedures
  • sp_help, sp_helptext, sp_helpindex
  • sp_helpdb, sp_rename, sp_recompile
  • System Views For Metadata Audits
  • DBID, DBName, ObjectID, ObjectName

Ch 2: SQL SERVER INSTALLATION

  • SQL Server & SSMS Installation Plan
  • SQL Server Pre-requisites : S/W, H/W
  • SQL Server 2022 & 2019 Installation
  • Database Engine Feature, OLTP
  • Instances : Types and Properties
  • Default Instance, Named Instances
  • Service and Service Account Use
  • Authentication Modes and Logins
  • Windows Logins and SQL Logins
  • SQL Server Management Studio
  • Server Connections with SSMS Tool
  • Local and Remote Connections
  • System Databases: Master and Model
  • MSDB, TempDB, Resource Databases

Ch 6: Constraints, Index Basics

  • Constraints and Keys - Data Integrity
  • NULL, NOT NULL Property on Tables
  • UNIQUE KEY Constraints: Importance
  • PRIMARY KEY Constraint: Importance
  • FOREIGN KEY Constraint: Importance
  • REFERENCES, CHECK & DEFAULT
  • Candidate Keys and Identity Property
  • Database Diagrams and ER Models
  • Relationships Verification and Links
  • Indexes : Basic Types and Creation
  • Index Sorting and Search Advantages
  • Clustered and NonClustered Indexes
  • Primary Key and Unique Key Indexes
  • Need for Indexes - working with Keys

Ch 10: TRIGGERS & TRANSACTIONS

  • Triggers - Purpose, Real-world Usage
  • FOR/AFTER Triggers - Real time Use
  • INSTEAD OF Triggers - Real time Use
  • INSERTED, DELETED Memory Tables
  • Using Triggers for Data Replication
  • Enable Triggers and Disable Triggers
  • Database Level, Server Level Triggers
  • Transactions : Types, ACID Properties
  • Transaction Types and AutoCommit
  • EXPLICIT & IMPLICIT Transactions
  • COMMIT and ROLLBACK Statements
  • Batch Concept and Go Statement
  • Open Transactions in Real-time
  • Using Conditional Commits, Rollbacks

Ch 3: SSMS Tool, SQL BASICS - 1

  • Creating Databases: Files [MDF, LDF]
  • Creating Tables in User Interface
  • Data Insertion & Report in User Interface
  • SQL : Purpose and Real-time Usage
  • SQL Versus T-SQL : Basic Differences
  • DDL, DML, SELECT, DCL and TCL
  • Creating SSMS Sessions : SPID
  • Create, Connect Databases using SQL
  • Creating Tables with INT, CHAR
  • Data Storage, Inserts - Basic Level
  • Table Data Verifications with Select
  • SELECT Statement for Table Retrieval
  • Identify Databases and Tables
  • Identify Sessions and Session ID

Ch 7: Joins Basics, TSQL Queries

  • JOINS - Table Comparisons Queries
  • INNER JOINS For Matching Data
  • OUTER JOINS For (non) Match Data
  • Join Queries with "ON" Conditions
  • Left Outer Joins - Example Queries
  • Right Outer Joins - Example Queries
  • FULL Outer Joins: Realtime Scenarios
  • CROSS JOIN and CROSS APPLY
  • One-way, Two way Data Comparisons
  • Using Table Aliases & Column Aliases
  • Optimizing Join Queries with Indexes
  • Choosing Correct Comparison Columns
  • Joining Unrelated Tables in TSQL
  • Self References, Self Joins in TSQL

Ch 11:  Normal Forms, Cursors

  • First Normal Form and Atomicity
  • Third Normal Form and MVD Property
  • Boycee-Codd Normal Form : BNCF
  • Fourth Normal Form : Advantages
  • Self Reference Keys and 4 NF Usage
  • 1:1, 1:M, M:1, M:M Relationship Types
  • Linked Servers Configurations, RPC
  • Linked Servers, Remote Joins in TSQL
  • 2 Part, 3 Part, 4 Part Naming Styles
  • Remote Joins Queries and Aliases
  • Cursors - Basics, Data Operations
  • Cursors - Life Cycle & Declaration
  • Cursors Types, FETCH Operations
  • Cursors - Deallocate, Real-world Use

Ch 4: SQL BASICS - 2

  • Creating Tables: VARCHAR, FLOAT
  • Single Row Inserts, Multi Row Inserts
  • Rules for Data Insertion Statements
  • SELECT with WHERE Conditions
  • AND and OR Operators Usage
  • IN Operator and NOT IN Operator
  • Between, Not Between Operators
  • LIKE and NOT LIKE Operators
  • ORDER BY, TOP & OFFSET
  • Basic Sub Queries with SELECT
  • UPDATE Statement & Conditions
  • DELETE & TRUNCATE Statements
  • ALTER, ADD COLUMN Statements
  • DROP Statements: Table, Database

Ch 8: Group By in TSQL, Views Basics

  • GROUP BY: Importance, Realtime Use
  • GROUP BY Queries and Aggregations
  • Group By Queries with Having Clause
  • Group By Queries with Where Clause
  • Using WHERE and HAVING in T-SQL
  • Group By with Joins in TSQL
  • Query Execution Order & Aliases
  • Joins with Sub Queries, Formatting
  • Database Objects: Overview & Usage
  • Views: Types, Usage in Real-time
  • Creating, Executing & Verifying Views
  • Storing Queries in Database Views
  • Excel Analytics - Joins & Views
  • Excel Office Data Connection Reports

Ch 12: TSQL Queries, SQL Analytics

  • IIF() Function with SELECT Query
  • WHEN..THEN..ELSE
  • WHEN MATCHED, NOT MATCHED
  • Incremental Loads, Upsert Statement
  • Stored Procedures: Merge Statement
  • UNION and UNION ALL Operator
  • Window Functions: Rank, Dense Rank
  • Row_Number, PartitionBy in TSQL
  • Duplicate Row Identification, Deletion
  • Grouping, Cube, Rollup, Lag, Lead
  • Data Types: Numerical, Date, Time
  • Data Types: Characters, Real, Float
  • Date & Time Functions, DateAdd
  • String Functions, Concat, SubString
Case Study 1: Database Design with Tables,
Constraints, Keys & Relations 		Case Study 2: Joins with Group By,
Sub Queries, Views, Excel Analytics

Mod 1: Snowflake Architecture, Basics

Mod 2: Snowflake Concepts, Admin

Mod 3: ETL, Stages & Pipes

Ch 1: Introduction to Cloud & Snowflake

  • Database Introduction & Database Types
  • OLTP, OLAP and Warehouse Databases
  • Need for Datawarehouses; Advantages
  • Popular Database Technologies
  • Popular Datawarehouse Technologies
  • Need for Cloud & Remote DWH Store
  • Cloud Implementation Types & Usage
  • IaaS: Infrastructure As A Service
  • PaaS: Platform As A Service
  • SaaS: Software As A Service
  • Snowflake Cloud: Introduction
  • Snowflake: Popular SaaS Platform
  • Cloud Datawarehouse Concepts
  • Advantages, Dependencies in Snowflake

Ch 7: Constraints and Data Types

  • Snowflake Constraints, Data Validations
  • NULL and NOT NULL Properties
  • Unique, Primary and Foreign Keys
  • Working with Named Constraints
  • Single Column, Multi Column Constraints
  • Inline and Out Of Line Constraints
  • Table Constraints Types, Real-time Use
  • Constraint Properties: ENFORCED
  • DEFERRED, IMMEDIATE Options
  • Numeric, String and Binary Data Types
  • Boolean Data Types and Usage
  • Date and Time Data Types
  • Semi Structured Data Types
  • Geospatial & Variant Data Types

Ch 13: Snowflake Tasks, Partitions

  • Snowflake Tasks and Real-time Use
  • Snowflake Serverless Compute Model
  • User Managed & Snowflake Managed
  • Tasks Tree: Root and Link Concepts
  • Directed Acyclic Graph (DAG)
  • Tasks Schedules and RESUME Options
  • CREATE, ALTER, DESCRIBE, SHOW
  • CREATE TASK … AFTER Statement
  • ALTER TASK … ADD AFTER Statement
  • CRON Syntax with Tasks, Procedures
  • Virtual Warehouse Concepts (DWH)
  • Multi Cluster Warehouse Config
  • Client Utilities, Drivers & Connectors
  • Auto Scale Options, Billing (Pricing)

Ch 2: Snowflake Account & Editions

  • Creating Snowflake Account (Cloud)
  • Snowflake Trail Account: Limitations, Uses
  • Snowflake Account Components
  • Cloud Platform: Azure, AWS, Google Cloud
  • Regions and Availability with Snowflake
  • Snowflake Editions, Credits; UI Usage
  • Default Accounts; Web UI & Snow Sight
  • Snowflake Storage: Ondemand, Capacity
  • Snowflake Editions and Comparisons
  • Standard Edition: Features, Advantages
  • Enterprise Edition: Features, Advantages
  • Business Critical Edition: Features, Usage
  • Virtual Private Edition (VPS) & Pricing
  • Snowflake Pricing: Ondemand Vs Capacity

Ch 8: Snowflake Cloning (Zero Copy)

  • Cloning Operations with Snowflake
  • Zero Copy and Schema Level Cloning
  • Real-time Uses: Cloning in Snowflake
  • Snapshot Concept, Metadata Options
  • Possible Objects for Snowflake Clone
  • Permissions for Snowflake Cloning
  • Accessing, Controlling Cloned Objects
  • Real-time Considerations @ Cloning
  • Storage Layer and Metadata Layer
  • Cloning with Foreign Key Constraints
  • Cloning Snowflake Databases
  • Cloning Snowflake Schemas, Tables
  • Security and MANAGE GRANTS
  • Cloning and COPY GRANTS Options

Ch 14: SnowSQL and Variables

  • SnowSQL: Concepts, Client Installation
  • SnowSQL Tool: Configuration Options
  • SnowSQL: Account Authorization
  • DDL, DML and SELECT Operations
  • Snowflake SQL Query Syntax Format
  • SnowSQL Command Line Options
  • Working with DB, Schema and Tables
  • Snowflake Variables, Batch Processing
  • Snowflake SQL Data Types, Usage
  • DECLARE, LET, BEGIN and END
  • EXECUTE IMMEDIATE, FOR, END FOR
  • Creating Warehouse, Database, Tables
  • Granting Permissions, Query Execution
  • Writing Output to Files (Win, MAC OS)

Ch 3: Architecture, Warehouse (DWH)

  • Snowflake Architecture & Compute
  • Shared Disk, Shared Nothing Architecture
  • Cluster Nodes and Snowflake Clusters
  • CPU & Memory Resources in Clusters
  • Disk Storage and Network Communication
  • Storage Layer and Cloud Service Layer
  • Database Query Layer & Data Cycle
  • Snowflake Datawarehouse Architecture
  • MPP: Massively Parallel Processing
  • Compute and Storage Components
  • Column Store and Virtual Warehouse
  • Datawarehouse Creation in SnowSight
  • Classic UI with Snowflake; Navigations
  • Data Load and Billing; Auto Suspend

Ch 9: Snowflake Procedures & Views

  • Snowflake Procedures and Functions
  • Creating and Using Stored Procedures
  • Using CALL Command in Snowflake
  • SQL and JavaScript Options with SPs
  • Snowflake Deferred Name Resolution
  • Overloading with Snowflake SPs
  • Transactions & Injection
  • Variables & CALL Command
  • Using execute() with Procedures
  • sqlText:command, createStatement
  • Cursoring Operations
  • Dynamic DML Operations with SPs
  • Loops & next.scan()
  • RETURN and RETURNS Statements
  • Views & Query Storage
  • DML and SELECT Operations on Views
  • Regular Views, System Predefined Views
  • Recursive Views, Parameterized Views

Ch 15: Snowflake Partitions, Stages

  • Snowflake Partitions, Real-time use
  • Service and Storage Layer Concepts
  • Micro Partition with DML, CDC
  • Cluster Key: Usage, ReClusters
  • Depth and Overlap Properties
  • Internal Partition Types & Usage
  • List, Range and Hash Partitions
  • SYSTEM$CLUSTERING_INFORMATION
  • Snowflake Stages and Usage
  • Internal and External Stages
  • User Stages : Creation, Usage
  • Table Stages: Creation, Usage
  • Internal Named Stages, Usage
  • COPY Command, Bulk Data Loads

Ch 4: Snowflake Databases & Tables

  • Snowflake Databases and Data Storage
  • Need for Snowflake Warehouse, Compute
  • Database Objects and Hierarchy
  • Snowflake Worksheet Parameters
  • Database Creation with Snowflake UI
  • Retention Time, DB List & Connections
  • Permanent and Transient Databases
  • Snowflake Tables and their Usage
  • Permanent, Transient & Temp Tables
  • Creating Tables with SnowSight
  • Describe Options, Data Inserts
  • CREATE TABLE AS SELECT
  • Cloning Tables, Case Sensitivity Options
  • Collation, ALTER, DROP & UNDROP

Ch 10: Security Management

  • Security Management Concepts
  • Security Entities with Snowflake
  • Securable Objects, Users & Roles
  • Prevligies and Privilege Groups
  • Snowflake Security Hierarchy
  • Organization, Account, Users, Roles
  • Schema, Tables, Other DB Objects
  • Creating and Using Roles, Users
  • System Defined Roles and Usage
  • Role Hierarchy and Dependency
  • Creating and Working with Users
  • Auditing Users and Password Policy
  • RBAC: Role Based Access Control
  • DAC: Discretionary Access Control

Ch 16: Azure & External Storage

  • Working with Azure Storage
  • Azure Subscription, Resources
  • Create, Use Azure Storage Account
  • Storage Containers, BLOB Data
  • Using SnowSQL with Azure BLOB
  • SAS [Shared Access Signature]
  • Using SAS Key and FILE PATH
  • External Stages in Snowflake
  • File Formats: Creation, Usage
  • Creating & Using External Stages
  • Azure Storage with BLOB
  • COPY INTO Command Usage
  • Listing Stages with Snowflake
  • Snowflake Patterns & RegEx

Ch 5: Time Travel & Transient Tables

  • Time Travel Feature in Snowflake
  • DML Operations and Silent Audits
  • Continuous Data Protection Life Cycle
  • Invoking Time Travel Feature in Snowflake
  • Timestamp, Offset & Query ID Options
  • Time Travel using Offset Feature
  • Time Travel using Query ID Feature
  • Data Recovery using TIMESTAMP
  • Using OFFSET options in Real-world
  • Fail Safe and UNDROP Operations
  • Transient Tables and Real-time Usage
  • Permanent Table and Real-time Usage
  • Restrictions with Permanent Tables
  • Identical Names and Naming Conflicts

Ch 11: Snowflake Transactions

  • Working with Transactions (ACID)
  • Atomicity, Consistency, Isolation
  • Durability and Data Storage Options
  • Transaction Types with Snowflake
  • Implicit, Explicit and Auto Commit
  • BEGIN TRANSACTION & COMMIT
  • DDL Statements and Transactions
  • BEGIN WORK Versus START
  • current_transaction() and Usage
  • to_timestamp_ltz and Usage
  • Failed Transactions with SPs
  • Batches Versus Transactions
  • Transactions with Stored Procedures
  • Scoped and INNER Transactions

Ch 17: SnowPipes & Incremental Loads

  • Snowflake SnowPipes: Incremental Loads & SnowPipe
  • Creating Azure Account For BLOB
  • Creating Container, Generate SAS Key
  • Creating Azure Queue and Event Grid
  • Notification Integration in Snowflake
  • Integrations: Show, Describe, Use
  • Azure Active Directory & IAM
  • Linking Azure AD with Snowflake
  • Enterprise Application, Authentication
  • File Formats with Regular Expr
  • External Data Stages
  • Data Unloading Concepts
  • PUT and GET with SnowSQL
  • Bulk Unloads; Data Preparation & Stages
  • Data Unloading to User Stages
  • Data Unloading to Table Stages

Ch 6: Schemas and Session Context

  • Schemas: Creation, Real-time Usage
  • Permanant and Transient Schemas
  • Managed Schemas in Real-time Usage
  • Verifying and Cloning Snowflake Schemas
  • Invoking Schemas & Cloning Operations
  • ALTER SCHEMA.. IF EXISTS Options
  • Creating, Working with Managed Schema
  • Snowflake Sessions (Workspaces)
  • Session Context: Role and Warehouse
  • Session Context: Database & Schema
  • Working with Fully Qualified Names
  • CTAS: Create Table As Select
  • Data Loading with GUI, SQL Scripts
  • Using Query and History Tab in GUI

Ch 12: Snowflake Streams & Audits

  • Working with Snowflake Streams
  • Stream Object and DML Auditing
  • Snapshot Creation, Offset Options
  • METADATA$ACTION Parameter
  • METADATA$ISUPDATE Parameter
  • METADATA$ROW_ID Parameter
  • Stream Types: Standard Stream
  • Append Only Stream & Usage
  • Insert Only Stream & Usage
  • Data Flow with Snowflake Streams
  • Auditing INSERT, UPDATE, DELETE
  • show streams; desc streams
  • Streams on Transient Tables
  • Time Travel; Using Stream Tables

Ch 18 : REAL-TIME PROJECT

  • Phase 1:
  • Legacy Data Systems
  • Heterogenous Data Platforms
  • File Data Sources
  • Phase 2
  • Desining DWH in Snowflake
  • Incremental Loads
  • Capacity Planning
  • External Data, Integrations
  • SnowPipes and Azure BLOB
  • Phase 3
  • Data Visualizations, Analytics
  • End to End Implementations
  • Project Solution & FAQs
  • Resume & Certification Guidance

Part 1: Power BI Report Design

Part 2: ETL, Data Modeling, DAX

Part 3: Power BI Cloud, Admin

Ch 1 : POWER BI BASICS

  • 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
  • PL 300 Certification Guidance
  • 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

Ch 7 : 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

Ch 13 : 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)

Ch 2: 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

Ch 8 : 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

Ch 14 : 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

Ch 3 : 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

Ch 9 : 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

Ch 15 : 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

Ch 4 : 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

Ch 10 : 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

Ch 16 : Report Server, RDL

  • Need for Report Server in PROD
  • Install, Configure Report Server
  • Report Server DB, Temp Database
  • Webservice 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

Ch 5 : 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

Ch 11 : 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

Ch 17: MSBI Integrations

  • Power BI with SQL Server Source
  • Power BI with SQL Data Warehouse
  • Power BI with SSAS OLAP Server
  • Power BI with Azure SQL DB Source
  • Power BI with Azure SQL Warehouse
  • Power BI with Azure Analysis Server
  • Power BI with SSRS (RDL) Reports
  • Power BI Report Builder Tool
  • Installation & Configuration
  • Paginated Reports Design, Use
  • Data Sources, Datasets, RDL
  • Report Publish (RDL) to Cloud
  • Report Verifications, Data Sync
  • Interactive Vs Paginated Reports
  • Creating, Managing Alerts in Cloud

Ch 6 : 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
  • Infographics, 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

Ch 12 : DAX FUNCTIONS Level 3

  • 1:1, 1:M and M:1 Relations
  • 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
Ch 18 : REAL-TIME PROJECT
  • Project Requirement Analysis
  • Implementing SDLC Phases
  • Requirement Gathering, FSA
Phase 1:
  • PBIX Report Design
  • Visualizations, Properties
  • Analytics and Formating
Phase 2:
  • Data Modeling, Power Query
  • Dynamic Connections, Azure DB
  • Parameters and M Lang Scripts
Phase 3:
  • DAX Requriements, Analysis
  • Cloud and Report Server
  • Project FAQs and Solutions
 
Other Popular Courses: TSQL Training, MSBI Training, Power BI Training, Azure Data Engineer Training, SQL DBA Training, [+] More Courses
 

SQL Server T-SQL, Azure SQL, Azure DBA, Azure BI, Azure Data Engineer, Power BI Training

SQL Server Developer Training
Online Video
MSBI Course Training
Online Video
PowerBI Course Training
Online Video
SQL DBA Course Training
Online Video
SSRS Course Training
Online Video
Azure SQL Course Training
Online Video
Azure Data Engineeer Training
Online Video
Azure SQLBI Course Training
Online Video
ADF Course Training
Online Video
Azure DBA Course Training
Online Video
Azure Admin Training
Online Register
DP-200 Training
Details Register
DP-300 Training
Online Register
DP-300 Training
Online Video
Snowflake Training
Online Video
 
More Azure Courses
Register Now
>