Power BI

11200,00
RON
18700,00
RON
THW course covers every facet necessary to become proficient in data analysis using Power BI tools. From getting started with the software, managing and transforming data, to creating complex models and dashboards, participants will acquire hands-on skills immediately applicable in any business context. This course is mainly designed for individuals aiming to leverage Power BI for enhanced data-driven decision-making in their organizations.
Course Structure
Specifications

Course Structure

Module 1: Introduction and Basics of Power BI (6 sessions)

  • Introduction to Power BI: Learn the essentials of Power BI to get started.
  • Navigating the Power BI Interface: Understand the layout and features.
  • Installation and Setup: How to install Power BI Desktop and set up your environment.
  • Data Loading and Initial Visualization: Importing data and creating basic visualizations.
  • Working with Different Views: Exploring Report, Data, and Model views in Power BI.
  • Understanding Power BI Service: Introduction to cloud services and basic operations.

Module 2: Data Management and Visualization (6 sessions)

  • Advanced Data Handling: Sorting, filtering, and cleaning up data.
  • Creating Complex Visualizations: Learn to create and format various visual types.
  • Effective Data Importing Techniques: Handling data from multiple sources.
  • Interactive Reports and Dashboards: Making interactive elements with slicers and other tools.
  • Using Power BI for Excel Users: Integration and transition from Excel to Power BI.
  • Publishing and Sharing: How to share your reports and dashboards effectively.

Module 3: DAX and Data Modeling (6 sessions)

  • Introduction to DAX: Basics of Data Analysis Expressions.
  • Creating Measures and Calculated Columns: Using DAX to derive more data insights.
  • Advanced DAX Functions: Deeper into DAX for complex calculations.
  • Data Modeling Techniques: Building effective models for analysis.
  • Time Intelligence in DAX: Working with date and time data for trend analysis.
  • Optimizing Data Models: Enhancing performance and maintainability.

Module 4: Power BI Service Deep Dive (5 sessions)

  • Using Power BI Service: Deep dive into online services of Power BI.
  • Collaboration in Power BI: Working with teams and sharing insights.
  • Security and Administration: Setting up row-level security and managing access.
  • Advanced Analytics: Using AI insights and machine learning in Power BI.
  • Enterprise Features: Understanding the administration and scalability options.

Module 5: Automation and Integration (5 sessions)

  • Automating with Power BI: Learn to automate data refresh and other tasks.
  • Integration with Other Tools: Connecting Power BI with various data sources.
  • Advanced Topics: Explore R and Python integration, big data connections.
  • Custom Visuals and Modifications: Creating and using custom visuals.
  • Final Project: Applying all learned skills in a capstone project.

Specifications

Format: 1:1 & Group

Recommended Sessions: 28

Level: Beginner

See also