Power BI - Sub-divide and segment
Power BI — Sub-Divide and Segment Your Visuals — Episode 3
19 Apr 2019

Welcome to Episode 3 of my Power BI Best Practices Series. In today’s episode, I will show you how to sub-divide and segment your data visualizations in your Power BI Dashboards or Reports. To check out prior episodes and see where we are going, here is what BEST PRACTICES for Power BI is all about. Be creative and tell a story Eliminate unnecessary columns Sub-divide and segment visual placement Table for key measures Prepare report requirements Relate tables using your data model Align the visuals Create drill through pages with detail Themes are your best friend Include a report support tab Cut unnecessary visuals Edit interactions S...

Power BI - Eliminate Unnecessary Columns
Power BI — Eliminate Unnecessary Columns — Episode 2
12 Apr 2019

Welcome to Episode 2 of my Power BI Best Practices Series. In this episode, I will show you the importance of eliminating unwanted columns from cluttering your Power BI Desktop Report. Be sure to check out prior episodes and see where I’m going with BEST PRACTICES below. Be creative and tell a story Eliminate unnecessary columns Sub-divide & segment visual placement Table for key measures Prepare report requirements Relate tables using your data model Align the visuals Create drill through pages with detail Themes are your best friend Include a report support tab Cut unnecessary visuals Edit interactions Set visual, page & r...

Power BI - Be Creative
Power BI — Be Creative and Tell a Story — Episode 1
05 Apr 2019

Welcome to my Power BI Best Practices video series Over the past year, I’ve been blessed to share my B.E.S.T. P.R.A.C.T.I.C.E.S. at the Memphis PASS Power BI meetup, the Microsoft Tech Expo in Portland, and the  Power BI World Tour in Seattle. At the Seattle event, I was lucky enough to meet with members of the Power BI product team like Will Thompson @Will_MI77 and Maggie Sparkman @maggiesMSFT. Since not everyone can get out and attend events like these, I sat down with the DB Best marketing team to create a series of videos that cover each letter in Best Practices for Power BI. So what do I mean by Best Practices? Be creative and tel...

Webinar 2.9 Followup (Episode 12 – Columnstore Indexes)
19 Dec 2017

Thanks to everyone who attended! You can get the slides and demo files here: Webinar 2.9 – Columnstore Indexes If you missed the session, or would like to watch the recorded session, the recording will be available soon. Don’t miss the next webinar on January 9th: Viewing Query Plans!   The registration link will be posted here when available, In addition, I am publishing a list of the upcoming topics. Please be aware they are subject to change or re-ordering. It’s not complete at this point, but it does show the planned topics for the next several months.  I will be updating it periodically. Related posts Why Learn About SQL Se...

Webinar 2.8 Followup (Episode 11 – Compression)
12 Dec 2017

Thanks to everyone who attended! You can get the slides and demo files here: Webinar 2.8 – Data Compression     If you missed the session, or would like to watch the recorded session, the recording is available here.   Don’t miss the next webinar on December 19th: Columnstore Index Storage!   You can register here,   In addition, I am publishing a list of the upcoming topics. Please be aware they are subject to change or re-ordering. It’s not complete at this point, but it does show the planned topics for the next several months.  I will be updating it periodically. Related posts Why Learn About SQL Server I...

Webinar 2.7 Followup (Episode 10 – Partitioning)
05 Dec 2017

Thanks to everyone who attended! You can get the slides and demo files here: Webinar 2.7 – Partitioning     If you missed the session, or would like to watch the recorded session, the recording is available here.   Don’t miss the next webinar on December 12th: Data Compression!   You can register here.   In addition, I am publishing a list of the upcoming topics. Please be aware they are subject to change or re-ordering. It’s not complete at this point, but it does show the planned topics for the next several months.  I will be updating it periodically. Related posts Why Learn About SQL Server Internals? Webi...

Webinar 2.6 Followup (Episode 9 – Fragmentation)
28 Nov 2017

Thanks to everyone who attended! You can get the slides and demo files here: Webinar 2.6 – Fragmentation If you missed the session, or would like to watch the recorded session, the recording is available here. Don’t miss the next webinar on December 5th: Partitioning!  Registration is available here. In addition, I am publishing a list of the upcoming topics. Please be aware they are subject to change or re-ordering. It’s not complete at this point, but it does show the planned topics for the next several months.  I will be updating it periodically. Related posts Why Learn About SQL Server Internals? Webinar #1.1 SQL Server Met...

Webinar 2.5 Followup (Episode 8 – Nonclustered Indexes)
21 Nov 2017

Thanks to everyone who attended! You can get the slides and demo files here: Webinar 2.5 — Nonclustered Indexes Because this week is a holiday week in the US, there is NO HOMEWORK! If you missed the session, or would like to watch the recorded session, the recording is available through this link. Don’t miss the next webinar on November 28th: Fragmentation! You can register here: https://www.eventbrite.com/e/webinar-kalen-delaneys-sql-server-internals-webinars-episode-9-tickets-39714618493 In addition, I am publishing a list of the upcoming topics. Please be aware they are subject to change or re-ordering. It’s not complete at this poin...

Webinar 2.4 Followup (Episode 7 – Clustered Indexes)
14 Nov 2017

Thanks to everyone who attended! You can get the slides and demo files here: Webinar 2.4 — Clustered Indexes If you missed the session, or would like to watch the recorded version,  here is the link to the video. Solution to the homework will be posted by or on next Monday. Don’t miss the next webinar on November 21st: Nonclustered Indexes!  You can register here. https://www.eventbrite.com/e/webinar-kalen-delaneys-sql-server-internals-webinars-episode-8-tickets-39713832141 In addition, I am publishing a list of the upcoming topics. Please be aware they are subject to change or re-ordering. It’s not complete at this point, but it doe...

Webinar #2.3 Follow-up (Episode 6)
07 Nov 2017

Thanks to everyone who attended! You can get the slides and demo files here: Webinar 2.3 — Large Datatype Storage And here is the link to the video. Don’t miss the next webinar on November 14th: Clustered Indexes! You can register here! ————————————– Homework discussion for Webinar #2.2: Calculate the maximum number of IAMs a single object, including its indexes, can have. (more…)...