Webinar on How DAX Works | Evaluation Context | Filter Context & Row Context | DAX for Power Pivot and Power BI in Hindi

How DAX Works?

Why It's important to know how it is working on functions. because if you know how any language works then you can easily learn and write complex functions. DAX looks like Excel formula language but it has some unique and powerful context. It the Evaluation context, unlike Excel you have to define every test and input in the formula. But not in DAX.

There are two contexts that effect DAX calculation.

Evaluation Context  ( Fliter context & Row context)

Evaluation Context is a combination of the Filter & Raw context. it's mean there is a current context

which has some filters or slicers lavy on the current data model. In this webinar, we have discussed these concepts in detail.

 

Download Practice File From Here

DAX Versus Excel Formula Language Introduction to beginners

DAX Versus Excel Formula Language Introduction to beginners

You are familiar with Excel formulas. Now a day DAX becomes popular among IT professionals. because of its scope and power to solve with big data. unlike Excel, its formulas work on a column, not a single cell.

DAX is the programming language of Microsoft SQL Server Analysis Services (SSAS) and Microsoft Power Pivot for Excel later it comes with the bundle of Power BI.

Understanding the data model

DAX is a language specially created to calculate business formulas over a data model. You might already know what a data model is, but if you are not familiar with it, it is worth dedicating some webinars to a description of data models and relationships, so as to create a framework on which you will build your DAX learning.

Data Model in Power Pivot for Excel or Power BI (Table Normalization & Denormalization)

Normalization & Denormalization of Table or Database in Power BI

This topic is not limited to Power BI. if you have worked on relational databases so probably you are familiar with these words. Normalization is nothing but a method or way to keep data in multiple connected tables to remove repetition and vice-versa denormalization. When all information related to a set of data is maintained in a single table then we can say it is a denormalized table See below image for better clarification.

Now observe the second image carefully. now one table is truncated and a new table has existence in the data model. in this form category and subcategory's duplication is removed. it saves lots of memory without losing the data.

Table Normalization is the root of all data models not only for Power BI. Let's Go with me with an upcoming webinar on 14th June 2020 Sunday at 2 PM. and Learn At Home with Me

Click here to Register here with a forthcoming webinar

Download Practice Files From Here

Meeting link will be sent to your registered mailing address. If you have not registered yet so CLICK HERE to Register.

Combine Multiple Files From A Folder with Power Query Editor in Power BI or Excel

Combine/Merge files in a folder using Power Query

In this webinar, We will talk to combine options in Microsoft Power Query or M Language.

To start the process of combining various files, first, ensure that all the files you want to combine are contained in an individual file folder. and also the same type. Excel, Text/CSV, and MS Access files are supportive.

Automation becomes crucial nowadays for working professionals. it is time obliged to work faster so Business can take resolutions on finger-tips. In Excel merger is a very tidy process. but don't worry with power query you can automate it.

On the Forthcoming webinar on 7 June 2020 at 2 PM, we will review this matter with details. See you there.

Click here to Register here with an upcoming webinar

Download Practice Files From Here

Meeting link will be sent to your registered mailing address. If you have not registered yet so CLICK HERE to Register.

Power BI Free Training (Pivot & Unpivot Transformation of Columns in Power Query Editor Class - 3)

Pivot & Unpivot Transformation of Columns in Power Query Editor

Yes! Yes! Yes! You can make a Pivot table in Power query too. In this webinar, we will discuss Table transformation of Pivot to the Unpivot table. Yes, we have to convert the cross tab table to an Unpivot table to make reports. Let's Discuss Why we need to change with a couple of examples.

No summarise report, not a chart can be made with the Pivot table / Crosstab table. If you have a 90-degree table as a source you must convert it to unpivot first like shown in the image.

I hope you find the difference. See the webinar.

Download Population Project Files

Meeting link will be sent to your registered mailing address. If you have not registered yet so CLICK HERE to Register. 

Power BI Free Training (Power Query for beginners) Transpose Table Class - 2

Transform Table or Column

Table Transformation: 

It is a very easy and important option given to make the table more interactive. there are some tools like Transpose and Group by is playing a major role in the table.

Transposing a Table is the same as Microsoft Excel in Power Query but slightly different. In Excel, the source table transpose but in Power Query transposing will be done in the data model only not with the source. See the image below for what is the mean of transpose the table.

Group by feature is just like a Pivot table. it formulates group by aggregate ( like sum or count ) based on other columns. 

Columns Transformation

Pivot & Unpivot Columns: There are only two ways to keep data in the table. It is a pivot table or Unpivot table.

Download Project Files

Power BI Free Training (Power Query for Beginners) Class - 1

Basics of Power Query

In this class, we will learn how to extract data from various sources such as Excel, Text/CSV,  PDF, SQL Server, MS access and from the Web and  apply some basic Column and Row cleaning

Please Note Kindly Login to your laptop with Power BI, If you have not it. (Click Here to Download)  from Microsoft site it is freely available unlike Excel.

Extract, Pull or Connect to Data Source

This process is the first footsteps, it is a very easy procedure to connect data in Power Query. Just click to a new data source in Power Query. See images below

Power query saves the data source as a Query or Command (M language). we can extract more than one query in a report no matter whatever base source is.
and later we can append merge or combine it for desired results.

Combine File Query

Merge (Similar to Joins)

• Merge Query
• Merge Query as New

Append (Similar to Union)

• Append Query
• Append Query as New

Query Type

• Query as REFERENCE
• Query as Duplicate

Transform Data

Manage Column

• Work with column
• Add Column
• Remove Columns
• Concept of other columns

Working on Data Types

• Text (when no need to calculate)
• Number (calculation needed)
• Date 
• etc.

If you are not registered with us Click here to Register (FREE). Training link will be sent to registered mail Id with us