Business Intelligence - SQL Server e Analysis Services

Come and master Analysis Services! This course is designed for beginners with no prior experience in OLAP (Online Analytical Processing) or Analysis Services. We'll guide you through building your first cubes from scratch.

Here's what you'll learn:

• Setting up your environment: We'll walk you through installing SQL Server and the necessary Data Tools, starting from the ground up.
• Cube Creation: Learn the step-by-step process of creating cubes, analyzing fact tables and dimension tables.
• Data Export: We'll cover exporting your completed work to a server for analysis.
• OLTP vs. OLAP: Understand the difference between OLTP (Online Transactional Processing) and OLAP (Online Analytical Processing) databases. We'll install example databases of both types.
• Security with Roles: Explore the crucial aspect of cube security and how to manage access using Roles.
• Practical Project: We'll start with a Microsoft sample database to familiarize you with the tools.
• Building Your Own Database: Then, you'll create your own database in SQL, laying the foundation for your Analysis Services semantic layer.
• Mastering the Time Dimension: Discover the importance of the Time Dimension – a cornerstone of any successful BI (Business Intelligence) project.

Who is this course for?

• Absolute Beginners: If you've never worked with an OLAP tool or Analysis Services, this is the perfect starting point.
• Students: Gain a practical understanding of OLAP environments for your studies.
• Anyone new to BI: Get hands-on experience with a powerful tool for data analysis.

Important Note: This course is not for those with existing Analysis Services experience. It's specifically tailored for individuals who need a clear, easy-to-follow introduction to the world of OLAP and Analysis Services.

See you in class!

– Mafra