Power BI

Power BI is a cloud-based set of analytic tools and capabilities that expand the utility of Excel for data analytics.  It is tightly integrated with Excel, works on computers and mobile devices, and is offered at various levels of capabilities.  

Key Competencies:

  1. Power BI DAX - Knowledge of Data Analysis Expressions which includes a library of functions, statements, queries and operators to build forumulas and expressions.

  2. Data Sources - Knowledge of getting data from multiple databases and files. Troubleshooting links to data sources.

  3. Cleaning Data - Knowledge of fixing column metadata, strategy for fixing outliers and missing data. 

  4. Data Modeling - Modeling data for analysis by working with relationships, defining herirarchies. Configuring properties, categories, and formatting. 

  5. Visualizing Data - Ability to create maps, charts, graphs, and matrices.

  6. Administrative - knowledge of the capabilities of various Power BI offerings, managing access to data.