- Improve Your Report Development With User Experience Theory
Chennie Teng will show you how to apply user experience theory to improve your report development. Well-designed reports will allow your end users to easily understand the reports and make better business decisions.
Good reports (with great UI/UX) will provide better insights into the data. Good UX applies not only to report development, but it could also be useful in presentations, Power App design, and many other applications.
Chennie will demo a bad UI report vs a good UI report. You’ll see the importance of UI design when it comes to report development.
You will learn…
• About UX theories
• How to apply UX theories to a report
• The difference between a bad report design and a good report design
• How you can improve your report development skills
• Power BI report tips and tricks
Chennie Teng is a Business Analyst at DesignMind. He graduated from UC San Diego with a degree in Cognitive Science - Human Computer Interaction.
- Power BI Bad Practices – Learn from the Mistakes of Others
You can learn about Power BI best practices by observing bad practices. Microsoft MVP Gil Raviv is here to show you all the bad ones!
There are tons of best practices we can learn about, but the day to day demands of our jobs often force us to take shortcuts and make mistakes. This can cause negative results, which tend to be more memorable, and can help us remember what to avoid. These mistakes can help motivate us to do things the “right way” the next time around. Besides, it is kind of fun learning about how things sometimes go wrong!.
You'll get to see demos on:
• Bad usage of pie and other charts
• Data shaping problems to avoid
You will learn:
• How to identify project failure or success
• How to learn best practices from the mistakes of others
• The four strong pillars for avoiding failures
Gil Raviv is Director of Analytics, Avanade, and a Microsoft MVP
- Introduction to Power BI Dataflows
Learn about Power BI Dataflow, Microsoft's self-service, cloud-based, data preparation technology. Power BI expert Zenifa Ali will show you different ways to create a Dataflow in Power BI service. You'll learn all about Power BI Dataflow and why and when to use Dataflows.
You will learn:
• How to create PBI Dataflow
• How to Manage and Consume Dataflow
• Refactor PBI Dataflow Entities
• Types of Dataflow Entities
• Benefits of using PBI Dataflow
• Best practices
Zenifa Ali is a Business Intelligence Consultant at DesignMind and has also worked as a SQL Administrator. She has experience creating PBI reports, ETL workflows, writing DAX, SQL queries, and Data Modeling.
- How To Build an Interactive Power BI Report
Did you know you can turn a Power BI report into an interactive app/report by using bookmarks, filters, interactions, buttons and selections? Chennie Teng of DesignMind will explain it all, plus show you how to create advance DAX measurements to display custom visualization based on user requirements. You'll get to see demos demonstrating all these features.
* How to make your Power BI report more interactive
* Tips and tricks to to improve user interface and user experience on Power BI
* Advance DAX measurement for building custom visualizations
* How to use bookmarks, filters, interactions, buttons, and and selections
- Power Apps / Power Automate: How to Create Role Request Forms and Approvals
Learn how you can automate your manual role request and approval system. Parinaz Kallick will demonstrate how to use Power Apps and Power Automate to change a manual role request and approval process to an automated system.
Parinaz developed this efficient workflow proof of concept during a hackathon. The goal was to quickly improve processes within an organization using the Microsoft Power Platform ecosystem.
She'll talk about the architecture and the code/nocode components, and demo the final product from an end-user perspective. By the end of the session, you'll have an excellent overview of the Microsoft Power Platform.
You'll learn about:
• How to use Power Apps to create role request forms
• Connecting Power Apps to Azure SQL
• Connecting Power Apps to SharePoint List(s)
• How to automate approval processes in Power Automate
• Connecting Power Automate to a SharePoint list
Parinaz Kallick is a Principal Business Intelligence Consultant at DesignMind. She develops solutions using SQL Server, Azure, Power BI, and the Power Platforms.
- External Tools for Power BI with Marco Russo
Note: This meeting is at 12:00 pm PST!
Power BI integrates with external tools that can provide additional features and improve the productivity for report authors. Internationally known BI expert Marco Russo will describe how the External Tools feature in Power BI works, and analyze a few popular external tools like DAX Studio and Tabular Editor.
In various demos Marco will show:
* How to find the configuration file for external tools and its content
* How DAX Studio works as an external tool
* How Tabular Editor works as an external tool
* How to integrate a tool in Power BI
* How to improve authoring Power BI models by using Tabular Editor
* How DAX Studio can be used to query an existing Power BI model and investigate DAX performance or calculation issues
- Automating Power BI Creations in 2020
Since Power BI was released in 2014, Power BI, Office 365, and Azure have added significant automation capabilities. To stay informed, you need to learn about the most recent capabilities and what they mean to you.
Angel Abundez will present a wide-ranging overview of data refresh setups common in Power BI projects going from DIY to more advanced scenarios that need IT support. Whether you’re automating reports for your department or for the enterprise, there’s something here for you.
You'll learn how to:
* Refactor your Power BI files to be automated
* Refresh data from files hosted on SharePoint, One Drive, and REST APIs (CSV, Excel, JSON, etc)
* Pull data from on-premises and cloud data sources using Power Automate, the Power BI Service, and Azure
* Learn about Power BI Gateways, if you need one, and things to watch out for in terms of performance and scale
* Work with cloud databases such as Amazon Redshift, Azure SQL DB, and Snowflake
- See Inside DAX, Power BI's Advanced Calculation Language
Learn all about DAX and the power it can bring to your enterprise reporting. Brian Grant will be your guide to looking inside basic DAX code to see what's happening under the hood. You'll find that at its heart DAX is a shockingly simple machine that is completely learnable, even by mere mortals.
> About DAX, and why it's important
> How to use DAX to perform advanced business calculations in Power BI
> How to make DAX easier by being able to see what it's doing behind the scenes
Brian Grant is an Analytics Consultant at CSG Pro by day, and a Power BI legend by night. Brian's passion for Power BI has led him to holistically master the tool from all three perspectives: M, DAX, and the visualization layer. He has a passion for teaching and is constantly uploading new material to YouTube, blogging, and leading Power BI training sessions for clients.
- Snowflake + Power BI: Cloud Analytics for Everyone
Angel Abundez will explain how Power BI and Snowflake can work together to bring a best-in-class data and analytics experience to your enterprise. You can combine Snowflake’s easy to use, robust, and scalable data platform with Power BI’s data visualization, built-in AI, and collaboration platform to create a data-driven culture.
You'll learn about the different analytical methods analysts and developers can use to leverage data, either from Snowflake or Power BI. Angel will review best practices that can help speed up development and optimize performance.
* Analytical methods for working with data in Snowflake and/or Power BI
* Typical Snowflake/Power BI architectures
* Infrastructure requirements
* Best practices for optimized performance
* How to help consumers gain insights
* Security requirements
* Governance considerations for End Users, Power Users, and Administrators
- Incremental Refreshes in Power BI
Speakers: Sravanthi Gandu and William Brown
Power Platform Technical Specialists at Microsoft
Incremental Refresh is a new feature in Power BI. It improves data load times and opens up PBI to the professional developer.
You will learn how to quickly set up the required parameters for Incremental Refresh. You'll also see lots of demos of XMLA RW endpoints.
Incremental Refresh offers refreshes that are:
• Faster - Only data that has changed needs to be refreshed. For example, refresh only the last five days of a ten-year dataset.
• More reliable - It's no longer necessary to maintain long-running connections to volatile source systems.
• Lighter and use less resource consumption - Less data to refresh reduces overall consumption of memory and other resources.