Scribd
Upload
88 views2 pages

Excel and Power BI Data Analysis Guide

The document outlines a course on data analysis using Excel and Power BI. It covers Excel fundamentals for data analysis including cleaning, manipulating, and visualizing data. It then covers Excel power tools for data analysis using Power Query and Power Pivot. Finally, it details lessons on using Power BI for data analysis, including importing, cleaning, transforming, visualizing, and publishing data and reports.

Uploaded by

Omar Ehab
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
88 views2 pages

Excel and Power BI Data Analysis Guide

The document outlines a course on data analysis using Excel and Power BI. It covers Excel fundamentals for data analysis including cleaning, manipulating, and visualizing data. It then covers Excel power tools for data analysis using Power Query and Power Pivot. Finally, it details lessons on using Power BI for data analysis, including importing, cleaning, transforming, visualizing, and publishing data and reports.

Uploaded by

Omar Ehab
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 2

Data Analysis Using Excel and Power BI

1- Excel Fundamentals for Data Analysis

• Cleaning and manipulating text


• Working with numbers and dates
• Defined Names for working more effectively with data
• Tables for automating data manipulation
• Logical and lookup functions
• Final assessment

2- Data Visualization in Excel

• Data Visualizations using Conditional Formatting, Sparklines and Number Formats


• Mastering charting techniques
• Specialized charts
• Create an Interactive Dashboard Using Pivot Charts and Slicers
• Complete

3- Excel Power Tools for Data Analysis

• Welcome and critical information


• Get and Transform (Power Query)
• Transforming data in the Query Editor
• Power Pivot and the Data Model

•
4- Power BI Data Analyst

• Lesson 1: Understand Power BI


• Lesson 2: Import Data into Power BI
• Lesson 3: Understand the Data View
• Lesson 4: Clean and Transform Data
• Lesson 5: Understand the Model View
• Lesson 6: Work with Relationships in Model View
• Lesson 7: Understand the Report View and Visualizations
• Lesson 8: Understand, Create and Format Text Visualizations
• Lesson 9: Create and Format Chart Visualizations
• Lesson 10: Connecting Visualizations and Queries
• Lesson 11: Gain Insights with Filters and Drillthroughs
• Lesson 12: Publish Reports
• Lesson 13: Get Started with Workspaces
• Lesson 14: Work with Dashboards
• Lesson 15: Datasets and Reports
• Lesson 16: Work with Apps
• Lesson 7: Integrate with Microsoft Suite

You might also like