Microsoft Power BI (Office Elearning Menu)

Introductie

We extend a warm welcome to you to explore the Power BI E-Learning Course. We are delighted that you are considering this opportunity to enhance your skills and knowledge in the realm of data analysis and visualization with Power BI Desktop.

Omschrijving

Engage in a comprehensive journey through the Power BI Desktop Training. This immersive video course is meticulously crafted to equip you with the ability to connect to diverse data sources, shape raw data into meaningful insights, and construct dynamic and visually appealing dashboards. Upon completion of the core modules, you will have the chance to practice and reinforce your understanding through practical exercises. All exercise files and their corresponding solution files are available for download to facilitate seamless learning.

Target Audience

This course is designed for individuals who process and analyze substantial volumes of data to construct efficient and pertinent dashboards using Power BI Desktop. Whether you are new to data visualization or seeking to refine your skills, this course is tailored to empower your journey.

Content

Module 1: Course Introduction

• Duration: 2 minutes

Module 2: Presentation of the Course

• Duration: 6 minutes
• Topics Covered: Introduction to Power BI Desktop, Workflow and Core Concepts, Course Organization

Module 3: Data Source Connection and Preparation

• Duration: 56 minutes
• Topics Covered: Connecting to Excel Workbooks, Preparing Imported Excel Data, Importing Excel Data into PivotTables, Exercise 1: Importing Orders from Excel, Connecting to Databases, Data Extraction, Cleansing, and Filtering, Creating Columns and Conditional Columns, Connecting to Other Data Sources (txt, csv, pdf, SharePoint list), Exercise 2: Importing Tables from French Books Sales, Solution 1: Importing Orders from Excel, Solution 2: Importing Tables from French Books Sales

Module 4: Building Data Models

• Duration: 44 minutes
• Topics Covered: Introduction and Steps, Establishing Relationships, Crafting the Calendar Table, Defining Explicit Measures, Organizing Model Fields, Exercise 3: Setting Up the Financial File Model, Exercise 4: Setting Up the French Books Sales File Model, Solution 3: Setting Up the Financial File Model, Solution 4: Setting Up the French Books Sales File Model

Module 5: Visualizing Insights

• Duration: 48 minutes
• Topics Covered: Crafting Dashboard Pages, Creating Bar, Line, and Pie Charts, Mapping Summary Data, Visualizing Geography, Generating Tables and PivotTables, Utilizing Slicers, Exercise 5: Crafting Charts using French Books Sales, Exercise 6: Creating Tables and PivotTables with French Books Sales, Solution 5: Generating Charts using French Books Sales, Solution 6: Crafting Tables and PivotTables using French Books Sales

Module 6: Advanced Data Analysis with DAX

• Duration: 31 minutes
• Topics Covered: Understanding Filter Context and its Propagation, Leveraging the CALCULATE Function, Exploring the ALL Function, Utilizing COUNTROWS and DISTINCTCOUNT Functions for Counting, Analyzing Trends with DATEADD Function, Exercise 7: Employing CALCULATE, COUNTROWS, and DATEADD to Construct a Table using French Books Sales, Solution 7: Utilizing CALCULATE, COUNTROWS, and DATEADD to Formulate a Table using French Books Sales

Module 7: Interactivity and User Experience

• Duration: 8 minutes
• Topics Covered: Managing Natural Interactions, Delving into Detailed Data, Exercise 8: Customizing Interactions in French Books Sales Dashboard, Solution 8: Tailoring Interactions in French Books Sales Dashboard

Module 8: Application Design Principles and Publishing

• Duration: 51 minutes
• Topics Covered: Principles of User Experience Design, Preparing Page Backgrounds and Themes, Incorporating Visual Elements, Adding Tabs and Buttons, Harnessing Bookmarks, Utilizing Slicers and Dynamic Titles, Enhancing User Experience with Tooltips, Applying Conditional Formatting in Tables, Process Overview

Module 9: Publishing on Power BI Service

• Duration: 9 minutes

Join us to embark on an illuminating journey through the realm of Power BI dashboard creation!

Course Format

The course is presented in the form of instructive videos, demonstration sessions, hands-on lab environments, and an accessible online Office environment. This dynamic blend of learning methods ensures that you gain a comprehensive understanding of Power BI Desktop's capabilities.

Admission Criteria

To embark on this enriching journey, a foundational level of good Excel skills is a valuable prerequisite. We welcome participants of diverse backgrounds and experiences to join us in exploring the potential of Power BI.

Accessibility

Recognizing the importance of flexibility, we offer you 24/7 online access to the course for a period of 365 days following activation. This allows you to learn at your own pace, aligned with your personal schedule. The total course duration is 5 hours and 7 minutes, subject to variation based on individual learning speed and time allocated for practical assignments.

Contact

With great pleasure, our dedicated educational advisors are ready to answer all your questions. Your curiosity and interest are welcomed with open arms. Whether it's about specific course details, study options, or learning pathways, we are here to assist you.

Our availability spans from Monday to Friday, within a time window that starts at 09:00 AM and concludes at 05:00 PM. During these hours, you have the opportunity to contact us directly and inquire about anything you need. We believe in personal interaction and strive to serve you with the utmost care and attention.

You can reach us by phone at +31 367601019. For those who prefer written communication, we are also available via email at info@officeelearningmenu.nl. Do not hesitate to get in touch, as we are here to nurture your curiosity and guide you on your educational journey.

Warm regards, Graham Hulsebos Educational Advisor at Office Elearning Menu