Data Analysis Boot Camp Using Excel and Power BI

Data Analysis Boot Camp Using Excel and Power BI For Professionals


Program Overview

Data analytics is a rapidly growing field with high job demand across a variety of industries. With the increasing reliance on data-driven decision-making, companies are seeking professionals who can analyze complex data sets and provide insights to improve business operations. 

Data-related jobs have seen a significant increase in demand over the years, and this trend is expected to continue in the coming years. According to the World Economic Forum, it is estimated that there will be a growth of 65% in data-related jobs by the year 2025.


What will you learn in this track? 


  • The fundamentals of Business Intelligence (BI) and OLAP operations. 
  • Data Cleaning and transformations using embedded Power Query Module in Power BI. 

  • The Advanced visualizations build in Power BI and the 3rd party charts. 

  • Different data connectors available in Power BI. 

  • Connecting Power BI to SQL servers in both Import and Direct Query modes. 

  • The art of Data storytelling in Power BI. 

  • Data Assets Management in Power BI.

  • Power BI Service and Microsoft Fabric. 

Course Outline
Who Should Attend ?
Course Prerequisites
Learning Methodology
Course Duration
Course Outline

Program Agenda

The following proposed agenda is subject to changes by the client for the ultimate benefit of improving the training ROI of delegates and the client organization. The schedule duration can also be lengthened if the client wishes to enable delegates to achieve an even deeper understanding.

Sessions Outline:

Session 1:

    1. Fundamentals of Business Intelligence (BI). 
    2. The BI tools market overview. 
    3. Basic OLAP operations applied in BI. 
    4. Power BI different SKUs and their features. 
    5. Power BI GUI exploration. 

Session 2:

    1. Data Profiling with Power BI. 
    2. Connecting data sources to Power BI through Power Query Module. 
    3. Data Transformation advanced techniques. 
    4. Building Calendar Table in Power Query. 
    5. Computed columns in Power BI and their performance advantages. 
    6. Advanced data combination techniques in Power Query. 
    7. filtering and Querying in Power BI. 

Session 3:

    1. An introduction to Query Editor in Power BI. 
    2. An introduction to M language for query writing/ editing. 
    3. Connecting Power BI to SQL server. 
    4. Connecting Power BI to cloud services and data hubs. 
    5. Best practices in dealing with different data types in Power BI.
Who Should Attend ?

Who Should Attend?

The course is suitable for:

  • Middle-level professionals in Sales, Finance, Marketing, and Customer Service. 
  • Data Engineers. 
  • CXO-level professionals 
  • Business Intelligence Professionals who are seeking to migrate from another BI tool to Power BI. 
  • Auditors and accountants. 
  • HR managers and heads of departments.
Course Prerequisites

Course Prerequisites

  • Basic Knowledge of Computers. 
  • Basic Algebra and statistics. 
  • Basic understanding of Data Model in Microsoft Excel. 
  • A device with a processor Core i5 or higher with 8 GB of RAM at least.
Learning Methodology

Learning Methodology

The learning methodology is highly interactive, consisting of a balanced mix of short presentations,  the Course Director’s extensive experience in this specialized field, handouts containing key articles and topic support, dialogue about leading practice, delegates’ own ideas, experiences and Q&A, sharing of knowledge, discussions, feedback, scenarios, case studies, practical examples, individual and group exercises designed to assist the participants to gain a working knowledge of the topics taught and to embed the skills.

Course Duration

Course Duration: 

18 Hours

Session 4:

    1. Introduction to Data Modeling in Power BI. 
    2. Data Normalization Fundamentals. 
    3. Database schemas. 
    4. managing relationships among the different tables in the data model. 
    5. Breakdown the workload between Power Query and DAX. 
    6. Creating Dimensions hierarchies for data grouping. 
    7. Creating Data binning for better visualization. 
    8. Designing proper (chart, page, report) filters and slicers. 
    9. Applying Data Drill Down and Data Drill Through Techniques. 
    10. Understanding the difference between row context, filter context, and query context in writing proper DAX formulas. 

Session 5:

    1. Exploring the different types of built-in charts in Power BI. 
    2. Importing third-party charts into Power BI. 
    3. Geocoding the data and maps charts. 
    4. choosing and customizing the report themes. 
    5. customizing the visuals in Power BI. 
    6. Enabling analytics and forecast lines into visuals. 
    7. AI-Powered visuals like root cause analysis and narrative charts. 
    8. AI-powered Q&A visual that accepts questions in the natural language. 

Session 6 (Capstone Project) :

    1. Real-world dataset 
    2. designing an efficient data pipeline to connect to the data source. 
    3. Performing Data Transformation and Cleaning. 
    4. Select the appropriate data model. 
    5. Writing the needed DAX formulas to implement the measures. 
    6. Wireframing an initial dashboard layout. 
    7. Implementing the dashboard design.
    8. Performance optimization.
    9. Publishing the report to the cloud platform.

Required Tools:

    1. Microsoft Excel 365 or at least Office 2016.