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
Topics
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.