Choose an application

• Reference Manager
• EndNote
• RefWorks (Direct export to RefWorks)

Discover the true power of DAX and build advanced DAX solutions for practical business scenariosKey FeaturesSolve complex business problems within Microsoft BI tools including Power BI, SQL Server, and ExcelDevelop a conceptual understanding of critical business data modeling principlesLearn the subtleties of Power BI data visualizations, evaluation context, context transition, and filteringBook DescriptionThis book helps business analysts generate powerful and sophisticated analyses from their data using DAX and get the most out of Microsoft Business Intelligence tools. Extreme DAX will first teach you the principles of business intelligence, good model design, and how DAX fits into it all. Then, you’ll launch into detailed examples of DAX in real-world business scenarios such as inventory calculations, forecasting, intercompany business, and data security. At each step, senior DAX experts will walk you through the subtleties involved in working with Power BI models and common mistakes to look out for as you build advanced data aggregations. You’ll deepen your understanding of DAX functions, filters, and measures, and how and when they can be used to derive effective insights. You’ll also be provided with PBIX files for each chapter, so that you can follow along and explore in your own time.What you will learnUnderstand data modeling concepts and structures before you start working with DAXGrasp how relationships in Power BI models are different from those in RDBMSesSecure aggregation levels, attributes, and hierarchies using PATH functions and row-level securityGet to grips with the crucial concept of contextApply advanced context and filtering functions including TREATAS, GENERATE, and SUMMARIZEExplore dynamically changing visualizations with helper tables and dynamic labels and axesWork with week-based calendars and understand standard time-intelligenceEvaluate investments intelligently with the XNPV and XIRR financial DAX functionsWho this book is forExtreme DAX is written for analysts with a working knowledge of DAX in Power BI or other Microsoft analytics tools. It will help you upgrade your knowledge and work with analytical models more effectively, so you’ll need practical experience with DAX before you can get started.

Business intelligence --- Computer programs. --- Microsoft PowerPivot (Computer file)

Choose an application

• Reference Manager
• EndNote
• RefWorks (Direct export to RefWorks)

Bring your data to life with Power BIKey FeaturesGet to grips with the fundamentals of Microsoft Power BI and its Business Intelligence capabilitiesBuild accurate analytical models, reports and dashboards Get faster and more intuitive insights from your data using Microsoft Power BIBook DescriptionMicrosoft Power BI is a cloud-based service that helps you easily visualize and share insights using your organization's data.This book will get you started with business intelligence using the Power BI toolset, covering essential concepts such as installation,designing effective data models, as well as building basic dashboards and visualizations to make your data come to life You will learn how to get your data the way you want – connecting to data sources sources and how to clean your data with the Power BI Query Editor. You will next learn how to properly design your data model to make your data easier to work with. You will next learn how to properly design your data model to navigate table relationships and build DAX formulas to make your data easier to work with. Visualizing your data is another key element of this book, and you will learn how to follow proper data visualization styles and enhanced digital storytelling techniques. By the end of this book, you will understand how to administer your organization's Power BI environment so deployment can be made seamless, data refreshes can run properly, and security can be fully implementedWhat you will learnConnect to data sources using both import and DirectQuery optionsUse the Query Editor to apply data transformations and data cleansing processes, including learning how to write M and R scriptsDesign optimized data models by designing relationships and DAX calculationsLeverage built-in and custom visuals to design effective reportsUse the Power BI Desktop and Power BI Service to implement Row Level Security on your modelAdminister a Power BI cloud tenant for your organizationDeploy your Power BI Desktop files into the Power BI Report ServerWho this book is forThis book is for aspiring Business Intelligence professionals who want to get up and running with Microsoft Power BI. If you have a basic understanding of BI concepts and want to learn how to apply them using Microsoft Power BI, this book is for you.

E-books --- Business intelligence --- Computer programs. --- Microsoft Excel (Computer file) --- Microsoft PowerPivot (Computer file)

Choose an application

• Reference Manager
• EndNote
• RefWorks (Direct export to RefWorks)

SQL (Computer program language) --- Microsoft Excel (Computer file) --- Microsoft PowerPivot (Computer file) --- Electronic spreadsheets.

Choose an application

• Reference Manager
• EndNote
• RefWorks (Direct export to RefWorks)

Microsoft's Power Pivot is an add-on to Excel that enables you to produce new kinds of reports and analyses that were simply impossible before. This book is the first to tackle DAX formulas, the core capability of Power Pivot, from the perspective of the Excel audience. Written by a leading Power Pivot educator (and former leader on the Power Pivot and Excel teams at Microsoft), the book's concepts and approach are introduced in a simple, step-by-step manner tailored to the learning style of Excel users everywhere. The techniques presented allow users to produce, in hours or even minutes, results that formerly would have taken entire teams weeks or months to produce. In this book you will learn how Power Pivot:  1) Gives you "portable" formulas that can be re-used across multiple different reports with a single click.2) Removes the need to ever write a VLOOKUP formula again.3) Allows you to add smart calculations to pivots, such as "Year over Year" and "Moving Averages" which auto-adjust as the pivot changes.4) Effortlessly merges disjointed sets of data into unified insight. As a bonus, Power Pivot and DAX formulas are both the heart AND brain of Microsoft's "Power BI" system, giving us a long-needed bridge between the worlds of Excel and Business Intelligence - a bridge that any Excel PivotTable user can cross with the help of this easy-to-follow book. Your new career - and your organization's future - starts within these pages.

Business intelligence --- Computer programs. --- Microsoft PowerPivot (Computer file) --- Microsoft Excel (Computer file)

Choose an application

• Reference Manager
• EndNote
• RefWorks (Direct export to RefWorks)

Long description: Excel gehört zu den wichtigsten Werkzeugen eines erfolgreichen Controllers. Die Gründe dafür liegen in der hohen Flexibilität und Vielseitigkeit des Programms, das trotz stetig wachsendem Funktionsumfangs intuitiv zu bedienen ist. Dieses Buch bietet Ihnen ein breites Spektrum von praktischen Tools und professionellen Anwendungen sowie ergänzende Gestaltungsempfehlungen. Unsere Expert:innen klären Fragen der Anwendung von Excel, stellen zahlreiche Musterlösungen mit unterschiedlichem Komplexitätsgrad vor und geben Ihnen Tipps für den effizienten Einsatz von Excel.Inhalte:Tabellen und Diagramme empfängergerecht gestalten und einsetzenAuswertungen in Excel optimierenAdd-ins wie PowerPivot und Solver effektiv nutzenEinfacher Einstieg in Predictive Analytics mit Excel und REmpfehlungen für den erfolgreichen Excel-Einsatz für Einsteiger:innen und ProfisArbeitshilfen online:Ausführliche Musterlösungen zur schnellen Anwendung  Biographical note: Andreas Klein Professor Dr. Andreas Klein lehrt seit 2003 Betriebswirtschaftslehre mit Schwerpunkt Controlling & International Accounting an der SRH Hochschule Heidelberg und verfügt über mehrjährige Erfahrung in einer internationalen Beratungsgesellschaft. Er ist Mitherausgeber der Schriftenreihe Der Controlling-Berater und als Unternehmensberater und Referent in der Industrie- und Dienstleistungsbranche tätig.

Datenanalyse --- Diagramme --- Tabellen --- Controller --- Auswertungen --- Reporting --- Auswertung --- Predictive Analytics --- PowerPivot --- Excel-Diagramme --- Solver --- Microsoft Excel (Computer file)