Live briefing
Everything about Data Analysis Expressions
Formula and data query language
Data Analysis Expressions (DAX) is the native formula and query language for Microsoft PowerPivot, Power BI Desktop and SQL Server Analysis Services (SSAS) Tabular models. DAX includes some of the functions that are used in Excel formulas with additional functions that are designed to work with relational data and perform dynamic aggregation. It is, in part, an evolution of the Multidimensional Expression (MDX) language developed by Microsoft for Analysis Services multidimensional models combined with Excel formula functions. It is designed to be simple and easy to learn, while exposing the power and flexibility of PowerPivot and SSAS tabular models. Wikipedia →
🧭 Start here: a 6-step reading path
- Read the overview: Data Analysis ExpressionsA 5-minute orientation
- Skim a recent paper: Correlation analysis between EEG data and facial expressions and sleep behaviorsInfluential work since 2022
- Pick up a classic book: Statistical Analysis of Gene Expression Microarray DataThe most-reprinted book on the subject
- Read the landmark paper: Analysis of Relative Gene Expression Data Using Real-Time Quantitative PCR and the 2−ΔΔCT MethodCited 168,111 times
- Go sideways: Power PivotA closely related topic
- Go sideways: Microsoft Analysis ServicesA closely related topic
📖 Definitions
No dictionary entry for this exact phrase.
🗂️ The subject at a glance
🏆 Landmark papers (most cited)
Analysis of Relative Gene Expression Data Using Real-Time Quantitative PCR and the 2−ΔΔCT Method
edgeR : a Bioconductor package for differential expression analysis of digital gene expression data
Data analysis of heavy metal content in riverwater: multivariate statistical analysis and inequality expressions
Internal standard-based analysis of microarray data. Part 1: analysis of differential gene expressions
Characteristics of facial muscle activity during voluntary facial expressions: Imaging analysis of facial expressions based on myogenic potential data
Analysis of multicrystal pump–probe data sets. I. Expressions for the RATIO model
BioNetApp: An interactive visual data analysis platform for molecular expressions
Analysis of the relationship between longitudinal gene expressions and ordered categorical event data
🆕 Influential since 2022
Correlation analysis between EEG data and facial expressions and sleep behaviors
How Facial Expressions of Recipients Influence Online Prosocial Behaviors?—Evidence from Big Data Analysis on Tencent Gongyi Platform
A Study on Analysis Model for Influence of Expressions from Others on Taste Expressions in Word-of-Mouth Data of Cooking Recipe Website
Identifying customer preferences on two competitive startupproducts: An analysis of sentiment expressions and textmining from Twitter data
Comparative Analysis of Heat Transfer Coefficient Using Experimental Data and Empirical Expressions
📚 Books worth reading
Statistical Analysis of Gene Expression Microarray DataTerry Speed · 2003
DNA microarraysB. Oliver · 2006
Gene mapping, discovery, and expressionMinou Bina · 2006
Bioinformatics and genome analysisHans-Werner Mewes · 2002- 📕A beginner's guide to microarraysEric M. Blalock · 2003
Data mining for biomedical applicationsJinyan Li, Qiang Yang · 2006
Modern genome annotationDmitrij Frishman · 2009
Research in Computational Molecular BiologyTerry Speed, Haiyan Huang · 2007
Ranked by number of editions on Open Library, a rough measure of how lasting a book is.
🔗 Related topics
- Power Pivot Power Pivot, formerly known as PowerPivot (without spacing), is a self-service business intelligence feature of Microsoft Excel which facilitates the creation…
- Microsoft Analysis Services Microsoft SQL Server Analysis Services (SSAS) is an online analytical processing (OLAP) and data mining tool in Microsoft SQL Server. SSAS is used as a…
- BIDS Helper BIDS Helper is a Visual Studio open source extension with multiple features that extend and enhance business intelligence development functionality in…
- Power Query Power Query is an ETL tool created by Microsoft for data extraction, loading and transformation, and is used to retrieve data from sources, process it…
- MultiDimensional eXpressions Multidimensional Expressions (MDX) is a query language for online analytical processing (OLAP) using a database management system. Much like SQL, it is…
- Essbase Essbase is a multidimensional database management system (MDBMS). The platform provides tools to build data analytic applications. Arbor Software developed…
- Microsoft Power BI Microsoft Power BI (PBI) is an interactive data visualization, database management, and data modeling software product developed by Microsoft with a primary…
- CubePort CubePort is a commercial software application that converts from Oracle Essbase to the analogous Microsoft product Microsoft Analysis Services, which is…