Advanced Analytics with Power BI and Excel
Learn powerful visualization and data analysis techniques using Microsoft BI tools along with Python and R
- English
- ePUB (mobile friendly)
- Available on iOS & Android
Advanced Analytics with Power BI and Excel
Learn powerful visualization and data analysis techniques using Microsoft BI tools along with Python and R
About this book
Empowering You to Master Business Intelligence and Solve Real-world Analytical Problems.
DESCRIPTIONIn today's analytics landscape, proficiency in Excel and Power BI is practically a prerequisite for a successful career. This book provides a concise yet comprehensive exploration of these foundational elements of modern Business Intelligence (BI).
Comprising ten chapters, this book covers the entire development journey of a Power BI analytical solution, spanning from data modeling and preparation to report creation, publication, and dashboard and app deployment. It offers insights into security measures and performance optimization, ensuring a well-rounded understanding of the BI ecosystem. Furthermore, it delves into advanced topics, such as leveraging data science algorithms within reports, offering readers an extensive learning experience.
The book takes a holistic approach to these technologies, offering a contrast to the narrow perspectives often adopted by contemporary BI professionals who rely solely on a single tool or language. The book allows data enrichment through calculations that can be achieved using various languages, including SQL queries at the source, Power Query Formula Language, M, Python, R, and DAX. By the end of this book, you will master these options but be able to also weigh their pros and cons to make informed decisions.
TABLE OF CONTENTS 1. Introducing the Theoretical Background for Democratizing Analytics2. Acquiring and transforming data from multiple sources3. Power Query Transformations and Formula Language (M) Overview4. Building a simple analytical solution with Power Pivot in Excel5. Enhancing the model and business analysis with DAX6. Creating reports in Power BI Desktop7. Using the Power BI Service8. Data Science in Power BI 9. Optimizing Power BI models and reports10. Deploying, Maintaining, and Securing Power BI Assets Index
Frequently asked questions
- Essential is ideal for learners and professionals who enjoy exploring a wide range of subjects. Access the Essential Library with 800,000+ trusted titles and best-sellers across business, personal growth, and the humanities. Includes unlimited reading time and Standard Read Aloud voice.
- Complete: Perfect for advanced learners and researchers needing full, unrestricted access. Unlock 1.4M+ books across hundreds of subjects, including academic and specialized titles. The Complete Plan also includes advanced features like Premium Read Aloud and Research Assistant.
Please note we cannot support devices running on iOS 13 and Android 7 or earlier. Learn more about using the app.
Information
Table of contents
- Cover Page
- Title Page
- Copyright Page
- Dedication Page
- About the Authors
- About the Reviewers
- Acknowledgements
- About the AdventureWorksDW Database
- Preface
- Errata
- Table of Contents
- 1. Introducing the Theoretical Background for Democratizing Analytics
- 2. Acquiring and Transforming Data From Multiple Sources
- 3. Power Query Transformations and Formula Language (M) Overview
- 4. Building a Simple Analytical Solution with Power Pivot in Excel
- 5. Enhancing the Model and Business Analysis with DAX
- 6. Creating Reports in Power BI Desktop
- 7. Using the Power BI Service
- 8. Data Science in Power BI
- 9. Optimizing Power BI Models and Reports
- 10. Deploying, Maintaining and Securing Power BI Assets
- Index