Thank you for sending your enquiry! One of our team member will contact you shortly.
Thank you for sending your booking! One of our team member will contact you shortly.
Course Outline
Introduction
Theoretical Science of Data Analysis
- The principles of data analysis
- Objectives of data analysis
- Approaches for data analysis
Excel and Data Science
- Data consistency
- Data types used in Excel
Overview of Power BI
- Processes and Power products used in Power BI
Preparing the Development Environment
- Installing and configuring Excel
- Installing and configuring Power BI
Business Data Analysis in Excel
- Inserting and working with PivotCharts
- Inserting and working with PowerPivots
- Mail merging
- Linking and duplicating sheets
- Freezing panes
- Splitting windows
- Using conditional formatting
- Creating a named range
- Using Execel Web Query
- Working with Power Excel functions
Power BI and Excel Integration
- Importing data from Excel to Power BI with Power View
- Incorporating Excel into the Power BI Portal
Cleaning Data in Power BI
- Cleaning up cross tab data with unPivot
- Cleaning up multiple cross tab data
- Combining data from multiple tabs and sheets
Databases and Reports in Power BI
- Using relationships to eliminate VLOOKUP
- Creating calculated columns
- Creating a custom date table
- Working with reports and visuals
- Filtering reports and viewing data
- Publishing the report to Power BI Portal
DAX and Power BI
- Adding calculated columns
- Text grouping
- Using Bin Analysis
- Adding measures
- Comparing past and current data
Summary and Conclusion
Requirements
- An understanding of the basics in Excel.
Audience
- Data Analysts
Testimonials
I thought the trainer was very patient and had a lot of knowledge.
Sinead Goss - Linda White, Health Service Executive
Review of excel functions
Linda White, Health Service Executive
The time given to do each exercise after they were given.
Claire Delaney - Linda White, Health Service Executive
interesting training
christina Doyle - Linda White, Health Service Executive
I learnt more about excel
Linda White, Health Service Executive
I like how clearly everything was explained and the excercises
Claire Delaney - Linda White, Health Service Executive
I really enjoyed the VLookup part of the training - I think the trainer was really engaging and made the training very enjoyable.
Melissa Murray - Linda White, Health Service Executive
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.
Karen Kinsella - Linda White, Health Service Executive
Trainers are very knowledgeable and patient in ensuring students could follow the lecture.
Trudy Staples Girardin - Indigenous Services Canada
I learned so much about Power BI, the trainers were patient and very knowledgeable.
Krystina Merkley - Indigenous Services Canada
Patience of Costas, adaptability to our various knowledge levels and work requirements. Possibility to ask questions.
Beatrice PLATEAU - Ameropa
Related Courses
Power BI
14 hours
Power BI for Business Analysts
21 hours
Power BI for Developers
28 hours
Power BI Dashboards
14 hours
Power BI Dashboard Design
7 hours
Analyzing Data with Power BI
28 hours
Advanced Power BI
21 hours
Power BI DAX Fundamentals
21 hours
Analysing Financial Data in Excel
14 hours
Excel For Statistical Data Analysis
14 hours