Gain a competitive edge in your career by developing better understanding and skills for moving into highly sought after operational and management roles in data-related/data science jobs.
This course is about Business Intelligence and Power BI. Understanding the data-driven world and the ability to develop actionable data-driven insights is essential to all businesses that want to improve operational efficiency and develop insights that are of tactical and strategic value. This course is designed with an engaging ‘learning-for-earning’ approach and practice – it uses meaningful real-world examples from business contexts that will enable attendees to take what they learn and apply this in their own workplace. The course will contain material that can help you prepare for Microsoft PL-300 PowerBI Data Analyst Certification.
This beginners-to-intermediate-level course is for those that want a better operational command of Business Intelligence, Power BI, and the knowledge & skills to apply this in a work-based setting. It is suitable for those that are either currently working in data analysis and want a better understanding of Power BI or those who are moving into this field of work.
Understanding of data, business intelligence, and Power BI tools and their application in a work-based setting.
Be able to set up Power BI and undertake intermediate levels of data analysis.
Be able to extract, transform and load data.
Be able to create intermediate levels of data visualisation.
Understand roles in Power BI and be able to assign these to users.
| 9:30am | Delegates join. |
| 9:45am | Introduction to Businesss Intelligence: Trainers welcome. Overview of learning outcomes. Introduction to Business Intelligence and its significance in a story-telling format. |
| 10:15am | Setting up Power BI: Downloading Power BI. Overview of data sources and data loading. ETL (Extract, Load, and Transform) Operations. |
| 11:15am | Coffee Break |
| 11:30am | Exploring Data: The value and application of data insights. Extracting/deriving multiple insights from data. |
| 12:15pm | Data Visualisation: Introduction to data visualisation and dashboards. Overview of visualisation types including graphs and their application. Creating insightful graphs for business intelligence. |
| 1:15pm | Lunch Break |
| 2:15pm | Advanced Data Manipulation and AI Integration: Filtering data effectively in Power BI. The backend functional role of AI. Introduction to Power Query, DAX calculations and use of SQL. Data refreshes. Assigning Roles: Power BI Pro and Premium versions and additional features. |
| 3:15pm | Wrap-up and Useful Resources: Overview of PL-300 Power BI Data Analyst exam. Career benefits and additional tips. Useful links and resources. Q&A. Summary and closing remarks. |
| 3:45pm | Close |
Kalsoom Ali is a Business and Data Analyst with extensive experience of driving digital transformation by deriving actionable insights, validating business assumptions, and facilitating informed decision making to ensure effective process improvement and business growth.
She has experience in analysing business processes, market trends, customer segments and undertaking comprehensive stakeholder requirements assessment.
As a Microsoft certified Power BI Data Analyst, she has expertise in leveraging data visualisation and analytics to deliver impactful business insights for continuous improvement. She has worked on a range of projects including a health and social care Internet of Things (IOT) healthcare management system featuring health analytics, system alerts and alarms to support health care workers and enhance the health & safety of children with health and wellbeing challenges.