Getting started with Power BI can seem like a dauntless and overwhelming task at the beginning. Because the reporting platform is so powerful, there is a lot to learn! This article breaks down the main areas to dive into with Power BI reporting and provides some readily available training resources for each.
Power BI
Typical Power BI Reports are built with the Power BI Desktop App and are designed to be more graphical and analytical in nature. They are meant to be interactive, so they consist of a series of dashboards and screens that are best viewed online. This type of report is best used for summarizing and analyzing data and is intended to be used to provide insights into the data that will help you make informed business decisions. Instead of just looking into what happened at a given point in time, the business analytics features of Power BI enable you to dig into why something happened.
Microsoft offers several free training resources to help you get started with Power BI. Provided here are some of our favorites:
Paginated reports are used for reporting that requires a more traditional printed report format instead of an analytical dashboard with visuals. This could be a table report that has multiple pages of data (eg. a list of all sales for the past quarter sorted by customer), or a structured report for printing (eg. a statement or invoice).
These paginated reports are built using a different tool, the Report Builder desktop app, which is similar to building an SQL Server Reporting Services (SSRS) report. Below are some of the resources we have found to help you get started with Paginated reports:
Data Analysis Expressions (DAX) is a formula expression language used in Analysis Services, Power BI, and Power Pivot in Excel. DAX formulas include functions, operators, and values to perform advanced calculations and queries on data in related tables and columns in tabular data models. Many functions can be accomplished in Power BI without coding. However, if you wish to create more complicated measures in your reports, you may need to become familiar with DAX formulas and syntax.
While this is not necessary to get started using Power BIand Paginated Reports, there are several resources available to help you learn DAX functionality as you need it:
Hopefully these suggestions and links will be helpful to you as you get started with your own Power Bi journey! If you have questions or ideas for other topics you would like to see covered, please let us know!
COMPETITIVE EDGE
Please contact us to explore how SDP can leverage these resources to create a competitive edge for your business.
ABOUT THE AUTHOR
Aimee Krummenacher is a Project Manager/Business Analyst at Software Design Partners.