Class Description
BI Quick Start provides a hands-on lab environment. In 5-days, Participants will build a fully functional prototype data warehouse using SQL Server along with the complete Microsoft BI Platform: SSIS, SSAS, SSRS and Power BI.
Course Benefits
- The Microsoft BI platform from top to bottom; Best practices of modeling a data warehouse
- Proficiency with the BI developer tools that will accelerate Students projects and improve Students solutions
- Readiness to undertake the toughest BI projects for Students organization
Suggested Prerequisites
A computer will be provided for lab work. There are no additional system requirements for this course.
Course Outline
- Creating the Data Model
- Loading Dimensions
- Loading Fact Tables
- Package Deployment
- Cube Design
- Creating MDX Calculations
- Creating KPI’s
- SSRS Reports
- Power Pivot
Related Classes
- Acrobat 101 – Adobe Acrobat for Professionals
- Acrobat 201 – Adobe Acrobat – eForms Introduction
- AWS 101 – AWS Business Essentials
- AWS 110 – AWS Technical Essentials
- AWS 201 – Architecting on AWS
- AWS 210 – Advanced Architecting on AWS
- AWS 220 – Certification Exam Readiness Workshop: Certified Solutions Architect – Associate
- AWS 230 – Certification Exam Readiness Workshop: Certified Solutions Architect – Professional
- AWS 301 – Developing on AWS
- AWS 410 – Systems Operations on AWS
Our goal is to make sure your class meets your objectives, not ours. Therefore, all of our outlines are treated as guides to help steer the workshop. This outline does not guarantee that all the topics listed will be covered in the time allowed. The amount of material covered is based on the skill level of the student audience. We may change or alter course topics to best suit the classroom situation.
Locations