What you'll learn
- Describe how Power BI enables real-time data sharing and reports by connecting directly to external data sources, including Excel
- Manage data relationships within Power BI including create, modify, and delete
- Create a set of applied steps to clean a data source including changing data types, modifying field names, and splitting and merging columns
- Create and customize visualizations to display your data including formatting, sorting, and filtering
- Format report pages including text, shapes, and images
- Create calculated columns using Data Analysis Expressions (DAX) for both strings and numbers
- Create explicit measures and add measures to visualizations
- Create interactive reports using real-time filters, hierarchies, and slicers
- Publish a report to the Power BI Web App and create multiple dashboards specific to different audiences
Requirements
- While this course does not have prerequisites, learners may wish to have experience storing data in Excel and some knowledge of data relationships.
Description
LEARN TO CREATE STUNNING REPORTS WITH REAL-TIME DATA
In Microsoft's Power BI, you can connect to existing data to create modern data visualizations and reports. In this course, you will learn everything you need to know to design reports, charts, and dashboards and distribute them to your team. We will walk you through the process from install to publish.
In this course, you will learn to connect to Excel files or other external data sources then create data relationships as the basis for your reports. Kat will walk you through modifying data relationships, creating a set of applied steps to clean and transform your data, and creating a variety of visualizations (charts) with your data. Then you’ll learn how to create measures and calculated fields and add them to your visualizations.
With a set of informative and engaging visualizations, Kat will show you how to add filtering and splicing then publish your reports. With a published report in the Power BI Web App, you’ll then learn to create multiple customized dashboards from one report.
By the end of this course, you’ll know how to use Power BI to empower your teams with the information they need to do their jobs well.
Who this course is for:
- Business users who manage large sets of data and create reports and dashboards for distribution to their teams or executives.
Course content
- Preview03:33
- Preview06:14
- Preview05:19
- 07:00Modifying Data Relationships
- 09:49Working with the Power Query Editor
- 08:15Transforming Data
- 07:40Creating Visualizations
- 06:28Customizing Visualizations
- 08:40Creating Calculations with DAX
- 05:46Creating Calculated Measures
- 08:24Filtering and Splicing Reports
- 07:55Publishing Reports
Instructor
Bigger Brains Founder and President Chip Reaves is a serial entrepreneur who has started five successful companies. An Atlanta native, Chip began fixing computers for small businesses in the 1980's while studying Computer Science at Georgia Tech. After 10 years building a successful IT Service Practice in Atlanta, Chip founded the Computer Troubleshooters franchise system alongside Wilson & Suzanne McOrist, which became the world's largest computer service franchise and received multiple awards from Entrepreneur Magazine, Franchise Business Review, and AllBusiness.
Chip has been interviewed on TV and other major media on topics related to small business technology and entrepreneurship, including ABC News, BusinessWeek TV, the Wall Street Journal, and the New York Times, and is a member of Jim Blasingame's "Brain Trust" on SmallBusinessAdvocate. In 2010 Chip was listed among the Top 150 most influential people in small business IT by SMB PC magazine.
Chip lives with his wife Maren and step-daughter Meg in Anderson, South Carolina where they also co-own a Computer Troubleshooters franchise location. In his spare time Chip is very active with his church and local charities, and consults with two aid organizations serving Rwanda and the Democratic Republic of Congo in Africa.