Designing Power BI Paginated 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 Reports

Designing an analytical report involves understanding the requirements and its audience. However, designing a compelling analytical report requires understanding the automatic and unconscious processes that occur when report consumers comprehend what they see. When you have the knowledge of how to structure and apply report design principles, you can raise the level of your report designs to produce relevant, intuitive, and visually pleasing experiences for your report consumers. While good report design is a skill that can take years to master, there are a few very, very basic concepts that will make your reports far better...and these concepts are pretty easy to learn.This course will walk through just those most basic concepts related to chart selection and page composition. This will by no means that this course will make you an expert, it will however get you over the first conceptual hurdles people tend to slam into after figuring out the basics of how to create a visual. These concepts aren’t really Power BI concepts and they tend to be the things a lot of tutorials out there don’t cover. When you're finished with this course, you will have the skills and knowledge in Power BI needed to communicate data stories through clear and compellin

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.