Microsoft Power BI Home / Courses / Microsoft Power BI PST, Application Classroom Length: 3 day Times: 9:00 AM – 4:30 PM Course Outline Lesson 1: Analyzing Data with Self-Service BI Topic A: Data Analysis and Visualization for Business Intelligence Topic B: Self-Service BI with Microsoft Power BI Lesson 2: Connecting to Data Topic A: Create Data Connections Topic B: Model Data with Relationships Topic C: Save Power BI Files Lesson 3: Performing Advanced Data Modeling and Shaping Topic A: Clean and Transform Data with the Query Editor Topic B: Shape Data with the Query Editor Topic C: Combine and Manage Data Rows Lesson 4: Visualizing Data with Power BI Topic A: Create Visualizations in Power BI Topic B: Chart Data in Power BI Lesson 5: Enhancing Data Analysis Topic A: Enhance Analysis with Customized Visuals and Pages Topic B: Enhance Analysis with Tooltips Lesson 6: Modeling Data with Calculations Topic A: Create Calculations with Data Analysis Expressions (DAX) Topic B: Create Calculated Measures and Conditional Columns Lesson 7: Creating Interactive Visualizations Topic A: Create and Manage Data Hierarchies Topic B: Filter and Slice Reports Topic C: Create Dashboards in Power BI Lesson 8: Performing Advanced Analysis Topic A: Create Calculated Tables, Variables, and Parameters Topic B: Enhance Visuals with Statistical Analysis Topic C: Review Analysis Services Connection Options Lesson 9: Publishing and Sharing Reports and Dashboards Topic A: Publish Reports Topic B: Share Reports and Dashboards Lesson 10: Extending Access to Power BI Topic A: Access Reports Using Power BI Mobile Topic B: Extend Access with the Power BI API Appendix A: Mapping Course Content to the Analyzing and Visualizing Data with Microsoft® Power BI® Certification Objectives COURSE DESCRIPTION: Upon the completion of this course, as a trained professional, you can enter Power BI which is a set of tools and applications that let you extract data from multiple unrelated sources and convert it into neatly managed and coherent set of information, visually appealing insights, interactive data, charts, graphs, and reports. Learn to perform powerful data analysis and create sophisticated data models with Microsoft's Power BI tools. Power BI is a suite of business intelligence tools that analyzes your data and shares insights. With courses on the fundamentals through to more advanced sessions on Power Pivot and Power Query, you will learn how to provide your team with the metrics they need, all in one place, updated in real-time on all of their devices. IDEAL CANDIDATES/PREREQUISITES: To ensure your success, you should have experience managing data with a spreadsheet program such as Microsoft Excel or Google Sheets. To meet this prerequisite, you can take any one or more of the following Logical Operations courses: Microsoft® Office Excel® 2016: Level 1 (Desktop/Office 365™) Microsoft® Office Excel® 2016: Level 2 Using Google G Suite™ RELATED COURSES: Excel Level 1, Excel Level 2, Excel Level 3, Excel Pivot Tables, Excel Power Pivot, Excel VBA Access Level 1, Access Level 2, Access Level 3, Office 365, Outlook Level 1, Outlook Level 2, PowerPoint Level 1, PowerPoint Level 2, Project Level 1, Project Level 2, Publisher, SharePoint Site Administrator, SharePoint Site Owner, SharePoint Site User, Visio Level 1, Visio Level 2, Word Level 1, Word Level 2, Word Level 3