
Explore data analysis with Excel and Power BI through hands-on visualization, forecasting with Excel, and data transformation in Power BI using Kaggle dataset.
You can download the CSV file from the resource, but I would suggest you go to Kaggle and download it from there.
Learn practical data cleaning in Microsoft Excel: sort and format stock data, remove dividend and stock splits, format prices in dollars, and focus on the last five years for analysis.
Learn to forecast stock data in Excel using the forecast function, projecting opening, high, low, close, and volume for the next 30 days from historical data.
Learn to forecast with Excel charts by filtering data, applying vlookup/xlookup/hlookup, and building line charts with trend lines and r square values for accurate forecasting.
Learn how to use vlookup, hlookup, and xlookup to retrieve dates and prices from a table, handle exact matches, and overcome left-to-right data lookup limitations.
Take a Power BI walkthrough, import Excel data, and transform it with Power Query to clean and shape datasets. Learn the workspace: reports, visuals, refresh, and undo steps.
Execute basic transformations in Power Query Editor, remove columns, set data types and decimals, then create a Power BI visualization for total volume by year with axis and color tweaks.
I have uploaded a sample dataset for the top 2000 companies. You can download them and try to make a visualization yourself. This is for your practice.
Namaste! Thank you for welcoming us to your course on Data Analysis with Excel and Power BI. It sounds like a valuable opportunity for those looking to pursue careers in data analysis, supply chain analysis, or business analysis. Analyzing data using these tools is a crucial skill in today's data-driven world, and I'm sure your course will provide valuable insights and hands-on experience.
I hope you are excited to enroll in this course.
By the end of this course, you'll be able to do:
1. Excel Data Manipulation: Learn to efficiently manage and analyze data using Excel, including functions such as LOOKUPS, and FORECAST for better understanding and data transformation.
2. Power BI Reporting: Dive into Power BI to create interactive and insightful data visualizations and reports for better decision-making.
3. Real-world Projects: Apply your knowledge through hands-on project, gaining practical experience in data analysis.
4. Industry-Relevant Skills: Acquire skills that are in high demand for roles such as data analyst, supply chain analyst, and business analyst.
These core areas will prepare you for success in data-driven roles and empower you to make informed business decisions. Enroll today to start your journey toward becoming a proficient data analyst and rock the industry.