Skip to main content
It looks like you're using Internet Explorer 11 or older. This website works best with modern browsers such as the latest versions of Chrome, Firefox, Safari, and Edge. If you continue with this browser, you may see unexpected results.

Tech Skills and Software Trainings

State Library resources to help you improve with tech skills and specific software.

Power BI Resources

Building Interactive Dashboards with Microsoft Power BI

Building Interactive Dashboards with Microsoft Power BI

This course provides an introduction to Power BI's powerful dashboard design features and how you can use it to the advantage of your organization. You'll begin the course by building a simple, functional interactive dashboard. You'll present linked charts and KPIs. You'll develop dashboard examples suitable for publishing to analysts through managers and executives. At times, you need to walk users through the data so we introduce some storytelling features of Power BI. Finally, we'll wrap up with some tips to style your dashboards for publishing.

Collect, Combine, and Transform Data Using Power Query in Excel and Power BI

Collect, Combine, and Transform Data Using Power Query in Excel and Power BI

Using Power Query, you can import, reshape, and cleanse any data from a simple interface, so you can mine that data for all of its hidden insights. Power Query is embedded in Excel, Power BI, and other Microsoft products, and leading Power Query expert Gil Raviv will help you make the most of it. Discover how to eliminate time-consuming manual data preparation, solve common problems, avoid pitfalls, and more. Then, walk through several complete analytics challenges, and integrate all your skills in a realistic chapter-length final project. By the time you're finished, you'll be ready to wrangle any data–and transform it into actionable knowledge.

Getting Actionable Insights from Power BI

Getting Actionable Insights from Power BI

This no-nonsense, hands-on course will help you create well-designed, truthful, insightful, and actionable reports using Power BI, an industry-standard data analysis tool. You will process and clean realistic data, extract meaning from it, and communicate it using charts and visualizations. You'll do all this by using Power BI and its built-in DAX language. By the end of the course, you will be able to use Power BI effectively as a business analytics tool to load, pre-process, and model data and create meaningful and actionable reports and visualizations.

Hands-On Data Visualization with Microsoft Power BI

Hands-On Data Visualization with Microsoft Power BI

This course aims to equip you with BI tools to make better business decisions and create accurate reports and dashboards in just few minutes. This course is specifically designed to give you hands-on experience of Power BI with more of a focus on practical applications in business environments. You’ll walk through Power BI, end to end, starting from how to connect to and import your data, author reports using Power BI Desktop, and publish those reports to the Power BI service.

Learning Microsoft Power BI

Learning Microsoft Power BI

Tell your data story with Power BI and reach millions of users with a single click on any kind of a device. Using Power BI, you can combine your data sources, create stunning visualizations, and embed your story on your website within seconds. The goal of this course is to teach you how to use raw data, monitor it, and visualize it in a form that will provide rich insights with the help of dashboards. When it comes to learning Power BI, this course will ensure that you have the necessary tricks of the trade for effective insights and simplified visual analytics.

Microsoft Power BI Complete Reference

Microsoft Power BI Complete Reference

In this Learning Path, you will learn to create powerful interactive reports by visualizing your data and learn visualization styles, tips and tricks to bring your data to life. You will be able to administer your organization's Power BI environment to create and share dashboards. You will also be able to streamline deployment by implementing security and regular data refreshes. By the end of this Learning Path, you will learn to implement the various Power BI tools such as on-premises gateway together along with staging and securely distributing content via apps.

Microsoft Power BI Dashboards Step by Step

Microsoft Power BI Dashboards Step by Step

Expand your expertise–and teach yourself how to create world-class Power BI business analysis dashboards that bring data to life for better decision-making. If you're an experienced business intelligence professional or manager, you'll get all the guidance, examples, and code you need to succeed–even if you've never used Power BI before.

Power BI Data Analysis and Visualization

Power BI Data Analysis and Visualization

Power BI Data Analysis and Visualization provides a roadmap to vendor choices and highlights why Microsoft’s Power BI is a very viable, cost effective option for data visualization. The book covers the fundamentals and most commonly used features of Power BI, but also includes an in-depth discussion of advanced Power BI features such as natural language queries; embedding Power BI dashboards; and live streaming data. It discusses real solutions to extract data from the ERP application, Microsoft Dynamics CRM, and also offers ways to host the Power BI Dashboard as an Azure application, extracting data from popular data sources like Microsoft SQL Server and open-source PostgreSQL.

Pro Power BI Architecture

Pro Power BI Architecture

Pro Power BI Architecture provides detailed examples and explains the different methods available for sharing and securing Power BI content so that only intended recipients can see it. Commonly encountered problems you will learn to handle include content unexpectedly changing while users are in the process of creating reports and building analysis, methods of sharing analyses that don’t cover all the requirements of your business or organization, and inconsistent security models.

Resources Organized by Content Level

A division of the State Library of Oregon | 250 Winter Street NE Salem, Oregon 97301 | Monday-Friday 8am-5pm | 503-378-8800 | LibraryHelp.SLO@state.or.us