Power Bi Fundamentals

This course is designed to provide participants with a fundamental understanding of the capabilities of Power BI. Students will discover how to quickly gather, clean, and transform data with just a few clicks.

They will also learn how to enhance results by integrating disparate data sources and adding simple calculations using DAX functions and queries.

Participants will create visualizations and incorporate them into dashboards that can provide up-to-the minute reporting. At the end of this course, participants will have a solid understanding of the skills required to use Power BI Desktop.

Power BI Desktop Topics

• What is business intelligence? Why do I need it?
• Getting Started with Power BI desktop
• Explore the Power BI interface:
• Get data from wherever it exists!
• Power BI data Sources
• Connecting to Excel Data
• Connecting to CSV file
• Connecting to an Access database
• Shaping Combining and Merging Data
• Reducing Data with Query Editor
• Transforming Data
• Inserting Custom Columns
• Appending Data to a Query
• Adding an Index Column
• Cleaning up Data
• Creating relationships between tables
• Merging data
• Using lookup tables in a dataset
• Create visualizations and reports.
• Creating and arranging Visualizations21. Creating textual visuals, Cards, tables, and matrixes
• Creating and formatting chart visuals
• Using a slicer to filter visuals
• Creating a map visualization
• Publish to Power BI services