On October 25th, 1997, I attended a football (American) game in Lawrence, Kansas between the number 1 ranked Nebraska Cornhuskers and the Kansas Jayhawks. It was a cold and rainy night which, in addition to a lopsided score, prompted some family members to suggest we leave early. I wasn’t old enough to legally drive at the time and thus had to plead that we stay till the end as I was enthralled by various attributes, behaviors and subtle details of a team that would go on to win a national championship several weeks later.
On October 27th, 2018, I’ll be presenting two sessions at SQL Saturday Lincoln (Nebraska), one of which is titled “Husker Power BI”. This blog post outlines the five sections included of this presentation and provides a preview of a few demo examples to be referenced in each section.
Section 1: Intro and Background
- Brief, high level overview of the Power BI platform
- Solution Architecture for Husker Power BI to be demonstrated
- New Power BI App Workspace (Preview) and App
- On-Premises Data Gateway
- Dataset, Dashboards, and Reports
- BI Scenario Background
- Who are the stakeholders and what questions do they have?
- What data is available and how is it stored and structured?
- Technologies in Section Demo:
- Azure Data Studio
- T-SQL Queries against Husker Data Warehouse
- SQL Server 2017 Database Engine
- Visio Database Diagram
- SQL Server Management Studio (SSMS)
- Azure Data Studio
Section 2: User Experience in Power BI
- How do users access and consume the solution?
- Power BI App, Mobile Applications
- Brief comparison of dashboards versus reports
- Enterprise design with multiple dashboards highlighting common KPIs
- Navigation links between dashboards and reports
- Technologies in Demo:
Section 3: Dataset Development in Power BI Desktop
- The different roles and layers of Power BI Desktop
- Report authoring versus data modeling tool
- Power Query Editor, Relationships & Modeling, and Visualization layers
- Power Query Editor and the future of Power Query (M) in MSBI
- Data Modeling Layer
- Relationships, Hierarchies, DAX, RLS (Row-level security)
- Technologies in Demo:
- Query Parameters
- Staging queries and conditional derived columns via M
- Intellisense for M Language (Preview)
- Relationships view, cardinality and cross-filtering in Power BI Desktop
- Row-level Security and testing RLS roles in Power BI Desktop
- DAX measure with semi-additive pattern and subtotal versus individual logic
Section 4: Report Development
- Live connection reports leveraging Power BI datasets as the source
- Report Themes
- Corporate colors (e.g. scarlet and white) as defaults
- Mobile Optimization for report pages and dashboards
- Technologies in Demo:
- Expression-based formatting
- Report page tooltips (how was it built?)
- Drillthrough report page (how was it built?)
- Custom Report Themes in VS Code
Section 5: Administration
- Power BI Service Admin role
- Power BI Management PowerShell Module
- Power BI Admin Portal
- Gateway Management Portal
- Technologies in Demo:
- PowerShell scripts for analyzing the volume and distribution of Power BI content at the tenant level
- PowerShell scripts for managing users and app workspaces
- On-Premises Data Gateway Portal and Cluster Settings
- Tenant settings in the Power BI Admin portal
Wrapping Up
On July 1st, 2018 I wrote in Quantitative Tightening Analyzed that “if something significant happens in the financial markets later this year, such as a bear market in stocks or bonds, I’ll definitely revisit this topic and extend this simple example.” Recent volatility in treasury yields and equity markets suggests this could be a great topic for after my Power BI World Tour – Seattle presentation later this month.
Insight Quest 
Can I download the .pbix file?
LikeLike
No, sorry. (As FYI there are multiple PBIX files used in the demo – one dataset file and several report files which leverage the dataset file via live connection.)
LikeLike
Good Content.and very informative information.
LikeLike
Thanks Vibodha
LikeLike