Call Us Today! 1-800-895-3254
[email protected]
Microsoft Training
Integent offers a comprehensive portfolio of training services, with an ideal fit for every organization. Ranging from general courses to custom solutions, we have you covered.
Learn About TrainingSee Full list of Courses
Microsoft Consulting
Integent provides consulting services for a variety of Microsoft applications including Microsoft Project, Project Online, Project for the Web, Dynamics 365, and Microsoft SharePoint.
Learn About Consulting
Microsoft Support
Microsoft technologies set the standard for project portfolio management, business applications, collaboration, and more. Integent has flexible solutions to support every customer.
Learn About Support
Microsoft Project
Integent has the knowledge and experience to help design and deploy a solution to help your organization manage projects and resources more effectively
Learn More About Microsoft Project
Microsoft Dynamics 365
Integent can help you nsure business continuity with a custom cloud solution that connects sales, service, finance, and operations teams to deliver results.
Learn More About Dynamics 365
Microsoft SharePoint
SharePoint is Microsoft’s collaboration platform that is a place where team members can communicate, exchange data, share files and much more.
Learn More About Microsoft SharePoint
Microsoft Power Platform
Consisting of Power BI, Power Apps, Power Automate and Power Virtual Agents, the Microsoft Power Platform helps streamline and improve business functions.
Learn More About The Power Platform
About Integent
Integent was founded in 2009 on the principles of building long-lasting relationships with customers, exceeding expectations, and providing outstanding customer service. 

We’re dedicated to providing a customized solution backed by our knowledgeable team of Microsoft experts.
Discover What Makes Us Different
GSA Schedule
Integent is GSA Schedule Contract holder. A GSA schedule helps simplify selling our services to government customers.
Read More Here
Stay informed on Integent’s latest company updates and other important industry information. Our passion is customer success.
Read The Latest News
Learning new software doesn’t have to be difficult with our library of dozens of free training videos. Our video training always has something new.
Browse Our Training Video Library
Our industry experts share best practices and common pitfalls to avoid, in order to get the most out of your technology solutions.
Discover More

March 29, 2021

Power BI Training - Tips on how to create a data model for powerful reports and dashboards


So you want to create powerful reports and dashboards? Well Power BI is certainly one of the strongest technologies available to create reports and dynamic dashboards for various roles in your organization.

What is Power BI?

Let's start off with what Microsoft Power BI is. Which is a collection of software apps, services and numerous connectors that work in conjunction to turn various types of data sources into visually immersive, highly dynamic and interactive insights. The data may be in an Excel spreadsheet, or a series of cloud-based as well as on-premise data warehouses. The Power BI service enables you to easily connect these various data sources in order to visualize and discover important analytics to share with anyone you want.

This Video

In this video we will look at the creation of the logical datamodel. Building a great data model basically organizes data and objects represented into data visualizations. Taking various data sources and every data element and making sense out of them by connecting them relationally to build complex dashboards and reports.  Ultimately we come up with a highly efficient database schema that will help an organization achieve real time data.

A star schema is one way to simplify a data model. The terminology you learn in this video will be equally important when understanding the process of building the data model. Choosing the correct amount of granularity is also very important for the usability and performance of your Power BI reports.

Working with Tables

You work with tables to create a structure that will be easy to navigate because column and table properties will be specific and user-friendly.

  • Use merged/appended tables to simplify tables with a data structure
  • Have relationships between tables that make sense

Working with Dimensions

When it comes to business intelligence and power bi desktop we will also have dimensions and fact tables. Fact tables are part of the logical data model and contain information about events such as sales orders, shipping dates, resellers and suppliers. A dimension table stores details about business entities such as products or time, that are connected back to fact tables through a relationship.

Understanding data granularity is important as well. You could settle on data granularity that is weekly, monthly or quarterly. Generally, the fewer the records that you work with the faster your reports and visuals will render. What this results in is a faster refresh rate for the entire model, which may allow more frequent refreshes.

Join Us!

Join us for this video to learn about creating a data model. Remember, all your reports use the data model for the source of their data. It is therefore, very important the data model is created correctly.

© Copyright 2023 | | All Rights Reserved
linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram