Get in Touch
 Duration 7 hours

Course Outline

Introduction

The Theoretical Foundations of Data Analysis

  • Core principles of data analysis
  • Key objectives in data analysis
  • Methodological approaches to analysis

Excel in the Context of Data Science

  • Ensuring data consistency
  • Data types supported in Excel

Introduction to Power BI

  • Workflows and Power-related products integrated within Power BI

Setting Up the Development Environment

  • Installation and configuration of Excel
  • Installation and configuration of Power BI

Performing Business Data Analysis in Excel

  • Creating and manipulating PivotCharts
  • Inserting and using PowerPivots
  • Executing mail merges
  • Linking and duplicating worksheets
  • Freezing window panes
  • Splitting application windows
  • Applying conditional formatting
  • Defining named ranges
  • Utilizing Excel Web Query
  • Operating with Power Excel functions

Integrating Power BI with Excel

  • Importing Excel data into Power BI using Power View
  • Embedding Excel content within the Power BI Portal

Data Cleansing in Power BI

  • Tidying cross-tabulated data using unPivot
  • Processing multiple cross-tabulated datasets
  • Merging data from various tabs and sheets

Managing Databases and Reports in Power BI

  • Using relationships to replace VLOOKUP functions
  • Constructing calculated columns
  • Building a custom date table
  • Developing reports and visuals
  • Filtering reports to inspect specific data points
  • Publishing reports to the Power BI Portal

DAX Mastery in Power BI

  • Incorporating calculated columns
  • Organizing data through text grouping
  • Conducting Bin Analysis
  • Adding custom measures
  • Comparing historical and current data trends

Summary and Conclusion

Requirements

  • A solid grasp of fundamental Excel concepts.

Target Audience

  • Data Analysts

Custom Corporate Training

Training solutions designed exclusively for businesses.

  • Customized Content: We adapt the syllabus and practical exercises to the real goals and needs of your project.
  • Flexible Schedule: Dates and times adapted to your team's agenda.
  • Format: Online (live), In-company (at your offices), or Hybrid.
Investment

Price per private group, online live training, starting from 1450 € + VAT*

Contact us for an exact quote and to hear our latest promotions

Testimonials (7)

Upcoming Courses

Related Categories