Power BI gives the Excel business user the ability to create and automate analytics in the Microsoft cloud without having to become an I.T. programmer. This course will start with a reporting example in Excel, then transition into Power BI where we will learn the foundations of data modeling and publish a hands-on Power BI report from scratch.
If you want to take your Excel analytical skills to the next level and provide on-demand insights for your business users, then Power BI is for you!
What you will learn
- Foundations of data modeling in Power BI
- Collect and transform raw data in Power Query
- Core concepts of evaluation context
- Develop your data model using common DAX measures
- Publish and automate report refresh in the cloud
- Combine your shared report with a data story
Meetings and format
The course consists of Zoom videoconference meetings with live instruction. To attend via Zoom, students will need a computer with webcam, microphone and high-speed internet.
Each Zoom session allows for live interactions with the instructor and other students via chat, web conferencing or phone, all in real time. Assignments and other materials will be available online through a web-based learning management system.
Who should attend
Working professionals, engineers, managers with intermediate knowledge of Excel formulas and pivot tables or data professionals who have a need to sharpen their skills relative to business analytics.
The instructional fee is $995, including a nonrefundable administrative fee of $75. See Registration for details.
Mark Walter is an Accounting and Business Intelligence professional passionate about providing business with data insights. A long time Excel user, Mark brought Power Pivot in Excel (2013), and later Power BI (2015) to his position at Industrial Finishes and Systems, Inc.
Mark has used Power BI daily to improve financial reporting, inventory tracking and marketing insights.
Mark is an Oregon certified public accountant and holds a finance degree from Western Washington University.