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
Delivery Options
Private Group Training
Our identity is rooted in delivering exactly what our clients need.
- Pre-course call with your trainer
- Customisation of the learning experience to achieve your goals -
- Bespoke outlines
- Practical hands-on exercises containing data / scenarios recognisable to the learners
- Training scheduled on a date of your choice
- Delivered online, onsite/classroom or hybrid by experts sharing real world experience
Private Group Prices RRP from €11400 online delivery, based on a group of 2 delegates, €3600 per additional delegate (excludes any certification / exam costs). We recommend a maximum group size of 12 for most learning events.
Contact us for an exact quote and to hear our latest promotions
Public Training
Please see our public courses
Testimonials (4)
very friendly and helpful
Aktar Hossain - Unit4
Course - Building Microservices with Microsoft Azure Service Fabric (ASF)
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
All good, nothing to improve
Ievgen Vinchyk - GE Medical Systems Polska Sp. Z O.O.
Course - AWS Lambda for Developers
IOT applications