Power BI Project Focused Course
What you'll learn
- Importing datasets from various sources (Excel, databases, etc.)
- Data Visualization and Dashboard Creation
- Designing interactive and responsive dashboards
- Using different visual elements: charts, tables, slicers, and cards
Requirements
- Basic understanding of using a computer (no prior Power BI experience required).
- Willingness to learn and explore data analytics
- Access to a computer with Power BI Desktop installed (free download from Microsoft).
Description
This Power BI course is a hands-on, project-based learning experience tailored for learners at all levels, from beginners to advanced users. The course focuses on building a complete dashboard report for an e-learning company, guiding you through the entire process of data extraction, transformation, and loading (ETL) within Power BI.
Throughout this course, you will learn how to:
Clean and prepare data: Learn how to clean raw datasets and merge them effectively, ensuring data quality and consistency.
Data Modeling: Build relationships between different datasets and create meaningful data models to drive accurate analysis.
Dashboard Design: Use Power BI’s intuitive tools to create stunning, interactive dashboards that present key insights clearly.
Pagination in Dashboards: Add professional touches by implementing pagination features in reports to enhance navigation and readability.
By the end of this course, you will have built a comprehensive Power BI dashboard from scratch, enabling you to apply these skills in real-world e-learning or business analytics scenarios.
Material Includes
Sample datasets for practice (related to the e-learning company project)
Step-by-step video tutorials
Power BI Dashboard templates
Access to the course discussion forum for peer support
Certificate of completion
What Will You Learn?
Overview of Power BI and its components
Data Extraction, Transformation, and Loading (ETL)
Importing datasets from various sources (Excel, databases, etc.)
Cleaning and transforming raw data for analysis
Merging multiple datasets for comprehensive insights
Creating relationships between datasets
Understanding the use of primary keys and foreign keys
Building calculated columns and measures using DAX
Data Visualization and Dashboard Creation
Designing interactive and responsive dashboards
Using different visual elements: charts, tables, slicers, and cards
Customizing visualizations to match specific audience needs
Advanced Power BI Features
Adding pagination to Power BI reports
Best Practices
Who this course is for:
- Intermediate Power BI Users
- Data Analysts and Business Intelligence Professionals
- Business Owners and Decision Makers
- Students and Graduates
Instructor
I am currently pursuing MSc Data Science and Artificial Intelligence at University of Hull. I have been in the data analytics industry for the past 4 years. Having worked in edTech, ecommerce and marketing industry, I am passionate about teaching you the skills I have gained over the years. I founded an academy in Nigeria called Tekskillup, and I am also a co-founder at Digitstem.