Jump to content
One on One Extensive Advanced Excel Training ×
Business Intelligence & Analytics for Digital Transformation

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


Saurabh Jain

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...