MS Azure BI: A Comprehensive Training Program
Welcome to Proximsoft’s MS Azure BI Training, your gateway to mastering Microsoft Azure’s Business Intelligence services and propelling your career into the world of data analytics and reporting. Our expertly crafted course is designed to equip you with in-depth knowledge and hands-on experience, ensuring you can confidently navigate the vast landscape of Azure’s BI capabilities.
In this course, you’ll delve into Azure’s Business Intelligence offerings, exploring powerful tools like Power BI, Azure Stream Analytics, Azure Analysis Services, and more. From understanding data storage solutions to building real-time analytics pipelines, you’ll gain practical exposure through hands-on projects, preparing you for success in the dynamic field of business intelligence.
Why Learn MS Azure BI?
- The demand for professionals with Azure BI expertise is soaring, opening up diverse and lucrative career opportunities in the data-driven industry.
- Azure BI seamlessly integrates with various data sources, offering a unified platform for efficient data processing, analysis, and reporting.
- Unlock real-time insights into your business with Azure Stream Analytics, a serverless analytics service designed for mission-critical workloads.
- Scale your data analytics needs effortlessly with Azure Synapse Analytics, combining enterprise data warehousing and Big Data analytics.
- Leverage the power of Azure Data Factory for code-free ETL processes, connecting data silos and streamlining data integration across diverse sources.
| Mode of Training | Online live Interactive sessions |
| Duration of the Training | 6 weeks |
| Training duration per day | 60 – 90 min session |
| Software Access | Software will be installed/server access will be provided, whichever is possible |
| Training Materials | Soft copy of the material will be provided during the training |
| Training fee | Depends on the Requirement |
| Resume Preparation | Yes, at the end of the course based on the JD |
| Interview Preparation | Yes, by sharing some FAQ’s |
| Mock calls | Yes, 2 Technical Mock calls |
| Internship Project | Yes |
| Certification | Yes, at the end of the training |
| JOB Assistance | Yes |
| JOB Support | Yes |
| Â | Â |
| Weekdays | 6AM -2 PM EST & 6-11:30 PM EST (student can pick any 1 hr) |
| Weekends | 8 AM – 12 PM EST (student can pick any 2 hrs) |
Course Content
INTRODUCTION TO AZURE BI
- INTRODUCTION TO MICROSOFT AZURE
- Â What is On Premise Data Centre
- Â Challenges of Maintaining Storage and
- Â Server On Premises
- Â Data Centre
- Â Data Centre Managed Services
- Â Virtualization
- Â Cloud Computing
- Â Advantages Of Moving Storage and Servers to Cloud
- Â Services Offering By Microsoft
- IAAS(Infra Structure As A Service)Â
- PAAS(Platform As A Service)Â
- SSAS(Software As A Service)
- Microsoft Azure vs AWS
- Â Creating Azure Account
- Â All Services of Azure
- Â What is Subscription
- Â What is Resource Group
- Â Creating Virtual Machines(VM’s) with Windows and Unix Operating System
- Â Executing few Unix Commands with Putty
- Â What is Resource
- Â Types Of Storage Accounts
- StorageV2 (general purpose v2)
- Storage (general purpose v1)
- BlobStorage
- Â What is Container?
- Â Types of Storages
- Blobs
- Data Lake Gen2
- Files
- Disks
- Queues
- Tables
Microsoft Azure SQL Databases
- Â What is Azure SQL
- Â Different deployments of SQL in Azure
- Â Creating Database along with Azure SQL Server
- Â Creating Another Database within the Existed Azure SQL Server
- Â Creating Tables and Feeding data in Azure
- Â Handling SQL/T-SQL with the following
- Â Client Tools
- Azure Client in Azure
- SQL Server Management Studio
- Azure Data Studio
- SQL Server Data Tools
- Migration of existed On Premise to Azure
- Â
Microsoft Azure Data ware House
- Â What is Warehouse
- Â What is Azure Data Warehouse
- Â Differences between Traditional Warehouseand Azure Data Warehouse
- Â Differences between SQL Server Database & Azure Data Warehouse
- Â Creating Azure Data Warehouse
- Â Querying Data from Azure Data Warehouse
- Creating Master Key
- Creating Scoped Credential
- Creating External Data Source
- Creating External File Format
- Creating External Table
- Â
Azure Data Factory
- Querying Data from Azure Data Warehouse
- Â Introduction
- Â Azure Data Factory vs SQL Server
- Â Integration Services
- Â Components Of Azure Data Factory
- Â Linked Services
- Data Sets
- Transformations
- Pipelines
- Activities
- Â Copy Data
- Â Creating Linked Services
- Â Creating Datasets
- Â Creating Pipeline with Copy Activity
- Â Running Pipeline
- Â Monitoring Pipeline
- Â Moving data from Blob to Azure SQL Server
- Â Moving data from SQL Server to Blob
- Â Configure different Types Of Integration Runtimes
- Â Azure Integration runtime
- Â Azure Self Hosted Integration Runtime
- Â SSIS Integration runtime
- Â Moving Data from Blob to On Premise SQL Server
- Â Moving Data from Blob to On Premise SQL Server
- Â Debugging and Monitoring Pipelines
- Â Web Activity
- Â Dataflow Activity transformations
- Source
- Sink
- Filter
- Select
- Conditional Split
- Derived Column
- Join
- Lookup
- Union
- Aggregate
- Â General Activities
- Stored procedure
- Â Moving data from Blob to Azure SQL Server
- Maintaining Metadata(Logging)
- Error handling and Logging error records
- Lookup
- Incremental Loading
- To get Configuration
- Get Metadata
- Set Variable
- Execute Pipeline
- Execute SSIS Package
- Delete
- Wait
- Â Iteration & Conditionals
- For Each
- If Condition
- Until
- Filter
- Â Version Control and Code Repository in Git Hub
- Â Deployment
- Â Azure Data Lake
- Â What is Data Lake
- Â Storing Data into Azure Data Lake Store
- Â Querying Data from Azure Data Lake Store to SQL Server
- Â Introduction to Azure Data Lake U-SQL
- Â Batch Job
- Â Data Lake Analytics
- Â Azure HD-insight
- Â U-SQL
- Â Basics Of Data bricks
- Â Basics Of Power BI with Azure
- Â
Â
Applications and Modules Administration
- Creating and modifying applications and modules and other related activities
- Limiting access of Applications and modules to specific set of roles
Introduction on Different Modules
- Incident Management
- Problem Management
- Change Management and it’s workflows
- Service Level Management
Change Management
- Different types of change requests and their significance
- Change Types and Respective workflows
- Risk Assessment Plugin activation
- Risk Questionnaires configuration and defining thresholds and conditions
Service Level Management
- SLA definitions and triggering conditions
- SLA schedules
- Retroactive start usage in SLA
- SLA workflow and Notifications on breach
Service Catalog
- Introduction to Items and Categories
- Introduction to Variables and Variable Sets.
- Creating workflows
- Associating workflows to Items
Email Notifications and Events
- Email notification creation(when to trigger, whom to trigger, What content to send)
- Templates utilization in email notification
- Events creation
- Email notification through events
- Email notification in workflow via notification and events
- Send to event creator usage
- Debugging mail sending issues
Import sets and Transform Maps
- Data load through excel
- Transform Mapping(Auto and Manual mapping)
- Scheduled Imports
CMDB and Discovery
- CMDB purpose in incident & problem & change request
- Data load using import sets into CMDB
- Different ways how data come into CMDB(importsets,discovery,3rd
- party CMDB integration)
- Discovery purpose
- Help the helpdesk in ServiceNow
- How to enable Discovery in Snow
Scripting Client Side scripting
- Client Scripts (Intro, How to write and use)
- UI Policy (Intro, How to write and use)
- UI Scripts
- UI Page
- UI Macros
- Server Side scripting
- UI Actions (Intro, How to write and use)
- Business Rules and Global Business Rules (Intro, How to write and use)
- Script Include
- Background Scripts
Update Sets
- Introduction to update set
- Creating an update set
- Using an update set
- Creating update source
- Retrieving update sets
- Moving changes between instances
- Advantages and best practices
Reports, Gauges and Homepage
- Creating Quick reports from lists
- Creating Reports, Gauges and Homepages
- Various types of reports and usage
- Scheduling reports
Integration with ServiceNow
- LDAP Integration
- SSO Integration
- Discovery Integration
- MID service Integration
- SAP Integration with ServiceNow
- ServiceWatch integration with ServiceNow
Service Portal
- Widget
- Page
- New Portal
Talk to Our Career Advisor
FAQ'S
Mastering Azure BI opens doors to a wide array of career opportunities, providing a competitive edge in the evolving data analytics industry.
Absolutely! The course emphasizes hands-on experience with Azure Stream Analytics, ensuring participants gain practical skills in real-time data insights.
The course includes projects covering ETL processes, building analytics pipelines, and creating models with Azure Analysis Services, providing a well-rounded learning experience.
Proximsoft provides dedicated job assistance, offering support in resume building, interview preparation to enhance their job placement prospects.
