Advanced Analytics with Power BI and Excel: Learn powerful visualization and data analysis techniques using Microsoft BI tools along with Python and R

Genere:E-book EPUB

Lingua: Inglese

Editore:

Orange Education Pvt Ltd

Pubblicazione: 10/2023

Key Features

? Fulfill your business analytics objectives through comprehensive theory and hands-on, real-world examples.

? Dive into the world of advanced Business Intelligence using data science with Power BI.

? Acquire in-demand skills that align with the current job market and enhance your career prospects.

In 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.

? Learn the art of crafting comprehensive reports and analyses using Excel and Power BI.

? Discover efficient methods for sharing your insights and reports with your team or clients.

? Gain the skills to maintain and update your analytical solutions effectively.

? Understand the significance of extracting valuable information from data in today’s business landscape.

? Address the increasing demand for skilled analysts, filling a critical gap in the industry.

This book caters to aspiring Business Intelligence developers, analysts seeking to enhance their skills, and beginners looking to efficiently use tools like Excel. It also appeals to data enthusiasts and serves as a practical resource for students and educators in data-related fields.

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