Split Column into Rows and Columns

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

Continue reading
Power BI Business Narration

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

Continue reading
What-if Parameters

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

Continue reading
Power BI Workspaces Report

Monitoring Power BI Workspaces Using the Admin Portal and PowerShell

G Com Solutions supply Power BI Training in London and throughout the UK. Workspaces play a pivotal role in Power BI collaboration and sharing workflows. The ability to create app workspaces is controlled in the tenant settings: Admin Portal > Tenant Settings > Workspace Settings. This ability can be enabled/disabled for The entire organization, or […]

Continue reading
Conditional Columns

Power BI MCSA Certification Training Tips – Part 7: If statements and Conditional 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 […]

Continue reading
Merge Queries

Power BI MCSA Certification Training Tips – Part 6: Merge Queries (Table.NestedJoin)

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

Continue reading
Fill Down

Power BI MCSA Certification Tips – Part 5: Fill Down

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

Continue reading
Table.UnpivotColumns

Power BI MCSA Certification Tips – Part 4: Unpivot Columns and Unpivot Other 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 […]

Continue reading
Table.SelectColumns

Power BI MCSA Certification Tips – Part 3 : Table.SelectColumns and Table.RemoveColumns

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

Continue reading
Connecting to Folders

Power BI MCSA Certification Tips – Part 2 : Connecting to Folders

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

Continue reading