Data Analysis and Visualization in Excel and Power BI

Overview

  • Total Duration 38 Hours
  • Course Fees ₹ 6,650
  • Course Type Classroom + Online

Classroom + app based learning

Industry Experience Faculty

Faculty Guidance through app

Hands-on application of tools

  • Learn analysing data and visualizing data with Advanced Excel
  • Learn to build & publish dashboards in Power BI by Microsoft
  • Extensive Learning hours with 38 hours of classroom training including the classroom assessment with additional 36 hours of online guided practice for better learning and increased retention
  • Hybrid Learning with Guided practice & Weekly Practice quiz questions on the app along with the classroom sessions
  • Hands-on application of Tools

Share

Get in touch with us

Please tick this box to indicate that you understand that your personal data will be used in accordance with the Privacy Policy here. *

Program gets you hands-on with data analysis and visualization in Advanced Excel along with equipping you with a understanding of data handling in Power BI with progression towards complex data visualization in Power BI.

 

  Learning Objectives

  1.  Learning using excel in Data Analysis and Visualization

              a. Using Excel inbuilt functions and user defined formula to for data analysis

              b. Using Excel Data Analysis Toolpack for data analysis

              c. Creating and customizing charts in excel for data visualization

    2. Data Visualization in Power BI

              a. Understanding Power BI Interface and Power BI Variants i.e. Power BI Desktop and Web

              b. Using Excel Data in power BI for visualization

              c. Reporting/Dashboarding using power BI

              d. Publishing Power BI Dashboards

              e. Data relationships and queries in Power BI

              f. Data Transformations in power BI

  • Data Analysis in Excel
  • Visualization using Power BI
  • Have basic knowledge of working in the Windows environment and Microsoft excel
  • Knowledge of Maths/Statistics upto Class XII