Microsoft On-Demand: Power BI for Excel Users

2 DaysLive Online & In-CenterInstructor-led since 1983Course Code: GPBEX1

Course overview

*** This is an On-Demand (self-study) course, 180-day, 24/7 access via the internet *** (Applicable State and Local taxes may be added for On-Demand purchases, depending on your location.) You may take this course at any time; there are no set dates. This On-Demand (self-study) training course includes expert lectures, demonstrations and exercises. Note: The 180-day course access period begins at time of purchase. The main purpose of the course is to review the essential skills needed to take data from Excel into Power BI then transform and shape the data, model the data, create reports, then publish the reports on the Power BI cloud service.

Who this is for

The course is for individuals who are not IT professionals but need to easily create and publish reports with Power BI**

Prerequisites

Before attending this course, students should have experience creating worksheets in Excel. Familiarity with Pivot Tables is a plus, but is not required. What You Need to Take this Training A Windows machine with Excel installed and a high-speed internet connection. Looking for a Live, Instructor-led Class Instead? If self-study training is not right for you, we have this same course in a live, instructor-led format. For instructor-led training click the below link: Power BI Introduction for Excel Users **Note** While this course is designed for average end users needing to learn essential Power BI skills, we also offer a more in-depth 3-day course titled PL-300: Power BI Data Analyst. It is for IT professionals and power users who want a deeper dive into the material and/or who are preparing to pass the related Microsoft certification exam. For details, visit: Instructor-led: PL-300: Power BI Data Analyst Duration You have 24/7 access for 180-days to this digital course that includes 5h 16m of video presentation. As a traditional course it would be a 2-day class.

Course outline

Getting started Introducing Power BI A quick look at Power BI Desktop A quick look at the Power BI service Power BI and Excel Introduction to using Excel data in Power BI Upload Excel data to the Power BI service Using Excel as a Data Source Import Power View and Power Pivot to Power BI Getting Data Data Sources in Power BI Desktop Connect to data sources in Power BI Desktop More advanced data sources and transformation Connect to SQL Server in Power BI Desktop Connect to CSV files in Power BI Desktop Shaping and Transforming Data Introduction to the Query Editor Clean and transform your data with the Query Editor Cleaning irregularly formatted data Modeling Data Introduction to modeling your data How to manage your data relationships Optimizing data models Introduction to DAX DAX functions Calculated columns in DAX Calculated measures in DAX Create calculated tables Visualizations Introduction to visuals in Power BI Create and customize simple visualizations Combination Charts Modify colors in charts and visuals Text boxes, shapes, and smart narratives Page layout and formatting Group interactions among visualizations Visual hierarchies and drill-down Using custom visualizations R integration in Power BI Desktop Publishing and Sharing Introduction to the Power BI service Publish Power BI Desktop Reports Create and configure a dashboard Share dashboards with your organization Quick insights in Power BI Ask questions of your data with natural language Create custom Q&A suggestions Create workspaces in Power BI Manually republish and refresh your data Install and configure a personal gateway Export dashboards and reports to PDF Printing from the Power BI Service Publish to web from Power BI

Download outline as PDF →

$495

Live Online & In-Center