Introduction to Microsoft Power BI: Visualizing & Analyzing Data

Code : IT024
Request In-house Training Proposal
Why Attend This Microsoft Power Bi Training Course?
This microsoft power bi training course certification is intended as a continuation of our introductory-level courses in Power BI (PL-300: Microsoft Power BI Data Analyst and/or Excel BI Tools: Power BI for Excel Users ).
This microsoft power bi training course covers common intermediate-level tasks and some of Power BI’s most desirable new features.

Get the best cost for this certified microsoft power bi training course certificate by ACAD Egypt

What Is The Microsoft Power Bi Training Course Methodology?
This microsoft power bi training course certification methodology depends on enabling participants to interact and exchange experiences, explore their competencies and achieve their career aspirations, using forward-thinking training arts, such as theoretical lectures and/or open discussion to exchange opinions and experiences, scenarios, innovative thinking brainstorming. Participants will receive an agenda including training material as a reference, in addition to some extra notes and booklets. 

Who Should Attend This Microsoft Power Bi Training Course?
The microsoft power bi training course certification is designed for users that have a desire to work effectively with data to create visually appealing reports or dashboards.

What Are The Microsoft Power Bi Training Course Objectives?
  • Import data from PDFs, regions of web pages, and collections of files
  • Characterize data with data profiling
  • Merge mismatched data sets with fuzzy matching
  • Generate custom columns in Power Query
  • Perform advanced data modeling
  • Use Power BI time intelligence
  • Work with custom scripts in R and Python
  • Create KPIs and scorecards
  • Use advanced report design techniques
  • Use advanced dashboard design techniques
  • Perform basic statistical analysis in Power BI

What Is The Microsoft Power Bi Training Course Curriculum?
Introduction to Power BI
  • What is Power BI?
  • The Power BI service
  • Power BI Report Server
  • Power BI Desktop
  • Reports and Dashboards
  • Datasets
  • Row-Level Security
  • Content Packs
  • Natural Language Queries
​​Data Sources
  • Connecting to Files
  • Importing Excel Files
  • Publishing to Power BI from Excel
  • Updating Files in Power BI
  • Data Refresh
  • The Power BI Data Model
  • Managing Data Relationships
  • Optimising the Model for Reporting
  • Hierarchies
  • SQL Servers
  • Other Data Sources
  • R Script Data Connector
  • Configuring Data for Q&A
  • Creating Content Packs
  • Creating a Group
Shaping and Combining Data
  • The Query Editor
  • Applied Steps
  • Advanced Editor
  • Shaping Data
  • Formatting Data
  • Transforming Data
  • Combining Data
  • Merging Data
Modelling Data
  • What are the Relationships?
  • Viewing Relationships
  • Creating Relationships
  • Cardinality
  • Cross Filter Direction
  • What is DAX?
  • Syntax
  • Functions
  • Context
  • Calculated Columns
  • Calculated Tables
  • Measures
Interactive Data Visualisations
  • Power BI Reports: Page Layout and Formatting
  • Multiple Visualisations
  • Creating Charts
  • Using Geographic Data
  • Histograms
  • Power BI Admin Portal
  • Service Settings
  • Desktop Settings
  • Dashboard and Report Settings

Hands-on Tasks:
Bring your own laptop to run and follow up the exercises and tasks provided by the instructor. To be sure that you can perform all tasks, Office 2010 or later version is required. Office 2007 users will find lack of some features and functions used during the exercises, in addition to some differences in the user interface and commands paths changes.
For the organization chart preparation, Microsoft Visio is required. We use Visio 2016 in the training. We recommend the latest version because Visio, unlike Excel and Office suite, usually comes with major enhancements and new features every release.

Apply now
Course Details
Personal Details
ACAD Professional Certificate - APC
ACAD Training & Consulting uses the power of its network to bring about positive, tangible change. We champion the training courses profession and the interests of individuals, engaged in that profession, for the benefit of all. ACAD Professional Certificates are designed for those who are enthusiastic to challenge themselves to reach the extra mile. Participants who fully attend an APC course and successfully pass the exam on the last training day, will receive an ACAD Professional Certificate (APC). APC are regionally recognized and can be esteemed when applying for more senior roles in Egypt and MENA region.

Exam Details:

Duration: 1 hour | Multiple Choice | Closed book | Pass mark: 65%

Course Schedule

14 - 18 Apr
10:00 AM To 3:00 PM
Cairo, Egypt
04 - 08 Aug
10:00 AM To 3:00 PM
Cairo, Egypt
17 - 21 Nov
10:00 AM To 3:00 PM
Cairo, Egypt

Search in Courses

Register Upcoming Courses