SUBSCRIPTION: Getting Started With Microsoft Power BI

Overview

*** This subscription includes five individual sessions for a total of 14 CPE. You receive significant savings when purchasing these webinars as a subscription. Each of the five courses runs live once a month beginning May 1, 2024 through April 30, 2025. Register for these scheduled courses as your schedule allows - at no extra cost to you. Once registered for this subscription, log in instructions will be emailed to you separately for each individual course. *** This Power BI intensive series is designed specifically for those aiming to master data management skills in the modern business environment. As data becomes increasingly central to accounting and financial analysis, the ability to effectively manage, clean, and transform this data is critical. These five courses delve into Microsoft Power BI, a tool known for its robust data processing capabilities. This series will take you from an entry-level overview of Power BI and lead you through building an actual data model for analysis. Once you have completed the courses in this series, consider taking the advanced subscription, “Taking Power BI to the Next Level”.

Highlights

Course 1: Get started with Power BI

CPE: 2

Description: Embark on a journey to master Power BI, a powerful tool for data analysis and business intelligence, in our comprehensive course, "Get Started with Power BI." This course is meticulously designed for professionals who seek to understand the full spectrum of Power BI capabilities, including its integration with Excel's Power BI features like Power Pivot and Power Query, and its comparison with standalone Power BI tools such as Power BI Desktop, Power BI Service, and Power BI Report Server.

Course 2: Become a Data Analysis Expert

CPE: 2

Description: You will learn the all important Data Analysis Process Flow that will take you from collecting data all the way to making insightful decisions based upon your data. We will explore the basics of data modeling that will allow you to access data from multiple sources and use sophisticated calculations to create our data metrics. You will learn how to create interactive dashboards, perform sophisticated reporting, and uncover deep insights from your data. Whether you're looking to streamline your reporting process, enhance your data visualization skills, or make more data-driven decisions, this course is tailored to meet those needs.

Course 3: Power BI - Analyze Your Data With Excel Pivot Tables

CPE: 4

Description: This session is designed to teach participants the importance of PivotTables for analyzing data. We will demonstrate how PivotTables can make data analyzation an easy task for all accountants. Participants will learn the step-by-step process to create PivotTables and PivotCharts. We will also cover all the setup options and features.

Course 4: Clean, Transform & Load Data in Power BI

CPE: 2

Description: This course delves into Microsoft Power Query, a potent tool within Excel and Power BI Desktop, known for its robust data processing capabilities. This course is designed to take participants from the basics of Power Query to exploring its more sophisticated features. It is an ideal blend of theoretical knowledge and practical application, centered around diverse data scenarios encountered in multiple industries. The aim is to ensure that the skills and techniques learned are universally applicable and beneficial in any professional context. Structured to be participant-focused, the course encourages active learning through a series of practical exercises, live demonstrations, and illustrative case studies. This approach not only deepens the understanding of Power Query's features but also demonstrates how to turn complex data sets into actionable insights. While the course is broad in its application, it remains detailed in its instruction, catering to both the novice and the seasoned professional.

Course 5: Build a Data Model for Analysis in Power BI

CPE: 4

Description: This intensive 4-hour course offers a deep dive into data modeling in Power BI, with a focus on Microsoft Excel's Power Pivot but applicable to Power BI Desktop. Designed for professionals looking to enhance their data analysis skills, the course covers the essential aspects of building robust, efficient data models. Participants will learn how to integrate different data sources, create meaningful relationships, and develop insightful metrics to drive business decisions. Participants will explore various aspects of data modeling such as establishing relationships, creating calculated columns, and understanding the intricacies of basic DAX (Data Analysis Expressions) measures.

Prerequisites

None

Designed For

Anyone interested in mastering data modeling techniques using Microsoft Power BI.

Objectives

After attending this subscription, you will be able to...

• Apply fundamental principles of data modeling in Power BI to integrate various data sources effectively.
• Determine the most appropriate scenarios for using calculated columns versus measures in Power BI data analysis.
• Choose and implement the correct type of DAX measures (explicit or implicit) for specific data modeling needs.
• Use pivot tables in Power BI to validate and refine data measures, ensuring accuracy and reliability in reporting.

Preparation

None

Notice

This course is offered by a 3rd party vendor and will not be accessible in the My CPE Tracker section of the ISCPA website. Course access information will be emailed directly to you by CPA Crossings.