Saurabh Jain Posted May 4, 2023 Share Posted May 4, 2023 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 More sharing options...
Recommended Posts