Jump to content
Business Intelligence & Analytics for Digital Transformation

Want to take your Power BI skills to the next level in 2023?


Recommended Posts

 Here are the key things you need to start learning & step up in your game -

1) Understand more connectors
-> Excel, CSV, TXT, Web Scraping, REST APIs, SQL Server, OData, SSAS, SAP etc.

2) Better DAX
-> Build a comprehensive Calendar Table
-> Save your time by using amazing templates available in Bravo (external tool)
-> Time Intelligence Calculations (YoY, YTD, Rolling, QTD, MTD etc.)
-> What-If Modeling - Numerical & Field Parameters
-> Table Calculations
-> Formatting & commenting DAX code

3) Power Query
-> Joins
-> Fuzzy Logic
-> M-Code (Read / Edit / Copy-Paste)
-> Parameters
-> Custom Functions
-> Vision
-> Text Analytics
-> Python / R Scripts

4) Data Modeling
-> Building Star Schema
-> Understanding Composite Key
-> Proper Naming Conventions for Queries, Tables & Columns
-> Cross Filter
-> Hierarchies
-> Folders for Measures
-> Custom Formats
-> Conversion of many-to-many to one-to-many
-> Active Vs Inactive Vs Virtual Relationships (+ how to handle in DAX)

5) Performance Tuning
-> Data Normalization
-> Use Performance Analyzer (Power BI)
-> Diagnostics (Power Query)

6) Visualization
-> Themes & Color Palettes
-> Formatting Options
-> Bookmarks
-> Syncing Slicers
-> Modifying Interactions
-> Using Custom Visuals (Store)
-> Building Custom Visuals (Charticulator)
-> Filters (Different Types)
-> Custom Tooltips
-> Groups, Bins and Clusters
-> Analytics Tab in Visuals
-> Error Bars
-> Custom Titles for Charts
-> Conditional Formatting using DAX
-> Geospatial analytics with custom maps (Shape Maps)

7) Power BI Service
-> Row Level Security Configuration (both Desktop & Service)
-> Scheduled Refresh
-> Connection Gateways
-> Dashboards & Apps
-> Roles in Workspace
-> Workspace Management
-> Datamarts
-> Dataflows
-> Pipelines
-> Scorecard
-> Sensitivity Labels
-> Data connection gateways
-> Query Folding

8. Power BI Integration
Take full advantage of Power BI integration with other tools / technologies
-> Power Automate (Scheduled refresh, Trigger Actions)
-> Power Apps (Embed)
-> Azure Machine Learning
-> Python / R Scripts
-> Power BI datasets in Excel
-> PowerPoint (embed)

Link to comment
Share on other sites

×
×
  • Create New...