See how live online training works in this brief video.
All Power BI classes include
Free retake
Detailed curriculum
Live instructor
Flexible rescheduling
Certificate of Completion
Small class sizes
Course recording
Power BI course Online October 28, 2024 Introduction
Power BI course - introduction
$795.00
This two-day introductory Power BI course is for anyone who needs to organize and visualize data, including Excel users looking to expand their skills with data management, manipulation, and visualization. The course is focused on building Power BI data visualizations, with emphasis on creating, adjusting, and formatting data from Excel and other sources. You will also learn to incorporate Power View and Power Pivot for enhanced capabilities, understand data modeling in Power BI, and gain skills in creating data connections, including database connections. Find out how to use the transformative capabilities of the Query Editor for data cleaning and formatting. The course also focuses on data relationships, as well as performing calculations on various data dimensions, including times and dates. Learn about publishing Power BI reports internally and externally, along with securing reports and controlling access. Gain a better understanding of options for interpreting data, applying techniques for quick data insights, and exploring the emerging capabilities of data interpretation and reporting with AI in Power BI.
Power BI Course Topics
Power BI and excel
- Introduction to using excel data in Power BI
- Importing and accessing excel data in Power BI
- Using power view and power pivot to Power BI
Connecting Power BI to data
- Data sources available to import into Power BI
- Creating a connection to a data source
- Connecting to databases
- Loading data from files
- Getting data from services and content packs
Transforming data with the query editor
- Understanding the query editor
- Transform data using the query editor
- Cleaning data and removing improper formatting
Data modeling with Power BI
- Understanding data modeling
- Types of data models
- Creating and managing data relationships
- Establishing relationship types
- Loading data from individual tables
- Working with and configuring tables
- Introduction to data analysis expressions (dax)
- Using dax in Power BI
- Working with dax functions
- Performing dax calculations
- Calculating columns, measures, and tables
- Working with times and dates
- Understanding differences between live and refreshed data
- Refreshing data and setting refresh frequency
Power BI data visualizations
- Overview of Power BI data visualization
- Creating visualizations in Power BI
- Adjusting Power BI data visualizations
- Adding text, images, and shapes
- Editing colors in charts and graphs
- Defining page size and object locations
- Formatting Power BI visualizations
- Defining relationships between visualizations
- Defining drill-downs to gather more data
- Creating custom visualizations
- Creating dashboards
Publishing Power BI reports
- Publishing options for Power BI reports
- Publish reports online
- Printing Power BI reports
- Using Power BI cloud-based services
- Sharing reports internally and externally’
- Managing security of Power BI reports and controlling access
- Using row-level security
- Using Power BI workspaces
Understanding and interpreting data
- Quick insights in Power BI
- Ask questions of your data with natural language
Using AI in Power BI
- Data interpretation capabilities with AI
- AI reporting options
Why Power BI classes at AGI are the best option for you
- Hands-on learning: Learn Power BI quickly with our proven teaching methods.
- Exceptional curriculum: AGI has delivered Power BI training to thousands over 25 years.
- Expert instructors: Our instructors are Power BI experts and skilled educators.
- Small class sizes: Receive personalized attention with 10 or fewer participants per class.
- Repeat for Free: If you need a refresher or miss a class day, retake the Power BI class at no cost.