And we trained even more in Excel. As Microsoft MVP (Most Valuable Professional), we’re awarded for exceptional technical and community leadership. We’re widely recognized as speakers and teachers in Power BI, making complex matters easy to comprehend. We love helping you to become successful with Power BI!
We base our courses on our 10+ years’ experience in customer projects with Power BI and related technologies. You will not only learn about the tools and features, but we help you with best practices to avoid pitfalls and build solution that are fast, robust, and that can be easily maintained.
Power BI has fundamentally changed the accessibility of data-driven insights for business leaders. It has never been easier to gain understanding of your business’s key metrics. But Power BI doesn’t stop there. It brings advanced analytics to the business, allowing users to detect hidden patterns in data and to make smart predictions and forecasts on what will happen.
Power BI made Microsoft a leader in the BI market. It integrates seamlessly with both Excel and enterprise data platforms, and it allows for fast development of business intelligence solutions.
Although Power BI is presented as an easy-to-use platform, a thorough foundation is crucial to effective use and development of reports and dashboards. In this training, you’ll get to know the Power BI platform and learn how to develop Power BI reports.
A Power BI data model, or analytical model, is the core of a Power BI solution. Each Power BI report is based on a data model that combines data and provides aggregations and all sorts of calculated results. The concepts of Power BI data models may seem easy and familiar, but make no mistake: building a well-performing data model requires a different way of thinking from working with relational databases or Excel. In this course, you’ll learn about building Power BI data models and how to use the DAX language.
One of the more tedious tasks in Analytics is preparing data for analysis. Power BI offers a powerful tool for loading and transforming data called Power Query or, simply, Query Editor. Power Query is also available in Excel as ‘Get and Transform’, the default mechanism to load external data in Excel 2016 and later. Moreover, the same techniques can be used in SQL Server Analysis Services, Azure Analysis Services, and in the Dataflows component of the Power BI cloud service.
In this course, we dive deeper in the DAX language of the Power BI data model. You learn all about DAX context, variables, and table functions. You also learn how to implement complex scenarios with DAX, end-to-end. We expect you to have basic knowledge of DAX. For instance, by having completed the Data Modeling & DAX Fundamentals course.
Data security has always been an important issue, but is increasingly important with an increasing number of users. How do you ensure that users have access to the information they need, but guard confidentiality of information where needed?
In this course, you learn about the different aspects of security in Power BI. From Workspaces, Power BI Apps, and use of AD security groups, to implementing role-based security in Power BI models. This course helps you to define a sound security architecture in Power BI and to implement simple or advanced Row-Level security policies.