© Mapbox, © OpenStreetMap


Jason Romans

Jason Romans

Builder of models

Nashville, Tennessee, United States

Jason Romans is a Business Intelligence engineer in Nashville, TN working with the Microsoft Business Intelligence stack. Jason started his career as a DBA and over the years moved to working in his passion of Business Intelligence and data modeling. His first computer was a Commodore 64 and he's been hooked ever since.

Area of Expertise

  • Information & Communications Technology


  • Microsoft Power BI
  • DAX
  • Data Modeling

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.

Power BI and External Tools: This is the way!

Much like an adventurer roaming the galaxy – Power BI is better when it is not a solo traveler. What lies beneath the tab in Power BI named external tools, there are a lot of choices to consider, each has their own strengths and weaknesses.

These tools offer the ability to execute queries against the model, gather insights about your data model, and make changes to the data model separate from Power BI Desktop.

This session will cover an overview of the tools available, so you don’t spend a lot of time straying from the path.

SQL Saturday Oregon/SW Washington 2023 Upcoming

November 2023 Vancouver, Washington, United States

2023 SQL Saturday Silicon Valley (SQLSatSV) Upcoming

October 2023 San Jose, California, United States

SQLSaturday Orlando 2023 Upcoming

October 2023 Sanford, Florida, United States

SQLSaturday MN 2023 Upcoming

September 2023

SQLSaturday Denver 2023

September 2023 Denver, Colorado, United States

SQL Saturday Baton Rouge 2023

July 2023 Baton Rouge, Louisiana, United States

SQL Saturday Columbus 2023

July 2023 Columbus, Ohio, United States

SQL Saturday South FL 2023

June 2023 Davie, Florida, United States

Ohio North SQL Saturday 2023

May 2023 Akron, Ohio, United States

SQL Saturday Jacksonville #1041

May 2023 Jacksonville, Florida, United States

Jason Romans

Builder of models

Nashville, Tennessee, United States