In this series of blog posts, we will be examining some of the key features of Power BI Desktop, Power Query and the Power BI Service needed to pass exam DA-100: Analyzing Data with Microsoft Power BI. The series was originally mapped to the MCSA: BI Reporting; however, the topics covered are also relevant to…
In spite of its bland name, the CALCULATE function is the most important function in the DAX language and by far the most widely used in advanced DAX calculations. The power of the CALCULATE function stems from the fact that it allows you to change the context in which a DAX calculation takes place. One…
In this series of blog posts, we will be examining some of the key features of Power BI Desktop, Power Query and the Power BI Service needed to pass exam DA-100: Analyzing Data with Microsoft Power BI. The series was originally mapped to the MCSA: BI Reporting; however, the topics covered are also relevant to…
In this series of blog posts, we will be examining some of the key features of Power BI Desktop, Power Query and the Power BI Service needed to pass exam DA-100: Analyzing Data with Microsoft Power BI. The series was originally mapped to the MCSA: BI Reporting; however, the topics covered are also relevant to…
Query Parameters allow you to make the content of a report dependent on one or more parameter values. If we parameterize a data source, then we can update all our queries using that data source simply by specifying a different parameter value. In this demonstration, we will parameterize the name of the SQL Server instance…
Given the official guidelines regarding social distancing and the restriction of all but essential travel, G Com Solutions are now converting all of their training courses into live, instructor-led Power BI virtual training courses. We will strive to ensure that our Power BI virtual courses provide all of the benefits of our classroom training sessions…
In the New Power BI Online Training Course: Power Query Essentials, you will learn the basics of Power Query; a robust data connection and transformation tool which is built into Power BI and which allows you to connect to data from a wide variety of sources and then transform that data into exactly the right…
To obtain your MCSA: BI Reporting you need to pass two exams: 70-778 (Analyzing and Visualizing Data with Power BI) and 70-779 (Analyzing and Visualizing Data with Excel). However, there is a huge overlap between the two exams resulting from the common BI features found in both Power BI and Excel: namely data modelling using…
Are you looking to extend your knowledge of Microsoft Power BI? Power BI Sales Pipeline Analytics and Visualization is a practical hands-on course, designed to give experienced Power BI users further practice on data modelling and report creation. Microsoft Power BI Online Training Courses. The course begins with data preparation. We connect to our data,…
To obtain your MCSA: BI Reporting you need to pass two exams: 70-778 (Analyzing and Visualizing Data with Power BI) and 70-779 (Analyzing and Visualizing Data with Excel). However, there is a huge overlap between the two exams resulting from the common BI features found in both Power BI and Excel: namely data modelling using…