Unlocking Your Data Potential with Power Query
Are you ready to supercharge your data analysis skills and take your career to the next level? Look no further than the ‘Power Pivot & Power Query’ course, where we dive deep into the dynamic world of Power Query.
Unleash the Power of Data Transformation
In today’s data-driven business landscape, harnessing the full potential of your data is paramount. Power Query is your gateway to this transformation. In this course, you will learn how to seamlessly extract, transform, and load data from a variety of sources. From databases to Excel files, you’ll gain the skills to effortlessly prepare data for analysis, creating a solid foundation for decision-making.
Empower Your Career
Imagine the doors that will open for you with these invaluable skills. For sales executives, business analysts, project managers, and more, mastering Power Query can be a game-changer. Whether you’re looking to streamline your workflow, enhance your analytical capabilities, or simply stay ahead in the corporate world, this course is your ticket to success.
Don’t miss out on this opportunity to become a data wizard. Join us and become the go-to data expert in your organization, armed with the transformative power of Power Query.
Course Details
Course Code:-; Duration: 2 Days; Instructor-led
Overview
Microsoft Power BI will help you analyze your organization’s data and uncover insights and trends in more advanced. This course will show you how to create more calculation and data modelling to use in visual reports that reveal data insights.
When to Use
- Add new column based on calculations
- Add new measures
- Add a new table
- Modelling data
Audience
- Sales Executive / Managers
- Business Analysist
- Resource Planning Team
- Project Managers
- Purchasing Manager
- Financial Executive / Managers
Prerequisites
User has an intermediate knowledge of Microsoft Power BI Desktop
Methodology
This program will be conducted with interactive lectures, PowerPoint presentation, discussion, and practical exercise.
Outlines
Lesson 1: Introduction to DAX
- What is DAX
- Component of DAX
o Functions
o Operators
o Values - Types of Calculation
Lesson 2: Aggregation Functions
- Implicit Measure with
o SUM
o COUNT / COUNT (DISTINCT)
o AVERAGE
o MAX
o MIN - Â Create Measure with Aggregation Function
o SUMX & FILTER
o COUNTX & FILTER
o AVERAGEX & FILTER
o COUNTROWS & FILTER
o COUNTBLANK & FILTER
Lesson 3: Filter Functions
- Measure with
o CALCULATE
o ALL
o ALLCROSSFILTERED
o ALLSELECTED
o ALLEXCEPT
o KEEPFILTERS
o REMOVEFILTERS
o RUNNING SUM
o ORDERBY
Lesson 4: Logical Functions
- Column with
o IF
o SWITCH - Measure with
o IF
o RANKX
Lesson 5: Information Functions
- Measure with
o ISINSCOPE
o HASONEVALUE
Lesson 6: Relationship Functions
- Measure with
o CROSSFILTER
o USERELATIONSHIP - Column with
o RELATED
o RELATEDTABLE
Lesson 7: Table Manipulation Functions
- Table with
o ADDCOLUMN
o CROSSJOIN
o EXCEPT
o UNION
o INTERSECT
o SUMMARIZE
o SELECTCOLUMNS
o CALCULATETABLE
o GROUPBY
o DISTINCT - Table with
o TOPN
Lesson 8: Text Functions
- Column with
- CONCATENATE
- SUBSTITUTE
Lesson 9: Time Intelligence Functions
- Table with
o CALENDAR
o CALENDARAUTO - Column with
o DATEADD
o DATEDIFF
o NETWORKDAYS
o WEEKNUM
o YEAR
o MONTH
o FORMAT - Measure with
o PREVIOUSDAY / PREVIOUSMONTH / PREVIOUSQURTER
o SAMEPERIODLASTYEAR
o PARALLELPERIOD
o DATESINPERIOD
o TOTALMTD / TOTALQTD / TOTALYTD
o DATESMTD / DATESQTD / DATESYTD
