Data Analysis Using Excel and Power BI

Home / Course / Data Analysis Using Excel and Power BI

Course overview:

This course is the ideal practice to Enhance your Data Analysis Skills and jumpstarting for the Data Science Track.

This course is a combination of The Concept Of Data Visualizations and Technical Skills to build a career future in one of the most important fields worldwide; where most of the global and innovative companies are utilizing data analysis to help make data-driven decisions using Business Intelligent Solutions.

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.

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.

Pivot Table & Pivot Chart & Dashboard

Intro & RoadMap

Tables

Creating PivotTable

Slicer

Creating Pivot Chart

Building First Dashboard

Getting Start with PivotTable

PivotTable Layout

PivotTable-Show Data Setting

Pivot Table Grouping With Text,Numbers,Date

Data Connection & Transformation Using Power Query

Load Form Table & Merge Query

Load Form Table & Append Query

Manage Queries & Load to Type & Automated Refresh Query

Power Query 1

Power Query 2

Power Query 3

Power Query 4

Power Query 5

Power Query 6

UnPivot

Level: Basic
4 Hours