This course provides a comprehensive training program designed to transform participants into proficient data analysts. It focuses on using two of the industry's most powerful tools: Microsoft Excel for data preparation and analysis, and Microsoft Power BI for creating dynamic, interactive dashboards and reports.

You'll learn how to leverage the full capabilities of each tool to extract, clean, analyze, and visualize data effectively. The training bridges the gap between traditional spreadsheet analysis and modern business intelligence, empowering you to make data-driven decisions and communicate insights compellingly.

Training Shall Broadly Cover

Advanced Excel for Data Analysis:

• Data Cleaning and Manipulation: Techniques using Power Query to transform raw data into a usable format.
• Formulas and Functions: Mastering complex and nested functions (e.g., VLOOKUP, INDEX-MATCH, SUMIFS, logical and text functions) for advanced data manipulation.
• PivotTables and PivotCharts: Creating dynamic summaries and visualizations to identify trends and patterns.
• What-If Analysis: Using tools like Goal Seek and Scenario Manager for forecasting and decision-making.
• Data Validation and Conditional Formatting: Ensuring data integrity and highlighting key information.

Introduction to Power BI:

• Core Concepts: Understanding the Power BI ecosystem (Power BI Desktop, Service, Mobile).
• Connecting to Data Sources: Importing data from various sources (Excel, SQL, web, etc.).
• Data Modeling: Creating relationships between tables to build a robust data model.

Data Transformation in Power BI (Power Query):

• Data Shaping: Using the Power Query Editor to clean, merge, and append data.
• M Language Basics: An introduction to the Power Query Formula Language for custom transformations.

DAX (Data Analysis Expressions):

• Calculated Columns and Measures: Creating new data fields using DAX formulas.
• Time Intelligence Functions: Analyzing data over different time periods (e.g., year-over-year growth).
• Aggregations and Filters: Writing advanced DAX to create powerful calculations.

Data Visualization and Reporting:

• Creating Interactive Dashboards: Designing compelling and intuitive dashboards in Power BI.
• Visual Best Practices: Choosing the right visuals (charts, graphs, cards) to tell a clear story.
• Slicers and Filters: Enabling users to interact with and explore data dynamically.
• Publishing and Sharing: Publishing reports to the Power BI Service and sharing them with colleagues.

Hands-on Workshops:

Practical exercises and case studies will be used to reinforce learning and provide real-world application of skills.

Who Should Attend?

This course is ideal for anyone who works with data and wants to enhance their analytical and reporting capabilities, including:

• Business Analysts and Data Analysts
• Finance and Accounting Professionals
• Marketing and Sales Analysts
• Operations and Supply Chain Managers
• Students and recent graduates seeking to improve their technical skills
• Anyone involved in reporting, forecasting, or strategic planning

Prerequisites

Participants should have a foundational understanding of Microsoft Excel. No prior experience with Power BI is required.

Self-Evaluation

• Pre-Evaluation: There shall be a Pre-Evaluation for Knowledge Check, whereby we shall be able gauge the specific needs of the Participant.
• Post-Evaluation: There shall be a Post-Evaluation for Knowledge Check, whereby we shall be able to analyse the Participant has achieved the learning objectives.

What’s Included?

• Learning Materials
• Hands-on Workshops
• Certificate of Training (Certificate shall be issued as a ‘Soft Copy’ from our Training Portal. This certificate can be verified anytime from our website tcb.qcin.org by entering its unique ID number or scanning the QR Code)

Enquire Now

Rohit Varshney, Project Manager TCB/QCI, rohit.varshney@qcin.org, Ph. 9773500376