What you'll learn:
- Connect to Microsoft Access Database
- Install Power BI Desktop
- Create and manage data relationship
- Create calculated columns
- Optimize models for reporting
- Implement time intelligence on data
- Apply filters on visuals
A data model refers to the logical inter-relationships and data flow between different data elements involved in the information world. It also documents the way data is stored and retrieved. Data models help represent what data is required and what format is to be used for different business processes
Power BI is a business analytics solution that lets you visualize your data and share insights across your organization, or embed them in your app or website. Connect to hundreds of data sources and bring your data to life with live dashboards and reports.
Data Modeling is one of the features used to connect multiple data sources in BI tool using a relationship. A relationship defines how data sources are connected with each other and you can create interesting data visualizations on multiple data sources.
With the modeling feature, you can build custom calculations on the existing tables and these columns can be directly presented into Power BI visualizations. This allows businesses to define new metrics and to perform custom calculations for those metrics.
What You will Learn includes:
How to connect to Microsoft Access Database File
How to create and manage data relationship
How to create calculated columns
How to optimize models for reporting
How implement time intelligence on data
How to apply filters on visuals
