Power Business Intelligence (Power BI) - Online Session

September 14, 20210Power Business Intelligence (Power BI)

  • Overview
  • Course Outline
  • Workshop Fee & Instructions:
  • Pre-Requisite
  • Gallery

Overview

Power BI is a business intelligence tool that brings all together all the organization’s data in one place so one can visualise it as a whole and gain valuable insights. It transforms company’s data into rich visuals to collect and organise in a way that one can focus on what really matters. Power BI helps you stay in the know, spot trends as they happen, and push your business further.

This virtual instructor-led training empower participants to build strong understanding of Power BI to integrate, make use of data, and build compelling and interactive reports.

Course Takeaways:

  • Connect MS Power BI to simple datasets in MS Excel and SQL
  • Build simple data models within MS Power BI Select and execute appropriate Visualisations within MS Power BI
  • Create a dashboard to explore data and answer queries using MS Power BI
  • Publish and share insightful reports to stakeholders using MS Power BI
  • Run fundamental analytics using the DAX language

Senior executives, department/ functional heads and business managers, project managers, business analysts, IT executives, data analysts and scientists looking to enhance strategic thinking in building their business intelligence/ analytics function.

Course Director:

Maan Eid (Bilingual)

Maan Eid is an Experienced Information Technology Project Management Trainer with a demonstrated history of working in the information technology and services industry. In last 8 years in the UAE, he has delivered numerous training sessions in government and public companies in the areas of IT Management, Project Management, Data Analysis Reporting Tools, Advance MS Excel, and MS PowerPoint.

Education & Certifications

  • Authorized PMP Trainer
    PMI Project Management Institute
  • MS Business Intelligence (BI) Reporting
  • MCT Microsoft Certified Trainer
  • MOS Excel 2016 Expert
  • MCP Microsoft Certified Professional Managing Project with MS Project
  • MOS Microsoft Office Specialist Master

(WORD, EXCEL, ACCESS, POWERPOINT)

  • ITIL Information Technology
    Infrastructure Library
  • IC3 Internet Core Competency Certification
  • Bachelor’s in Civil Engineering
    Aleppo University, Aleppo, Syria

Memberships

  • Project Management Institute (PMI)
  • Institute of Leadership & Management (ILM)
  • Syrian Engineers Association (Auditor)
  • United Arab Emirates PMI Khaleeji (UAE) Chapter

Some of His Recently Delivered Courses

  • Authorized STC Saudia Arabia – PMP Certificate, Jan 2021
  • Emirates ID – Preparation for PMP Certificate, Nov 2020
  • RTA Preparation – PMP Certificate, Jun 2020
  • MICROSOFT CAPM, Dec 2020
  • DCT Abu Dhabi – Project Management, Dec 2020
  • Etihad Airways – Project Management, Dec 2019
  • Dubai Police – Project Management, Dec 2019
  • DEWA – MS Excel Advanced, Sep 2019
  • Deyaar – Power BI, Sep-Oct 2019
  • ALDAR – MS Excel Advanced, Aug 2019
  • ADNOC – PMP & MS Excel Advanced, July 2019
  • Al Fahim Group – MS Excel Intermediate and Advanced, Apr 2019
  • Ministry of Foreign Affairs – Project Management, Mar 2019
  • Abu Dhabi Police – MS PowerPoint, Mar 2019
  • ADNOC – Dashboards & Excel Advanced, Nov 2018

Past Participation Includes:

Al Batha Group | Global Foods UAE | AXA Insurance | Binzagr Company KSA |  Coca-Cola | Commercial Bank of Dubai | Department of Culture and Tourism  | Dubai Financial Services Authority | Emirates Islamic Bank | Mashreq Bank | ROCHE Middle East | Schlumberger | Precision (Al Tayer group)

About SIMFOTIX:

SIMFOTIX is a trusted name in the executive education industry that offers cutting-edge corporate training programs. SIMFOTIX focuses on creating value for both learners and businesses through its varied program offerings. We, at Simfotix, hold unique expertise in developing our programs based on the design-learning concept that focuses on the key challenges of a learner and organization. Engagement, relevance, and effectiveness are the hallmarks of our learning solutions. So far, SIMFOTIX training programs are attended by over 5000 participants from over 1000 organizations operating MENAT region. Our clients regard their training experience with us inspiring and transformative.

On the e-learning front as well, SIMFOTIX offers courses that result in serious learning but in fun way, we adopt efficient gamification approach that is aligned with clear learning goals that L&D teams want to see as the achieved objectives. We also understand the ever-shifting corporate world challenges and even in online programs, we carry our legacy of quality, relevance, and impact that’s why our programs are conducted by learned faculty comprised of global thought-leaders and top industry practitioners.

We also provide bespoke training solutions that are tailored and delivered in a way that it surpasses your expectations.

  • Soft Skills
  • Finance & Banking
  • Information Technology
  • Gamification

 

Course Outline

Introducing Power BI:
  • Getting started with Power BI
  • Uploading data to Power BI
  • Introduction to reports
  • Introducing Visual Interactions
Using Power BI Desktop:
  • Connecting to a database
  • Loading from multiple sources
  • Using Query Editor
  • Hiding or removing tables
  • Handling seasonality and sorting
  • Months
Consuming and transforming data by using Power BI Desktop:
  • Data connectivity modes
  • Importing data
  • Connecting to a Folder
  • Import from Excel
Developing Power BI reports:
  • Choosing the right visualizations
  • Choosing between standard visuals.
  • First steps with custom visualizations
  • Improving reports by
  • custom visualizations
  • Identifying conditions when custom
  • visualizations are required
  • Using DAX in data models
Using Microsoft Power BI in your company:
  • Publish Excel data models in Power BI
  • Consume Power BI content from Excel
  • Pushing real-time data to Power BI dashboards
Create calculated columns, calculated tables, and measure:
  • Create DAX formulas for calculated columns
  • Calculated tables
  • Using Measures
  • Use What-if parameters
Create hierarchies and format interactive visualizations:
  • Create date hierarchies
  • Create hierarchies based
  • on business needs
  • Add columns to tables to
  • support desired hierarchy
  • Select a visualization type
  • Configure page layout & formatting
  • Configure interactions between visuals
  • category of columns
  • Position, align, and sort visuals
  • Format measures
  • Use bookmarks and themes for reports
Configure a dashboard:
  • Add text and images
  • Filter dashboards
  • Dashboard settings
  • Introducing data refresh
  • Publishing to Power BI

Workshop Fee & Instructions:

  • 08-09 December, 2021 – 10:00 am – 03:00 pm (UAE) | 09:00 am – 02:00 pm (KSA)
  • Regular Fee: USD 480 Per Participant (Exclusive of VAT)
  • Team Offer: Pay for 2 and register 3rd for free
  • Includes: Courseware, and SIMFOTIX Certificate
  • For registration (s) send us your Name, Designation, Organization, and Mobile Number to register@simfotix.com
  • For More Information please contact: Qazi Waqas Ahmed Mobile: +971 56 309 0819; Email: waqas@simfotix.com

Pre-Requisite

  • There are no prerequisites for this program.Prior knowledge on any of the topics is not required. Upon successful completion of the course, every participant will receive a Certificate of Participation.

Gallery

Share