Overview
Learn how to create pie, bar, line, area, histogram, scatter, regression, and combo charts, Learn how to obtain interesting, real-time information from Excel,Power BI,SQL., Understand different data types and their memory usage, Expand your knowledge of NumPy – statistics and preprocessing, Solve a final capstone project
You should take this course if you want to become a Data Analyst and Data Scientist, This course is for you if you want a great career, The course is also ideal for beginners, as it starts from the fundamentals and gradually builds up your skills
You’ll need to install Power Bi, Excel. We will show you how to do that step by step, No prior experience is required. We will start from the very basics
In today's data-driven business world, the ability to analyze information isn't a luxury, it's a necessity! This HUGE-VALUE Data Analysts Toolbox Bundle equips you with the 3 POWERFUL TOOLS you need to transform from data novice to confident analyst!
No prior experience with Python or Power BI? No problem! This bundle starts with intermediate Excel and guides you step-by-step through mastering these in-demand skills:
Excel: Become an Excel pro with advanced techniques like Power Pivot, Power Query, and DAX. Learn to connect to various data sources, manipulate data efficiently, and create insightful reports.
Python: Unlock the world of Python for data analysis. This course covers everything from getting started to using powerful libraries for data manipulation and visualization.
Power BI: Master the art of data storytelling with Power BI! Learn to import data, build data models, create stunning visuals, and share your insights effectively.
Here's what you'll gain:
Solid foundation in Excel: Sharpen your existing skills and learn advanced techniques.
Python for data analysis: Gain the ability to handle even the most complex datasets.
Power BI mastery: Craft interactive and visually captivating reports.
Hands-on practice: All courses include exercises to solidify your learning.
Don't let data intimidation hold you back! This comprehensive bundle gives you the confidence and skills to unlock the power of data analysis and propel your career forward!
Akhil Vydyula
Hello, I'm Akhil, a Senior Data Scientist at PwC specializing in the Advisory Consulting practice with a focus on Data and Analytics.
My career journey has provided me with the opportunity to delve into various aspects of data analysis and modelling, particularly within the BFSI sector, where I've managed the full lifecycle of development and execution.
I possess a diverse skill set that includes data wrangling, feature engineering, algorithm development, and model implementation. My expertise lies in leveraging advanced data mining techniques, such as statistical analysis, hypothesis testing, regression analysis, and both unsupervised and supervised machine learning, to uncover valuable insights and drive data-informed decisions. I'm especially passionate about risk identification through decision models, and I've honed my skills in machine learning algorithms, data/text mining, and data visualization to tackle these challenges effectively.
Currently, I am deeply involved in an exciting Amazon cloud project, focusing on the end-to-end development of ETL processes. I write ETL code using PySpark/Spark SQL to extract data from S3 buckets, perform necessary transformations, and execute scripts via EMR services. The processed data is then loaded into Postgres SQL (RDS/Redshift) in full, incremental, and live modes. To streamline operations, I’ve automated this process by setting up jobs in Step Functions, which trigger EMR instances in a specified sequence and provide execution status notifications. These Step Functions are scheduled through EventBridge rules.
Moreover, I've extensively utilized AWS Glue to replicate source data from on-premises systems to raw-layer S3 buckets using AWS DMS services. One of my key strengths is understanding the intricacies of data and applying precise transformations to convert data from multiple tables into key-value pairs. I’ve also optimized stored procedures in Postgres SQL to efficiently perform second-level transformations, joining multiple tables and loading the data into final tables.
I am passionate about harnessing the power of data to generate actionable insights and improve business outcomes. If you share this passion or are interested in collaborating on data-driven projects, I would love to connect. Let’s explore the endless possibilities that data analytics can offer!