Data Analysis using Microsoft Power BI

Every Manager, Business Analyst, and key Decision Makers require Microsoft Power BI to gather and process data, analyze, and provide data driven insights to help in making informed decisions real time. This program 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 OBJECTIVES

Upon completing this program, participants 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

The Expedition

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 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

CERTIFICATION

Upon successful completion of the training, participants will be awarded Cynet East Africa Consultancy certificate.

N/B

Online training is available at USD 710.

Training will be facilitated by Cynet East Africa Consultancy seasoned trainers.