Microsoft Power BI Desktop

Microsoft Power BI is quickly becoming one of the world's most powerful self-service business intelligence platforms, as well as an absolutely essential tool for today's top data professionals.

This course is your hands-on, project-based guide to mastering Power BI Desktop. We'll follow a clear, systematic progression through the entire business intelligence workflow, and break down our process into four key stages:

1. Connect and transform the raw source data

2. Design and build a relational model

3. Analyze the data with calculated columns & DAX measures

4. Design custom, interactive reports and dashboards

Whether you're a casual Excel user, aspiring analyst, or data professional, this is the only course you need to build job-ready Power BI skills.

COURSE CONTENTS:

• 14.5 hours on-demand video (25.0 CPE credits)

• 25 homework assignments & solutions

• 5 quizzes

• 2 skills assessments (1 benchmark, 1 final)

COURSE CURRICULUM:

WHO SHOULD TAKE THIS COURSE?

• Excel users who want to develop advanced analytics and data modeling skills, or transition into a business intelligence role

• Analysts or BI professionals looking for a self-service platform to analyze large datasets, connect to external sources, build relational models, or design custom dashboards

• Anyone seeking a clear and straight-forward introduction to Power BI Desktop

WHAT ARE THE COURSE REQUIREMENTS?

• Power BI Desktop for PC/Windows (Power BI is currently unavailable for Mac)

• Experience with Power Query, Power Pivot & DAX is a plus, but not required

• No advance preparation is required (we'll walk through set-up and install)

WHAT ARE THE COURSE OBJECTIVES?

• Identify basic Power BI functionality, including data sources, contextual menus, regional settings, and differences between Power BI Desktop & Service

• Identify common Power Query tools and use cases for adding and transforming columns, including grouping, merging, appending, and transforming text and dates

• Identify common data modeling tools and best practices, including table names, relationships, hierarchies, data categories, cardinality, and filter flow

• Identify examples of filter context and various filtering methods, including user roles, parameters, and drillthrough filters

• Identify DAX syntax, when to use common functions, performance implications, and differences between measures and calculated columns

• Identify and interpret key Power BI visuals, including configuration options, interaction modes, and common use cases

• Identify common optimization techniques, including pausing visuals, applying presets, analyzing performance, and leveraging external tools

CPE ACCREDITATION DETAILS:

• CPE Credits: 25.0

• Field of Study: Information Technology

• Delivery Method: QAS Self Study

Maven Analytics LLC 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 the 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.

For more information regarding administrative policies such as complaints or refunds, please contact us at admin@mavenanalytics.io or (857) 256-1765.

*Last Updated: May 25, 2023