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

More Info

power bi

  1. What's new in this club
  2. 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)
  3. What is the difference between workspace and App in Power BI ?
  4. Download the dataset for practice https://bi-analytics.org/files/file/314-dataset-for-tutorial-1-for-poer-bi/ Assignment & Instructions 1 create the visual by your hand - once done - pl comment Done- You can also share the screenshot : Choose better colours Additionally now try the following 2 Create a chart - showing Sales by year 3 Add Qty in Tooltips : You can now see sales and Qty both in tool tip when you hover a mouse on the column of any year. Do comment what you learnt in the tutorial ?
  5. Version 1.0.0

    28 downloads

    Download the data set for practice
  6. The first step is to install the power BI on your machine There may be many ways to Install (Download) Power BI and as always you can google "Download Power BI" Once done , pl comment Done It will be pleasure to know your location as well... or simply you can keep your profile up to date
  7.  

×
×
  • Create New...