Data Analytics Process, Cloud Solutions, and Power BI Solutions Training Course
Data analysis refers to the process of obtaining, cleaning, and analyzing data, often times in a visual manner, to derive insights for better decision making. More and more data is being stored in databases in the cloud so it is important to have a strategy for understanding, managing and accessing such data. One popular tool for accessing and visualizing data is Power Bi.
This instructor-led, live training (online or onsite) is aimed at technical persons who wish to gain a practical understanding of available cloud solutions, the data analysis processes needed to work with data in the cloud, and the hands-on practice to apply tools such as Power BI to analyze data.
By the end of this training, participants will be able to:
- Install and configure Power BI.
- Evaluate the various data solutions offered by cloud providers such as Azure.
- Gain an understanding of the different structures, modeling approaches, and data warehouse designs used to store, manage and access Big Data.
- Apply tools and techniques to clean data in preparation for analysis.
- Build reporting and analytics solutions based on on-premise as well as cloud data.
- Integrate data analytics solutions with a data warehouse.
- Mitigate data security risks and ensure data privacy.
Format of the Course
- Interactive lecture and discussion.
- Lots of exercises and practice.
- Hands-on implementation in a live-lab environment.
Course Customization Options
- To request a customized training for this course, please contact us to arrange.
Course Outline
Introduction
Overview of On-Premise and Cloud-Based Data Storage and Analysis Solutions
Understanding Big Data
- Big Data criteria
- Big Data structure
- Working with Big Data
Cloud Solutions
- Azure SQL Database
- Azure Data Warehouse
- Azure Data Factory
- Azure Databricks
- Power BI
Working with Databases
- Data warehouse design
- Dimensional modelling
- Implementation and deployment
Data Models - A Comparison
- SSAS Tabular Data Models
- SSAS Multidimension Models
- Power BI Models
Data Cleansing
- Strategies and tools
Report Models
- Building Power BI tabular models
- Understanding DAX
PowerBI Reports
- Designing Power BI reports
Power BI Architecture
- Workspace generation
- Licensing
- Permissions
Administration
- Administering Azure solutions
- Administering the Power BI Service
Security
- Maintaining a secure Azure architecture
- Azure SQL Database/Data Warehouse, Data Factory and Data Bricks
- Data Masking and Privacy Issues
Summary and Conclusion
Requirements
- Experience with elementary data analysis (e.g., Excel).
- A general understanding of cloud concepts (e.g., AWS).
Audience
- Database engineers
- Developers
Open Training Courses require 5+ participants.
Data Analytics Process, Cloud Solutions, and Power BI Solutions Training Course - Booking
Data Analytics Process, Cloud Solutions, and Power BI Solutions Training Course - Enquiry
Data Analytics Process, Cloud Solutions, and Power BI Solutions - Consultancy Enquiry
Consultancy Enquiry
Testimonials (5)
very friendly and helpful
Aktar Hossain - Unit4
Course - Building Microservices with Microsoft Azure Service Fabric (ASF)
Amount of Information, Exercises
Lukasz Kowalski - Sii Sp. z o.o.
Course - AWS IoT Core
Machine Translated
The manual serverless setup. Also, I had no Idea sls web console exits, which is nice.
Rafal Kucharski - The Software House sp. z o.o.
Course - Serverless Framework for Developers
IOT applications
Palaniswamy Suresh Kumar - Makers' Academy
Course - Industrial Training IoT (Internet of Things) with Raspberry PI and AWS IoT Core 「4 Hours Remote」
Later the balance between theory and practice was much better. But the beginnings were terrible. The way of expressing (language) is very calm, understandable, in a human way.
Lukasz Derkowski - NetworkedAssets Sp. z o.o.
Course - AWS CloudFormation
Machine Translated
Provisional Courses
Related Courses
Advanced Amazon Web Services (AWS) CloudFormation
7 HoursThis instructor-led, live training in Poland (online or onsite) is aimed at cloud engineers and developers who wish to use CloudFormation to manage infrastructure resources within the AWS ecosystem.
By the end of this training, participants will be able to:
- Implement CloudFormation templates to automate infrastructure management.
- Integrate existing AWS resources into CloudFormation.
- Use StackSets to manage stacks across multiple accounts and regions.
Amazon DynamoDB for Developers
14 HoursThis instructor-led, live training in Poland (online or onsite) is aimed at developers who wish to integrate a DynamoDB NoSQL database into a web application hosted on AWS.
By the end of this training, participants will be able to:
- Set up the necessary development environment to start integrating data into DynamoDB.
- Integrate DynamoDB into web applications and mobile applications.
- Move data in AWS with AWS services.
- Implement operations with AWS DAX.
Tworzenie rozwiązań IoT z wykorzystaniem Amazon Web Services
28 HoursThe "Creating IoT solutions using Amazon Web Services" training focuses on presenting AWS services in the context of creating IoT solutions. Participants will gain skills in using the management console, the AWS CLI tool, and learn about the AWS architecture. The course covers the AWS IoT Core service, defining devices, generating certificates, and establishing secure communication. Additionally, participants will learn how to integrate IoT Core with various AWS services, including SNS, SQS, DynamoDB, S3, API Gateway, AWS Lambda, as well as how to integrate IoT with artificial intelligence services such as Rekognition and Texttract.
AWS IoT Core
14 HoursThis instructor-led, live training in Poland (onsite or remote) is aimed at engineers who wish to deploy and manage IoT devices on AWS.
By the end of this training, participants will be able to build an IoT platform that includes the deployment and management of a backend, gateway, and devices on top of AWS.
Amazon Web Services (AWS) IoT Greengrass
21 HoursThis instructor-led, live training in Poland (online or onsite) is aimed at developers who wish to install, configure, and manage AWS IoT Greengrass capabilities to create applications for various devices.
By the end of this training, participants will be able to use AWS IoT Greengrass to build, deploy, manage, secure, and monitor applications on intelligent devices.
Building Microservices with Microsoft Azure Service Fabric (ASF)
21 HoursThis instructor-led, live training in Poland (online or onsite) is aimed at developers who wish to learn how to build microservices on Microsoft Azure Service Fabric (ASF).
By the end of this training, participants will be able to:
- Use ASF as a platform for building and managing microservices.
- Understand key microservices programming concepts and models.
- Create a cluster in Azure.
- Deploy microservices on premises or in the cloud.
- Debug and troubleshoot a live microservice application.
Certified Cloud Security Professional (CCSP) - training
35 Hours___ is ___.
This instructor-led, live training (online or onsite) is aimed at beginner-level / intermediate-level / advanced-level ___ who wish to use ___ to ___.
By the end of this training, participants will be able to:
- Install and configure ___.
- ___.
- ___.
- ___.
Format of the Course
- Interactive lecture and discussion.
- Lots of exercises and practice.
- Hands-on implementation in a live-lab environment.
Course Customization Options
- To request a customized training for this course, please contact us to arrange.
AWS CloudFormation
7 HoursThis instructor-led, live training in Poland (online or onsite) is aimed at engineers who wish to use AWS CloudFormation to automate the process of managing AWS cloud infrastructure.
By the end of this training, participants will be able to:
- Enable AWS services to get started managing infrastructure.
- Understand and apply the principle of "infrastructure as code".
- Improve quality and lower the costs of deploying infrastructure.
- Write AWS CloudFormation Templates using YAML.
Fn Project
7 HoursThis instructor-led, live training in Poland (online or onsite) is aimed at programmers and developers who wish to use Fn in creating serverless applications and services.
By the end of this training, participants will be able to:
- Set up Fn to create directories and functions.
- Create applications using different programming languages.
- Monitor functions to resolve issues at the development and deployment stages.
Industrial Training IoT (Internet of Things) with Raspberry PI and AWS IoT Core 「4 Hours Remote」
4 HoursSummery:
- Basics of IoT architecture and functions
- “Things”, “Sensors”, Internet and the mapping between business functions of IoT
- Essential of all IoT software components- hardware, firmware, middleware, cloud and mobile app
- IoT functions- Fleet manager, Data visualization, SaaS based FM and DV, alert/alarm, sensor onboarding, “thing” onboarding, geo-fencing
- Basics of IoT device communication with cloud with MQTT.
- Connecting IoT devices to AWS with MQTT (AWS IoT Core).
- Connecting AWS IoT core with AWS Lambda function for computation and data storage.
- Connecting Raspberry PI with AWS IoT core and simple data communication.
- Alerts and events
- Sensor calibration
Industrial Training IoT (Internet of Things) with Raspberry PI and AWS IoT Core 「8 Hours Remote」
8 HoursSummary:
- Basics of IoT architecture and functions
- “Things”, “Sensors”, Internet and the mapping between business functions of IoT
- Essential of all IoT software components- hardware, firmware, middleware, cloud and mobile app
- IoT functions- Fleet manager, Data visualization, SaaS based FM and DV, alert/alarm, sensor onboarding, “thing” onboarding, geo-fencing
- Basics of IoT device communication with cloud with MQTT.
- Connecting IoT devices to AWS with MQTT (AWS IoT Core).
- Connecting AWS IoT core with AWS Lambda function for computation and data storage using DynamoDB.
- Connecting Raspberry PI with AWS IoT core and simple data communication.
- Hands on with Raspberry PI and AWS IoT Core to build a smart device.
- Sensor data visualization and communication with web interface.
OpenFaas for Developers
14 HoursThis instructor-led, live training in Poland (onsite or remote) is aimed at developers who wish to use OpenFaas to create, build, test, debug and deploy event-driven functions without needing to worry about managing the underlying server infrastructure.
By the end of this training, participants will be able to:
- Install and configure OpenFaas.
- Package any binary or code as a serverless function without repetitive boiler-plate coding.
- Decouple from AWS Lambda to avoid lock-in.
- Deploy event-driven functions to an on-premise server or to the cloud.
Parallel Programming with OpenMP
14 HoursThis instructor-led, live training in Poland (online or onsite) is aimed at software engineers who wish to develop parallel applications using OpenMP.
By the end of this training, participants will be able to:
- Understand and use parallel programming with Fortran in OpenMP.
- Calculate fractals in parallel to render multiple pixels and characters.
- Implement vector programming with SIMD extensions for HPC systems.
- Add parallel blocks for specifying shared memory parallelism.
Serverless Framework for Developers
14 HoursThis instructor-led, live training in Poland (onsite or remote) is aimed at developers who wish to use Serverless Framework on AWS and other cloud platforms to create and deploy microservice applications.
By the end of this training, participants will be able to:
- Set up Serverless Framework to work with compute services such as AWS Lambda.
- Reduce the complexity and cost of deploying microservices on different cloud platforms.
- Emit and capture events and execute functions automatically.
Serverless on Kubernetes Fundamentals
21 HoursThis instructor-led, live training in Poland (online or onsite) is aimed at developers and DevOps engineers who wish to utilize a serverless approach for building enterprise applications in Kubernetes.
By the end of this training, participants will be able to:
- Setup and configure the Kubernetes system to start developing with a serverless architecture.
- Understand the concepts and principles foundational to serverless environments.
- Operate toolchains necessary to serverless development and integrate it with Kubernetes components.
- Practice their skill in Python programming language and apply it to implement serverless systems.
- Secure enterprise applications that are deployed through a serverless framework on Kubernetes.
- Utilize modern cloud computing methods in optimizing DevOps task processing workflows.