IT Training Courses IT Training Courses | Page 10

Microsoft Power BI Essentials Our range of Power BI training is suitable for beginners and advanced users alike. We deliver tutor-led Power BI courses at our training centre in Peterborough. We can also organise Power BI training courses on-site, anywhere in the UK. Our Microsoft business intelligence courses could help to transform your career and your organization’s data. Power BI Introduction Power BI Intermediate Power BI Advanced (2 days) (1 day) (2 days) Overview Overview Overview Our introduction to Power BI will familiarize users with the key features and operations of the Power BI suite. By the end of this course, delegates will be confident in using the three main components of Power BI: Power BI Desktop, the Power BI Service, and Power BI Mobile Apps. Our intermediate Microsoft Power BI training course delves deeper into the Query Editor and DAX formulas; it discusses Excel and PowerPoint integration; and shows delegates how to use custom visuals to construct interactive data narratives for their audience. Audience This course is aimed at those who are still new to Power BI. A basic familiarity with data analysis and database concepts is useful but not essential. This course is designed for users who are already familiar with Power BI and are looking to broaden their horizons when it comes to designing reports and dashboards. This course provides in-depth coverage of the Power Query M language as well as the use of advanced DAX formulas. Delegates will also learn how to improve the user experience through the use of parameter tables; how to optimize the data model by the strategic use of calculated tables; and how to work with advanced visuals and dashboard tiles. Key Topics Covered Key Topics Covered • Getting started • Parameters and Templates Key Topics Covered • Connecting to software services • Power Query Functions • The Power Query Formula Language • Getting data into Power BI • DAX Time Intelligence • Understanding Automatically • Cleaning up and transforming data • What If Parameters • Data modelling • Excel Integration • Creating custom functions in M • Using DAX • Custom visuals • Iteration Techniques • Creating reports • Business narration • Advanced DAX • Creating visualizations • PowerPoint integration • Working with calculated tables Audience Audience Aimed at experienced Power BI users looking for guidance on the more challenging aspects of Power BI. Generated Code • Publishing content • Using parameter tables • Creating Power BI Mobile Content • Using ArcGIS Maps for Power BI • Consuming and customizing content • Using R Visualizations and Datasets • Refreshing content • Advanced dashboard tiles “ Excellent introduction to Power BI. Thorough and at a good pace for everyone. ” Richard Willis Head of Analytics and Insight, Essentra plc - 10 - G Com Solutions Limited 0800 998 9248 www.gcomsolutions.co.uk