susannegov commented 6 months ago

Agenda: https://powerbisummitapp.azurewebsites.net/SingleAgendaApp Monday - Feb 12-Feb 16

Monday
- 2:20-3:20
  - Intro to Power BI
  - Introduction to M
  - Lessons Learned from my Power BI Journey
  - What it takes to be Visual MacGuyver
  - Designing Efficient Architectures: Best Practices for Governance, Security, and Sharing Policies
- 3:40-4:40
  - Getting Started with the SQL Language
  - Data Modeling and DAX with Power BI product team (Ask PBI team product managers)
  - Advanced Tabular Model Management of the Data Gods
  - Power BI Azure Map - Are You Ready?
  - Don't Panic I'm Power BI Admin
- 5:00-6:00
  - Getting started with Calculation Groups in Power BI Desktop
  - Approaches for analyzing Budget vs Actual in Power BI
  - Conditional Formatting Two Ways: Easy Recipes for Conditional Formatting
  - Scalable Power BI XMLA Reporting From Excel
Tuesday
- 1:00-2:00
  - What are we doing to achieve greater visibility of female talent in technology?
  - Writing DAX queries with DAX Query View
  - Dimensional Data Modeling in Power BI for the Beginner
  - We don’t need another dashboard, be the hero
  - Implementing DataOps practices in Power BI and Fabric
- 2:20-3:20
  - Visual Calculations: Making DAX easier
  - Time Intelligence in Power BI: Easy Wins and What to Watch Out For
  - Unlocking Power BI REST API: Exploring amazing requests with Python
- 3:40-4:40
  - Introducing Explore - a new way to explore data right within Power BI.
  - Level up your Power BI game with Field parameters!
  - Your report looks boring and nobody cares
  - Using Dynamic Management Views (DMV) to create an automated Power BI glossary dashboard
- 5:00-6:00
  - Modern Power Query User Interface in Power BI Desktop
  - Leveraging DAX for Advanced Data Storytelling in Power BI
  - Mastering Mobile Reports Design: Best Practices and Special Cases
Wednesday
- 1:00-2:00
  - Create a Star Schema from One Annoyingly-Wide Flat File
  - Double Power: Power BI and Power Apps Integration
  - My Perfect Date (Table)
  - Prepare for Power BI Data Analyst Associate using free resources
  - Continuous deployment
- 2:20-3:20
  - Mastering Rapid Power BI Development with ChatGPT: A Deep Dive
  - CALCULATE evaluation order
  - From Vega-Lite to Vega in Power BI
  - Advanced data security implementation for Power BI
- 3:40-4:40
  - Tales from a Power BI rookie: How I learned enough to create engaging reports for front-line workers
  - DAX is Easy….until it isn’t DAX basics for beginners
  - 12 things I wish I knew when I started using Power BI
  - Become Power BI Analyst in 30 minutes!
- 5:00-6:00
  - Unlocking the Power of the Power BI Community: A conversation with Super Users
  - Callbacks in Your DAX: Key to Measuring Performance in Power BI
  - Developing Custom Visuals for Power BI
  - Easy Ways to Understand the Existing Power BI Pr
Thursday
- 1:00-2:00
  - Licensing for Microsoft Fabric - An Ultimate Guide
  - From Excel Enthusiast to Power BI Pro: Navigating Data Analysis Tool
  - NotebookEverything: Tips, Tricks to Boost Your Development Using Notebooks
  - Data Modeling in Power BI
  - Make your Power BI Reports Pop
  - Building a Sustainable Data Culture
- 2:20-3:20
  - Creating Real-Time Analytics Experiences with Power BI Reports
  - Fuzzy Wuzzy Was a Bear. Or a Beer?
  - Personalization - Help users to help themselves!
  - Power BI - Time to Git CI/CD
- 3:40-4:40
  - Semantic Link, where Power BI meets Spark
  - Advanced Use Case for DAX
  - Power BI Top 10 tips and tricks
  - Power BI Developer Mode - is it for me?
- 5:00-6:00
  - Avoiding Common Pitfalls in Models and Reports: Lessons in the Trenches
  - Optimizing Power BI: a holistic View
  - Native Kernal Density Estimation in Power BI with DAX and SVG
  - Power BI Datamart: Democratizing data warehousing
Friday
- 1:00-2:00
  - Ask the Microsoft Fabric and PBI Team anything
- 2:20-3:20
  - Inventory Management
  - SQL for Power BI Developer
  - Turning Data into Influence: Lessons from Disney+ Imported Visual Storytelling in Power BI
  - Mastering Paginated Reports: Cascading Parameters and Performance Optimization
- 3:40-4:40
  - Sensitivity labels - Fabric, Power BI and Purview
  - HR Reports: DAXing Your Way to Insights
  - Making Power BI Run Faster!!!
  - Storytelling and Power BI report that connect to different audiences
  - Powershell Hacks for Power BI
- 5:00-6:00
  - How to track KPI with Power BI Metric and Charticulator
  - A complete guide to user-defined aggregations in Power BI
  - I have always asked for export in Excel. What can you do to avoid this request?
  - Power Query Custom Functions 101
  - Unleash full power of built-in Power BI visuals create custom IBCS-styled charts using DAX only!
  - Modernizing Power BI: Bridging the Feature Gaps in the transition from SAP BO to Power BI

maccallump commented 6 months ago

If I am interested will you share?

susannegov commented 6 months ago

Sessions are prerecorded, but live Q&A is on MS Teams.

Monday

Lessons Learn in Power BI Journey

Only bring what is necessary
Transform upstream as possible
Check datatypes
Use Views over Tables
Don't Ignore Query Folding
Organize folders in Power Query Editor
Go for Star Schema Data
Create bridge table instead of many:many
Live Talk with Power BI and Fabric Product team
Query caching and Edit feedback in documentation
"Tabular Editor" third party tool usage. Prioritizing basic functionality
Using DAX in Power BI Desktop for beginners training course
"Will there be a functionality to select a default value automatically for a slicer based on a dax formula rather than a saved author selection?" Yes, that is absolutely in the plan
People currently using a mixture of third party model cleanup tools such as Monkey Tools, PBI Cleaner, SideTools (export to VS)
Will there be a way for DAX measures or calculations to be saved, almost like stored procedures? Currently we save some of our complex measures in a table in SSMS. But curious if there will be a repository for measures, so that if I need to reference an old DAX script I don't have to go back to the original .pbix that it was written in.
- currently all DAX are stored in BIM file if you use pbip
  - "In my org, we use Power Automate to trigger our Power BI refreshes after our Data Warehouse has finished its daily ETL process."
  - "Star Schema"
  - Replace vs. Duplicate vs. Reference

susannegov commented 6 months ago

Tuesday

Time Intelligence in Power BI

Date Table (using DAX)
Auto date/time performance improvement
You can use Calendar Function with Min and Max Functions to create Dynamic Date Table
For multiple dates, it is good to mark as a date table to mark date intelligence functions
Visual Calculations: Making DAX easier
Defined on a visual
Any visual can be represented as a matrix
- Visual Calc Profit = [sales] - [total product]
- Measure Profit = SUM([sales]) - SUM([total product])
  Field Parameters in Power BI
  - 3 columns
  - Name of column
  - NAMEOF = allows to change column by slicer
  - Order
Group attributes within field parameter slicers
SELECTEDVALUE
Extend field parameter table using relationship tables
Using Dynamic Management Views for automated Power BI glossary
Using DAX Studio
Using Power BI for Storytelling
Highlighting Max and Min
- Best Month MAXX(ALLSELETED(Months,MonthNo),[Total Sales]))
- Worse Month MINX(ALLSELETED(Months,MonthNo),[Total Sales]))
- Month Color SWITCH(TRUE(),first condition, second condition,etc....)
Highlight Top months
- Monthly Rank RANKX(ALLSELETED(Months,MonthNo),[Total Sales]))
- Month Rank Color SWITCH(TRUE(),first condition "good", second condition "bad",etc....)
- The "good" and "bad" is from sentiment colors in Power BI themes
- Month Rank Color V2 = IF(ISINSCOPE([Month]),[Month Rank Color]))
Dynamic Formatting based on Slicer Selection
- Create parameter
- Target constant line = set to paremeter
- Dynamic target Color IF([TotalSales] > Target Value, "good")
Dynamic Data Labels with Colored Variation
- Setup a YOY % measure
- Text Label and label color if condition

susannegov commented 6 months ago

Wednesday

My Perfect Date (Table)

Year, Month No., Month Name, Day of Week, Is Holiday
Date Time needed for DAX's Time Intelligence functions
Recommended to turn off Auto date/time
- Creates a calendar table for every column of data type date/time
- Available columns are restricted to Year, Month, Month Number, Day
  - No way to edit or add columns
- Disabling Auto date/time later can corrupt your data model and your reports
  - Visuals using the date hierarchy will change their content
Do not create from fact table. Create in DAX, Power Query, or SQL instead
Uses Dax Studio (Free open source tool) to show how auto datetime memory usage
Use of AI and Chat GPT in Power BI development
Navigating effects of AI study - Good at Junior level, not so much at senior level
Use cases
- SQL BI Professional to tweak M and DAX
- PBI/Citizen developers/SME lacking coding expertise
- Professional lacking UI/UX and need inspiration
Generate issues with a data model from reading a sql script
Analyze files for data quality issues
- In the demo, it showed the unit cost and zip missing values
Generate Artificial Data
- Great for testing
- Ask it to generate a python script of fact and dim tables
- Please please double check the code generated before running it >:(
Generate Power Query code
- Date Table
Generate DAX Measures
Generate a Report Banner
Generate a Tabular Editor script
DAX is easy until it isn't

12 things I wished I knew when using Power BI
Renaming columns in Power Query. Use optional parameter called missingField.UseNull will keep the refresh
Data preparation recommended at source or power query
Centralize logic using shared datasets: single source of truth
Dealing with dates
Keep track of changes
- Use sharepoint/onedrive

susannegov commented 6 months ago

Thursday

Building a Sustainable Data Culture

Data Culture influence Data governance
Data governance

susannegov commented 6 months ago

Friday

Ask the Microsoft PBI and Fabric team anything

Chat GPT has a business platform where the data is supposedly secure and not used for training. Normal personal ChatGPT isn't.
Microsoft product team will be working on Microsoft Fabric to be available on the GCC Government tenant around the Summer. Not sure if it mean s it will be available per se, but they said they will be working on it that semester.
From comment about what PBI resource to use for data model:

I use these...

https://data-goblins.com/dataset-checklist

https://exceleratorbi.com.au/new-power-bi-reports-golden-dataset/

https://www.withum.com/resources/power-bi-data-model-governance-with-power-bi-golden-dataset-and-thin-reports/#:~:text=A%20Golden%20Dataset%20or%20Golden,without%20affecting%20the%20model%20itself.
About Git integration in Microsoft Fabric:

Fabric GIT integration doesn't currently support GitLab. Git enablement i.e. using downloading files and saving as PBIP you can put those files in source control and use api's etc to do automation of deployments. Git integration with Power BI Desktop projects - Power BI | Microsoft Learn

Roadmap item is (trying to find the roadmap item on the other source control platforms as there is one with GitHub and Github enterprise i believe)

Mastering Paginated Reports
Used for professional reporting (ledger type)
Format dataset for physical printing purposes
Example demo: PBI report using a dataset
Data model tables
Storytelling