Excel and Power BI for Data Analytics ( 4 weeks )
Prerequisite: No prior knowledge, Working Computer, Good Internet
Gain practical skills in Microsoft Excel and Power BI for effective data analysis and visualization.
For Students Who Are Unable To Join The Live Sessions Due To Conflicting Schedules, The Recording Of Any Live Class You Miss Will Be Sent To You 3-5 Hours After The Class Ends
Why you should join this Bootcamp
live-classes
Participate in interactive live classes for hands-on learning and real-time Q&A sessions.
project-based-learning
Apply your skills to real-world scenarios through project-based assignments.
career-guidance
Receive guidance on potential career paths in data analytics and visualization roles.
certification
Earn a certification upon successful completion of the Excel and Power BI for Data Analytics course.
Curiculum
Excel Fundamentals
Introduction to Microsoft Excel,Navigating the Excel interface,Basic data entry and formatting
MON - FRI
Excel Formatting
Cell formatting and styles,Conditional formatting,Creating and formatting charts
MON - FRI
Excel Data Analysis
Sorting and filtering data,Advanced functions for data analysis,Creating data tables
MON - FRI
Table Pivot
Introduction to PivotTables,Creating and customizing PivotTables,Analyzing data with PivotCharts
MON - FRI
Excel Functions
Common Excel functions (SUM, VLOOKUP, IF, etc.),Nested functions and formula auditing,Text and date functions
MON - FRI
Get Started with Microsoft Data Analytics
Introduction to data analytics concepts,Importing and transforming data in Excel,Connecting Excel to external data sources
MON - FRI
Prepare Data for Analysis
Cleaning and shaping data in Excel,Data transformation and manipulation techniques,Data quality and validation
MON - FRI
Model Data in Power BI
Introduction to Power BI,Creating data models in Power BI,Relationships and DAX formulas
MON - FRI
Visualize Data in Power BI
Building interactive dashboards,Customizing visuals and layouts,Adding insights and annotations
MON - FRI
Data Analysis in Power BI
Performing advanced data analysis in Power BI,Using advanced DAX functions,Optimizing data models for performance
MON - FRI
Manage Workspaces and Datasets in Power BI
Creating and managing workspaces,Publishing and sharing Power BI reports,Refreshing and updating datasets
MON - FRI
Final Data Analytics Project
Selecting and scoping a final data analytics project,Applying Excel and Power BI skills to real-world scenarios,Project presentation and feedback session
MON - FRI
Next Steps and Career Guidance
Exploring further learning paths in data analytics,Preparing for job interviews in data analysis and visualization,Networking and community engagement
MON - FRI