Analyzing and Visualizing Data with Power BI

Course Length: 2 days (In house)

Course Overview:
This course is taught to publish those reports to the Power BI service, create dashboards, and share with 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.

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 modeling.
• Create a Power BI desktop visualization.
• Describe how to connect to Excel data.
• Describe how to collaborate with Power BI data.

Target Audience:
This course is for individuals whose job responsibilities include creating complex Excel
reports, as well as conducting advanced analytics and data science.

Prerequisites:
Excel Introduction or equivalent skills. Previous experience with database concepts is
helpful but not required.