Cool way to create Data Models and Relationships in Excel

Course details

This course enables you to develop your own data models to gather accurate, complete and timely reports from your enterprise system. Whether you are new to Excel or an advanced user, Grey Campus Power course will cover what you need to know to become a Power BI User.

In this course, we will cover the various topics about the power BI which includes:

• How to publish Excel Spreadsheets using SharePoint
• ER diagrams
• Designing a layout for Excel based data model
• How to use a Power Query to create data models
• Power Pivot, design and manage the newly built data model
• Develop Interactive Dashboards using Power Views

Each and every topic mentioned above are explained in detail in the Hands-on videos. Excercises and datasets included in this course are useful to practice and implement the concepts learned in this course.

This course is is intended for the analysts and business users who are willing to explore the Power BI tools present in Microsoft Excel 2013. This training is best suited for all business professionals: data analysts, developers, IT professionals, project leads, and project managers.