Solution Architects learning catalog

Do you design solutions that meet your customers' needs and budgets?

The following catalog is organized from core knowledge to specific domains, and from most basic to most advanced. If content exists in multiple formats, we'll let you know, so that you can choose the training format that best meets your needs.

Get started

Content Description Format Length
Microsoft Power BI YouTube channel YouTube channel with content from Microsoft's Power BI product team Videos
Paul Turley's SQL Server BI Blog Sharing Paul Turley's experiences with the Microsoft data platform, SQL Server BI, Data Modeling, SSAS Design, Power Pivot, Power BI, SSRS Advanced Design, Power BI, Dashboards & Visualization since 2009 Blog
Guy in a Cube Video blog on Power BI including weekly information roundups and technical videos focusing on the Microsoft Business Intelligence stack (including Power BI, Reporting Services, and Analysis Services). Blog

Case Studies

Content Description Format Length
Proven Healthcare Solutions to Improve Both Patient Outcomes and Profitability Healthcare organizations face the challenge of turning vast amounts of data into patient insights, and those insights into action. Register for this webinar to learn how to design meaningful healthcare reports that will help your organization convert data into useful patient insights. Get expert strategies and advice from US Medical IT founder and CEO Stephen Cracknell, Director of Healthcare IT Stuart Macanliss, and Texas-based rheumatologist Dr. John P. Lavery. Webinar
Applied Intelligence for Sales & Service Customer experiences are the new competitive battleground. Consistent and relevant interactions unlock new value, increasing customer engagement, loyalty, and Learn how Avanade combines modern analytics, artificial intelligence, and automation to surface Next Best Action in context-whether in a marketing campaign, online customer self-service portal, or sales and service interactions. Webinar
Digital transformation in Manufacturing - leverage analytics to maximize profitability The fastest way to improve efficiency and profitability in manufacturing is to empower everyone, from the CEO to the line-technician, with real-time analysis of performance. Capturing your order-to-cash data isn't enough. Putting that data to work requires turning day-to-day transactions into visual elements that "touch a nerve.” In this webinar, Microsoft and Blue Margin, Inc. (Gold Partner in Data Analytics and Data Platform) will demonstrate how companies can transform into data-driven organizations in a matter of weeks. Hear directly from a $100M+ manufacturer who uses analytics to uncover the answers to difficult questions, and fix misalignments between production and demand. " Webinar
Deep dive into data modeling using Power BI desktop and SQL Server Analysis Services The Analysis Services model used in both Power BI Desktop and SSAS allows the solving of complex modeling issues. In this session, we will look at solving several complex modeling problems, like many-to-many, using the latest version of Power BI Desktop and Analysis Services. This is a "Level 300" webinar, and you'll need to have some understanding of Power BI Desktop and data modeling to get the most out of it. Webinar 1 hr 5 min 40 sec

Performance

Content Description Format Length
My Power BI report is slow: what should I do? by Marco Russo This session will guide you in analyzing the possible reasons for a slow Power BI report. By using Task Manager and DAX Studio, you will be able to determine whether you should change the report layout or if there is something in DAX formulas or in the data model that is responsible for the slow response. At the end of this session, you will understand how to locate a performance bottleneck in a Power BI report so you will focus your attention on the biggest issue. Webinar 34 min 35 sec