Designing Power BI Reports

DAX in Power BI

This training introduces Data Analysis Expressions (DAX), a formula expression language used to define calculations in PowerPivot for Excel® workbooks, tabular model projects authored in SQL Server Data Tools and in Power BI Desktop. DAX functions provide extensive filtering to calculate on data across multiple tables, work with relationships, and perform dynamic aggregation. There are millions of Microsoft Excel users who are familiar with using Excel formulas to perform calculations. Those calculations may be as simple as adding up a column of numbers, or they may be far more complex simulations of various business models. But in every case, each formula is built using a combination of basic operators and functions that are provided within Excel. Similarly, for professional BI solution developers using Multidimensional Expressions (MDX) in multidimensional model solutions, the fundamental concepts of creating calculations by using formulas is much the same; however, the differences in syntax, operators, and functions between MDX and DAX formulas is greater than it is between Excel and DAX formulas. Whether you are familiar with Excel or MDX formulas, this basic understanding of formulas is important when developing tabular data modeling solutions. While understanding Excel or MDX formulas will give you a head start in learning DAX, it is not necessary. DAX formulas are very similar to Excel formulas, and there is considerable overlap between the list of DAX functions and Excel functions. But there are also significant differences, and many new functions in DAX that don’t exist within Excel. These functions are designed to offer capabilities that focus on data analysis, particularly for related tables of data, and for dynamic analysis.

Designing Power BI Paginated Reports

Paginated reports are designed to be printed or shared. They're called paginated because they're formatted to fit well on a page. They display all the data in a table, even if the table spans multiple pages. They're also called pixel perfect because you can control their report page layout exactly. They display all the data in a tabular form, even if the table spans multiple pages. Power BI Report Builder is the standalone tool for authoring paginated reports. Paginated reports are based on the RDL report technology, like the format in SQL Server Reporting Services. To view your Paginated Report, you can either access it through Power BI service in a browser and also in the Power BI mobile apps. From the Power BI service, you can export the report to a number of formats, such as HTML, MHTML, PDF, XML, CSV, TIFF, Word, and Excel, or you can share it with others. 

Power BI Basic

This basic Power BI training is intended for end users who have access to complete data models and are ready to visualize data from these models. The course is designed for beginners and no previous experience is required. You learn step by step how to use your data to build reports in Power BI Desktop and publish them in the cloud service where you can create and share your custom dashboards. Courseware Digital Material

Power BI Intermediate

This Power BI (level 2) workshop is an intensive three-day course that is designed for pro-Information workers who want to learn utilize the most of the tools available in the Power BI stack, including the Power BI Cloud Portal. We’ll learn the importance of building good models, we’ll learns to use DAX as well as Power Query to shape additional information that can be found in external data sources.You’ll also use new Power BI cloud platform as a way of Deploying/sharing your reports and dashboards, and utilize extra features such as building interactive dashboards, use Q&A and manage Data refresh and alerts for your queries and sources. At the end of this course we’ll introduce you to some hot topics such as Dataflows, Composite Models, Aggregation Tables, Common Data Service for apps.

Power BI for Data Stewards

This training is designed for data wranglers, developers or data transformers, who want to transform raw data coming from one or more data sources and make that data ready for further analytics. The emphasis on this course is how to turn low quality data into something that will help you to deliver the business value and the business insights you need to make the right decisions.