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

Power BI MCSA Certification Training Tips – Part 10: Split Columns by Digit to Non-digit

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

Power BI MCSA Certification Training Tips – Part 9: Split into Rows vs Columns

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

Power BI Business Narration

(G Com Solutions provide Power BI Training in London and throughout the UK.) Power BI reports can be very detailed and consist of many pages. Inevitably, there will be particular insights which it is important that consumers of the report do not miss. In the Power BI world, business narration means taking a journalistic approach […]

Power BI MCSA Certification Training Tips – Part 8: What-if Parameters

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