Svenska
Analyse data on a whole new level with Power Pivot and Data Analysis Expressions (DAX)
With Power Pivot and DAX, you can model data, visualize big data, and easily and efficiently perform analyses to gain important insights. DAX (Data Analysis Expressions) is a collection of formulas used, among other things, in Power Pivot, Power BI, and Azure Analysis Services. If you work with data management and analysis, the Excel add-in will be highly valuable.
- Build smart data models that save time
- Analyze large datasets with powerful DAX formulas
- Boost your CV with a diploma
- Practice with real business scenarios
- Short lessons – flexible structure
- Learn at your own pace, over 12 months
- Used by companies and universities
Try some lessons in this course for free
Fill in your e-mail address and telephone and we will give you 7 days free access to some lessons in this course.
Try some lessons in this course for free
Fill in your e-mail address and telephone and we will give you 7 days free access to some lessons in this course.
Course manager
Emil
Emil is an important part of our team of course creators. He has been creating courses on Learnesy since 2017 and has an education in computer science. Many of the popular courses that can be found in Learnesy’s course range have been developed by Emil and he has a broad competence in Excel, data analysis and programming.
Niklas
Niklas creates new courses and manages existing courses on the Learnesy platform. He has studied statistics and has a background in programming and data visualization. In addition to good knowledge of Excel, he has a burning interest in data analysis, and possesses good knowledge of the subject and tools for the field.
Some of the things you will learn in this course:
Power Pivot basics
Gain a basic knowledge base in Power Pivot by first downloading and creating a shortcut to Power Pivot as an add-in for Excel. Retrieving data from external sources correctly is the most important step for the program, and in this course you will learn to do just that.
Relationships and columns
Relationships are an essential building block of working in Power Pivot, where many different kinds of relationships are created between separate databases. You can connect columns from one database to another to create completely new information as well as new ways of looking at the data you’re working with.
Measures
Measures are calculations that are applied to large amounts of data for data analysis. This course gives you an introduction to the concept and how to use it to provide new insight into your data.
Data Analysis Expression (DAX) formulas
DAX formulas are special measures that can take in multiple columns as arguments and can process big data in a way that Excel cannot. Learn the most common and useful DAX formulas as well as how these measures work.
A lesson from the course
In this lesson from the course Power Pivot & DAX, you’ll learn about relationships. This is one of the lessons in the chapter Relations & columns. What differentiates Power Pivot from regular pivot tables is that we can retrieve external data from multiple places and perform extensive pivot table analysis. Where we would normally have to write a lot of VLOOKUP formulas to find related data among different databases, we can make the job easy with the help of relationships. A relation is a connection between two tables of data, based on one or more columns in each table. Power Pivot allows you to take multiple data sources and combine the data tables into a coherent database called a relational database. Power Pivot & DAX is a basic course in Power Pivot and DAX, which requires some knowledge in Excel. Power Pivot is an Excel add-in that can be used for data analysis and for creating data models. Power Pivot uses the DAX formula language that allows the user to create new information using calculations.
More about the course
Power Pivot is a powerful add on for Excel and DAX (Data Analysis Expressions) includes additional functions to use when you work with relational data and dynamic aggregation. With Power Pivot & DAX you can create data models, data analysis and import data from different various sources.
- Approximately 15 lessons divided into 4 chapters.
- Total video time: 37 minutes.
- Estimated time to take the course including quizzes: 2.5 hours.
- Average duration per lesson: 3 minutes.
- Personal shareable certificate after completing the course.
Invest in your knowledge
One course (Power Pivot & DAX)
2 995 kr
VAT will be applied.
Educate yourself further with an online course in Excel, Power BI, or PowerPoint – to name a few.
Course package
5 995 kr
VAT will be applied.
Take your career to the next level with our tailored course packages!
Educational scheme
- Access to all material 24/7 for 12 months
- Complete the course at your convenience
- Repeat freely during the access period
- Courses that are maintained and updated
- Personal and digitally shareable diploma per course
- Schedule and set goals for your learning
- Save your favorite lessons
- Ask your questions in our forum
- Tech Support
- Track and test your knowledge
- Admin features for your team
- LMS integration
- Discounts for multiple users
Business groups
With our platform, we focus on improving your company's skills through customized course content, flexible learning times, and tracking tools to track and test employee progress. We offer courses in several languages and for different skill levels, as well as the possibility of hybrid training and integration with your company's LMS system. When you feel ready - contact us for a quote.
- Personal Account manager
- Personal User Accounts
- Select courses
- Quantity discount
- Statistics
- Unique login domain
- Prior knowledge and follow-up test
- Compare progress with the group
Prices excluding VAT
How Your Learnesy Course Works
At Learnesy, we believe that education should be accessible and straightforward. That’s why we’ve created a platform with you, the user, at the center. Within the platform, you can easily navigate in and between your online courses.
• My Account – here you’ll find your dashboard, where you can access both ongoing and completed courses. Your dashboard is the starting point for your learning journey.
• Get a glimpse of a Learnesy course – from your dashboard, you can easily click through to an ongoing or completed course.
• Favorite and share lessons – found a particularly useful segment or something you want to review again? You can save these by marking them as favorites. You can also share lessons with others who might benefit from them.
• Quizzes and practice exercises – practice makes perfect. Here, you put your theoretical knowledge into action. All quizzes, as well as all course content, can be repeated.
• Congratulations on your course diploma – upon completing a course, you’ll receive a personal, shareable diploma as proof of your new skills.
Have a question? You might find your answer here. If not, don’t hesitate to contact us.
FAQ
What is covered in the Power Pivot & DAX course?
You’ll learn data modeling using Power Pivot and advanced DAX (Data Analysis Expressions) formulas to analyze large datasets and derive insights efficiently. The course includes practical exercises, quizzes, and a personal, shareable certificate.
How is the course structured and how long does it take?
It includes around 15 video lessons totaling roughly 2.5 hours of content.
Who is this course for?
Ideal for Excel users with basic knowledge who want to move beyond PivotTables into robust data modeling and advanced analytics.
How much access do I get and for how long?
You get full access to all materials for 12 months, with the freedom to repeat any lesson.
Will I receive a certificate after completing the course?
Yes, a personal, digitally shareable certificate (diploma) is provided upon successful completion of the course.
Can I try the course before buying?
Yes, you can try select lessons for free over a 7-day period.
Is there group or business pricing available?
Absolutely, we offer discounted group packages. Just reach out and we’ll tailor a solution to fit your needs.
Who should I contact for additional questions or support?
For questions about course content, technical assistance, or group licensing, contact support@learnesy.com.
Related courses
