Microsoft On-Demand Bundle: Power BI for Excel Users & Power BI Intermediate

Description

*** 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 Power BI for Excel Users 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. The Power BI Intermediate course is intended as a continuation of the introductory-level courses in Power BI (DA-100: Analyzing Data with Power BI and/or Power BI for Excel Users). It covers common intermediate-level tasks and some of Power BI’s most desirable new features.

Prerequisites

Students should have experience creating worksheets in Excel. Familiarity with Pivot Tables is a plus, but is not required. Before moving to the Intermediate class, students should have the general knowledge equivalent to what is covered in: Power BI for Excel Users or DA-100: Analyzing Data with Power BI. What You Need to Take this Training A Windows machine with Excel installed and a high-speed internet connection. Do You Still Prefer a Live, Instructor-led Class? Already know On-Demand, self-study training is not right for you? We also offer this same course content in a live, instructor-led format. For more details, click on the link below: <a href=https://www.onlc.com/power-bi-training-classes.htm>Power BI Training Classes</a> **Note: While this course is designed for average end users needing to learn essential Power BI skills, we also offer a more in-depth 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: <a href=https://www.onlc.com/outline.asp?ccode=apl300> PL-300: Power BI Data Analyst (Instructor-led Class)</a> Course Outlines: - Power BI for Excel Users 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 View outline in Word - Power BI Intermediate Course Outline - Intermediate Power Query Import Data from PDFs Connect to webpages from Power BI Desktop Get webpage data by providing examples Combined files (binaries) in Power BI Desktop Use Fuzzy Matching to Combine Disparate Data Sets Using Data Profiling Add a Column from Examples Add a Custom Column with M Intermediate Data Modeling Create and use What-If Parameters to Visualize Variables  Using Grouping and Binning in Power BI Desktop Set and user Date Tables in Power BI Desktop Use Quick Measures for Common Calculations Script Visuals Create R Visuals in Power BI Desktop R Integration: Installing an R Environment Create Python Visuals in Power BI Desktop Python Integration: Installing Python Advanced Report Design Using Report Themes in Power BI Desktop  Use Conditional Formatting in Tables  Using Drillthrough in Power BI Desktop Adding Data-Driven Images to Power BI Reports Using Parameters Create and Use Report Templates in Power BI Desktop Advanced Dashboard Design Use Dashboard Themes in the Power BI Service Import and Display KPIs in Power BI KPI Visuals The Multi KPI Visual The UNICHAR Function  Analytics A tiny introduction to machine learning and predictive analysis in Power BI Forecasting with ARIMA Visualizing and Operationalizing R Data in Power BI Desktop