Course Outline
Introduction
Theoretical Foundations of Data Analysis
- Core principles of data analysis
- Primary objectives of data analysis
- Strategic approaches for data analysis
Excel and Data Science
- Ensuring data consistency
- Data types commonly used in Excel
Power BI Overview
- Workflows and Power products integrated within Power BI
Setting Up the Development Environment
- Installation and configuration of Excel
- Installation and configuration of Power BI
Business Data Analysis using Excel
- Creating and managing PivotCharts
- Implementing and using PowerPivots
- Executing mail merge tasks
- Linking and duplicating worksheets
- Freezing panes for easier navigation
- Splitting window views
- Applying conditional formatting rules
- Defining named ranges
- Utilizing Excel Web Query
- Employing Power Excel functions
Integrating Power BI with Excel
- Transferring data from Excel to Power BI using Power View
- Embedding Excel content into the Power BI Portal
Data Cleaning in Power BI
- Transforming cross-tabulated data using unPivot
- Managing multiple sets of cross-tabulated data
- Aggregating data from various tabs and sheets
Databases and Reporting in Power BI
- Establishing relationships to replace VLOOKUP functions
- Defining calculated columns
- Building custom date tables
- Managing reports and visual elements
- Filtering reports and exploring data insights
- Deploying reports to the Power BI Portal
DAX and Power BI
- Implementing calculated columns
- Grouping text data
- Utilizing Bin Analysis
- Creating measures
- Analyzing historical versus current data trends
Summary and Wrap-up
Requirements
- Foundational knowledge of Microsoft Excel.
Intended Audience
- Data Analysts
Testimonials (7)
Great pace during the training. very knowledgeable and teaching style
James - Gilead Sciences Ireland
Course - Excel to Power BI
I thought the trainer was very patient and had a lot of knowledge.
Sinead Goss - Health Service Executive
Course - Excel to Power BI
The time given to do each exercise after they were given.
Claire Delaney - Health Service Executive
Course - Excel to Power BI
interesting training
christina Doyle - Health Service Executive
Course - Excel to Power BI
I like how clearly everything was explained and the excercises
Claire Delaney - Health Service Executive
Course - Excel to Power BI
I really enjoyed the VLookup part of the training - I think the trainer was really engaging and made the training very enjoyable.
Melissa Murray - Health Service Executive
Course - Excel to Power BI
i had completed some power bi training previously so this was a good opportunity to learn about it again and i feel i understand it more now and as a result will be more confident in using it.
