Introduction to Power BI:

• What is PowerBI?
• How can it be used to analyze financial data?
• First Project 1/3: Installing Power BI Desktop & Source File Connection.
• First Project 2/3: Working in the Query Editor.
• First Project 3/3: The Data View & Creating our First Visuals.
• Exploring the Interface of the Data Model.
• Understanding the Power BI Desktop Workflow.
• Understanding the Query Editor Interface.
• Important! Creating the Project File & Recommended Settings.
• Connecting Power BI Desktop to Source Files.
• Keeping & Removing Rows.
• Working with Filters.
• Removing Empty Rows.
• Appending Queries.
• Working with Columns.
• Formatting Data & Handling Formatting Errors.
• Pivoting & Unpivoting Data.
• Splitting Columns.
• Creating Groups & Cleaning Up our Project.
• Creating a Group.

Power BI Architecture:

• Using Excel as a data source.
• Using a folder as a data source.
• The Power BI data model.

Data Analysis:

• Introduction to analytics.
• Explore statistical summary.
• Identify outliers with Power BI visuals.
• Group and bin data for analysis.
• Apply clustering techniques.
• Conduct time series analysis.
• Use the Analyze feature.
• Use advanced analytics custom visuals.

Understanding Relationships:

• Cardinality: Many-to-One & One-to-One.
• Cross Filter Direction & Many-to-Many.
• Understanding Active Properties.
• Understanding the DAX Basics.
• How to properly use the DAX Syntax.
• Supported DAX Data Types.
• Understanding "Data Category".
• Understanding the CALENDAR Function.
• Understanding IF & RELATED.
• Calculated Columns vs Measures.
• Understanding Basic Visual Concepts.
• Getting Started with Visuals & Reports.
• Understanding Tooltips & Interactions.
• Diving Intro Hierarchies & Drill Mode.
• Data Colors & Conditional Formatting.
• Formatting Report Pages.

Working with Report Themes:

• Using the Slicer.
• Understanding Default Summarization & Sorting.
• Working with Treemaps & Tables.
• Understanding Filter Types (Visual, Page & Report).
• Creating Combined Visuals & Waterfalls.

Improving Business Decisions using Power BI Results:

• Reports vs dashboards.
• The Natural Query Language “Q&A”.
• Analytics features.
• Forecasting.
• Data alerts.
• Share and Collaborate.

Final Project:

At the end of the program, the trainer summarizes all the material explained during the previous days and focuses on the most important points which are applicable in our daily life. Later, the trainer splits the class into several groups (teams) and distributes the final project which is a simulation of real life tasks and challenges. Every team starts applying what is requested in the final project. Meanwhile, the trainer passes through team members and tries to help them in case of any difficulty faced. At the end of the day, every team should present his final work in front of the class and an open discussion is held to assess the work.