Data Analysis Using Excel and Power BI

Home / Course / Data Analysis Using Excel and Power BI

44 hours of practical training

3 months Practical projects

The diploma is presented in the Arabic language

Introduction to data analysis:

Business Intelligence (BI) has become one of the most important commercial and marketing terms in recent years in the Middle East, especially in the Gulf region. In addition to other terms such as Big Data, Data Mining, Predictive Analytics, and Data Science

Learn how to analyze data faster, extract business insights smarter, and present your business better. All while making it look so easy

دورات تدريبية كورسات اونلاين

Why study Data analysis?

  • Increase the Awareness of data analysis techniques using excel & Business Intelligent Solution [Power BI].
  • Perform Data Transformation to explain how findings from data can and should be visualized, to enable stakeholders to make sound business decisions.
  • Develop data modeling and DAX to manipulate relevant data and deeply analyze it by applying appropriate techniques and answering the appropriate questions.
  • Advance Data Visualizations techniques in Excel & Power BI to enhance stakeholder Involvement in Decision Making.
  • Build confidence in influencing business decisions through Data-Driven decisions.

IMP has been one of the most important organizations specialized in data analysis training for several years, as it has trained many companies, banks, and institutions in the field of data analysis in several Arab countries.

دورات تدريبية كورسات اونلاين

What will you learn in the data analysis diploma?

  1. Understand The Concept Of Data Analysis & Visualization.
  2. Understand the Data Analysis Process.
  3. Data Analyst Competencies and Roadmap.
  4. Connect, Transform, and Load Data Using Power Query.
  5. Enhance Data Modeling.
  6. Build Data Analysis Expression[DAX] in Excel.
  7. Mastering Data Visualizing in Excel & Creating Dynamics Dashboard.
  8. Understand The Concept Of Business Intelligent Solutions.
  9. Connect, Transform, and Load Data Using Power BI.
  10. Working With DAX and Advanced DAX Measures.
  11. Mastering Data Visualizing & Data-Driven decisions Using Power BI.
  12. Act as a data-driven visual storyteller for optimal presentation.
  13. Apply data visualization best practices, including choosing the right chart type for the situation.

 

Course methodology:

This course will be highly interactive, with a mix of theory, including practical sessions. You will have the opportunity to learn by doing and sharing your experience, and you will develop your skills through a series of assignments and projects.

MICROSOFT EXAM TOWARDS

This Program fully prepared you for

Exam DA-100: Analyzing Data with Microsoft Power BI as Part Of Microsoft Certified: Data Analyst Associate Certificate.

Who should attend?

  • Professionals who wish to gain an understanding of the benefits and uses of data analysis and the techniques applied using Excel and Power BI when analyzing business data, in order to improve their analytical skills and understanding of data.
  • For Business Professionals, business analysts, data analysts, finance professionals, marketing and sales professionals, HR professionals, IT professionals, administrative staff, supervisors, general business professionals, and staff from any function who need to learn and apply data analysis techniques to their daily business reporting and decision making.
  • For Professionals who want to jumpstart to Data Analysis Career and gain the Knowledge and Practical Skills of Data Analysis Using Excel & Power BI.

ROUNDS:

Besides rounds that are conducted in IMP’s head office in Egypt; IMP courses are also delivered LIVE with fully interactive sessions allowing for a highly engaging Q & A and assuring that you get the best ever learning experience.

Interactive Online Training

Start DateTimeDaysAvailable Seats
14-Dec7:00 PM-10:00 PMSunday-WednesdayVery Limited
4-Jan-20237:00 PM-10:00 PMSunday-WednesdayLimited
6-Jan-20231:00 PM-5:00 PMFridayLimited
9-Jan-20237:00 PM-10:00 PMMonday-ThursdayLimited
14-Jan-202311:00 AM-3:00 PMSaturday

CERTIFICATE OF COMPLETION

To have successfully completed; a trainee should:

  • have an attendance rate of not less than 80% (or such higher attendance requirement as prescribed for the course);
  • Pass the course practical assignments and projects in at least 75% of the total number of assignments as required in each training course.

Reviews

The cost of the full course is $290 instead of $400 for a limited time

Choose the appropriate date for you and pay through an electronic payment card or PayPal

Classic Excel Dashboard

Introducing Pivot Tables & PivotChart

Analyzing Data with PivotChart

Connect, Transform, and Load Data Using Power Query

Introducing to Power Query

Connecting to Excel Workbook Files

Connecting to CSV & TEXT Files & Folders

Connecting to Access Files

Transforming Data Using Power Query

Loading Data to the Excel Data Model

Working with Multiple Queries

Custom Columns with M Calculations

WORKING WITH DATA MODEL IN POWER PIVOT

Power Pivot Capabilities

Understand Data Model Concept

Create Relationships in Data Model

WORKING WITH DAX

Understand Data Analysis Expression – DAX

Create Calculated Column

Create Measure

Row Context

Filter Context

WORKING WITH ADVANCED DAX MEASURES

Building a Calendar table

Time Intelligence in DAX

VISUALIZING DATA IN EXCEL

Create Dynamics Excel Reports

Create interactive Excel Dashboards

DATA ANALYSIS USING POWER BI

Introduction to Self-Service Business Intelligence

GET STARTED WITH POWER BI DESKTOP

Introduction Power BI

Create Report & Dashboard

CLEAN, TRANSFORM, AND LOAD DATA IN POWER BI

Loading Data to Power BI

Uploading & Updating PBIX Reports

Transforming Data Using Power Query in Power BI

CREATE DATA MODEL IN POWER BI

Mange Data Model in Power BI

Create Relationships

Create Hierarchies

WORKING WITH DAX IN POWER BI

Create Calculated Column

Create Measure

PERFORM ADVANCED DAX IN POWER BI

Building a Calendar Table

Time Intelligence in DAX

DATA VISUALIZATIONS IN POWER BI

Creating Reports & Dashboard

Report Filtering

Drill-down & Drill-Through

Formatting Visualizations

Apply conditional formatting

Slicers and Advance Card Visuals

Bookmarks & Buttons

INTRODUCTION TO DATA SCIENCE

What is Data Science

Difference Between Data Scientist & Data Analyst

Data Analysis Competences VS Data Science Competences

STORYTELLING WITH DATA FOR DECISION MAKING

Understand the importance of context and audience

Determine the appropriate type of graph for your situation

Direct your audience’s attention to the most important parts of your data

Leverage the power of storytelling to help your message resonate with your audience

INTRODUCTION TO PYTHON

Data Scraping Using Python

Data Cleaning Using Python

Data transformation Using Python

Data Visualization Using Power BI integrated With Python

Level: advanced
44 Hours