Introduction to DAX (Quick Overview)

-

This is just an overview of DAX language. We will begin calculations and extensive analysis on my next post.Enjoy.

What is DAX?:

Data Analysis Expression(DAX) is a Functional Language currently used in Power BI Desktop ,Analysis Services Tabular and Power Pivot for Excel. It is a collection of functions that can be used to calculate and return one or more values. In DAX, functions can contain other, nested functions and value references depending on your model and key business questions to be answered. DAX includes some of the functions used in Excel formulas plus other functions designed specifically to work with relational data and perform dynamic aggregations.

Why DAX?:

The difficult questions raised facing a business or an organization can be simplified using DAX, to shed more light into your data. Learning how to create effective DAX formulas will help you get the most out of your data and be able to solve real business problems.

What is DAX used for?:

1. Calculated Columns: This DAX model operates in the context of the current row across that table. Which also indicates,you cannot directly access the values of other rows. You must know, all calculated columns occupy space in memory and are computed during table processing.(calculated column uses your RAM).

2. Calculated Measures: This DAX model is used to aggregate values from many rows in a table. A measure is evaluated in the context of the cell evaluated in a report or in a DAX query on like calculated column computed at the row level within the table it represents.

What are DAX's Data types?:

1. Whole Number.

2. Decimal Number.

3. Currency.

4. True/False.

5. Text.

6. Date.

7. Binary.

Other important DAX concepts will be discussed in my next post.

Comments

Post a Comment

Popular posts from this blog

AWS: Benefits of using Amazon S3

-
Image
Let us start with a quick introduction. Amazon simple storage service or Amazon S3 provides developers / IT teams / Organizations / Individuals with secure, available, price friendly object storage in the cloud. Ok. Slow down. What is object storage? It is a computer data storage architecture that manages data as objects, as opposed to other storage architectures like file systems, which manage data as a file hierarchy, and block storage, which manages data as blocks within sectors and tracks. Amazon S3 is easy to use and can be used to store and retrieve any amount of data at any time. All data transfers are over automatic encryption and SSL. Data is secure, available when needed and will scale as your needs grow. Last thing you want to worry about is losing valuable data. Amazon S3 automatically replicates your objects on multiple devices across multiple facilities. In Amazon S3, you create bucke
Read more

Google To Acquire Looker For $2.6 Billion

-
Image
The deal is expected to close later this year, at which point Looker will become part of Google Cloud , helping serve Google customers a more comprehensive analytics solution. Data remains an untapped resource for many organizations and businesses. I believe the addition of Looker to Google Cloud will provide customers with a more comprehensive analytics solution,from ingesting and integrating data to gain insights, to embedded analytics and visualizations enabling enterprises to leverage the power of analytics, machine learning and AI. Whether that’s supply chain analytics in retailing; media analytics in entertainment; or healthcare analytics at global scale. The market for business intelligence software is large. Indeed in August 2018, IDC said that "Worldwide revenue for big data and business analytics (BDA) solutions was $166 billion, up 11.7% over 2017 and would reach $260 billion
Read more

Python - GUI - Tkinter(Bar & Pie Chart)

-
Image
Quickly, i just want to show you a simple example of creating bar and pie chart with Tkinter . Try this simple example: import tkinter as tk root = tk.Tk() root.title("Tkinter Bar and Pie Graph") #here is for bar chart............ tk.Label(root, text='Bar Chart').pack() data = [21, 20, 19, 16, 14, 13, 11, 9, 4, 3] c_width = 400 c_height = 350 c = tk.Canvas(root, width=c_width, height=c_height, bg= 'white') c.pack() #experiment with the variables below size to fit your needs y_stretch = 15 y_gap = 20 x_stretch = 10 x_width = 20
Read more