In this blog, our Chief Technology Storyteller Bill Ramos shows how to use the array sub-expression operator and “splatting” with hash tables to build the parameters needed for the Invoke-Sqlcmd cmdlet.
Talks on Managing Data and Applications Anywhere
In this second blog post for my series, Power BI for the SQL Server DBA, I’m going to show how you can take Windows Perfmon (Performance Monitor) data for SQL Server and analyze it with Power BI.
I’m going to assume that as an SQL Server DBA, you probably have not used Power BI yet. If you have some familiarity with Power BI, I hope there are still gems you can pull out of this blog post.
Over the last few months of benchmarking SQL Server performance on AWS, I discovered a way to optimize SQL Server performance running on EC2 instances by paying close attention to several key Windows performance counters. This blog post is the first in my new series called Power BI for the SQL Server DBA. I’m going to show how you can easily capture performance counters to optimize SQL Server performance and cost on AWS EC2 instances. I’m going to start with […]
Welcome to the last episode of my Power BI Best Practices Series. In today’s episode, I will show you how to filter your report based on visual level, report level, or page level filters.
Visual level filters allow for filtering only the selected visual. Likewise, page level filters allow for filtering the entire page. And report level filters allow for filtering all tabs together in your entire report.
Read more on our blog and be sure to watch the related video.
Welcome to Episode 12 of my Power BI Best Practices Series. In today’s episode, I will show you how and why you should edit your interactions in your visuals. Editing interactions allows for you to apply the filter directly on a visual. Also, you can change the way the filter interacts with different visuals on your page.
Please note that you can not edit interactions if the report was shared with you. Also, by default, drilling one visualization has no impact on the other visualizations on the report page.
Find more details from this blog post.
Welcome to Episode 10 of my Power BI Best Practices Series. In today’s episode, I will show you how to include a report support tab in your Power BI report. This tab helps your users see where the data comes from. Also, here you can include your contact information, so the users of your report will know how to reach you if they have questions.
A report support tab is not mandatory. However, this is one of the developers’ best practices and the way to show some respect to the other users working with your report.
Welcome to Episode 9 of my Power BI Best Practices Series. In today’s episode, I will show you how you can create themes in your Power BI report and allow for more branding experience.
Power BI themes allow for brighter visualizations, as well as customizing and standardizing your reports. You can select one of the predefined themes, import an existing theme, pick up a theme from the gallery or even create a new theme.
Welcome to Episode 8 of my Power BI Best Practices Series. In today’s episode, I will show you how you can create drillthrough pages in your report.
Drillthrough pages allow for your users to navigate to different pages within your report to expore the details of the visuals that they choose. For example, you can create a drillthrough filter in Power BI based on the specific entity.
Welcome to Episode 6 of my Power BI Best Practices Series. In today’s episode, I will show you how to relate tables and your data model to allow for cross filtering and relationships. Here we go! Power BI — Relate tables and your data model By default, Power BI relationships are not active. So, you need to set the relationships in your dashboard. You can also set the type of cardinality of the selected relationship from one of the following […]