Course Outline
Introduction
Theoretical Foundations of Data Analysis
- Core principles of data analysis
- Defining the objectives of data analysis
- Selecting appropriate approaches for data analysis
Excel and Data Science
- Ensuring data consistency
- Data types commonly utilized in Excel
Introduction to Power BI
- Processes and Power-related products integrated within Power BI
Setting Up the Development Environment
- Installation and configuration of Excel
- Installation and configuration of Power BI
Conducting Business Data Analysis in Excel
- Creating and manipulating PivotCharts
- Creating and manipulating PowerPivots
- Implementing mail merge features
- Linking and duplicating worksheets
- Utilizing frozen panes for better navigation
- Splitting windows for enhanced visibility
- Applying conditional formatting rules
- Defining and using named ranges
- Utilizing Excel Web Query
- Implementing Power Excel functions
Integrating Power BI with Excel
- Importing Excel data into Power BI using Power View
- Embedding Excel within the Power BI Portal
Data Cleansing in Power BI
- Resolving cross-tab data issues using unPivot
- Cleaning complex multiple cross-tab datasets
- Consolidating data from various tabs and sheets
Managing Databases and Reports in Power BI
- Replacing VLOOKUP with relationship modeling
- Building calculated columns
- Constructing custom date tables
- Developing reports and visuals
- Applying filters and reviewing data views
- Publishing reports to the Power BI Portal
DAX and Power BI
- Implementing calculated columns
- Performing text grouping
- Conducting Bin Analysis
- Defining and using measures
- Analyzing historical versus current data
Summary and Conclusions
Requirements
- Fundamental proficiency in Excel is required.
Target 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.
