โ Scribed by Prabhu, Punit
No coin nor oath required. For personal study only.
Book Description
This Book will transform you into Data Analytics Expert . In this course you will learn how to use MS Excel to read, clean, transform, visualize and analyze the data.
Course Outcomes
A. Skills
1.Understand what is Data Analytics
2.Change in perception to view data
3.In depth knowledge in MS Excel
4.Creating Interactive and deep insight Dashboards
5.How to use Data Analytics for effective decision making
B. Best Practices
Experience on how to transform and model data, create advanced calculations and build stunning reports, publish your model, build a dashboard.
C. Way Forward
Recommendations and guidance on how to apply the knowledge acquired to resolve real problems at the workplace.
Who can Apply for this course
CMA, CA, MBA, Engineers, IT professionals, Banking and Finance professionals, Marketing, Suppy chain, Students in UG/PG programs, HSC passouts, and aspiring professionals of any other educational background.
Jobs opportunities
IT system analyst, Healthcare Data Analyst, Operations Analyst, Data Scientist, Data Analytics Consultant, Quantitative Analyst, Big Data Specialist
Prospective Employers
Banks, Insurance companies, Specialist software development companies, Consultancies, Telecommunications companies, Public sector organizations, Social media specialists, Colleges and universities, Pharmaceutical companies, Manufacturers.
Title Page
Copyright
Contents
Introduction to Data Analytics
Applications of Data Analytics
Real life examples of Data Analytics
Basics & Navigation
Formulas & Functions
Functions
Formatting
Pivot Table & Slicer
Power Query
Power Pivot
Charts & Dashboard
Practice Files Link
About The Author
Data Analytics Expert, In this course you will learn how to use MS Excel to read, clean, transform, visualize and analyze the data
๐ SIMILAR VOLUMES
Book Description This Book will transform you into Data Analytics Expert . In this course you will learn how to use MS Excel to read, clean, transform, visualize and analyze the data. Course Outcomes A. Skills 1.Understand what is Data Analytics 2.Change in perception to view data 3.In depth
Book Description This Book will transform you into Data Analytics Expert . In this course you will learn how to use MS Excel to read, clean, transform, visualize and analyze the data. Course Outcomes A. Skills 1.Understand what is Data Analytics 2.Change in perception to view data 3.In depth
Overall this is a good book, but it would be much nicer if they provided Excel worksheets with the data used in the book's examples. Some sample code is provided for dowload on Oreilly's website, but this does not include example data. Nonetheless, the book is worth looking at.
Containing many advanced features, yet simple to navigate, Excel is one of the most widely used desktop applications today. This guide for managers, accountants, and other business professionals explains how to apply Excel's statistical and programming capabilities to specific kinds of business prob
<p><b>Helping tech-savvy marketers and data analysts solve real-world business problems with Excel</b></p><p>Using data-driven business analytics to understand customers and improve results is a great idea in theory, but in today's busy offices, marketers and analysts need simple, low-cost ways to p