All posts by Grant Gamble
Power BI Formal and Informal Hierarchies
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
Continue readingParameterizing SQL Server Connections
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
Continue readingPower 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
Continue readingPower 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
Continue readingPower 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
Continue readingManaging 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
Continue readingDashboard 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
Continue readingPower 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
Continue readingPower 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
Continue readingPower 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
Continue reading