ADVANCED POWER BI

GMUSD77

Credits: 2.00

Prerequisites : No Prerequisites Required

Course Duration : 30 Hours / 12 Weeks

Start Date : 2024-08-01

End Date : 2024-10-31

Seats Remaining : 60

BACK

Aim & Summary

The aim of this Advanced Power BI course is to provide students with in-depth knowledge and practical skills in data visualization, advanced data modeling, analytics, and integration with other tools and services. By the end of the course, students will be proficient in using Power BI to create insightful and interactive dashboards, perform advanced analytics, and optimize performance for effective business decision-making.

Course Content
Week 1	Introduction to Power BI • Overview of Power BI • Importance of Data Visualization • Power BI Desktop, Service, and Mobile Apps • Installing Power BI Desktop • Hands-On: Basic Dashboard Creation
Week 2	Data Sources and Data Transformation • Connecting to Different Data Sources • Data Import vs Direct Query • Data Transformation with Power Query • Handling Missing Data and Data Cleansing • Hands-On: Transforming Data in Power BI
Week 3	Advanced Data Modeling • Introduction to Data Models • Creating Relationships and Managing Joins • Creating Calculated Columns and Measures • Using DAX for Advanced Calculations • Hands-On: Building Complex Data Models
Week 4	Advanced Visualization Techniques • Custom Visuals and Their Usage • Interactive Reports with Slicers and Filters • Using Bookmarks and Buttons for Navigation • Advanced Chart Types and Visual Customization • Hands-On: Creating Interactive Dashboards
QUIZ 1
Week 5	Time Intelligence in Power BI • Understanding Time Intelligence Functions • Creating Date Tables • Year-to-Date (YTD), Quarter-to-Date (QTD), Month-to-Date (MTD) Calculations • Time-Based Comparisons and Trends Analysis • Hands-On: Implementing Time Intelligence
Week 6	Advanced Analytics in Power BI • Introduction to Advanced Analytics • Using R and Python in Power BI • Forecasting and Trend Analysis • Clustering and Outlier Detection • Hands-On: Performing Advanced Analytics
Week 7	Power BI Service and Collaboration • Publishing Reports to Power BI Service • Sharing Dashboards and Reports • Creating and Managing Workspaces • Data Refresh and Schedule • Hands-On: Collaborating with Power BI Service
Week 8	Power BI and Power Automate Integration • Introduction to Power Automate • Automating Workflows with Power BI and Power Automate • Triggering Actions Based on Data Changes • Hands-On: Creating Automated Workflows
QUIZ 2
Week 9	Security and Administration in Power BI • Row-Level Security (RLS) Implementation • Managing Permissions and Access • Auditing and Usage Metrics • Data Governance and Compliance • Hands-On: Implementing Security Measures
Week 10	Power BI with Azure • Introduction to Azure Services for Power BI • Connecting Power BI to Azure SQL Database • Using Azure Synapse Analytics with Power BI • Leveraging Azure Machine Learning in Power BI • Hands-On: Integrating Power BI with Azure
Week 11	Performance Optimization in Power BI • Best Practices for Data Model Optimization • Reducing Data Load Time • Optimizing DAX Queries • Monitoring and Improving Report Performance • Hands-On: Performance Tuning in Power BI
Week 12	Future Trends and Capstone Project • Emerging Trends in Business Intelligence and Power BI • AI and Machine Learning Integration • Real-Time Analytics and Streaming Data • Preparing for Power BI Certification • Final Project Preparation and Presentation
PROJECT REPORT

Course Certification

Certificate will have your name, photograph and the score in the final exam with the breakup. It will have the logos of GMU and company handling the course.