Data analysis with Power BI and DAX (English)

Description

With the rollout of Power BI, your organization is rapidly changing into a data-driven organization. In the short term, there is no longer a department where employees do not regularly analyze data in order to make well-founded choices. How do you ensure you have the right skills to get the most out of Power BI without spending weeks on training? With the Wortell Smart Learning Path: Power BI!

In this Data analysis with Power BI and DAX training course - we work through all kinds of aspects of data analysis with Power BI for 5 weeks. Here you will learn everything you need to do advanced data analysis with Power BI: from the basics of accessing and profiling data to the advanced operation of DAX: everything is covered!

This learning path includes three trainings:

1. Power BI - self-report and analyze data (week 1 and 2)
2. Power BI Data Modeling (Week 3)
3. DAX for Power BI level 1 - Fundamentals (week 4)
4. DAX for Power BI level 2 - smart solutions (week 5)

Audience

As a data analyst, you want to use Power BI to properly support your data analyses. But it doesn't stop for you at gaining insights yourself: you also want to design your reports in such a way that others can use them. And you want to be able to transfer them in a manageable way. In a responsible way: you want to work safely in accordance with best practices .

Basic knowledge alone will not get you there. You want to be able to make advanced analyzes and help colleagues with their calculations. That's where DAX comes in: the language for powerfully shaping data models and advanced calculations in Power BI.

Do you want to know more about the Azure side? Then the Azure Data Engineering course may also be of interest to you. More information can be found at: Training Azure Data Engineering

Skills gained

After these 5 weeks you have achieved the following learning objectives:

• Independently create reports in Power BI
• Share reports with "customers" in your organization via Power BI Apps
• Load and edit new data yourself for reporting
• Perform both basic and more advanced analytics with Power BI and DAX
• Independently develop measures and calculated columns with DAX
• Recognize and implement common patterns in DAX

Afterwards you have a thorough knowledge of Power BI, and you can do advanced analyzes in Power BI using DAX. You also know where to find more information and how to easily find out new things.

Prerequisite knowledge to follow the training "Data analysis with Power BI and DAX".

As a participant, you do not need any specific prior knowledge to start with Power BI. However, if you have not worked with Power BI or other data analysis at all, this process is probably quite tough. We recommend that you first follow the Power BI section ( Power BI - self-reporting ) and after you have worked with this more, continue with the DAX section.

If you already have experience with data analysis in another tool, or if you have already worked with Power BI yourself but now really want to go into depth, then you have the necessary prior knowledge. In addition, as a participant you need access to Power BI Desktop on your own work laptop, and access to a Power BI Pro account within your organization.

Course outline

The Data Analysis with Power BI and DAX training consists of five weeks, in which the following topics receive full attention:

• Working with Power BI
  • Data visualization
    • Create reports
    • Create dashboards
    • Enrich reports with advanced functionality
    • Interactive reports
    • Effective report design
  • Data analysis
    • Enrich reports to unlock insights
    • Advanced analytics
  • Data preparation
    • Data access from various sources
    • Data profiling
    • Cleaning and ETL
    • Load data yourself with Power Query
  • Data Modeling
    • Designing Power BI data models
    • Developing Power BI data models
    • Create measures with DAX
    • Improve performance of Power BI data models
  • Collaborate and share reports
  • Making good use of the Power BI Portal
  • Deployment and maintenance
    • Data set management
    • Create and manage workspaces
• Power BI Data Modeling
  • Introduction to Dimensional Modeling
    • Facts
    • Dimensions
    • Recognize the business process
  • Practice with a first dimensional model
  • The modeling process
    • Best & Bad Practices
    • 4 steps to a Dimensional Model
    • The Bus Matrix
    • Special dimensions
  • Practice with a more complex business process
  • Handle date and time
  • Customer and product dimensions
• DAX
  • Introduction DAX
  • Distinction between calculated columns, calculated tables and measures
  • Write calculated columns yourself
  • Write your own measures
  • Variables
  • Understanding DAX: how it really works
  • Adding and removing filters in DAX
• Common DAX solutions
  • Percentages of the whole
  • Work with dates and times
  • Time Intelligence: Running Totals (Year-to-Date, Quarter-to-Date), Time Period Comparison (Year-Over-Year), and more
  • Dealing with stocks: stock, balances, etc. / semi-additivity
  • Average per summed category
  • Other common resolution patterns

Course material

In the Data analysis with Power BI and DAX training, we use material that we have developed ourselves at Wortell Smart Learning. We make sure that you receive all the necessary material on time.

In this training we have added many extra materials on top of the extensive Microsoft Official Courseware material ("Analyzing Data with Power BI", PL-300T00), which you as a participant will receive during the course:

• Assignments to actually get started with Power BI
• Ideas to apply what you have learned every week within your organization
• Links to in-depth and broadening videos, articles and background information: we are happy to share the places where we learn ourselves!
• Recordings of the instructional sessions

Everything is done to ensure that you can apply new knowledge in your organization from week 1.