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.
TARGET AUDIENCE
This course is for individuals whose job responsibilities include creating complex Excel reports, as well as conducting advanced analytics and data science.
COURSE OBJECTIVES
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.
PREREQUISITES
Excel Introduction or equivalent skills. Previous experience with database concepts is helpful but not required.
COURSE OBJECTIVES
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
