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
- Data Analysis Lifecycle – Concept of Data Analysis and Its Lifecycle - Installing and Setting Up the Python Environment (Anaconda / Jupyter Notebook) - Python Basics: Variables, Data Types, Loops, and Functions - Introduction to Core Libraries: NumPy, Pandas, Matplotlib - Reading Files (CSV and JSON) and Writing Them - Overview of the Data Analysis Project Workflow
