Power BI Fundamentals

Loading Events

Power BI Fundamentals

October 14th - October 15th

Power BI Fundamentals is a rigorous 2-day training course for aspiring report developers and data professionals seeking to hone their skills in Power BI. The class is instructor led and paced as a group. The course is designed to walk you through each important capability of Power BI and provide you sample situations to practice your skills. The goal is to build “muscle-memory” for Power BI best practices on report creation and data transformations.

 

You will learn:

  • Report and data visualization best practices
  • How to transform your data with Power Query
  • Write basic DAX calculations
  • Build an analytical data model

 

Day One – Basic Report Building

(1) Introduction to Power BI development stages

(2) Introduction to data visualization best practices

(3) Building a chart driven report using best practices

-Lunch-

(4) Building a table driven report with conditional formatting & drillthrough

(5) Introduction to publishing

(6) Data wrangling primer (extract, clean, and load two Excel tables)

(7) Q&A

 

Day Two – Data Wrangling and Modeling

(1) Review of Power BI development stages

(2) Accessing Data Sources (Excel sheets/named-ranges, CSV files, and folders of workbooks)

(3) Basic transformations of data sources (date/text parsing, filtering, pivoting)

-Lunch-

(4) Intermediate transformation of data sources (joining, appending, and data structures)

(5) Introduction to dimensional modeling

(6) Setting relationships and building simple DAX measures

(7) Q&A

 

Click here to register >>

Share this:

Details

Start:
October 14th
End:
October 15th
Website:
https://www.eventbrite.com/e/power-bi-fundamentals-portland-or-tickets-67370100785

Venue

Multnomah Athletic Club
1849 SW Salmon Street
Portland, OR 97205 United States
+ Google Map
Share this:

Ready to wrangle your data?