Blog & Company Updates

Data Modeling Solutions for Challenging Data Modeling Problems

Do your Power BI models suffer from “ambiguous relationships”? Have you expanded your vocabulary while encountering errors trying to relate multiple tables in a data model?

Data modeling is an essential skill in Power BI design and hard problems require creative solutions. In a recent webinar Lead Consultant Paul Turley identifies common challenges and demonstrates modeling techniques to resolve them.

Over the past five or so years, we’ve seen a surge in self-service BI. This means that the business intelligence tools are no longer only in the hands of IT, developers, and analysts, but also in the hands of business users. Sure, importing data and throwing it into a chart is easy to do in many of these tools including Power BI, Excel, and Power Query, but is this type of reporting enough?

For the casual business user these tools promote the idea of importing data, mashing it together into a single flat table like in Excel and maybe bring this into a spreadsheet where we can filter, group and aggregate columns; this is referred to this as flat spreadsheet based reporting.

This reporting has its place but when dealing with a large volume of data and more complex data structures, this will not meet all your business needs. This is where the dimensional model comes in and this is the first key to understand in your data modeling journey. Dimensional modeling is the go-to modeling approach 95% of the time for business intelligence data.

This demo heavy webinar will teach you all you need to know about building a data model with examples. Paul will discuss:

  • Dimensional modeling rules; the process and steps
  • The importance of role-playing dimensions
  • Bi-directional filters
  • Many to many relationships
  • Disconnected tables and dynamic measures
  • Plus, links to some important resources and guidelines

So, if you want to learn about data modeling in Power BI, this webinar is for you. Watch the complete presentation below.

 

Need further help? Our expert team and solution offerings can help your business with any Azure product or service, including Managed Services offerings. Contact us at 888-8AZURE or  [email protected].

 

Author

  • 3Cloud is a “born in the cloud” Gold-certified Microsoft Azure technology consulting firm and Azure Expert Managed Services Provider that provides cloud strategy, design, implementation, and managed services to clients across multiple industries. Founded by former Microsoft technology leaders, 3Cloud combines a team of highly experienced cloud architects and technologists with a strong network of Microsoft sales and engineering relationships to deliver the ultimate Azure experience for clients. 3Cloud is headquartered in Chicago, Illinois with offices in Dallas, Texas and Pittsburgh, Pennsylvania and supports clients throughout North America and Europe. To learn more, visit www.3cloudsolutions.com.

3CloudData Modeling Solutions for Challenging Data Modeling Problems