Course Description: This course provides an introduction to Power BI, a powerful business analytics tool by Microsoft. Students will learn how to connect, transform, visualize, and share data using Power BI for effective decision-making.
Introduction to Power BI
- Overview of Power BI and its capabilities
- Installing Power BI Desktop and setting up an account
- Understanding Power BI service and Power BI mobile app
Connecting to Data Sources
- Importing data from various sources (Excel, databases, web)
- Data transformation and cleaning using Power Query Editor
- Creating data relationships and data modeling
Data Visualization Basics
- Creating basic visualizations (e.g., charts, graphs, tables)
- Formatting and customizing visuals for better presentation
- Working with slicers and filters for interactivity
Advanced Data Visualization Techniques
- Utilizing custom visuals and visuals from the marketplace
- Creating calculated fields and measures
- Implementing conditional formatting and dynamic visuals
Power BI DAX (Data Analysis Expressions)
- Introduction to DAX functions and formulas
- Calculated columns, measures, and calculated tables
- Aggregations and advanced DAX functions
Power BI Reports and Dashboards
- Building interactive reports with multiple visuals
- Creating effective dashboards for data storytelling
- Organizing and sharing reports in Power BI service
Power BI Service and Collaboration
- Publishing reports to Power BI service
- Configuring dashboards, workspaces, and apps
- Collaborating with team members and sharing insights
Power BI Data Gateway and Refreshing Data
- Configuring and using Power BI Gateway
- Scheduling data refresh for cloud and on-premises data sources
- Troubleshooting data refresh issues
Power BI Mobile App and Accessibility
- Overview of Power BI mobile app features
- Designing reports for mobile consumption
- Accessibility considerations for Power BI reports
Power BI Governance and Administration
- Implementing security and access control
- Setting up row-level security (RLS)
- Auditing and monitoring Power BI usage
Power BI Embedded (Optional)
- Introduction to Power BI Embedded for embedding reports in applications
- Embedding reports in web applications and SharePoint
Final Projects and Capstone
- Applying Power BI concepts to real-world scenarios
- Conducting a complete data analysis project
- Final project presentation and evaluation
Assessment:
- Class participation and engagement
- Homework assignments and practical exercises
- Mid-term and final projects
- Final project presentation and evaluation