ADVANCED DATA ANALYSIS EXPRESSIONS (DAX)
Filter DAX Functions and Variables
Use filtering functions to manipulate data context and to create dynamic calculations such as:
- ALL(), ALLEXCEPT(), FILTER()
- SELECTEDVALUE(), ALLSELECTED()
- Utilizing VAR for dynamic calculations.
Table Manipulation and Relationship Functions
Use table functions to return values or manipulate existing tables such as:
- TOPN(), VALUES()
- RELATED(), RELATEDTABLE()
- USERELATIONSHIP() for advanced relationship management.
Time Intelligence Functions
Use time intelligence function to perform calculation using time periods, including days, months, quarters, and years, and then build and compare calculations over those periods such as:
- DATEADD()
- NEXTYEAR()
- PREVIOUSYEAR()
- PREVIOUSMONTH()
- TOTALMTD()
- TOTALYTD()
DATA MODELING PRINCIPLES
- Introduction to data modeling and its importance in analytics.
- Understanding and managing relationships: terminology, logic, and troubleshooting.
- Best practice for Many-to-Many Relationships
- Creating a Dynamic Calendar Table
- Comparing Star Schema vs. Snowflake Schema
- Optimizing performance and avoiding a single large table
- Maintaining robust and scalable data models.
ADVANCED VISUALIZATIONS
- ArcGIS Maps: Geographic visualizations for spatial analysis.
- Metrics and KPIs: Displaying performance indicators.
- Narrative Visualizations: Creating meaningful data stories.
- Decomposition Tree: Root cause analysis and pattern discovery.
- Key Influencers: Identifying factors influencing outcomes.
- Python and R Script Visuals: Incorporating advanced analytics.
ADVANCED REPORTING
- Paginated Reports: Generating detailed, print-ready reports.
- Utilizing parameters for dynamic report filtering and customization.
- Designing advanced dashboards for interactive reporting.
- Create visually rich report tooltips to provide additional information about data on dashboard visuals.
POWER BI AI TOOLS FOR ANALYTICS
- Leveraging AI tools for advanced analytics:
- Text Analytics: Analyzing and interpreting textual data.
- Vision: Visual AI for image-based data.
- Azure Machine Learning: Integrating machine learning models into Power BI.
