Demystifying DAX: An Introduction to Data Analysis eXpressions

Welcome to the wide, wonderful world of DAX! In this introductory session, we embark on a journey through Data Analysis Expressions (DAX), the language at the heart of Microsoft Power BI, Excel Power Pivot, and Analysis Services. We'll lay out a DAX learning path, examine DAX syntax, and provide a solid foundation to know how, when, and where to leverage DAX in your data analysis journey.

Basics of Building a Data Model in Power BI

So, you want to start using Power BI. You have a couple of data sources that you want to bring in. How do you go about bringing in this data? How do you build a data model out of this data?

This can be a daunting task and one we will tackle from the beginning. First, we will look at using Power Query to bring in the data. Then we will examine how to best create the data model.

We will cover some of the best practices when developing the data model so that it scales well. One of the benefits of having a well-designed model is the DAX code can be easier to understand.

Requirements Gathering 101

No analytics, BI, or reporting effort will succeed without a great foundation. If you, the report creator, do not know what success looks like in the eyes of your stakeholders and report consumers, your reporting project is destined to fail.

In this presentation, we will begin with the basics, understanding the "why" behind the report(s) you are creating, and then explore a method I call "design backward and build forward".

Together, we will explore the process and technique of what sets a great foundation for successful analytics. Join us on March 21 to discuss how to build a great foundation for your next reporting project.

Storytelling in the Age of Big Data

In today's data-driven world, the ability to distill complex information into compelling narratives is paramount. Join us for an enlightening exploration of "Storytelling in the Age of Big Data: A Visual Perspective," where we delve into the art and science of conveying insights through powerful data visualization.

Key Highlights:

Mastering Data Visualization Techniques: Learn how to create visually stunning representations of data that engage, inform, and inspire.

Narrative Construction: Understand the nuances of crafting narratives around complex datasets, ensuring your message is clear and impactful.

Interpreting Visual Cues: Explore the psychology behind effective visual communication and how to guide your audience through your data-driven stories.

Ethical Considerations: Delve into the responsible use of data visualization and storytelling, ensuring accuracy, transparency, and privacy.

Case Studies and Best Practices: Gain insights from real-world examples and best practices from leading professionals in the field.

Tools and Technologies: Explore a diverse array of tools and technologies that facilitate seamless data visualization and storytelling, regardless of your preferred platform.

Who Should Attend:

This session is designed for data analysts, visualization specialists, storytellers, UX/UI designers, business analysts, researchers, and anyone passionate about transforming data into compelling narratives. Whether you're a seasoned professional or just starting your journey, this session offers valuable insights and practical knowledge applicable to all skill levels.

Unlock the potential of your data-driven narratives and leave with a fresh perspective on how to captivate your audience in the age of big data.

Intro to Microsoft Fabric

Microsoft Fabric is an all-in-one SaaS analytics solution combining elements from Power BI, Azure Synapse, and Azure Data Factory. In a unified platform, this combination allows users to build:

• Scalable data pipelines with native connections to ~200 data sources

• Machine Learning models

• Data Warehouses

• Data Lakehouses

• Real-time analytics solutions

• Power BI report and dashboards

During this talk, we'll introduce Fabric's features and capabilities. We'll also demo how to build a data pipeline, load data into Fabric's OneLake, model the data, and visualize the data with Power BI.

Power BI 101 - Connect and Transform with Power Query

This is the first session in our series to help you get started with Power BI. This session will focus on connecting to data and transforming it into an organized dataset that can be visualized in Power BI.

Dashboard Contest Presentations - 6th Annual

We hope you can join us to watch your fellow users present their dashboards in our 6th annual Excel & Power BI Dashboard Contest. You do not need to present a dashboard to come. We need people to vote, so please join us.

If you want to participate in the contest, reply to this email or message Will Harvey through meetup. Don't wait, because there are limited slots. Here are the contest rules:

• Use Power BI, Excel, or Tableau to create a dashboard. (Yes, we are going mix it up and allow people to use Tableau this year!) You can share something you already made at work if you want. Just make sure you hide anything sensitive.

• Tell a story with your data. We will be looking for originality and creativity.

• Submit the title of your Dashboard by Tuesday Jan 17th to Will Harvey (williamharvey at gmail.com or Meetup.com message).

• Present your dashboard on January 19nd meeting (~5-10 min).

• The live audience will vote and we will announce the winner.

• If you win, you get the bragging rights and we will share a screenshot and description of your Dashboard with our 1,000+ User Group email list.

Modern Excel with Chris Webb

If you have a long memory you'll recall that 8 years ago Microsoft BI was all about Power Pivot and Power BI in Excel. Power BI is the big thing nowadays but Excel's BI features have recently had a makeover - and in this session we'll see just how much BI you can do with the Excel you already own, without paying for Power BI or any other BI tool. As well as seeing what's new in Power Pivot and Power BI you'll see how Office Scripts can be used to automate tasks and Data Types can bring in external data.

Chris Webb is a member of the Power BI Customer Advisory Team at Microsoft. He has over 20 years of experience using Microsoft BI tools, has written several books and blogs about Microsoft BI at https://blog.crossjoin.co.uk/

Power BI: Tips and Tricks

Michael Hewitt will be presenting Power BI Tips and Tricks that he has learned over the years using Power BI and being a part of our user group.

We will be meeting both in-person and online. (Note: the Microsoft Office requires a health check so if you plan to come in person, see the details below. If that does not work for you or if you will not be able to come in person, we will provide a Zoom link for the meeting.)

Power BI & ALM: Or How to Do Version Control at Scale

If you have ever developed Power BI content with someone else or within a team, you know how difficult it can be to manage version control. Also, what if you need traceability and audit capability? This can be a crucial requirement for Sarbanes-Oxley compliance.

That said, not every team and not every Power BI solution requires the same level of rigor. In this meetup, we will explore the options for managing version conflict and being able to trace the changes you make to your Power BI content.

Power BI: Tips and Tricks

Power BI Tips and Tricks

We will be meeting both in-person and online. (Note: the Microsoft Office requires a health check so if you plan to come in person, see the details below. If that does not work for you or if you will not be able to come in person, we will provide a Zoom link for the meeting.)

ZOOM Meeting:
https://us02web.zoom.us/j/81975508982?pwd=bmkzNnJUV3U5Nmhtd2lBNFc1SDBodz09

For those in person, we will provide a free lunch.
In this meeting we will try and show 30 Power BI tips and tricks in 30 minutes! The clock is on!

IMPORTANT:
Everyone entering a Microsoft facility in the U.S. must be fully vaccinated and upload proof of their COVID-19 vaccination or attest to having an approved accommodation in HealthCheck. (For approved accommodations, please be prepared to show a negative COVID test that has been taken 7-days prior to the date of entering the office).

HealthCheck:
https://msrtw.powerappsportals.com/en-US/

Power Query Review: 10 Years Later

After a long hiatus, we are back!!

We will be meeting both in-person and online. (Note: the Microsoft Office requires a health check so if you plan to come in person, see the details below. If that does not work for you or if you will not be able to come in person, we will provide a Zoom link for the meeting.)

For those in person, we will provide a free lunch.

The topic of this meetup will be one person’s journey using Power Query for almost 10 years. We will look at the basics of Power Query, talk about the pros and cons using it in different applications, and the best way to learn more about it. Power Query is a data exploration and transformation tool in Power BI and Excel.

IMPORTANT:
Everyone entering a Microsoft facility in the U.S. must be fully vaccinated and upload proof of their COVID-19 vaccination or attest to having an approved accommodation in HealthCheck. (For approved accommodations, please be prepared to show a negative COVID test that has been taken 7-days prior to the date of entering the office).

HealthCheck:
https://msrtw.powerappsportals.com/en-US/

ZOOM Meeting Info:
We will post the Zoom link on the day of the event, so check back on this page then.

Basic Data Modeling for BI Reporting

In our BI journey, we all hit a plateau in our learning curve. One reason is that we haven't modeled our solution correctly. In order to move to the next level of our journey along the BI learning curve, we need to understand how a tool like Power BI works. Only then will we understand why we design our data models the way we do. In this session, we will review how tools like Power BI work how that impacts the way we build data models.

About: Michael McKinley is the founder of McKinley Consulting. Michael has managed data transformation projects for the last nine years. He is Microsoft Certified in Power BI and the Power Platform and has worked with major clients such as HCA, FedEx, and the United Methodist Church, among others.

Daniel Otykier Talks Tabular Editor 3: The Best Power BI Tool That Isn’t Power BI

Join us *online* as we meetup to share ideas around Power BI, Modern Excel, and the Power Platform.

After you've mastered Power BI Desktop, the most important tool for taking your data analytics career to the next level is Tabular Editor. Daniel Otykier, the creator of Tabular Editor, has just released the third full version, and it is chock full of advanced features.

If you work on Power BI datasets on a regular basis--particularly large, complex datasets with several tables, dozens or hundreds of metrics, and a lot of data--then this is the professional, enterprise-grade tool that you will need.

Daniel Otykier joins the Nashville Modern Excel & Power BI User Group to give us a walk-through of the best Power BI tool that isn't Power BI. Be sure not to miss out on this great presentation!

Fifth Annual Dashboard Contest

We hope you can join us to watch your fellow users present their dashboards in our 5th annual Excel & Power BI Dashboard Contest. You do not need to present a dashboard to come. We need people to vote, so please join us.

If you want to participate in the contest, reply to this email or message Will Harvey through meetup. Don't wait, because there are limited slots. Here are the contest rules:

• Use Power BI and/or Excel to create a dashboard. You can share something you already made at work if you want. Just make sure you hide anything sensitive.

• Tell a story with your data. We will be looking for originality and creativity.

• Submit the title of your Dashboard by Tuesday July 20th to Will Harvey (williamharvey@gmail.com or Meetup.com message).

• Present your dashboard during the July 22nd meeting (~5-10 min).

• The live audience will vote, and we will announce the winner.

• If you win, you get the bragging rights, and we will share a screenshot and description of your Dashboard with our 1,000+ User Group email list.

Thursday, June 17, 2021

11:30 AM CDT

How To Use Data Visualization To Make Better Decisions — Faster

Many organizations don’t realize how much faster and more accurate their decision-making would be if they were better at data visualization. Indeed, most organizations struggle with seeing and understanding their data. (Think about some of those 100-page slide decks and 60-column spreadsheets.)

In this live session, best-selling author and data visualization consultant Steve Wexler will share insights on how to get your organization to "get" data visualization.

Attend and learn:
Why “just the numbers” isn't good enough
The “gateway drug” to data visualization
Why we see so many bar charts
Why most people make a mess of using color
The secret to engaging your stakeholders and the power of disaggregated data
What you should always, always, always keep in mind

If you’re new to data visualization, this webinar will help you understand the benefits of well-designed charts and dashboards. If you are experienced in data visualization, this webinar will help you evangelize its use in your organization.

About: Steve Wexler is the founder of Data Revelations, co-author of The Big Book of Dashboards: Visualizing Your Data Using Real-World Business Scenarios, and author of the upcoming book The Big Picture: How to Use Data Visualization to Make Better Decisions—Faster.

Steve has worked with ADP, Gallup, Johnson & Johnson, Deloitte, ExxonMobil, Convergys, Consumer Reports, The Economist, SurveyMonkey, Con Edison, D&B, Marist, Cornell University, Stanford University, Tradeweb, Tiffany, McKinsey & Company, and many other organizations to help them understand and visualize their data.

A winner of numerous data visualization honors and awards, Steve also serves on the advisory board to the Data Visualization Society.

His presentations and training classes combine an extraordinary level of product mastery with the real-world experience gained through developing thousands of visualizations for dozens of clients. Steve has taught thousands of people in both large and small organizations and is known for conducting his seminars with clarity, patience, and humor.

Tuesday, May 18, 2021

11:30 am cdt

[Online] Paginated Reports in an Hour

Join us *online* as we meetup again to share ideas around Power BI, Modern Excel, and Power Apps.

This month Alex Powers, Senior Program Manager of the Power BI Customer Advisory Team, joins to give us hands-on-keyboard training on paginated reports in Power BI. There are lots of occasions when paginated reports are called for over the "sliceable and diceable" reports you might be used to in Power BI, so this will be an invaluable technique in your BI toolset.

Paginated Reports in an Hour

This session will include a live hands-on-keyboard training for attendees, teaching you how to get started with creating Paginated Reports for Power BI to meet all your end user “Export-to” and Parameter based needs.

Follow Along URL: https://aka.ms/pbiworkshops

About: Alex Powers (Microsoft – Sr Program Manager)
From financial services to felines, the World Wide Web to professional wrestling – Alex Powers has an affinity for the conventional and unconventional when it comes to information. A self-proclaimed Excel and Power BI Enthusiast – Alex enjoys contributing to online forums, co-hosting the Power BI YouTube series Two Alex and sharing his passion for empowering others using Microsoft technologies.

Thursday, April 8, 2021

11:30 AM CDT

[Online] How Power Query Thinks

Join us *online* as we meetup again to share ideas around Power BI, Modern Excel, and Power Apps.

This month Ben Gribaudo is joining us to explain "How Power Query Thinks". Ben has one of the best blog series explaining the Power Query language. He has a wealth of knowledge about software development and data engineering, and you will not want to miss this talk if you want to learn more about Power Query.

How Power Query Thinks: Taking the Mystery Out of Streaming and Query Folding

How does Power Query’s mashup engine process the expressions you write? Query folding is one key concept—where behind the scenes, the engine may transform part or all of your M code into the data source’s native query language then ask the source to execute that query. Streaming, though perhaps a less familiar term, is even more fundamental, as it describes how table, list and binary data flows between functions in M.

Let’s take the mystery out of these two terms—but before we get to them, we’ll lay a foundation of basic concepts about how the Power Query language works. Altogether, the goal of our time together is to give you an understanding of How Power Query Thinks, so you can write more efficient mashups, are better positioned to debug problems, and can avoid unexpected variability in results.

Thursday, March 11, 2021

11:30 am cst

[Online] Building a Data Culture with Power BI

Join us *online* as we meetup again to share ideas around Power BI, Modern Excel, and Power Apps.

Succeeding with business intelligence involves technical skill and deep understanding of the business problems being solved. With traditional BI tools, delivering solutions typically requires collaboration between technical data professionals and business professionals. With modern self-service BI tools like Power BI, business professionals are empowered to produce more with less IT involvement, but success still requires efficient collaboration between business and IT. There is no one "right" or "best" way to deliver managed self-service capabilities, but there are common patterns and approaches that successful teams apply. Some companies have found the right balance - some are still struggling.

In this insight-packed session, Matthew Roche from the Power BI CAT team will present guidance on creating and maintaining a data culture, and establishing a successful center of excellence for delivering managed self-service business intelligence using Power BI. This guidance will be distilled from patterns and practices learned from engagements with over 150 global enterprise organizations that are using Power BI as their enterprise BI platform.

If you're struggling with challenges from self-service BI, if you're tasked with establishing a BI center of excellence and don't want to reinvent the wheel, if you want to help establish a sustainable data culture within your organization - or if you just want a head start to understanding the road ahead, join Matthew to learn from those who have gone down that road before you.

Matthew Roche is a Principal Program Manager in Microsoft’s Cloud + AI Group, where he focuses on data culture, business intelligence, enterprise information management, metadata, and data warehousing.

Matthew is currently a member of the Power BI CAT team, where he was saddened to learn that there were not actually any cats. Previously Matthew has worked on Azure Data Catalog, SQL Server Integration Services, Master Data Services, and Data Quality Services. Before joining Microsoft, he worked as an architect, consultant, and trainer focusing on ETL, data warehousing, and business intelligence.

When he’s not enabling the world to get more value from its data, Matthew enjoys reading, baking, heavy metal, and competitive longsword combat.

Tuesday, February 16, 2021

11:30 AM CST

[Online] Power BI Time Intelligence – Beyond the Basics

Join us *online* as we meetup again to share ideas around Power BI, Modern Excel, and Power Apps.

Time Intelligence refers to analyzing calculations and metrics across time and is the most common type of business intelligence reporting. Power BI has a lot of built in capabilities to help you get started but these alone are not enough for most real-world solutions.

The key to mastering time-intelligence in Power BI is a good date table and understanding how to control the filter context. This session will teach you about both!

In this (demo-heavy) session, we’ll quickly review Power BI’s built-in time intelligence capabilities and why you should avoid them! We’ll also cover the importance of a good date table, what attributes it should include, and how it can be leveraged to simplify complex time-intelligence calculations. Finally, we’ll breakdown many of the 40+ DAX time-intelligence functions, showing you how they work under the covers (hint: filter context) and how they can be used in combination to accommodate complex business logic.

Bill Anton is an expert in Analysis Services and an experienced data warehouse practitioner. In 2013, he founded Opifex Solutions, a consulting firm with deep expertise in enterprise-scale architecture, design, and performance optimization of Analysis Services and Power BI solutions. He loves eating and spends most of his free time convincing his beloved wife to adopt more golden retrievers.

Thursday, January 21, 2021

11:30 am cst

[Online] Practical Application of Storytelling Techniques in Power BI

Join us *online* as we meetup again to share ideas around Power BI, Modern Excel, and Power Apps.

In data visualization, we are inundated with the idea that we should be telling a story. But what is a story? And how do you use visual properties and navigation to tell a story? Join Meagan Longoria for this discussion of storytelling in data visualization and demonstration of storytelling techniques.

Meagan Longoria is a business intelligence consultant with Denny Cherry & Associates who lives in Denver, Colorado. She is a Microsoft Data Platform MVP. Meagan spends a lot of time thinking about how to use data integration, DAX, and data visualization techniques to make data useful for people. She enjoys sharing her knowledge and experiences at conferences and user group meetings, as well as through her blog (DataSavvy.me).

Thursday, December 10, 2020

11:30 AM CST

[Online] Using Calculation Groups in DAX

Calculation groups are the most important feature introduced in DAX after variables in 2015. By using calculation groups, you can apply transformations to existing measures without having to create new measures in the model. For example, you can define the year-over-year calculation once and apply it to all the measures you want. Yet, calculation groups can do more than that.

This session introduces the syntax of calculation groups, when they should be used and several examples of use cases. You will also learn how calculation groups work internally and what are the limits of this amazing tool.

Alberto started working with SQL Server in 2000 and immediately his interest focused on Business Intelligence. He and Marco Russo created sqlbi.com, where they publish extensive content about Business Intelligence.

Alberto published several books about Analysis Services, Power BI, and Power Pivot. He is a Microsoft MVP and he earned the SSAS Maestro title, the highest level of certification on Microsoft Analysis Services technology.

Today, Alberto's main activities are in the delivery of DAX and data modeling workshops for Power BI and Analysis Services all around the world. Alberto offers consulting services on large and complex data warehouses to provide assessments and validation of project analysis or to perform specific problem-solving activities.

Alberto is a well-known speaker at many international conferences, like PASS Summit, Sqlbits, and Microsoft Ignite. He loves to be on stage both at large events and at smaller user groups meetings, exchanging ideas with other SQL and BI fans. When traveling for work, he likes to engage with local user groups to provide evening sessions about his favorite topics. Thus, you can easily meet Alberto by looking up local Power BI user groups during scheduled courses.

Outside of SQLBI, most of Alberto's personal time is spent practicing video games, in the vain hope of eventually beating his son.

Tuesday, November 17, 2020

11:30 AM CST

[Online] Source Control* with Power BI

Join us *online* as we meetup again to share ideas around Power BI, Modern Excel, and Power Apps. We will be hearing from William Butler, Senior Data Architect at myNEXUS, about leveraging Teams, SharePoint, and Power BI to protect your time and energy without losing productivity.

Thursday, October 15, 2020

11:30 AM CDT

[Online] Meyers Briggs Personality Types You Find In A Self-Service BI Platform

Join us online for a terrific presentation by Microsoft MVP Chris Wagner,
Analytics Architect, Mentor, Leader, and Visionary.

Chris has been working in the Data and Analytics space for nearly 20 years. Chris has dedicated his professional career to making data and information accessible to the masses. A significant component in making data available is continually learning new things and teaching others from these experiences. To help people keep up with this ever-changing landscape, Chris frequently posts on LinkedIn and to his blog.

Come hear a talk you've likely never heard anywhere else: The Meyers Briggs Personality Types You Find in a Self-Service BI Platform. Chris will walk you through how people's different personality traits impact their relationship with data, and what that means for the creators of self-service BI solutions.

The talk is free, virtual, and open to the public. Just sign up and join the Zoom conference on Thursday, October 15, at 11:30 AM Central.

Thursday, September 10, 2020

11:30 AM CDT

[Online] Power BI Desktop and AI or “There's AI in in the Power BI Desktop?”

Yes, there is AI built right into the Microsoft Power BI Desktop. This session will guide you through adding more Intelligence to your BI reports!

Power BI is masterful at helping designers create storytelling reports that provide answers to the questions of “What has happened?” and “What is happing right now?” We can even get some insight as to “What will happen?” BUT what if you want to know “Why something happened? Or “How can we alter what will happen?” With the built in AI tools, we can start the journey of getting our “Why” and “How” questions answered.

In this session we will review the following Power BI Desktop tools:

* Q&A Tooling
* Explain the Increase / Decrease (Insights)
* Key Influencers Visual
* Decomposition Tree Visual

Tuesday, August 18, 2020

11:30 AM CDT

[Online] Guiding User Experiences With Advanced Reporting Features

As Power BI continues to innovate with new features that enhance the user experience, it is more important than ever to understand what's available to configure for the report consumer experience. Learn about advanced features such as: bookmark capture states and uses, button configurations and formatting, report tooltip applications, and the wide applicability of measure based formatting. Come listen to Reid Havens help you take your Power BI techniques to the next level.

Reid is the founder of Havens Consulting Inc. and is a Microsoft Most Valued Professional (MVP). He has an extensive background in technology and organizational management, and has obtained a Master's Degree in Organizational Development and Business Analytics. He has experience as a consultant working with many Fortune 50, 100, and 500 companies. Additionally, he teaches Business Intelligence, reporting, and data visualization courses at the University of Washington and other universities.

Reid is also an avid content developer. He has authored numerous videos and articles on multiple video platforms and blog sites. He has also developed multiple training curriculums that have been delivered to numerous companies around the world. In addition to corporate trainings, he has also developed college level curriculum for the University of Washington and other universities.