Data Analysis using Excel & Power BI
Program Overview
Data Analysis is the process of modeling and transforming data into useful information, this information helps us to make a clear, uniform, and right decisions, but how can we do it with so much data?
This is the importance of data software In Data Analysis Diploma we will focus on 2 of the best data analysis software:
- Microsoft Excel
- Microsoft Power BI
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 the most of global and innovative companies are utilizing data analysis to help making data-driven decisions using Business Intelligent Solutions
Program Content
Part 1: Data Analysis
Module 1: Data Analysis in Excel
- Lesson 1: Classic Data Analysis with Excel
- Lesson 2: Excel Pivot Tables
- Lesson 3: Limitations of Classic Data Analysis
- Lab: Building a Classic Excel Dashboard
Module 2: The Excel Data Model
- Lesson 1: Using an Excel Data Model
- Lesson 2: DAX
- Lab 2: Explore an Excel Data Model
Module 3: Importing Data from Files
- Lesson 1: Importing Data into Excel
- Lesson 2: Shaping and Transforming Data
- Lesson 3: Loading Data
- Lab 3: Importing Data from a CSV File
Module 4: Importing Data from Databases
- Lesson 1: Available Data Sources
- Lesson 2: Previewing, Shaping, and Transforming Data
- Lesson 3: Table Relationships and Hierarchies
- Lesson 4: Loading Data
- Lab 4: Import Data from Multiple Sources
Module 5: Importing Data from Excel Reports
- Lesson 1: Importing Data from Excel Reports
- Lesson 2: Transforming Excel report Data
- Lab 5: Importing Data from a Report
Module 6: Creating and Formatting Measures
- Lesson 1: DAX
- Lesson 2: Measures
- Lesson 3: Advanced DAX Functions
- Lab 6: Creating Measures using Advanced DAX Functions
Module 7: Visualizing Data in Excel
- Lesson 1: Pivot Charts
- Lesson 2: Cube Functions
- Lesson 3: Charts for Cube Functions
- Lab 7: Data Visualization in Excel
Part 2: Power BI
Getting Started with Power BI Desktop
- Power BI Concepts and Overview
- Introduction to Main Features
- Imports
- Visualizations
- Filters and Queries
- Reports
Connecting to Data Sources with Power BI Desktop
- Data Sources Power BI Desktop will connect to
- Data Types and Properties in Power BI Desktop
- Import and Enter Data
- Get Data and Query Editor
- Introducing the Query Editor
- Using the Query Editor to Connect to Data
- Combining Data Sources as a Mash Up
- Working with Relationships in Data
Data Visualizations
- Overview of Data Visualizations
- Tables and Matrix Views
- Applying Conditional Formats
- Charts
- Interactive Data and Date Slicers
- Drill Visualizations to see underlying data
- Create Reusable Field Hierarchies
- Record Grouping and Binning in Visualizations
- Drill Visualizations with using Dates
- Clustering
- Analytics and Forecast Lines in Visualizations
- Creating Role Based Views
- Data Categories, Geo-Data and Maps
Querying and Shaping the Data
- Common Activities using Query Editor
- Filters
- Transforms
- Pivot and Group By
- Creating Custom Calculated Columns
- Adding Conditional Columns
- Introduction to DAX Expressions
- Histograms
Power Pivot and Data Model
- Relationship
- Common DAX Functions
- Concept of Measures
- Calculated Columns
Reports and Output Options
- Report Elements and Options
- Working with Pages
- Adding Graphics
- Visual and Filter Settings
- Export Power BI Data to CSV
- Create a Power BI Template
Program Benefits
Upon completing the diploma, you will:
- Differentiate yourself as Data Analyst Using Excel & Power BI
- Be Prepared with solid jumpstarting to became Data Scientist
- Understand the Concept of Data Analysis & Visualization
- Understand the Data Analysis Process
- Data Analyst Competencies and Roadmap
- Connect, Transform, and Load Data Using Power Query
- Enhance Data Modeling
- Build Data Analysis Expression [DAX] in Excel
- Mastering Data Visualizing in Excel & Creating Dynamics Dashboard
- Understand the Concept of Business Intelligent Solutions
- Connect, Transform, and Load Data Using Power BI
- Working with DAX and Advanced DAX Measures
- Mastering Data Visualizing & Data Driven decisions Using Power BI
- Act as a data-driven visual storyteller for optimal presentation
- Apply data visualization best practices, including choosing the right chart type for the situation
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, 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 want to jumpstart to Data Analysis Career and gain the Knowledge and Practical Skills of Data Analysis Using Excel & Power BI.
Course Duration
40 Hours
Course Method
Online
Registration Deadline
Three days before the course date.
Registration and Payment
- Open www.thetraining-hub.com/ Training Facilities/Course Registration and fill your registration form.
- Payment by cheque in The Training HUB’s name, cash to our address or by bank transfer.
- Your registration is confirmed only after course payment
- Payment is non-refundable; however, participant can be substituted or can attend next confirmed round of the same course or another course.
For More Information
Phone: 02 22907369 / 22909369
Mobile: 01280720167- 01280653407
Email: info@thetraining-hub.com
