ANALYZING AND VISUALIZING DATA WITH POWER BI

INTRODUCTION FOR ANALYZING AND VISUALIZING DATA WITH 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/ 2019.

LEARNING OUTCOMES

After completing this course, students will be able to:

• Import Data from several of the data source.
• Structuring, 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.

COURSE CONTENT

Level 1: Data Cleansing with Power Query

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

Level 2: Data Analyze & Visual with Power BI

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