MS10989

Ladda ner som PDF

Analyzing Data with Power BI

About this course

This two-day instructor-led course provides students with the knowledge and skills analyze data with Power BI.

Målgrupp

Data Professionals

Förkunskaper

This course requires that you meet the following prerequisites:
• Basic knowledge of the Microsoft Windows operating system and its core functionality.
• Basic knowledge of data warehouse schema topology (including star and snowflake schemas).
• Some exposure to basic programming concepts (such as looping and branching).
• An awareness of key business priorities such as revenue, profitability, and financial accounting is desirable.
• Familiarity with Microsoft Office applications – particularly Excel.

These prerequisites can be achieved by attending courses
• 20761A – Querying Data with Transact-SQL
• 20767A -  Implementing a SQL Server Data Warehouse

At course completion

After completing this course, students will be able to:
• Describe key features of a self-service BI solution
• Describe Power BI and its data sources
• Model, shape, and combine data
• Describe Power BI data visualizations

Course OutlineModule 1: Introduction to Self-Service BI SolutionsIn this module students will be introduced to the key concepts in business intelligence, data analysis, and data visualization. In addition they will learn the rationale for self-service BI, considerations for using self-service BI, and how Microsoft products can be used to implement a self-service BI solution.Lessons

  • Introduction to business intelligence
  • Introduction to data analysis
  • Introduction to data visualization
  • Overview of self-service BI
  • Considerations of self-service BI
  • Microsoft tools for self-service BI

Lab : Exploring an enterprise BI solutionAfter completing this module, you will be able to:
• Describe key concepts in business intelligence
• Describe key concepts in data analysis
• Describe key concepts in data visualization
• Describe the rationale for self-service BI
• Describe considerations for self-service BI
• Describe how Microsoft products can be used to implement a self-service BI solution
Module 2: Introducing Power BIThis module introduces... Läs mer

At course completion

After completing this course, students will be able to:
• Describe key features of a self-service BI solution
• Describe Power BI and its data sources
• Model, shape, and combine data
• Describe Power BI data visualizations

Course OutlineModule 1: Introduction to Self-Service BI SolutionsIn this module students will be introduced to the key concepts in business intelligence, data analysis, and data visualization. In addition they will learn the rationale for self-service BI, considerations for using self-service BI, and how Microsoft products can be used to implement a self-service BI solution.Lessons

  • Introduction to business intelligence
  • Introduction to data analysis
  • Introduction to data visualization
  • Overview of self-service BI
  • Considerations of self-service BI
  • Microsoft tools for self-service BI

Lab : Exploring an enterprise BI solutionAfter completing this module, you will be able to:
• Describe key concepts in business intelligence
• Describe key concepts in data analysis
• Describe key concepts in data visualization
• Describe the rationale for self-service BI
• Describe considerations for self-service BI
• Describe how Microsoft products can be used to implement a self-service BI solution
Module 2: Introducing Power BIThis module introduces Power BI.Lessons

  • Power BI
  • The Power BI service
  • Power BI mobile apps

Lab : Cresting a Power BI dashboardAfter completing this module, you will be able to:
• Describe Power BI
• Describe the Power BI Service
• Implement Tenant Management
• Describe Power BI mobile apps
• Create a simple dashboard
Module 3: Power BI DataThis module describes Power BI data sources.Lessons

  • Using Excel as a Power BI data source
  • Using databases as a Power BI data source
  • The Power BI service

Lab : Import data into Power BIAfter completing this module, you will be able to:
• Use Excel as a Power BI data source
• Use databases as a Power BI data source and describe the R language
• Configure the Power BI Service
Module 4: Shaping and Combining DataThis module describes how to shape and combine data.Lessons

  • Power BI desktop queries
  • Shaping data
  • Combining data

Lab : Shaping and combining dataAfter completing this module, you will be able to:
• Create Power BI Desktop queries
• Shape data
• Combine data
Module 5: Modeling DataThis module describes how to model data in Power BI.Lessons

  • Relationships
  • DAX queries
  • Calculations and measures

Lab : Modeling dataAfter completing this module, you will be able to:
• Configure the Power BI Service
• Create Relationships
• Write simple DAX queries
• Create calculations and measures
Module 6: Interactive Data VisualizationsThis module describes Power BI visualizations.Lessons

  • Creating Power BI reports
  • Managing a Power BI solution

Lab : Creating a Power BI reportAfter completing this module, you will be able to:
• Use Power BI Desktop to create interactive data visualizations
• Describe the management of a Power BI solution

Kurs-ID: MS10989
Längd: 2 dagar
Pris exkl moms: 20 450 kr
Kan betalas med:
TRAINING CARD

"Utbildning var du vill, när du vill"

11 650 kr
Boka nu!

Lämna dina kontaktuppgifter om du önskar en företagsintern utbildning.

Tipsa