Outcomes
By the end of this training course, trainees will be able to :
- Recognize the importance of data analysis in making the right decisions.
- Analyze data with Microsoft Power BI
- Import data from different sources.
- Clean data, profiling and shaping.
- Visualize data with Power BI.
- Improve data analysis by adding and customizing visuals.
- Model data through the construction of relationships between variables.
- Use DAX to analyze data.
- Create dashboards.
Target Group
- It targets anyone who needs to deal with data and make decisions based on it in various sectors, from managers, to people working in the fields of data analysis , project management, accounting, finance, marketing campaign management and sales, in addition to human resources employees, researchers and those wishing to develop their future skills.
Contents
- The importance of data analysis in decision-making.
- Introduction to Power BI:
- Download the program.
- The importance of Power BI in data analysis.
- A tour of the main interface of the program.
- Data Preparation:
- Import data from multiple sources
- Clean up data with Power Query.
- Transform and organize data.
- Advanced Data Cleanup
- Report & Dashboard Design:
- Control and coordinate the work interface in an attractive and professional way
- Insert images and shapes
- Create professional visualizations of all kinds advanced using charts and tables.
- Customize visualizations using formatting properties.
- Build interactive dashboards and link them with multiple reports.
- Data Modeling:
- Create relationships between tables.
- Create calculations using data analysis expressions (DAX)
- Create calculated metrics and conditional columns
- Use variables in DAX to improve performance.
- Share and analyze reports:
- Publish reports on the Power BI service.
- Practical Cases.