Power Analytics for DoD Cost Analysis (Power BI)
An introductory course designed for analysts to learn how to apply data sciences processes and principles within Power BI.
Includes Power BI
Training Formats:
Open Training
Self-Paced
Onsite Training
Description:
An introductory course designed for analysts to learn how to apply data sciences processes and principles within Power BI. We leverage the latest DoD acquisition cost and programmatic data sources (FlexFile and IPMDR) to teach Power BI best practices for building data models and visualizations.
- Extract authoritative data
- Clean the data
- Shape the data
- Transform the data
- Import the data into Power BI
- Model relationships between data sources
- Analyze FlexFile and IPMDR data sources
- Create reports
- Create Visualizations
- Build dashboards
- Analyze FlexFile and IPMDR data sources
Successful students should already have a working knowledge of data science and spreadsheet operations. This course focuses on how to use Power BI and does not teach underlying data science principles.
Module 1: Intro to Power BI and Demo
Module 2: Sharing Power BI Files
Module 3: Understanding the Raw Data
- 3.1 CSDR - FlexFiles
- 3.2 Earned Value - IPMDR
Module 4: Data Processing - Importing Data
Module 5: Cleaning the Dataset - Data Preparation
Module 6: Exploratory Data Analysis - Visualizations & Filters
Module 7: Models and Algorithms
- 7.1 Building Measures
- 7.2 Appending Data & Conditional Columns
- 7.3 Mapping Relationships
- 7.4 Merging Queries
Module 8: Reports
Module 9: Decision Making
Open Training
- In-person classes taught by ACEIT Certified Instructors.
- Classes are held in the Washington DC area unless otherwise indicated.
- Classes runs for 2 consecutive days (8:30 am – 4:30 pm) on location.
- Hardcopy Training Manual.
- Electronic Starting and Results files.
Self-Paced
- Designed to allow you to learn at your own pace.
- Instructional Videos accessed online through the Media Center.
- Includes up to 4 remote tutoring hours with an ACEIT Certified Instructor.
- Hardcopy Training Manual.
- Electronic Starting and Results Files.
Onsite Training
- In-person classes taught by ACEIT Certified Instructors.
- Economical option for 5 or more students at your organization.
- Classes on 2 consecutive days at your location or virtual available.
- Hardcopy Training Manual.
- Electronic Starting and Results Files.
Upcoming Courses
Interested in tutoring services?
This course can be taught at your location. To request an onsite training quote, submit a request.
Don’t see a class you’re looking for or need additional information?
Contact the ACEIT Training Coordinator
eNewsletter 
Publication containing ACEIT tips, support alerts, upcoming classes, and more!
View the archive >