Business Intelligence with Microsoft Azure and Microsoft Power BI – data warehousing, database building, and data visualisation from reports

Training process

Training needs analysis

If you have specific requirements regarding the training programme, we will carry out a training needs analysis for you. This will guide us on which aspects of the programme should receive greater emphasis, so that the training programme meets your specific needs.

What will you gain?

Navigate Azure with confidence - You will understand cloud models, IaaS, PaaS and SaaS services, and how to work in Azure Portal, so you can implement BI solutions in the Microsoft ecosystem more effectively.

Build a secure data environment - You will learn to use Azure Active Directory, Key Vault and monitoring features, allowing you to set up a data environment with proper access control, auditing and protection.

Work effectively with Data Lake - You will master data organization in Azure Data Lake Storage, file management and core data lake architecture, helping you build a well-structured foundation for analytics.

Use Azure SQL in practice - You will learn how to create, scale and maintain databases in Azure SQL Database, and how to plan backup and recovery, so your reporting and analytics sources stay reliable.

Automate data flows - You will learn to use Azure Data Factory and Logic Apps for copying, transforming and integrating data across services, helping you reduce manual effort in data processes.

Process large data sets - You will explore Azure Databricks fundamentals and see how to analyze large data volumes and connect them with other Azure services to prepare data for advanced analytics work.

Improve Power BI models and diagnostics - You will work with Power BI External Tools such as ALM Toolkit, Tabular Editor and DAX Studio, so you can refine semantic models, optimize DAX and manage changes more cleanly.

Compare Azure and Fabric wisely - You will understand when to choose Azure services and when Microsoft Fabric is a better fit, how capacity works, and what the key differences are for BI architecture and cost planning.

Training programme

1. Introduction to the cloud

definition and basic concepts of cloud computing,
cloud deployment models: public, private, hybrid,
cloud service models: IaaS, PaaS, SaaS,
benefits and challenges related to cloud computing.

2. Introduction to Microsoft Azure

overview of the Microsoft Azure platform,
key Azure services and features,
creating an account and basic navigation in the Azure Portal,
Azure Resource Manager: resource management.

3. Security and permissions in Azure

basic security principles in the cloud,
access and identity management: Azure Active Directory,
Azure Key Vault: secure storage of keys and secrets,
monitoring and auditing in Azure.

4. Cost management in Azure

planning and controlling costs in Azure,
tools for cost management,
cost-saving and expenditure optimization practices,
tracking and reporting costs.

5. Data storage and management

Azure Data Lake Storage,
introduction to Azure Data Lake Storage,
Data Lake architecture and functionalities,
file and data management in Data Lake.

6. Cloud database

Azure SQL,
introduction to Azure SQL Database,
creating and managing databases in Azure SQL,
scaling and performance in Azure SQL,
backups and data restoration.

7. Tools for copying and moving data

Azure Data Factory,
introduction to Azure Data Factory,
data copying and transformation,
integration with other Azure services.

8. Processing large amounts of data

Azure Databricks,
introduction to Azure Databricks,
architecture and basic Databricks functions,
processing and analysis of big data,
integration with other Azure services.

9. Integration of services in Azure

Azure Logic Apps,
introduction to Azure Logic Apps,
creating and managing workflows,
integration with various services and systems,
practical examples of using Logic Apps.

10. Data visualization

Power BI – External Tools,
introduction to external tools in Power BI,
ALM Toolkit,
Tabular Editor,
DAX Studio.

11. Creating Capacity and comparing services

Fabric,
introduction to Microsoft Fabric,
creating and managing Capacity,
overview of Fabric functionality,
comparison of Fabric with Azure services.

What are the prerequisites for participating in the training?

Basic data handling - You should be comfortable working with tables, files and common data formats, so you can more easily follow data loading, storage and integration across Azure services.

Relational database basics - You should understand relational database concepts such as tables, relationships and simple queries, because the training includes Azure SQL and reporting data sources.

Power BI fundamentals - You should know the Power BI interface and understand reports, data models and measures, because the training covers external tools and semantic model development.

Confident computer use - You should be comfortable using a web browser, desktop applications and basic system settings, so you can work efficiently in Azure Portal and Power BI tools.