Delivered from our Belfast City Centre training suites (opposite the Europa Hotel)
• Use the Query Editor to transform your data & get it ready for reporting: (i) Remove unwanted rows/ columns (ii) Remove duplicate rows (iii) Clean, standardise & filter data (iv) Split fields/ merge fields & extract from fields, etc)
• Review the use of M & edit/ update generated steps
• Create measures
• Create columns/ fields using more advanced functions (IF, Nested IF, CALCULATE)
WHY USE POWER BI?
Power BI allows you to create interactive dashboards that visualise your data, connecting directly for real time reporting or to downloads. Use single or multiple sources inc Excel, CSV, SQL, SharePoint, Online Databases, etc. Learn what Power BI can do for you and how to visualise, clean & consolidate data – where necessary, transform it to make ready for reporting. Share your dashboards with others via Teams, PDF or Power BI Online. Turn your data into information then your information into insights.