POWER BI END USERS – ONE DAY

Prerequisites:

Participants should have a strong knowledge of Excel 2010, 2013 or 2016 and have an understanding of data analysis.

Course Overview

This course is designed to provide participants with a fundamental understanding of the capabilities of Power BI. Students will discover how to quickly gather, cleanse and transform data with just a few clicks. They will also learn that to enhance results by integrating disparate data sources and add 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.

Advanced Project Topics

  1. Getting Started
  2. Explore Power BI interface:
  3. Get Data
  4. Power BI data Sources
  5. Connecting to Excel Data
  6. Connecting to CSV file
  7. Connecting to an Access database
  8. Connecting to Facebook
  9. Importing Excel Data Model
  10. Shaping Combining and Merging Data
  11. Reducing Data with Query Editor
  12. Transforming Data
  13. Inserting Custom Columns
  14. Appending Data to a Query
  15. Adding an Index Column
  16. Cleaning up Data
  17. Creating Relationships between tables
  18. Merging data
  19. Using Lookup tables in a dataset
  20. Create Visualizations & Reports
  21. Creating and arranging Visualizations
  22. Creating text visuals, Cards, table, matrix
  23. Creating and formatting chart visuals
  24. Using a slicer to filter visuals
  25. Creating a map visualization
  26. Share your work
  27. Publish to Power BI services
  28. Republishing a dataset to Power BI services
  29. Refreshing and removing datasets and reports
  30. Sharing and unsharing reports
Share This Post
Have your say!
0 0

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>