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
Custom Corporate Training
Training solutions designed exclusively for businesses.
- Customized Content: We adapt the syllabus and practical exercises to the real goals and needs of your project.
- Flexible Schedule: Dates and times adapted to your team's agenda.
- Format: Online (live), In-company (at your offices), or Hybrid.
Price per private group, online live training, starting from 7250 € + VAT*
Contact us for an exact quote and to hear our latest promotions
Testimonials (2)
All of the training was great. Especially liked the training documentation to reference. Looking forward to the Advanced Training, when we are ready.
Amy Gregg - Qualfon
Course - Boomi Integration Fundamentals
I've find out new interesting things about Lambda and Serverless