Microsoft Power BI for Beginners & Excel Users
Dive into a course initially recorded live, making it engaging and interactive. You won't just be passively learning; you'll feel like you're right there in the room with participants from the corporate world and learning solutions to REAL problems.
Here's what you'll learn in each unit:
Introduction to Business Intelligence
Overview of Business Intelligence
The journey from data to wisdom
Understanding the Business Intelligence process with Power BI
Understanding the Data Cycle
Exploring the limitations of traditional tools like Excel
Reviewing different licensing options in Power BI
Data Transformation Techniques in Power BI
Introduction to Power BI Query Editor
Common issues with data and how to identify them
Steps for effective data cleaning:
Removing columns and rows
Setting the first row as header
Changing data types, replacing values, and removing spaces
Handling errors, renaming and optimizing steps
Filling down missing values, splitting columns, and removing duplicates
Tips and tricks to automate data cleaning
Data Modeling and Enrichment
Basics of data modelling and building relationships
Understanding filter propagation and cardinality
Best practices in data model construction
Introduction to data enrichment: Creating calculated columns and measures
Basics of Data Visualization
Familiarization with native and custom visuals in Power BI
Hands-on creation of various charts (pie, line, bar), tables, and cards
Techniques for drilling down hierarchies and setting visual interactions
Formatting visuals and reports, including titles, legends, and axes
Utilizing slicers and different levels of filtering
Applying conditional formatting
Embedding images into reports
Publishing and Sharing Insights
Steps to publish reports and set default user experiences
Creating and managing workspaces for collaboration
Strategies for sharing reports effectively
Designing reports for mobile layouts
