Udemyallfr

ANALYSE MODERNE DES DONNEES AVEC EXCEL ET POWER BI

Master Excel Power Query, Power Pivot & Power BI. Build impactful reports & dashboards. Data analysis & visualization skills.

4.3(88)
460students
5h 4m
Certificate
Lionel Guéri
Lionel GuériMicrosoft Office Excel Power BI Expert

Course Content

ANALYSE MODERNE DES DONNEES AVEC EXCEL ET POWER BI is an all-levels Udemy course taught by Lionel Guéri. It runs 5h 4m, is taught in French, and includes a certificate of completion. Learners rate it 4.3 out of 5 from 88 reviews, with 460 students enrolled. It is a paid course, last updated June 2023.

Lifetime access to content and practical case studies. 100% money-back guarantee.

Unlock the power of Business Intelligence with this comprehensive course, led by Lionel Guéri, a leading expert in Excel, Power BI, and the Microsoft Power Platform. Lionel, author of popular articles on Excel tools and BI via his widely read blog XL Business Tools (with nearly 20,000 monthly readers), delivers high-quality training recognized throughout the French-speaking world. He is a certified Microsoft Data Associate Power BI and Microsoft Office Certified Expert, and an Associate with DAF INNOV, specializing in financial performance management and digital transformation.

This training equips you with essential Business Intelligence technologies, accessible to all, to effectively analyze your data in Excel and Power BI. You'll learn to create reliable, efficient, and dynamic dashboards using:

  • Power Query: Data cleaning and transformation for seamless data integration.
  • Power Pivot: Building robust data models and performing advanced calculations.
  • Pivot Tables: Analyzing data with dynamic summaries and aggregations.
  • Pivot Charts: Visualizing data trends and insights.
  • Slicers: Interactive filters for focused data exploration.
  • Power BI: Creating interactive dashboards and reports for data-driven decision-making.

Who is this course for?

This course is designed for anyone who wants to:

  • Create management reports.
  • Analyze data effectively.
  • Build interactive dashboards.
  • Develop Key Performance Indicators (KPIs).
  • Make informed decisions based on data.

Course Objectives:

  • Data Analysis & Integration: Analyze and combine data from diverse sources (ERP, Excel, Web, Text, etc.).
  • Automation: Automate dashboard creation with integrated business calculations.
  • Data Modeling: Import and format data for analysis.
  • Relational Modeling: Link data sources within a relational model.
  • DAX Formula Creation: Build powerful formulas using DAX within Pivot Tables and Power BI reports.

Course Curriculum:

  • Power Query:
    • Introduction to Power Query
    • Power Query Interface
    • Importing Various Data Types
    • Data Cleaning and Transformation
    • Adding Data
    • Merging Data
    • Grouping Data
    • Loading Data into Power Pivot
    • Power Query Quiz: Test your knowledge! [New 2023]
  • Power Pivot:
    • Introduction to Power Pivot
    • Loading Data into Power Pivot
    • Creating Relationships
    • Creating Calculated Columns
    • Creating Calculated Fields (Measures) with DAX
    • Creating a Calendar Table
    • Data Refresh
  • Interactive Dashboards:
    • Introduction to Interactive Dashboards
    • Creating KPIs
    • Using the LIREDONNEESTABCROISDYNAMIQUE Function
    • Creating Pivot Charts
    • Creating Map Charts
    • Creating Sparklines
    • Conditional Formatting
    • Connecting Slicers to Reports
  • Power BI:
    • Introduction to Power BI Desktop
    • Power BI Interface
    • Importing Excel/Power Pivot Data
    • Importing and Linking Data in Power BI
    • Creating DAX Measures in Power BI (SUM, CALCULATE, Time Intelligence Functions)
    • Creating Visualizations in Power BI (Histograms, Maps, etc.)
    • Creating a Date Table
    • Publishing Power BI Reports Online
    • Power BI Report Templates
  • Practical Examples:
    • Example 1: Supply Chain Analysis
    • Example 2: Supplier Quality Analysis
    • Example 3: Retail Sales Analysis
    • Example 4: IT Expense Analysis
    • Example 5: Opportunity Analysis
    • Example 6: Customer Profitability Report
    • Example 7: Human Resources Report
    • Example 8: Sales & Marketing Report

Start your journey to becoming a Business Intelligence expert today!

$ whoami — the devs behind tutorialsearch.io

Want AI in your product? Hire the team behind TutorialSearch.io

LLM features, RAG, agents and automation wired into a real product — built by the devs who shipped this site.