Power BI is Microsoft’s play into the growing Business Intelligence reporting space, and they have created an incredible tool worthy of your attention. If your reporting requirements are more serious, that is you work with larger volumes of data, your data updates frequently, you create external facing reports/dashboards and need to share/publish your data online or via company intranets then Power BI may be your best option for building robust MI. We asked highly experienced BI Consultant, Andrew Ward to create this course and to bring you to an intermediate level of expertise. Andrew will guide you step by step and help you to create high value dashboards and reports by the end of this course
Course Curriculum
(Click for details)
MODULE 1: INTRODUCTION TO POWER BI
1.1 The Power BI Interface 1.2 The Three main views in Power BI 1.3 Getting Familiar with Power BI
MODULE 2: WORKING WITH DATA IN POWER BI
2.1 Connecting to Excel Data 2.2 Getting familiar with Power Query 2.3 Building & Cleaning a Date Table
MODULE 3: DATA ANALYSIS WITH POWER BI
3.1 Understanding relationships 3.2 Introduction to calculations 3.3 Working with measures 3.4 Measure for total profit 3.5 Measure for previous year profit 3.6 Using a slicer to filter dates
5.1 Introduction to Sharing & Publishing Dashboards 5.2 Building Dashboards in Myworkspace 5.3 Refreshing Data sources 5.4 The benefits of reports 5.5 Pinning a Dashboard 5.6 Sharing your Dashboard 5.7 The Power BI Community 5.8 Outro and next steps