DTBS 0015 - Power BI – Introduction
Course Description
Power BI transforms your organization’s data into rich visuals for you to collect and organize so you can focus on what matters to you. In this course, you learn how to connect to data, then clean and transform it. You also create a data model and report on KPIs. Lastly, you produce visualizations on the data and publish them to share. The course includes an introduction to DAX language and best practices.
The course involves lecture, demonstration, hands-on practice and instructor coaching. No previous knowledge of Power BI is required.
Course Outline/Topics
The course teaches all skills needed to build a rich report and covers the following:
Extract, transform and load data
- Learn how to combine data sources, perform complex transformations, and then load to the model
- Understand the Power Query window
Model data and create Key Performance Indicators (KPIs)
- Model data best practices and create relationships between tables
- Learn an intro to the DAX language
- Make DAX measures and columns for KPIs
- Measure time intelligence
- Use best practices for data optimization
Visualize the data
- Learn how to create rich visualizations
- Add a layout to make stunning reports
- Use advanced features such as tooltips and bookmarks for advanced analysis
- Use the correct graph and best practices for visual layout design
Share the reports
- Deploy your reports to share with the correct people in your organization
- Use best practices for sharing and maintaining reports
Benefits and Learning Outcomes
- Understand capabilities and uses of Power BI
- Understand the four phases of handling data in Power BI: load, model, visualize and report
- Apply understanding of the four phases to analyze real-world examples
- Extract, Transform and Load sample data
- Model sample data into tables with accurate relationships
- Create visualizations from sample data
- Explore options for sharing and reporting data visualizations
Who Should Attend
Individuals charged with identifying data insights and sharing them with others.
Testimonials
"Mike did a great job; very objective and supportive."
-Raul Setien, Wells Vehicle Electronics LP, Mexico, May 2021
"Mike Carlo provided great instruction and insight to the usefulness and power in using Power BI. The tutorial PDFs were great tools to support and guide through the natural sticking points of learning a new program. I thoroughly enjoyed the classes and look forward to learning more about this program and how to incorporate it into work-related reports. Thank you!"
-Russell Kruse, Wells Vehicle Electronics , May 2021
"Mike was great! I would take another class with him. Very knowledgeable about this subject, and a great personality."
-Carlie Herbst, Wells Vehicle Electronics, May 2021
Instructors
Applies Towards the Following Credentials
- Business Analysis Certificate : Elective
- Data Analysis Certificate : Elective