Data Analysis
Using Microsoft Excel and Power BI
30 hrs
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. 1. 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