Analyzing & Visualizing Data using Power BI

This course is taught to publish those reports to the Power BI service, create dashboards, and share to business users so that they can consume the dashboards through the web and their mobile devices. Microsoft Power Query is an Excel add-in that enhances the self-service Business Intelligence experience in Excel by simplifying data discovery, access and collaboration. With Power Query, non-technical Excel users can access large corporate and Internet-based databases to conduct analysis and produce reports.

Power Query is an add-in program for Excel 2010 and Excel 2013. Its features are also integrated into Excel 2016.

After completing this Power BI course, participants should be able to:

• Import Data from several of the data source.
• Structure unstructured data (Data Cleansing)
• Prepare data for analyzing and visualizing.
• Perform Power BI desktop data transformation.
• Describe Power BI desktop modelling.
• Create a Power BI desktop visualization.
• Describe how to connect to Excel data.
• Describe how to collaborate with Power BI data.

Excel Introduction or Intermediate Level. Previous experience with database concepts is helpful but not required. Basic exposure to programming constructs (such as looping and branching).

Module 1: Introduction to Power Query

• Installing Power Query
• Creating a Simple Query
• Editing a Simple Query

Module 2: Common Data Import Sources

• Working with CSV files
• working with Text Files
• Working with Excel Files
• Working with other file types

Module 3: Working with Data from the Web

• Scraping Data from Web Pages
• Calling a Web Service
• Finding Data Using a Power Query Online Search

Module 4: Working with Folders and Multiple Files

• Working from Data from the Windows File System
• Combining Data from Multiple Files

Module 5: Filtering and Sorting Rows

• Using Auto-Filter
• Using Number, Text and Date Filters
• Filtering Rows by Range
• Removing Duplicate Values
• Filtering out Rows with Errors
• Sorting

Module 6: Changing Values in a Table

• Replacing Values
• Text Transformations
• Number Transformations
• Date/Time Transformations
• Replacing Missing Values

Module 7: Table Transformations

• Unpivoting Columns to Rows
• Transposing a Table
• Creating Custom Columns

Module 1: Introducing Power BI

Getting started with Power BI

Uploading data to Power BI

Introducing natural-language queries

Introducing Quick Insights

Introduction to reports

Introducing Visual Interactions

Decorating the report

Saving the report

Pinning a report

Filtering a report

Module 2: Sharing the dashboard

• Inviting a user to see a dashboard
• Inviting users outside your organization
• Creating a group workspace in Power BI
• Turning on sharing with Microsoft OneDrive for Business
• Viewing reports and dashboards on mobile devices

Module 3: Using Power BI Desktop

• Connecting to a database
• Loading from multiple sources
• Using Query Editor
• Hiding or removing tables
• Handling seasonality and sorting months

Module 4: Improving Power BI reports

• Choosing the right visualizations
• Choosing between standard visuals
• Using custom visualizations
• First steps with custom visualizations
• Improving reports by using custom visualizations
• Identifying conditions when custom visualizations are required
• Using DAX in data models
• Creating high-density reports

Module 5: Power BI and Excel

• Excel and Power BI
• Import an Excel table into Power BI
• Import Excel files with data models and Power View sheets
• Connect OneDrive for Business to Power BI
• Excel data in Power BI summary

• Fundamentals of Power BI Desktop
• Integrating Microsoft® Excel Power Query Technology
• Introduction to Power Business Intelligence with Excel 2010
• Business Intelligence with Microsoft® Excel 2010 & PowerPivot - Level 2
• Microsoft® Excel for Intermediate/Advance User
• More other Information Technology related courses