Power Bi Course

12 October 2023

Business intelligence

Now you can build your ERP by your self
– Integrate all the programs and software.
– Build up all your reports and Dashboards.
– Share the results with very high authentication.
– Instant results, on diffident platforms (tabulates, mobiles, computers.
– Accurate decisions with Business inelegance

Overview:
Microsoft Power BI transforms your company data into rich visuals that facilitate new ways of thinking about and organizing your data, so that you can focus on what is important to achieving your goals. This Course includes on job training, actual practical cases from the field. Customized exercises and homework.

Who Should Attend:
This course is intended for Business Managers, Report Developers, Analysts, Project Managers and Team Leads, Financial Accountants, HR managers, Data Manager and Analyst.

Course Goals:
Upon completing this course, students will have 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
• Sharing and Report authentication.

Course Outline:
1: Course Overview

2: Power BI
• What is Power BI?
• Examining Power BI Suite of Products
• Identifying Differences Between Products
• Understanding Power BI Updates

3: Power BI Desktop
• Installing Power BI Desktop
• Exploring the Power BI Desktop Interface
• Examining Data Sources
• Discussing Data Refresh
• Understanding Data Types
• Examining the company data and reports.

4: Working With CSV, TXT and Excel Worksheets
• Importing, Transforming, and Loading Data
• Working with Folders and Files
• Using Pivot Tables

5: Connecting to Databases
• Working with Relational Data
• Understanding Relationships
• Importing from SQL Server Analysis Services Multidimensional and other data sources.

6: Merging, Grouping, Summarizing, And Calculating Data
• Understanding the Issues with Merges
• Performing Merges
• Grouping Options
• Summarizing
• Calculating
• Transforming data

7: Reporting
• Creating Reports
• Utilizing the Matrix Visualization
• Utilizing the Map Visualization
• Utilizing the Card Visualization
• Utilizing the Chart Visualization
• Utilizing Slicers
• Publishing to Power BI Online

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

9: implementing Power BI in the company

• Testing the data sources.
• Transforming the data.
• Building the dashboard reports.
• Publishing the reports.

Number of hours: 30

Our Locations:
Nablus – Main Square – Main comercial Building – 8 th floor
Ramallah – Al ersal street – nabali and faris building – 7th floor