Microsoft® Power BI for the Desktop User: Part 2

Microsoft® Power BI for the Desktop User: Part 2 is designed to provide proficiency in modifying charts and graphs along with creating advanced formulas and functions. The Power BI program will involve the connection to external data sources, working with data relationships, creating calculations, and developing visualizations for analytical review.

LESSON 1: ANALYZING DATA WITH VISUALIZATIONS

• CREATING VISUALIZATIONS
  • Clustered Column Chart
    1. Using Data Labels
  • Pie Charts
• USING MULTIPLE PAGES
  • Stacked Bar Chart
  • Line and Clustered Column
  • Creating a Gauge Visualization
  • Creating a Matrix
  • Creating Maps
    1. Bubble Maps
    2. Filled Maps
  • WORKING WITH CUSTOM TOOLTIPS

LESSON 2: WORKING WITH CALCULATED FIELDS AND MEASURES

• CREATING CALCULATIONS
  • Calculated Columns
  • Using DAX Functions
  • Creating Formulas using Concatenation
  • Creating Measures
  • Conditional Formulas

LESSON 3: CREATING HIERARCHIES AND FILTERING DATA

• CREATING HIERARCHIES
  • Drilling down data
• FILTERING DATA
  • Visual Level Filters
    1. Basic Filtering
    2. Top N
    3. Advanced Filtering
  • Page Filters
    1. Filters on This Page
    2. Filters on All Pages
  • Creating Slicers
  • Using Drillthrough Reporting

IMPORTANT INFORMATION ABOUT PARTICIPATION:  As part of our sponsorship with NASBA, we have agreed to provide at least three (3) instances of engagement per CPE hour (50 minutes).  These may come in the form of open-ended questions, hand-raising, polling, and other techniques.  You MUST answer or respond to all three opportunities to engage in order to receive credit for that CPE hour.   Knowledge Source Inc. retains these responses after all CPE classes for audit purposes.

Knowledge Source Inc. is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.nasbaregistry.org.