Data Management and Visualization using PowerBI Training

Data Management and Visualization using PowerBI Training

About Program

Microsoft Power BI is a business intelligence technology from Microsoft that gathers and processes your data, analyses and provides data driven insights that enables managers, business analysts and key decision makers to make informed decisions real time. It allows one to ask questions and get answers about their data. Users of Power BI are able to create interactive dashboards and insights by self-interacting with the technology. This 5-days comprehensive training course will take the participants through the key features of Power BI, including data modelling, creating visualizations, and publishing reports. They will learn how to connect to various data sources, create stunning visualizations, and share insights with others in their organization.

Program objective

Upon completing this course, students will have a basic understanding of the topics below, as well as an ability to utilize and implement the concepts learned.

• Power BI
• Power BI Desktop
• Working with CSV, TXT, and Excel Worksheets
• Connecting to Databases
• Merging, Grouping, Summarizing, and Calculating Data
• Reporting
• Power BI Online

Target Audience

• Data Analysts.
• Business Intelligence Analysts.
• Data Scientists.
• Business Managers and Executives.
• Financial Analysts.
• IT Professionals.
• Database Administrators.
• Sales and Marketing Professionals.

Training Period

• Classroom: 5 Days
• Online: 7 Days

Modules

Module 1: Introduction to Microsoft Power BI

• Visual analysis and visual analytics.
• Power BI Infrastructure.
• Loading Data.
• Introduction to Power BI Desktop.

Module 2: Using Power Query to clean, transform and load data

• Profiling your data.
• Resolve data quality issues.
• Apply user-friendly names to Queries, tables, and columns.
• Import data from an Excel formatted report.

Module 3: Model development in Power BI

• Understand the role of the Data Model in Power BI.
• Create table relationships.
• Understand Cardinality and Cross Filtering.
• Discuss Star and Snowflake schema.
• Create a Date Dimension.
• Build a Data Model from multiple Data sources.

Module 4:Working With CSV, TXT and Excel Worksheets

• Importing, Transforming, and Loading Data.
• Appending Operations.
• Working with Folders and Files.
• Using Pivot Tables.

Module 5: Connecting to Databases

• Working with Relational Data.
• Understanding Relationships.
• Importing from SQL Server Analysis Services Multidimensional and Tabular.

Module 6: Merging, Grouping, Summarizing, And Calculating Data

• Understanding the Issues with Merges.
• Performing Merges.
• Grouping Options.
• Summarizing.
• Calculating.

Module 7: Reporting

• Creating Reports.
• Utilizing the Matrix Visualization.
• Using the Map Visualization.
• Plying the Card Visualization.
• Utilizing the Chart Visualization.
• Using Slicers.
• Publishing to Power BI Online.

Module 8: Power BI Online

• Introduction to Power BI Online.
• Importing Data.
• Creating Reports.
• Configuring Dashboards.
• Sharing Reports and Dashboards.
• Exploring Power BI Mobile.

Delivery Method

This program is taught through a mix of practical activities, theory, group work and case studies. Training manuals and additional reference materials are provided to the participants.

CERTIFICATION

Upon successful completion of the training, participants will be awarded a certificate of course completion