Category Archives for Blog

G Com Solutions Running Virtual Power BI Training Courses

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 […]

New Power BI Online Training Course: Power Query Essentials

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 […]

Power BI MCSA Certification Training Tips – Part 14: On-premises Data Gateway

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 […]

New Power BI Online Training Course: Power BI Sales Pipeline Analytics and Visualization

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. The course begins with data preparation. We connect to our data, perform basic transformations and import an […]

Power BI MCSA Certification Training Tips – Part 13: Analyze in Excel

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 […]

New Course Available: Power BI SQL Server Integration

Power BI MCSA Certification Training Tips – Part 12: Power Query Custom Functions

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 […]

Managing Relationships in Power BI

When creating reports in Power BI, you will typically create a data model that has several tables. To provide meaningful results, these tables must be linked; so that they can behave like a single unified dataset. This linkage is achieved by creating relationships between tables that share common attributes. Relationships enable us to analyze and […]

Dashboard Alerts on Power BI Usage Metrics

Within each Power BI tenant, usage metrics are available not just for administrators, but for all content-creators. A usage metric report can be generated for any individual dashboard or report. In this blog post, we will see how you can combine usage metric reporting with Power BI alerts feature to get notified when one of […]

Power BI MCSA Certification Training Tips – Part 11: Connecting to Excel 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 […]