Data Analytics and Visualization MasterClass
---a fusion of Microsoft Excel and Power BI---
with Microsoft Power BI Data Analyst Certification PL-300
Duration: 3 weekends (In-Class), 6 weeks (live virtual class)
Fee: 405,000 Naira
In-Person & Live Virtual Class Options
Data Analytics and Visualization MasterClass
Excel and Power BI are two powerful tools for data analytics and visualization. Both tools offer a wide range of capabilities that can help users extract insights from data and create compelling visualizations.
With Excel, users can manipulate and analyze data using functions, pivot tables, and charts. Excel’s flexibility and ease-of-use make it an excellent choice for small to medium-sized datasets. Users can also leverage Excel’s add-ins, such as Power Query and Power Pivot, to enhance data processing and analysis capabilities.
Power BI, on the other hand, is a more advanced data analytics and visualization tool that can handle larger datasets and create more sophisticated visualizations. Power BI offers a wide range of visualization options, including charts, maps, and gauges, and allows users to create interactive dashboards that can be shared with others. Power BI’s integration with other Microsoft tools, such as Excel and SharePoint, also makes it easy to collaborate with others and access data from various sources.
In this training, we’ll cover the basics of data analytics and visualization using both Excel and Power BI. We’ll start with Excel and cover topics such as data cleaning, filtering, and sorting. We’ll also explore how to use Excel’s functions and pivot tables to perform data analysis and create charts and graphs.
Next, we’ll dive into Power BI and cover topics such as data modeling, data visualization, and creating interactive dashboards. We’ll also explore how to use Power BI’s advanced features, such as DAX formulas and custom visuals.
Throughout the training, we’ll emphasize the importance of effective data storytelling and communication. We’ll provide tips and guidance on how to create compelling visualizations that highlight key insights and engage the audience.
This course would also be taught with a minimum of 5 live projects. This is a 100% Practical Intensive Course; hence all participants are expected to come with their personal Computers
By the end of this training, participants will have a solid understanding of how to use Excel and Power BI for data analytics and visualization, and will be equipped with the skills and tools necessary to extract insights from data and effectively communicate them to others.
Course Learning Outcome
In this course, you will analyse and visualize data using Microsoft Excel and Power BI and associated tools
- Perform data analysis fundamentals.
- Visualize data with Excel.
- Analyze data with formulas and functions.
- Analyze data with PivotTables.
- Present visual insights with dashboards in Excel.
- Create geospatial visualization with Excel.
- Perform statistical analysis.
- Get and transform data.
- Model and analyze data with Power Pivot.
- Present insights with reports.
- Analyze data with self-service BI.
- Connect to data sources.
- Perform data cleaning, profiling, and shaping.
- Visualize data with Power BI.
- Enhance data analysis by adding and customizing visual elements.
- Model data with calculations.
- Create interactive visualizations.
- Use advanced analysis techniques.
- Enhance reports and dashboards.
- Publish and share reports and dashboards.
- Extend Power BI beyond the desktop.
Audience Profile
This course is designed for professionals in a variety of job roles who are currently using desktop or web-based data management tools such as Microsoft Excel or SQL Server reporting services to perform numerical or general data analysis. They are responsible for connecting to cloud-based data sources, as well as shaping and combining data for the purpose of analysis. They are also looking for alternative ways to analyze business data, visualize insights, and share those insights with peers across the enterprise. This includes capturing and reporting on data to peers, executives, and clients.
This course is also designed for professionals who want to pursue the Microsoft certification Exam PL-300: Microsoft Power BI Data Analyst.
Course Outline
- Module 1: Data Analysis Fundamentals
- Module 2: Visualizing Data with Excel
- Module 3: Analyzing Data with Formulas and Functions
- Module 4: Analyzing Data with PivotTables
- Module 5: Presenting Visual Data with Dashboards in Excel.
- Module 6: Creating Geospatial Visualization with Excel.
- Module 7: Working with Multiple Worksheets and Workbooks.
- Module 8: Performing Statistical Analysis
- Module 9: Automating Workbook Functionality.
- Getting and Transforming Data.
- Using Lookup Functions and Formula Auditing.
- Forecasting Data
- Creating Sparklines and Mapping Data.
- Modelling and Analyzing Data with Power Pivot
- Presenting Insights with Reports
- Module 1: Introduction to Power BI
- Module 2: Working with PowerBI Desktop Files
- Module 3: Connecting to Data Sources with PowerBI Desktop
- Module 4: Creating a Report with Visualizations
- Module 5: Doing more with Visualizations
- Summary
- Project One
SECTION TWO (Working with Data)
- Module 6: Transforming and Sanitizing Data
- Module 7: Using the Query Editor
- Module 8: Data Modelling
- Module 9: Managing Relationships
- Summary
- Project Two
SECTION THREE (Working with Reports and Visualizations)
- Module 10: Managing Report Pages
- Module 11: Changing Reports View Options
- Module 12: Working with Visualizations.
- Module 13: Adding Static Objects to Report.
- Summary.
- Project Three
SECTION FOUR (A closer look at visualizations)
- Module 14: Matrixes, Tables Charts
- Module 15: Maps.
- Module 16: Cards, Gauges and KPIs.
- Module 17: Slicers
- Project Four
- Project Five
- Project Six
