Essential Skill Tracker for PowerBI

by Animesh Singh

follow me on ......LinkedIn

Microsoft Power BI is a business intelligence (BI) platform that provides nontechnical business users with tools for aggregating, analyzing, visualizing and sharing data. Power BI's user interface is fairly intuitive for users familiar with Excel, and its deep integration with other Microsoft products makes it a versatile self-service tool that requires little upfront training..

Things to know to Organize your skill and Work

🔥 The skills below will prepare you for almost any entry-level Data Analyst role!

Each points has a skills list, video tutorials, and guided projects

    Skills List
  • Calculated Columns
  • Connecting to Data Source
  • Creating Dashboards in the PowerBI service
    • Adding comments or alert to tiles
  • DAX
    • Calculate
    • Filter
    • SUMX, AVGX, etc
    • VAR
  • Exporting reports to Powerpoint/PDF
  • Filter pane use (page filters, report filters)
  • Independent date table
  • Measures
    • Creating a measure
    • Quick measure
  • PowerBI licensing
  • PowerQuery data manipulation
    • Column manipulation (split, trim, pivot, etc)
    • Copying versus referencing a table
    • Data types
  • Publishing Reports
    • Embedding in Sharepoint
    • PowerBI service
    • Teams
    • Website or portal
  • Slicers - Editing slicer interaction with visuals
  • Subscribing individuals to reports/dashboards
  • Table relationships
  • Visuals
    • Analytics features (Reference lines, average lines, etc.)
    • Formatting
  • Views (Default & phone)
  • Workspaces
  • Date Timeline (Month, Year, Day, Weekday, End Date, Start Day, YTD, Etc)
  • Video Tutorials