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 series was originally mapped to the MCSA: BI Reporting; however, the topics covered are also relevant to […]
Continue reading
Parameterizing 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 by specifying a different parameter value. In this demonstration, we will parameterize the name of the SQL Server instance […]
Continue reading
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 […]
Continue reading
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 […]
Continue reading
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 […]
Continue reading
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 […]
Continue reading
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 […]
Continue reading
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 […]
Continue reading
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 […]
Continue reading
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